Search results

Here is a sample (very raw)... Notice that Form's On Current Event Sets Me.SecondsElapsed = 0 This means that if you change records, then the new Person's time starts over and the former person's Elapsed time remains intact. Good Luck..

Rick.. Take a look at the new form layout. Placing a continuous subform where your endless comment fields used to lie will give you much more efficiency. In order to properly link the newly added Job Qualifications it was necessary to add this bit of code in the Before Insert Event of the Sub...

RichM.. You said.. What is the benfit/cost of these 2 steps? The method I currently use is simply to put the .mdb in a shared network folder and create a shortcut which everyone copies onto their own Desktop. This works just fine. I guess I'm just not clear on where the System.MDW piece of...

Steve, I believe you misunderstood the above post. The DATE(year,month,day) worksheet function is not meant to return a value in and of itself. If you were to use Date(param,param,param) you would need to input 3 parameters (year,month,day). Thus, this is probably not the function for you...

A disk would be good. So how about that .zip so I can take a look at where you are?

Here's the thing Rick.. We truly are not far from having this thing looking (and working) fairly slick. The only catch is going to be data entry. If we add a third table you are going to have to go through and manually enter the qualification for each of your 400+ job positions. If this is...

Rich, 1) The reason you can't import all of the tblEmp records is because some are orphaned. That is, they don't have a corresponding department head. If you remember, we set your table structure up so that there is ONE (1) DeptHead to MANY Employees. Translated, this means that EVERY employee...

So, was there a question in that last post? Did you get the timer to work? Were you able to post the data where you wanted? You said you are not seeing the elpased time incrementing?? Did you put the code in correctly? Did you set the timer to 1000 (1 second)? Did you activate the On Timer...

Sorry about the fat fingers. Disregard the txtStart.. First of all, the timer is always running, so there is no need to "stop" the timer. Second, if you set the default value of txtTime to 0, then it will start at 0 every time you open the form. Finally, in order to help you insert the record...

Create a hidden text box on the form (txtTime) Set txtTime Default value = 0 Set the timer interval = 1000 Now in the on timer event place this bit of code Me.txtTime = Me.txtTime + 1 This will increment the count by one for every second they are in the form. Now in the onclose event of the...

Say What Rich?? I will yield if Today() is incorrect, but I am fairly sure that it should work.

ps... If you want to get today's date use Today() instead of Now()

The Date Function Requires 3 Parameters The Now Function Simply Returns a Serial Number of Date/Time Format

Ahh.. Now it is beginning to make sense. Unfortunately I can't think of what would cause this problem to occur. Troubleshooting question.. Do you get two completely seperate recordsets from your query when you open it two different times (without changing anything)? If so, than that is very...

Put a checkbox (bootCheck) on a hidden form that is always open to all users logged on. Now set the form timer to 60000 (once a minute, or whatever you choose) and in the on timer event put this code. If Me.bootCheck = -1 Then 'The box is checked Access.Application.CloseCurrentDatabase...

You said.. This leads me to believe that B is a subset of A. That's all fine and dandy, but then you go on to say.. So my question.. How can A be a subset of B, yet they both have the same structure? Also, if you're joining tables w/o using the Primary/Foriegn Key (parent/child)...

How else do you Join a table if not by Primary/Foreign key relationships?

Here is all I can come up with. In Excel, if you enter a date/time.. 6/1/1999 2:00:00 PM And then change the Format of that cell to General Number. The result of that cell then becomes.. 36312.58333 The numbers to the left of the "." represent the day, and the numbers to the right represent...

Bummer.. Auto Increment IDs always work because you leave the Application in control. As soon as you give the user control you set yourself up for bad things. If you want a primary key that won't let you down, then add another ID field to your table and make it the primarykey (auto increment)...

Why not just use one field and populate it with the Now() function? This gives you date and time in one field. This would also allow you to control your selections w/o concatenating the 2 fields.