Save database from Visual Basic (1 Viewer)

T

TDN169

New member

Local time

Today, 05:25

Joined

Sep 11, 2008

Messages

5

• Sep 11, 2008

• #1

Please help! I need to get either VBA code or a macro to simply:

1. Save the database (what you get with CTRL+S)
2. Open a table.

I can't do either of them.

 

NigelShaw

Registered User.

Local time

Today, 13:25

Joined

Jan 11, 2008

Messages

1,573

• Sep 11, 2008

• #2

wouldn't you be better opening a table through a form? Afterall that's what they are for. What do you mean by save database? When you edit a record, it's already saved. You could try docmd.save

 

T

TDN169

New member

Local time

Today, 05:25

Joined

Sep 11, 2008

Messages

5

• Sep 11, 2008

• #3

This is from a form- sorry I forgot to explain that one.
basically, I need to update the lookup list before I open the table as the form edits the lookup list in the table. The best way is to save the Access database.

Hope you can help!

 

NigelShaw

Registered User.

Local time

Today, 13:25

Joined

Jan 11, 2008

Messages

1,573

• Sep 12, 2008

• #4

Hi,

a little confused so would advise to be clear when looking for help as everyone here might not have much time and could probably do without having to decipher a question first as it would most likely be dismissed.

Now

if i am understanding this right, you have a form that is holding information. a user will update the information and you want to save it to a table?

NS