Search results for query: *

Actually I realize that. The procedure that adds data to table1 from the combo box is "NotOnList". However I cannot use that for two tables at once. Let me know if you think of anything else. Thanks, Z

Hello Leslie, The reason for storing the data in two places is that that is what is required. I think it is just as silly, believe me. To answer your second question, the user enters the data string directly into a combo box cboData that then enters it into Table1. So my question is now how to...

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

Thanks so much, both of these threads proved excellent, and I have the result that I was looking for. Zuzia [gorgeous]

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...

Thanks so much Tom! That is exactly what I was looking for and it works very well. Z

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...

Thanks for the suggestion Roy, although the Tab key is strictly used as such in my form. In fact it is used to navigate between text boxes using the Tab stop property. I will go ahead and check the other forums that you mention. Z

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