Search results for query: *

Korngeek, your response was especially helpful. Thanks for your time to make that post.

thanks

docmd.showtoolbar,"form view", actoolbarno or in the "Startup" -- "Advanced" -- uncheck use built in toolbars

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...

Thanks, I'll check out the article. But what I've found is that if you: 1. Open Access 2. (Without a db open) - press Alt-F11 (VBEditor opens) 3. Go back to Access Screen 4. Choose File-Open and open a .mdb and pres Alt-F11 5. And theres the code! .mde's are different, but I still need to...

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

Will I need to do this to every form? My goal is for there NEVER to be a tool bar. So when it loads on another pc if they previously had a toolbar loaded, it would be unloaded. My guess would be that if I have to unload "toolbar1" then if they have the default or another toolbar by...

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...

thanks i will

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...

Thanks Fancy

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?

Anthony, It worked!!!!! (but you already knew it would didn't you?) Thank you!!!!!!!! I tried puting the txtbox IIF in the detail section and then summing the count, but that didn't work either... thank you so MUCH! Jon

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...

Nealv, Thanks

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

Thank you for your help

Ken, Your input is very appreciated, unfortunately, yes I do need more. Ultimately a query will be ran to gather all purchase orders that are due for a specific day. Which means it needs to find the "One-time" entered purchase orders and the "Recur" purchase orders that...