Search results

Is the SaveTo Location Static in code? If so, did they upgrade to a new OS. In Windows 2k C:\user is switched to C:\Documents and Settings\user Just a thought..

I'll take a crack if you want to Zip it and post it.

Click On Tools->References in your VBA Code Window. Make sure that the reference to Microsoft Access DAO 3.6 is Checked. This will let you use the DAO library. Shame on you for not explicitly declaring your variables... There is no better time than the present to learn. You are correct about...

Sounds like a table relationship issue. If you want many dates for one record, then you need to set up a one to many relationship between the two elements. Structure your tables like this.. -- TABLE1 -- tblStuff -- Table Name StuffID -- Primary Key (AutoNumber) StuffField1 StuffField2 --...

Is there a way to Make the Table to a different network (through 2 firewalls, out of one and into the other)? Right now I simply run a batch file that emails the entire "remote" database (after the tables have been made) to my email address. This process works, but is kind of cumbersome...

Just a note, The shift key should actually be held down as the application is loading. I was originally under the impression that it should be hold down only as you click on the Icon. This is not completely true. Try holding down the shift key just after you double click on the icon, and then...

Everything is safe if you've always got a backup copy. How big is your .mdb file? You should be backing up your working version quite frequently as you develop.

You could create a new, blank .mdb file and import all of your forms/tables/queries/reports. How about Compacting and Repairing??

Great idea Wayne!! I have been wrestling with this issue for a while myself. I think I'll try your suggestion.

I think you have a similar problem to one I have been having. The best remedy I could cook up was to simply make the size of the form to be exactly the same size as the detail section (so it has the appearance of a Single Form) and then Add "PgUp" and "PgDwn" buttons in the forms Header and...

In regards to opening and retrieving excel.. You need to do 1 of 2 things. 1. If Excel.exe is already running, use GetObject Method OR 2. If Excel.exe is not already running, use CreateObject Method Check out this site to find the nuts and bolts behind the fIsAppRunning function. Dim...

Sorry for the confusion. I just put the tables in the query builder as a visual guide. I don't actually want to export the query, just the tables that were shown. And no, these aren't the only tables. These are merely the tables that will recieve new data daily. All other tables are reference...

I have 9 Inner Joined Tables that I would like to export to a temporary database every night via code. Here is the long and short. I'm doing a data dump once per day across networks. I don't want to dump the entire .mdb file (its too big), so I'm just going to get the data I need and store it...

Here is a good utility I think I picked up on this site.. You can pass any data type into this function to find out if there is anything in it. Function IsNothing(varToTest As Variant) As Integer ' Tests for a "logical" nothing based on data type ' Empty and Null = Nothing ' Number = 0 is...

This post will tell you how to have a "hard coded" password. This means that the password will not reside in a table, but rather, you choose the passoword in code. Password Protect a Form (db)

When you say splash screen, do you mean you want to just pop up a form for a couple of seconds and then have it go away? If this is the case then, go to Tools -> Startup.. Then choose the form you would like to display at startup (this would be your splash screen). As for the name, it does not...

Use a query as your recordsource. This query should resemble the following... (Don't copy this exactly, IT WILL NOT WORK!!) "SELECT yourTable.DeptHead, yourTable.JobCodes, etc... FROM yourTable WHERE dept# = yourForm!dept#" Use the visual query building tool to build this. Use the Help files...

That sounds great. How do I assure that I (admin) have access to all options that I need? Is there a "hot key" that will turn everything back on as it should be?

Hayley.. I downloaded your db and I am curious as to how you made it so that the user is limited in design functionality. For example.. The right click doesn't work in form view. There are no Toolbars Available for the Application. It is quite a bit harder to make changes. I am very interested...

Excess?! That sounds cool, where can I get a copy? Just kidding. I get fat fingers quite often also. What you want to do is create a form and set the recordsource for that form equal to the table that you are trying to populate. Once you have done this you need to drag all of the fields of...