access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version Standard

Sylvia has attended:
Access Intermediate course

Access

I am using one database at the moment which I will need to split - what is the best way to do this - save as the database and delete the columns I don't need from each?

RE: Access

Hi Sylvia, Thank you for your post, welcome to the forum, if you are going to split a single database into two separate access databases the way you have suggested is perfectly acceptable. Alternatively you could create a query which has the fields in it that you wish to keep and then create a table from that query (Make Table Query), open a new database and import the table to your new database, that sounds a little long winded I know but would be probably safer in the long run. I hope that helps, best regards Pete.


 

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Server loaded in 0.11 secs.