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...

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 "search Provider" 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 "Non Null" (validation check, so to speak), for a field using the lost focus feature for that field? Thanks, in advance.

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.

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

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 "looked-up" 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 "address" 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 "auto complete" the entry and "look-up" and...

I am relatively new to Access and am struggling with a problem. I have a "Customers" table and a "Customers" form. The 1st fiels on the form is the customer's last name. I want to be able to begin typing the existing customers last name and have the rest of the form...

I am trying to build a maintenance database. I have a customers table and a workorders table. Each has a form for data entry. I have a command button on the customers form that brings up the workorder form. The last name field is the primary key. The problem - I would like to be able to toggle...

Good Day All, I am struggling with forms, being somewhat new to Access. Description: I have a Maintenance Database. The 1st form is based from the table "Customer". It displays customers using a primary keyed "CustomerID" field. The 2nd form is based from the table...

When opening a database I keep getting an "Enter Parameter Value" message box, I assume, asking for some value to be entered by me. In my application I should not need to supply this data, Therefore, how would I go about finding, or what would I look for, trying to repair the code, or...

When a user selects a combo box and the desired value does not exist, how can I input the new value, updating the original table? Thanx in advance.

Being a novice, I am trying to use a query to calculate when ColumnA & ColumnB are both true: Rec ColumnA ColumnB ColumnC (result) 1 0 0 0 (if A=1 & B=1 then C=1) 2 1 0 0 (if A=1 & B=1 then C=1) 3 0 1 0 (if A=1 & B=1 then C=1) 4...

Being a novice, I am trying to use a query to calculate when ColumnA & ColumnB are both true: Rec ColumnA ColumnB ColumnC (result) 1 0 0 0 (if A=1 & B=1 then C=1) 2 1 0 0 (if A=1 & B=1 then C=1) 3 0 1 0 (if A=1 & B=1 then C=1) 4...