Search results

I have created a query that deletes and replaces tables, but I do not want the Delete Confirmation message to pop up all the time, how do I turn it off?? I know there are options in the Edit section to turn off 3 other confirmations, but not the delete. I want the macro to run silent without...

Sweet! Perfect, I created a lable and used the function. Works perfect! Thanks so much! Shawn

Huh?? lol... Ok, lets put it this way...I have no idea how to do that. I am soooo new to Access and VBA. Could you show me the syntax is the table I want to do a count on is called 'PoolA'?? I appreciate it! Shawn

I want to create a form that just counts the number of records in a given table and displays the total number of records in the table. Also, putting a button or something by the total in the even the user wants to access the table. Anyone?? Shawn.

Is this possible?? I am doing this with a 3rd party macro right now, but would like it in VBA so I can run it directly from access prior to my queries. Basically what the query below does is look at the source path for a filename that has the current date in it, and if it's todays date, it...

Doesn't appear to work... I set the relationship up and ran a query, but it only generated the column header?? How should the query look? Sorry, but am very new with access. The relationship is one to one from my main table to the lookup table, then again from lookup to the secondary table I...

I am working with a system where on the accounting side, each record has an account number, but on the operations side, the records have a record number. I have created a lookup table to match the account number to the record number but I still need to reconcile. At this point, I have all...