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

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

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?

I have a table with an auto number and its format is: \R000"08" My goal was to have an auto number where it looks like R00108 and only the 3 digits between the R and the 08 change. The above format enabled me to do so. THe problem is that in the Form i am making, it will only show the...

I am making a tablethat will require an auto numebr, but i need it to generate in my format: R00108 R00208 R00308 R00408 As yo can see the number that changes will be the 3 digits between the R and the 08. How can i do this? I am not too farmiliar with this stuff so forgive me if my...

I am trying to make a table or a query that auto fills in if another table or query has met a certian criteria. Basically here is my set up: Query 1: has a check mark in a given cell, or it says YES. Table/query 2: I want a given cell to say Yes, or auto populate a checkmark, because...