Search results for query: *

Being new to Access, How would one go about having a form display records based on values selected from a drop down combo box. Thanx in advance, ddmtn546

OPC: IIf([Resupplied]="Yes",0,+[1IntMW]-[Integrated]) The above criteria assign's a 0 to the OPC range if the value in the range "Resupplied" is equal to Yes. Else, subtract Integrated from 1IntMW. There are 4 choices in the drop down box: Yes, No, Unknown & Wheel. Question? How do I also cause...

ddmtn546 Hey Lupins46, I', not sure how this works, but it does. I'll use it. Maybe you could email an explanation. Thanks, ddmtn546@bellsouth.net

Lupins 46, Thanks for the response, however I get a syntax error at the "1starttime" following the iif command, any ideas? iif(1starttime<=1endtime,DateDiff("s",[1StartTime],[1EndTime])/60, (DateDiff("s",[1StartTime],[1EndTime])+86400)/60)

Hello All! I need to calculate time difference in minutes on a form where the user enters: Date, Start Time, End Time. These times use military time. In a query, I use: 1TimeDiff: DateDiff("s",[1StartTime],[1EndTime])/60 This works fine except when crossing midnight where going from, say...

Help! I got into something I cannot get out of. Normally I would type a keyword or phrase in the address bar and get a listing of the most likely sites. Now, I get a &quot;search Provider&quot; that list's other search providers that could privide the results of my original search phrase. How...

How would one find the difference in two time fields formatted in military time within a query? Example: StartTime-StopTime. Wheresas StartTime was 17:00 & StopTime was 19:00.

What would be the best way to restrict access to some worksheets but not others? However, in general, most users will only need to view one worksheet, while others may need other worksheets. all contained in the same workbook. Thanks in advance.

How would one write the code to require an entry or &quot;Non Null&quot; (validation check, so to speak), for a field using the lost focus feature for that field? Thanks, in advance.

Both you guys are right. Thanks. Is there a less criptic way to display the error message? Thanks.

I have entered the suggested &quot;Is Not Null&quot; & set required to &quot;Yes&quot; & entered a validation text. When I bring up the table in edit mode, I can tab and/or arrow through and past the field set up above seemingly without burp from the system. Am I missing something? Thanks.

What is the best way to require a user to enter a value, or not null? Is it best done at the table or form level? Thanks in advance.

Thanks randysmid, I will give it a look. ddmtn546

Thanks SaraG, interesting thought, I will give it a try - Thank You very much - ddmtn546.

When a user logs on to Access 2000, a lock file is opened. Typically a user does no close the DB at the end of the day. Of course then when trying to perform maintenance, I get an error stating that I don no have exclusive access to the DB. The machines are spread around the property. Is there...

How would I display the results of a query on a form ?? Thanks in Advance - ddmtn546

Thanks hjgoldstein, your tips helped alot - thanks ddmtn

I have a queriey that looks for a checkbox ( -1 ) on a form (Frm #1) then looks up data from a table (Tbl #1) and correctly displays this data. Now I want to turn around and put this &quot;looked-up&quot; data into another table (Tbl #2). I am obviously making this harder than necessary and am...

I have a workorder database where: field1=start date & field2=end date. This work period could be from, say, 10/22/02 (field1) to 12/22/02 (field2). I am trying to run a report every day stating open and jobs. I am using in the query criteria field: Between Date() And...

I have created an &quot;address&quot; table. I also created a form to display the information from this table. My problem: In the first field on the form, LastName, I want an operator to begin typing the last name and have MSAccess &quot;auto complete&quot; the entry and &quot;look-up&quot; and...