Search results for query: *

If there is no consistent rule, you can manually group them by creating a separate table. Name | Group_Name awbz | awbz awbz (GGZ) OB)DAG | awbz awbz (GGZ) OB)DAG + OB-ALS | awbz You just have to be sure that you're capturing all the names and grouping them.

I have a table with tblPrice having fields: StartDate ProductID Price 1/1/06 1 $10 1/2/06 1 $10 1/3/06 1 $5 1/4/06 1 $10 Is it possible to query this table so the result would look like: ProductID Price MinDate MaxDate 1...

You DA MAN!

I have two tables: Table1: Product, SaleDate Table2: Product, SaleDate, Price I'd like to join the two tables on Product and the closest SaleDate. For example, Table1 has a SaleDate of 8/18/05, while Table2 has SaleDate's of 7/1/05, 8/1/05, and 9/1/05 for the same product. I'd like to match...

Geoff Franklin is a wise wise man. Listen to him. Else, you're stuck with PHV's recommendation...something like... WHERE field = "* 01" or something like that

Do you have a sample list of field a and b and what you'd like to capture?

...(make sure you have DAO 3.6 checked in Tools -> References) Dim db as DAO.Database Dim rs as DAO.Recordset Dim strSQL as String strSQL = "SELECT * FROM Query1" set db = CurrentDB() set rs = db.OpenRecordset(strSQL) rs.MoveFirst While Not rs.EOF 'You can access fields by...

something like... Function RunAllMyQueries() CurrentDB.Execute "SQL Statement 1" CurrentDB.Execute "SQL Statement 2" CurrentDB.Execute "SQL Statement 3" End You can also create a macro using RunSQL. You can also run the Query itself in VB using DoCmd.OpenQuery QueryName.

You can't pop up a message through a query (not to my knowledge). You need to do this on the form. In your form where you want to check your value, use the following... If (condition) Then MsgBox "Must Have State Mandated Application" End If I can't make out what you're trying to do with...

Also, I didn't quite understand what you're trying to do with the dlookup. I only corrected the syntax to the best of my knowledge.

IIF(DLOOKUP([GRP_INVENTORY].St, "LKup_State", "Mandated Apps='Yes'),"Must Have State Mandated Application","") I assumed [GRP_INVENTORY].St is a field in the query, LKup_State is the name of the lookup table. Just as a note, there's no msgbox to pop up a message. Also, you wanted a pop-up...

WOW. Thanks to both of you. Much shorter coding.

Just curious if there are more efficient ways of going about this. I would like to populate a combobox with a list of all the tables in the database. Function AllTables() Dim db As Database Dim tbl As TableDef Dim strTable As String Set db = CurrentDb() strTable = ""...

Any error messages? It should update your table.

I would use a command button and the On_Click() event. CurrentDb.Execute "INSERT INTO OBJECT(as400narr) VALUES ('" & [Forms]![objQry1]![text35] & "')

You can use the SQL statement Insert. CurrentDB.Execute "INSERT INTO table (as400narr) VALUES ('" & txtField & "')

Create a report with name and last name. Go to Page Setup -> Columns, and set the columns to the number of columns you want per page.

I would create one query for OnDate and one query for OffDate. Then match their date. Query 1 Query2 100 2/1/04 100 2/13/04 101 2/13/04 101 2/1/05 But, what if two or more vehicles were exchanged? For example 100 1/1/05 1/2/05 101 1/1/05 1/2/05 102 1/2/05 1/3/05 103 1/2/05 1/3/05...

I don't think there is a limit. It just takes a matter of time processing all those queries. I consolidated all my queries in one report. If I had stuck with building queries, I'd say I would've had to maintain well over 50. It takes about 5 minutes to complete. The advantage is I don't...

docmd.close docmd.openform("form name") You can also hide your switchboard by toggling the visible property.