Search results

like this?? Assuming that you have a form that is based upon a table named tblPrice, with a field named Price [currency], and another field named Check [yes/no] SELECT tblPrice.Price FROM tblPrice WHERE (((tblPrice.Price) Between [Please enter min price] And [Please enter...

Suggestion: Do not use the open form to filter the records. Go ahead and open the form. If load times are an issue, open it displaying no records. Then, on the form, have your alpha buttons a-z to filter your records. The best example I've seen on this is in the Northwind db, on the...

In Access? Windows? More info please.

Are you trying to query more than 255 fields? If so, STOP IT! ;) Are you trying to 'update' query more than 127 fields? If so, STOP IT! ;) If not, Access may 'think' you are. Try a Compact and Repair. Also, are your fields 'too full'? There is a character limit per record. If...

;) ;) ;)

You are welcome. We all started somewhere, and despite what you might think from the attitudes of a few, NONE of us knows it all. Happy coding. ;)

OK. SELECT Val([Field1]) AS Field FROM tblNumberText ORDER BY Val([Field1]);

OK. One last shot. This may be a printer issue. When you say you installed an Epson printer, are you sure that you installed the proper drivers? Maybe try a re-install. Have you set the new printer as the default printer. Is the printer setup in Access as the printer to use? I really think...

Not a problem... Table named tblNumberText with field named Field1... SELECT Max(tblNumberText.Field1) AS MaxOfField1 FROM tblNumberText WHERE (((IsNumeric([Field1]))=-1)); HTH :cool:

Assuming that you have stepped thru this code and any related code and still cannot find the problem.... Report or query or table upon which the report is based may be corrupt. Try a compact and repair. If still no go, create a new db, and import all objects from original db into the new...

No, EXEC is not functional within the query. The query must be 'called' or executed externally, ie from a command button, opening a form or report, or via VBA.

From the link below: "When developing an Access database using the desktop Microsoft Access application, you are able to create and store queries. These are usually referred to as "Stored Queries", similar to SQL Server's "Stored Procedures", but less powerful. They are only SQL statements, no...

Sorry if this is not much help, but really it seems that you need to get a basic understanding of table relationships in general and query design. Take a look... http://www.fmsinc.com/tpapers/queries/ HTH

Pretty simple. Just a dd a new field... call it whatever you want, then the data that will fill that field. Then insert the prompt just the same way you would for any other field. This example is totally meaningless, but should illustrate... SELECT tblMain.RecNo , Now() AS NewField FROM...

Easy mistake, you select the Totals query via the toolbar button that looks like a greek symbol for 'E'. Just hold your mouse pointer over the symbol and it should read 'Totals'. That will add a Total criteria to you query designer, and you select the fields that you wish to group by. Here it...

Should be easy. Just use a 'totals' query,select your groupby fields, and set the totals field to sum your QTY field. Something like: SELECT tblHCPCS.HCPCS , Sum(tblHCPCS.Qty) AS SumOfQty FROM tblHCPCS GROUP BY tblHCPCS.HCPCS; HTH :cool:

Creating a query with your SQL works fine for one cbo on one form, but only if you delete the first and last brackets. Not sure if it is different in a multiple cbo situation.

Forms are not designed for that sort of thing. You may want to try to create a report that looks like the form, and then e-mail the report.

Yes, No, Maybe Yes, As long as your query is updateable. Check the Access Help File, and search "When can I update data from a query?" :cool:

Follow this link. Sorry I can't be more help. http://www.access-programmers.co.uk/forums/showthread.php?t=22255&goto=nextoldest