Make Form Appear Automatically After Opening Database

[shaley86]

Hi, when I open up my MS Access 2010 database, all of the Access Objects are along the left hand side and nothing is on the big screen in the centre (until you click on of the Access objects). I would like the objects to appear along the side, but the Form to be automatically on the screen when you open up the database, so that the people using this form can easily enter the data without having to look through all of the objects along the left. How can I do this?
Thanks!

 

[boblarson]

This should do it for you:
http://www.btabdevelopment.com/ts/2010setstartup

 

[NickHa]

You can set the form which opens with your database in the Application Options. These are in the Current Database tab of Access Options, which you will find from the Office buttom (top left of Access window).

 

[missinglinq]

In 2003 and earlier versions you'd go to Tools - Startup and use the dropdown to set the Display Form/Page to the Form in question.

Don't know where it is in 2010, but if you enter "Startup options" in Help it should guide you.

Alternatively, but a little more complicated would be creating a Macro named Autoexec to open the Form.

Autoexec, if present, runs when the Database first opens.

Linq ;0)>

 

[shaley86]

Thanks! i got Bob's reply first and it worked like magic!!!

 

[missinglinq]

I've got to start keeping these 2007/2010 instructions archived so I can help these 'modernized' posters! Of course, I could actually upgrade myself!

Linq ;0)>

 

[boblarson]

Thanks! i got Bob's reply first and it worked like magic!!!

All of the replies were basically saying the same thing. Mine just uses pictures D). Glad we were able to help.

 

[boblarson]

I've got to start keeping these 2007/2010 instructions archived so I can help these 'modernized' posters! Of course, I could actually upgrade myself!

Linq ;0)>

Just remember I have a bunch of 2007/2010 quick tutorial links there for just that purpose. And yes, upgrading would be helpful, if nothing else but to know what is there. You can get the latest software (more than just Office) by doing the Microsoft Partner Action Pack:
https://partner.microsoft.com/40016455

(US $329 for download only)

 

[shaley86]

Hi Everyone again, I am now having a new problem with my form. Whenever you close the database, then go back into it, the data that you entered last is what shows up again. I want to have all of the fields in the form BLANK each time you enter the form. Do you know how to fix this?

 

[boblarson]

Set the form's DATA ENTRY property to YES.

 

[shaley86]

thankyou!!!!

 

[shaley86]

Hi again,
Is there a way to make the cursor go from one textbox to the next? Currently, when you open up the form, the cursor is in the second textbox.... but I want it to start in the first textbox, then with using the arrows on the keyboard, go from one box to the next. Right now, when you use the arrows, the cursor jumps from one text box to another one, in no direct pattern!
Thanks

 

[boblarson]

You need to set the form's TAB ORDER.

 

[shaley86]

how do you do that?

 

[boblarson]

how do you do that?

Since I don't happen to have it handy with me right now, how about we teach you an important trick on this stuff.


Go to the help file. (make sure that it is set to NOT use ONLINE help but you should be able to see the options for help once you open the help and then you can set it to only use local help)

The help file is your friend. You should discover what a wealth of information is right at your fingertips and, if you go to the VBA Window and then if you even start typing something and hit F1 if it can recognize what you have (for example, if I typed DoCmd.TransferSpreadsheet and had my cursor somewhere in the TransferSpreadsheet part, and hit F1, it will come up with good info on it - what parameters there are, definitions, etc.

So give it a go and see what you can find. Try looking. Don't be reliant on just asking someone else for the answer (also work at GOOGLE - you CAN find what you are looking for very simply by taking the time to go look. The trouble is, many people forget that and they get lazy wanting someone else to answer everything for them).

 

[shaley86]

Thanks, that worked using the Help Feature. I have been using Help but sometimes if you don't know the exact terminology to use, ie. "Tab Order," the help doesn't help much.....I had no idea it was called Tab Order.Is it possible to add up anything in Access Reports that DOESN'T include numbers? Let me explain better: I have a report that includes if people entered or not, and the number of entries made. I can get the report to calculate the number of entries made using the Sum Function in the property sheet since that field contains actual numbers, but the other field just used checkmarks to mark whether an entry was made or not. I don't even know if it's possible to add up info in Access that doesn't include actual numbers. Please let me know.

 

[YNWA]

To count blanks you can use:

=Sum(IIf(IsNull([FIELDNAME])=True,1,0))

I think...

 

[shaley86]

Now it won't even let me add up the sum...This is the error code that I get when I have inputted my formula: =Sum([Number of Smoke Alarms Installed])A warning symbol shows up which says: "Data type mismatch in criteria expression."This is the exact same formula that I used in last year's database and it worked fine...I don't know why it doesn't work now