Search results

Thanks Rural Guy!!! When they click submit, it will close the form. Thanks again!

Rural Guy, I have 2 forms that users will either use to update their information or on input new information. When the click their form on the switchboard, I don't want any records displayed. Then they can either use the find button or input. Am I making sense?

Hello, I know I've read the code for this somewhere before, but I can't seem to find it. I'm using a switchboard to open a form, and I want it to open with no records showing. Please help!

It worked!!!! :D Thank you sooooo much.. Have a great weekend!!!

I have updated the make table query with the fields I want to add. I get an Action Failed message with the macro name ... condition: True ... Action Name: Open Query ... & Arguments: queryname, Datasheet, Edit. When I click 'Halt' I get 'You can't delete the table 'table name'; it is...

Thank you ... I got everything updated. The append query works perfectly. The make table query think I'm trying to delete it....:confused:

I have finally managed to figure out what is happening (I think). You click on a menu item that runs a macro. The macro opens and runs a make table query closes it then runs an append query closes that, and then opens the table (from the make table query) where I need to add the columns...

Thank you...here is the SQL SELECT [ALL 05/06Fall].ID, [ALL 05/06Fall].SSN, [ALL 05/06Fall].[Last Name], [ALL 05/06Fall].[First Name], [ALL 05/06Fall].[Middle Name], [ALL 05/06Fall].[Maiden Name], [ALL 05/06Fall].Address, [ALL 05/06Fall].City, [ALL 05/06Fall].State, [ALL 05/06Fall].[Zip code]...

I apologize for not being clearer. I need to add two columns. I have over 300 records in the table and need to update the two new columns. It is a select query. I added all of the fields from the table plus the two fields from an existing query. How do I find the underlying SQL?

Good morning, I'm a newbie....and I inherited this db. I have an existing table. I need to add two rows of information. When I add the rows, they are empty. I have tried running a query with all the fields from the table plus the two rows I need, but I loose 90+ records. What am I doing...

It worked...thank you both!!:)

Hello, I am new to the forum and fairly new to Access. And I inherited this database. :confused: I'd first like to thank you all for the very helpful information I've found so far! I actually have a couple of problems with this registration form. First off, I can't get it to clear all the...