Search results for query: *

I have a report that I have been using the DateAdd function to query the last 12 hours for a helpdesk log and that works no problem. Our shifts run from 7am to 7pm (days) and 7pm to 7am (nights). What I would like to do is make a query that would look at the time when generated and only grab...

I am trying to make a report that will act as a logfile of work done in the last 12 hour period. I have no problem with the time and setting up the query. The problem is that I want to see any field that is changed(edited)in that period as well. Is there an easy way to do this? The problem...

I have a report that I made for a workorder database. This report prints out daily entries made on workorders. As it is now it prints all entries in the memo field, which may be days or weeks worth of work. My question is that I would only like to print the last entry made in a memo field...

I'm trying to group on part of a text field in a report. Column will have the following: Date Location 29April2005 Station A 02May2005 Station B 06May2005 Station B 07May2005 Station C What I want is a group header based on the A, B or C in...

I am trying to get two comboboxes working that are dependant on each other, on eis called cboSelTitle and the second cboSelSys. Rowsource for cboSelTitle: SELECT DISTINCT PMI.number, PMI.Title FROM PMI ORDER BY PMI.number Private SUB cboSelTitle_AfterUpdate() Me. Title.SetFocus...

I have 2 fields in my table, one is manhours and the other is total_manhours. WHat I need to happen is when someone goes into form to log work done, they will enter into manhours the hours worked on job (manhours should be 0 when they call up form) . I would then like the manhours entered to...

I have several combo boxes on my form and for the text fields I have no problem. One of the records is a number and am having a problem figuring out what I should call in the Row Source. How would I change the following for a number vice text? Select Distinct [pmi].[number] From [pmi] Where...

I have 2 tables as follows: tblEquipment tblMM_PCN PCN (serial number) OLD_PCN New_PCN MM_PCN Model Location Due_Cal Comments WHat I am trying to do is update New_PCN in tblEquipment with the new changed number (MM_PCN)...

I have a simple Equipment table that I want to make a report weekly that shows me what equipment is due calibration in the next 2 weeks. This is not the problem, I'm doing this with query Date() and looking 14 days in advance. The problem arises when a piece of equipment cannot be taken for...

I have a form with a subform in it. The subform is showing text from a memo field in another table. SUbform works fine but will not show more then 255 characters of the memo field. Tried enabling scroll bars , etc. Is there a clean way of doing this? Maybe the subform is not the way to go. Jim

I am probably missing something really stupid here but been pulling my hair out today. I have an Equip Table that has a field PCN (Product Control Number). These PCN's are all being updated (someones great idea) and I have created a NEW_PCN field in tblEquip. I received an Excel spreadsheet...

I am using 2 tables: ETR and LOG. The main form I am using shows all records from tblETR and 1 record from tblLOG. The record from tblLOG (tblLOG.Action)is displayed in a subform. My problem is that the subform record pulls separate LOG text entries on a particular Electronic Trouble Report...

Here's the problem. I have a table Equip that has a SN (serial number) field in it. The higher powers that be decided to change the serial numbers on all pieces of equipment. My problem is that at least until all 1000 items have been retagged, I need to be able to search and find all pieces...

I have a form that show preventive maintenance info and 2 of the fields are "Date Completed" and "Date Due". What I need to do is when a user calls the form up to fill in the new date complete, I need the Date Due field to update to the new date, (this will be 7 days for...

I have a table called "NEWETR1" and am using a Select Query using the "like" statement to find a specific "ETR". The ETR number has the format 2003-0001 and is a text field. Query works fine and opens my Read_ETR Form and shows me all the data. What I need is a...

I have an existing Access 2000 database (.mdb). It has many linke dtables in it. I am trying to change a table's specs. but can't get to it since it's linked. If I take the link away the table disappears. Is it still in the .mdb? Microsoft says that you can re-l;ink to it again....but not if...

here's what i'm trying to do. I have a table (Table1) and what I'm trying to do is use a form (SearchForm) that would call a query. This form needs to have multiple fields that it can query from by hitting a submit button or similiar. I could do a bunch of separate select queries but would...

I am using a simple Select Query where I am trying to find a particular (text field) record, which is not a problem. The problem is that I do not want to view the form that the query is calling if there is no matches. A blank form shows up now. I tried a macro that will bring up a msg box if...