Search results

I have a query that uses needs two dates which are entered through a form. The query was working fine to list the items that occur between those dates. When I added grouping to the query the form started to appear blank. The form opens and there are no fields or controls on it. Just the...

Int () works great! Thanks

I need to print multiple copies of a report and number of copies is varrying each time depending on the entry. Is there any way that I can indicate the number of copies on the report just like I indicate the number of pages. (Like "Page 1 of 5"). I can't use ([Page] & " of " & [Pages]) because...

How do I truncate a decimal number in a VBA code? Currently I am using MOD to overcome this problem but it is a pain and takes too many lines of code to do a simple task. There must be something to use instead. All I need is to cut out the decimal part of a number and use the whole number part...

I used the wizard to make my form go to a record by using the content of a combo box. But I need the form to go to a specific record depending on the values from two seperate combo box because none of the two combo box create a uniqe value. I changed the code to insert one more arguement for...

I am now positive that the error is caused by the code. There is no such problem when I don't run the code. In addition though I found out that the code is not working properly. I need it to find the firs record depending on the values from two controls, not only one. I tried to add another...

I am using two text boxes that gets their values from another form. And using a code to make the table go to a specific record depending on those values on those two tex boxes. The form opens without any problem on the record that I want it to be. I need to add some information to other fields...

When I make Access read the data in a table-type recordset, it follows an order that I could not figure out. I need to sort the data according to a field in the base-table. The help files are not helpfull. The only thing I understood was, I must use Index for a table type recordset, but I...

That helps! Thanks a lot Emre

I tried that but whenever I use action queries it pops up a confirmation meessage box to confirm the appended records, etc. I don't want the users to see that kind of stuff. Is ther anyway avoiding that? Actually I solved the problem with by writing a module, but for future reference if I...

I need to copy the data in a table to another table and simultaneously enter a number under a particular field for all the records. I created a recordset. But I don't know how to enter data (the same number) to that particular column for every record and copy them to another table. Can I do it...

If the problem is on the Recordset line Try, Dim rst As DAO.Recordset Instead of Dim rst As Recordset And make sure that "Microsoft DAO 3.6 Object Library" under Tools/References menu

Due to a version conflict, when Microsoft DAO 3.6 Object Library is checked under Tools/References, Access does not recognize some DAO objects from previous versions. Try: Dim rs As DAO.RecordSet instead of, Dim rs As RecordSet

I had the same problem. This is definitely a problem with Access version that you run. You must be using 2000. Somewhere deep indside the help files (!) a list of changed commands are declared. Recordset command is one of them. I fixed my problem by typing: Dim db As Database Dim rs...