Search results

Is it possible to place a text box where I can search for a field in a query that has unique records (no record is the same in this fiels). Basically i am looking for a simplified "Find" box where i can type in the search criteria and click find. It works perfect when I use the "Find/Replace"...

It worked! So the new query I made is called an update query? IS this something I should have to run all the time or was it just a one time deal? Thank you for all your help!

Where do i paste that into? If a make a new query, where do i paste it in the query? Do I have to call the query anything special? When in design view do I delect a field, table, or enter in any criteria? Is this the criteria?

Here is the database file.

I did this and my query comes up blank when I open it. Also, when I open the query back up in design more there is a new column called "StatusID" with the quotes around it. It is in this column that the expression was moved to. The orginal column for StatusID stays unchanged. :(

Just to clarify... For Status ID #'s 1 & 2 the date is in the future. For 3 it is in the past. So if today is 12/15/08 and the date in the Exp Date field is 12/25/08 it would be a 2 in StatusID b/c it is within 30 days of todays date, but is also in the future. If the date was 12/14/08 in the...

The code for an espression if in a query is not working. It says the function i have entered has the wrong number of arguments.

So where exactly am I suppose to enter an expression for a query? I thought it was in the criteria part of the design view for that field, but that does not seem to be working.

Hey guys, thanks for the feedback. Basically what I am looking for is a field (StatusID) in my query (query1) that populates one of 4 numbers (1, 2, 3, 4) based on the date in another field (Exp Date) in the same query. So, IF the date in the field "Exp Date" is more than 30 days from the...

Please help be build this condition in a query: =IIF (Exp Date>Date()+30) Then StatusID=1 ElseIf (Exp Date<= Date()+30) Then StatusID=2 ElseIf (Exp Date<Date()) Then StatusID=3 Else StatusID=4 End If If "Exp Date" is > Todays date + 30 days I want "StatusID" to = 1 If <= to todays date +...

I just emailed you what I have so far.

Also, when i am entering in data on the form that i made using the form wizard, it used the ID number assigned to the Company and Issuer. How can i make it so it shows the actual issuer and company?

So far so good. Here are a few things that are a must for this database. 1. I need that PO number to match the format above and it must autopopulate. I see how this is tricky especially when you try to make a search or a combo box to find a record. 2. I need to have the invoice field becasue...

I am making a database for my business. It is a Purchase Order Database. Please help me with the table set up. A Purchase Order has a unique #. My numbers start with R00109 and go up to R99909. Only the three digits between the R and the 09 will change. So i can have 999 purchase orders, which...

where do i put that in the code?

Ok I got it to work. The code was right. The report was messed up. Here is my question. How can I add an update command to the below code that I am using for that button. I guess the form needs to update before I do print preview. Private Sub cmdPrintRecord_Click() On Error GoTo...

i tried this too but still wouldnt work Private Sub cmdPrintRecord_Click() Dim strDocName As String Dim strWhere As String strDocName = "rptPrintRecord" strWhere = "[ID]=" & Me!ID DoCmd.OpenReport strDocName, acPreview, , strWhere On Error GoTo Err_Print_Click DoCmd.DoMenuItem acFormBar...

This is my event procedure and when i click the button it prompts me to input the "ID" which is the primary key of the record I want to print. How do I make it so it just automatically uses the ID that is on the form? Private Sub cmdPrintRecord_Click() Dim strReportName As String Dim...

I want to make a button that takes the info from a single record in a query or table. I do not want the enitre query or table, but just the record I am on in my form. How can i do this?

Go it working :) thanks guys!