Search results for query: *

Hi, I have a combo box using table1 data. When the user adds more data into the combo box it gets added to table1. How do I do the following: Given that there are two different tables, table1 and table2, how do I append the data input in the combo box to table2 as well? Thanks, Z

Hi, I have 4 combo boxes bound to individual queries. From these combo boxes I generate a report of matched records. I need help in generating an error message if the resulting report is blank i.e. the combo box selections have no record matching. Any suggestions on doing that will be...

Hi, Does anyone know the best way to remove a varying number of leading zeros from a table or query in MS Access 2000? These zeros occur at the beginning of a Address field's street number, and are followed by the number, and then by the street name. Thanks, Z

Not sure if this is the correct forum, but has anyone ever seen this error? Disk I/O Error: Status = 00000400 It appears immediately after bootup. When I hit ctrl-alt-del, the PC reboots and is extremely slow, that is after it automatically scans the C file system. Any ideas what could be...

Hi, I have a question about groupings. I need to group months on a report, but they are fiscal months, meaning that they run from the 15th of the first month to the 15th of the next month. I want all the fiscal months to be grouped individually per page, but all per report. So far the "Group...

Hello, I am using VBA to create a report showing the monthly cost summaries. The search dates are input by the user, and the report returns the month by month sum result. Right now this report is broken down so as to sum monthly results per customer, what I need is a sum of monthly results in...

Hello, I want to be able to hit the enter key and have the check box in MS Access show the checkmark, as opposed to clicking on the check box only. This check box is located on a form. Any suggestions about property settings or how to do it in VBA will be appreciated. Thanks, Z