Search results for query: *

I have a form which pulls records in for different areas.. The user enters in dates, the area they want to see records hit a button and a report comes up displays the information for that site and for those dates. My question is in between those dates are other records from other sites.. I want...

I have a form which searches for records ... When the user hits enter another forms pops up and ask for your name and the company you work for.. The user enters in the information hit ok and the form closes and a report of the records the user ask for pops up with the users name and company on...

I have a module .. that counts the first two letters in my field "INSP" module: Function funCount1(prmSearchString As String) As String funCount1 = DCount("[INSP]", "[qryQualityStatus]", "left([INSP],2) = '" & prmSearchString & "'") End...

I fergot how to count all null field in a query... First I'm tryin to get all "Y" in a yes no field ... so in my query I add my table then add my field .. i put the letter Y in the criteria.. and it pulls all "Y" yes for that field... Next I add in my date field.. which...

Hi, I have a combo field with data from a table.. as follows.. AB AB1 AB2 AT AT1 AT2 AF AF1 AF2 etc...... I have a form and a subform inside.. when the user selects AB1 in the combo box and hits a button it returns all records with an AB1 on it.. What I want to know is .. when the user...

I have a group of records .. With fields "OpenDate" "CloseDate" "Rejection" and "Inspections".. Inspections in a combo box that has data like.. DR, DR1, DR2, PS, PS1, PS2, PF, PF1, PF2, PF3, PF4 ETC.. ( DR-Design Review, PS-Pipe Shipment, PF-Pipe Fitting )...

I have a report.. which has some text of numbers.. I want to add all the numbers up and display it on my report.. I tired in my report.. adding a unbound text box to the footer of my report " =Sum([MIL]) " I get error in return... I'm sorta new .. thanks for baring

Can someone help me with my SQL.. Im doing a search of unique records.. I can't get it to work after adding the Is null stmts.. SELECT * FROM tblInspections WHERE ((tblInspections.strDate) = Between [Forms]![Search]![open] OR IsNull([Forms]![Search]![open]) And [Forms]![Search]![close] OR...

Can someone help me with my SQL.. Im doing a search of unique records.. I can't get it to work after adding the Is null stmts.. SELECT * FROM tblInspections WHERE ((tblInspections.strDate) = Between [Forms]![Search]![open] OR IsNull([Forms]![Search]![open]) And [Forms]![Search]![close] OR...

Hi, I have a form which I let the user enter in data, each group of data is stored as a inspection. Everytime an inspection is created, the current date is assigned to each inspection. I also made another form to let the user update any inspection they choose. In this update form the user...

I have a form which stores records.. Now I need to create another form which pulls specific data in.. ie. say I need to pull in all records that were dated between.. 7/01/03 thru 7/30/03 AND where inspected by supervisor 1. Something of that nature.. I'm new to access.. so please bare with...

HI, I have a form which has a subform inside.. In this sub-form I have my table of records.. each of these records has sub-records .. What I want to do is.. let the user highlight whichever record he/she wants to see sub-records for.. each record has 7 fields.. out of those 7.. 3 of those...

Hi, I have a form with a sub-form inside.. In the sub-form is a listing of all records.. Each of these records has sub records... what I want to know is .. is it possible for the user to scroll through the list of records and whichever sub-record the user wants to look at all the user has to do...

I have a form, which pulls records in to update ( modify, close ) My problem is when i pull in a record I can make modifications no problem.. It allows me to update.. all fields except for the close date field.. When I leave the close date field empty ( since that record isnt closed .. yet ) it...

Hi, I have a form which user pulls in records.. I also have a button to where the user can update the record.. This works fine as long as there is something being updated.. The problem is When i pull the record and say I want to delete whatever is in the field leaving it blank. then update...

Hi, I have a form which has unbound fields.. On my form .... I'll let the user enter in new data for a record.. click the add button.. my problem is.. after the user hits the add record button.. it does save all info to table.. but the original info that the user entered stays there.. I want it...

I have a form with a button that opens another form.. on form 1 when i hit to open form 2 I want form 1 to close.. leaving only form 2 visible... how do i do that ?? thanks

A friend of mines helped my out on some code.. but he gave me only 3 fields to work with.. what i'm trying to do is.. on my form it pulls up records.. to that record.. you can add sub-records.. i took 3 unique fields of the original record and made a button to transfer those 3 fields to my new...

Hi, I have a form where users enters/retrieves records.. each record is assigned a unique number .. when user enters data in.. on my form I have a field that shows the user the unique number for that record.. what i want to know is.. is there a way to keep the user out of that field.. I want...

Hi, I tired posting this in the access forms section.. but got no response.. maybe I posted in the wrong forum anyways.. heres my problem.. I keep on getting an error ... compile error : invalid qualifier... on my second form.. my 2nd form is called.. "frmAddInspec" with 3 text...