Search results

For each of the controls in the subform that you do not want to get focus, in their properties, set "Tab Stop" to "no" Does this help? Please respond

Do you want it linked or do you want it without the link so it does not update when you change it in excel?

Since you do not know how to use the Tab order... function I may have to tell you. In the main form open up Tab order, make sure the last field is at the ***Edit*** second last from the bottom with the name of the subform at the bottom ***Edit*** ( if it is not click on the row button on the...

This would be like saving calculations, therefore not recommended. even if you wanted it for a primary key, it would be a hassle to change each record if you had to delete (or whatever) record number 2 of 1000. you would have to go through all records and readjust them. If you want to keep a...

Now that I think of it, when in design view, try right clicking and choose "Tab Order...". You can then choose which order the curser goes. don't forget the list in the popup box is different depending if you have the subform focused or the mainform etc etc.

This will help you with your Parramiter queries and how to make them look at values in text boxes in forms too.

When in form view, right click on the field header, then choose "Hide Column". Don't forget to save by pressing Ctl+S while form is still selected otherwise it will go back to what it was before you choose to hide it.

If it does not do it by default, then there is a way to force it to do this. This website should help you along http://www.officecomputertraining.com/vbtutorial/tutpages/page9.asp Does this help? Please respond

Dont try to link the querys together. instead click on the "show table" button on the toolbar and select the queries tab. then choose the query that you want to add into this new query. then select the fields you want like you would as with a table. thats it. Did that help? Please respond

Hi all I have a database which works great on Windows XP but fails because I am using code to get the user name and only works with Win XP that is: Environ("UserName") Could someone please tell me the code to use for windows 98? Thanks a lot scott

I find that restricting users depending on what user has loged into windows is useful because the user is not wasting time going through all these security checks. This is only recommended if you know your users have limited knowlegde of Access This however is not as secure as if you had done...

I find that restricting users depending on what user has loged into windows is useful because the user is not wasting time going through all these security checks. This is only recommended if you know your users have limited knowlegde of Access This however is not as secure as if you had done...

Are you trying to do this in datasheet view or form view?

If you want a more perminant version, I have a field so that the date and time is changed when the user changes the current record. see attachment I use This to enter the current user name of windows (won't work for windows 98 but will work for windows XP) for when the user is entering a new...

Better not pull her over A woman is driving her car when she is pulled over by a a cop. He says to her: "Ma'am, may i see your licence please? you were speeding". The woman answers: "Oh no, officer, I don't have a licence, they took it after the 4th time i was caught driving drunk.". The...

Genie In A Bottle A husband and wife were having an argument. Suddenly the husband picked up a bottle lying near him and threw it at his wife. The bottle missed the wife and got into the neighbours' house breaking the window glass. Now both the husband and wife got embarassed and went to...

Fast Divorce A married couple are driving along a highway doing 60mph, the wife behind the wheel. Her husband suddenly looks over at her and says, "Honey, I know we've been married for 20 years, but I want a divorce." The wife says nothing but slowly increases speed to 70 mph. He then says...

Labor Pills Once a woman was in labor; she was having a really tough time dealing with the pain. The doctor came to her husband and her and told them of a new experimental drug that allows the woman to transfer 25% of the pain to the father. The husband feels really bad for his wife so he...

Why Men Can't Win If you work too hard, there is never any time for her. If you don't work enough, you're a good-for-nothing bum. If she has a boring repetitive job with low pay, it's exploitation. If you have a boring repetitive job with low pay, you should get off your ass and find...

Advanced Medicine An Israeli doctor said, "Medicine in my country is so advanced, we can take a kidney out of one person, put it in another and have him looking for work in six weeks." A German doctor said "That's nothing! In Germany, we can take a lung out of one person, put it in another...