drawing an X on a report at runtime
is it possible in access 2007 to draw an X during runtime at a specified point on the report during runtime? ...
ms-access
Custom buttons in MS-Access 2k7
I'm adding some custom buttons to my forms in MS Access, but somehow I can't make them work. In buttons properties Event tab I've changed 'On Click' event to call 'Event procedure'. Then in VBasic I'm selecting my button and from what I know this code should give me prompt, and if Yos is selected the form should close. But when I click m...
how to find copyright code???
hi all, we were maintaining an MS Access application. Person who actually developed the application used copyrighted code. Now we want to remove that code and re-write that logic. Problem is we dont know what is the copyrighted code and what is not. Is there any way or tool that can be used to scan through the existing code and flag the...
How do I chain forms in Access? (pass values between them)
Hello, I'm using Access 2007 and have a data model like this... Passenger - Bookings - Destinations So 1 Passenger can have Many Bookings, each for 1 Destinations. My problem... I can create a form to allow the entry of Passenger details, but I then want to add a NEXT button to take me to a form to enter the details of the Booking (...
filtering wav files and playing them
hi - i am trying to get a database together for a community radio station. i am a newbie at this but would like to be able to display only wav files from a directoy (can get all files using dirlistbox but cant work out how to filter them down). then would like to able to highlight a file from the list, hit a button and play it. thanks fo...
How do I simply set up an alert/reminder for dates set in MS Access?
I have a database in MS Access and within it I am holding dates for expirations for SSL's. I want to set a reminder for any SSL that is soon to expire. Anyone know the easiest way to go about this? ...
best way to read string into a table in ACCESS
i have a string like this some_string= "something, something2, something3, something4, etc.." i would like to read this string into a table like this: field1 = "something" field2 = "something2" etc what is the best way to do this in vba/sql? ...
reading into table: comma values and quotes SQL
i have a string like this something = "something, something1, "something2, something else", something3" i need it to be read into a table like this: field1 = "something" field2= "something1" field3 = "something2, something else" field4 = "something3" please notice that the double quotes in the something string signified that the s...
insert values with different delimiter
i want to insert values into a table, with an INSERT INTO statement but i would like to use a different delimiter (not a comma) how do i do this? i dont want to use a comma for the following reason: the data is in this format: |something|somethingelse|something3 ,moretextinsamefield| field1 = "something" field2 = "somethingelse" fiel...
SQL query for an access database needed
Hey guys, first off all sorry, i can't login using my yahoo provider. anyways I have this problem. Let me explain it to you, and then I'll show you a picture. I have a access db table. It has 'report id', 'recpient id', and 'recipient name' and 'report req'. What the table "means" is that do the user using that report still require it...
ms-access: a folder listener?
i don't know if this is the standard way to do things, but i will need to take a text file and have it imported into access. i need access to be always looking (or every minute or so) in a folder, importing the text file, and then automatically printing a report is this possible? how do i have access look in a folder every couple of m...
Microsoft Access Error 2482
I am using MS Access application and I am getting an error on just one user's pc: Microsoft Error: 2482 - Microsoft Access can't find the name ... you entered in the expression.You may have specified a control that wasn't on the current object without specifying the correct form or report context. To refer to a control on another form o...
How effectively manage a database: using direct sql commands or DataSets?
Sometimes I need to develop a simple database application using MS Access Databases. I`ve learned that I can manipulate data in my tables using direct SQL Commands or gather everything in a DataSet and update any changes that it tracks (insert, delete...). But the question is: should my app make changes is my database tables using dire...
How do I specify a default value in a MS Access query?
I have three tables similar to the following: tblInvoices: Number | Date | Customer tblInvDetails: Invoice | Quantity | Rate | Description tblPayments: Invoice | Date | Amount I have created a query called exInvDetails that adds an Amount column to tblInvDetails: SELECT tblInvDetails.*, [tblInvDetails.Quantity]*[tblInvDetails.Rate]*...
How to configure database for exe.file
Recently I had created a Java Desktop Application, I wish to share it with my friends. I was thinking to convert it into exe file using exe4j, but as for the database part I not sure how to configure it so that the application can run on my friends desktop without re-configure the database again. I am using Microsoft Access, anyone can g...
Check if access table exists
I want to log web site visits' IP, datetime, client and refferer data to access database but I'm planning to log every days log data in separate tables in example logs for 06.06.2010 will be logged in 2010_06_06 named table. When date is changed I'll create a table named 2010_06_07. But the problem is if this table is already created. A...
access: read CSV file into table
is it possible to programmatically have access open a certain csv file and read it into a datasheet and set parameters like what time of delimiter, TEXT QUALIFIER etc, including all the steps that one takes to manually import a csv file into a table? ...
Docmd.TransferText question
b'h i will be programmatically importing a text file into a table. i have saved the import steps. i will use this: DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage) to do the import. this is what SpecificationName means: Specification Name The specification name for the...
Resize Access Database Column/Field Programmatically with C#
If I know that a particular Text column exists in a table, how can I programmatically resize that field (say from 10 to 20) with C#? I don't want to use the method where I would create a temporary column, copy the data over, drop the old column, and rename the new one. I'd like to preserve the orde. ...
MS Access: Why is ADODB.Recordset.BatchUpdate so much slower than Application.ImportXML?
I'm trying to run the code below to insert a whole lot of records (from a file with a weird file format) into my Access 2003 database from VBA. After many, many experiments, this code is the fastest I've been able to come up with: it does 10000 records in about 15 seconds on my machine. At least 14.5 of those seconds (ie. almost all th...