Search results for query: *

I am entering Dates of birth and if someone is born before 1930 then the date format recognizes it as 2029, i.e... Birthday Keystrokes Access Reads as 1/1/1930 010130 1/1/1930 1/1/1929 010129 1/1/2029 1/1/1928 010128...

does anyone know how to prevent users from entering a mdb by hitting alt + f11

How do you remove the toolbar? It doesn't show in my db's but when I put it on another pc, it comes up with the toolbar showing. I tried to set the toolbar control to =1 like you do to remove the menubar, but it didn't work.

I want a cmd button on a form that lets the user "compact and Repair" the database. The menu's have been removed. There is a hidden menu, called "Developer" which is only accessible thru a password protected form, that has the menu option "Compact and Repair...

On the doubleclick event I have an input box that asks for a password. I want the form to open if inputbox = txtPassword and cancel if it doesn't. I can't seem to "call" the inputbox string. In the Open event looks something similar... if txtpassword.text = inputbox.text then 'do...

I would like to give the user the option of what fields they want on a report. For instance if they wanted to print out a sales report they could choose, before printing, what fields they wanted... DateSold Salesperson SalesRegion ProductSold SoldTo Customer CustomerAddress If they wanted...

I want to add info to a memo field without being able to change info that was already added, and with a date/time stamp. Is that possible?

I want to count the number of orders due for today at the end of a report. The report lists orders due for past future and present dates, but I want to count only the orders due for today. So in the report footer there is a textbox with a control set as...

How do you suppress Microsoft Access error messages? For instance, when user enters date format incorrectly I would like my own msgbox to appear instead of access. But I don't know how to suppress MS A2K's error msg. Any suggestions? Thanks

What I need to do is generate a new record(s) based on selections made by the user that gets calcualted by a query then the appropriate number of records become generated. For instance: Form 1: User chooses if it is a one time purchase order or recurring purchase order. (One time orders - no...

I'm new to vba, as if you wouldn't soon find out... I want to use a function in my db. But I don't know where to put it!

I need to get a value from a subreport into my main report footer section, does anyone know how to do this?

I'm having trouble importing! I can import from a .mdb to a .mdb and export from a .mdb to a .mde, however my problem is.... The raw data is in the .mde that the users have been using. There was a problem with one of the queries in the .mde. Fixed the query with the original .mdb and want to...

Anyone know how to handle this? I have a query that using the iif function with 9 conditions listed - it works, but when I add the 10th condition it gives me the expression is too complex error msg. Anyone know how to get around this?

How do you call a value from a form into a subform. I have a form with a query calculated value of Days. There is a subform on this form with other values that need the days value for other calcs. I'm thinking, *in the subforms footer* *in a textbox* formated to percent* ([subformfield] /...

in a query I want to show usage days by subtracting the end date from the beginingdate, however sometimes the ending date isn't complete, so I want to say something like if enddate is null then date() - beginingdate. Anyone know how to do that?

How do you remove the "Restore Button" on a form when it's maximized and in the properties section you've answered no to control box, min max buttons, and close button?

Does anyone know how to make the copyright and trademark symbols in A2K?