Set up a macro named "AutoExec" and in it used the function to open your Form. ... CONFIDENTIAL. ... any ... have ... the message ... the ... medium. ... good ...
I have my database all set up. I just want to make sure I don't mess it up creating my front end. After making the copies of the database in each users folder;...
Joe Assuming Access 2000 simplest way is to use the Database Splitter tool (Tools, Database Utilities, Database Splitter). This will create a backend database...
Charles, Thank your for your great advise. It worked great!! Joe Rio _____________________________________ This message and any attachment is intended only for...
Thanks to everyone who responded. I learned with this feature, I can actually only allow the user to see just the forms and they can not get to the queries or...
Joe, Also, if you chose to hide the database window, but need to see it again for modifications, when you open the db, hold down the shift key and the db ...
Beth, You are a saint!!! Thanks for the little trick !!! Joe Rio _____________________________________ Legal Collections Manager, North America marcus evans ...
A startup form is not really a secure way to keep users out of the database window. If you hold down the shift key while opening the database, the startup form...
Here's the code that sets database properties and prevents the less- than-expert Access user from seeing the database window, stops errors from breaking itno...
My company uses accounting periods rather than a date in accounting data. Originally the accounting period matched the calendar year, 200302 meant Feb. 2003....
Paula Aren't Accounting depts wonderful? I built a financial database based on a 13 4-week period for a company that suddenly decided to go with a monthly...
Thanks Bill. But what about the translating into a real date part? I still some input on that! Thanks you for your help, Bill. Paula S. ... based ... with ... ...
Oh, and actually, October 2003 is not like Jan 2003. Since the accounting period changes, Oct 2003 becomes 200401. ... based ... with ... with ... have ... ...
I notice when I set up a .adp file it can only access an SQL Server. I would like it instead to access an Oracle DB. Is this possible. If so, where does...
I'm afraid I don't know much about accounting dates, so take this for what it's worth: You could think through this problem in a couple steps- 1. Change all...
Thanks Robert Joe Rio _____________________________________ Legal Collections Manager, North America marcus evans The NBC Tower 455 Cityfront Plaza Drive, 9th...
Create a table to do the translation. Use it as a validation table for selecting the accounting period going forward. tlkpAccountingPeriodDate AccountingPeriod...
ADP projects are only for SQL Server databases. That's just one more example of Micro$oft limiting functionality to its own products, or it may be that it is...
Hi, I have an Access db that I use to export tables to MySQL. I can export small numbers of rows to the MySQL db (residing on a Linux box), but any attempt at...
Hi I am need help. I am trying to create a report that will calculate the total number of different issues that occurs within a date range. When I have the...
Bruce, Copy and paste the sql view of your query into an email message and post to the list so we can try to help you. Regards, Beth M ... From: ecurb_2000...
e, You understood just fine. And thank you for your suggestion. I was thinking of doing something like you described. Paula S. ... for ... a ... with ... from ...
Well, looks like I made a grave error in setting up my queries. I have found two good solutions. I found all I have to do was have my combo box access a row...
Thanks Charles, I will give this a try. Joe Rio _____________________________________ Legal Collections Manager, North America marcus evans The NBC Tower 455...
Is there a way to error trap the cancelling of an excel spreadsheet? I have a command button that starts to open an excel spreadsheet based on a query result....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
