Recent content by TheCleaner

I'll keep it short.A table with each vehicle in the company listed as a field name. In that field the scheduler drops in the names of the employees to work each of those vehicles. For the scheduler this form is great. However when the employees read the schedule (a report) they have to search...

THANK YOu! Everything you said is dead on. I used a list box for FieldOne because it was the only type that would return the value in the query. The text box with a control source or even default value of "=[QueryOne]![QueryFieldOne]" would give me a #Name? Eventhough I have an event...

Nope FeildOne is a List box and FieldTwo is a text. I got a run time error 2448. Can't assign a value to this object. so on and so forth. Thank you

Hello back with another. I'm looking for a SendKey function that would copy the text that I have in a field [FieldOne] into another filed [FiledTwo]on the same form (FormOne). This would take place when the user changes the value in a combo box. It will not be visible to the user, however it...

This is the code for the ElapsedTime Calc. Function GetElapsedTime(interval) Dim totalhours As Long, totalminutes As Long, totalseconds As Long Dim days As Long, hours As Long, minutes As Long, Seconds As Long days = Int(CSng(interval)) totalhours =...

when opening the form I get a "runtime error 3061 too few perameters. expected 1". The GetElapsedTime function is the control source for my [ElapsedTime], it is in the details, and it does the math/function for each record. It't in the footer that I want the totals of the...

New road block. I have the report calculating the =GetElapsedTime Function. After the following the advice of many, this calculated value is NOT stored anywere (only displayed on the report). I've adjusted the function so that it displays only the values I need (omitting the "seconds&quot...

thanks everyone for all of your help. I got it figured out.

OKAY. I'm sorry for all this, and I completely understand what Gus is saying. Forget ALL that I've said. This is the new question. I have a sort query that finds a field in an old record. How can I save the value that it found? I may be thinking this is an easier task than it is, or maybe to...

Wow, I was with you up until the "declare". Let me try it this way. Form has field [LastDuty] who's control source is "LastDuty". It's Row source is a query, SELECT DISTINCTROW [QueryName].[FieldInQuery] From [QueryName]; The query has a...

Thank you for taking the time to answer. The short of it goes like this. How do I get the results of a query(requery) that are displayed on my form saved into a table when I save/exit the record(form). Here we go. Form "timeLog" has field [PilotOnDuty]. When you select the pilot via...

Sorry to seem so uptight about this. But I've asked some questions on this board and nobody replies. I've fumbled my way through alot of stuff, but this I just can not get. So here goes, last time. I have a form that I use to imput duty log times. With this form I use the [Pilot]drop down field...

I think I have a question along the same lines. I use a query to search for an older record. One of the values that it returns (endtime) I want it to store in a table so that I can use that value in another calculation (resttime. so I guess my question is the same; how do I store the results of...

I used the "Top Values" button in a query that sorted the records with some other fields that I needed. However, I used this with a Record number not a date, don't know if that will work. Hoped that helped.

Pease....