Search results for query: *

I,ve tried the DSum function in the contyol properties - data control source, =DSum([FoodTotal]).I can,t enter it I get the message "The expression you entered has a function containing the wrong number of arguments".

I am entering daily sales into a table named tblSales with fields SalesCounter, Date, Shift, FoodSales, Tax and PayType. I am loading this table from a form, frmDailySales, with two sub forms, frmDailySalesLunch and frmDailySalesDinner. Forms frmDailySalesLunch and frmDailySalesDinner - both...

I need the ‘Like’ it is the only way I’ve tried that gives the correct result. This in clause is in a query grid - an example of how to concat quotesin the in clause would help. You are correct, the reason Or is being used is because the user could use any combination of text boxes. geodelb

jsteph, I need the ‘Like’ it is the only way I’ve tried that gives the correct result. This in clause is in a query grid - an example of how to concat quotesin the in clause would help. You are correct, the reason Or is being used is because the user could use any combination of text boxes...

I am attempting to make a query for 10 text boxes. I have tried to enter it in the Zoom Box and I,ve entered it row by row in the query. Every time it gets cut short after being saved. How do I accomplish this? Example of saved version (Incomplete) Like "*" &...

Is there an easy way to convert an Access 2000 Application to an Access 97 Application?

I would like the Labels to be the a sample of the first ones, maybe 5, that are going to be printed.

I want to be able to run a printer alignment test by clicking a button. I need to limit the number of labels printed in order to test printer alignment. How can this be accomplished?

I want to use one "Dialog Form" to do several "Reports". I thought it would work this way but I can't Get the "Dialog Form" to stop to fill it out. I can see it opening then the "Report" opens immediately I just need a way to stop it to fill it out...

I am trying to open a Dialog Form that populates a Report. I open the Report to start the Dialog Form. The problem I have is the Dialog Form opens then the report comes up before the dialog form can be can be filled out. I have the code in the report “open event”. This is the Code I am...

I have a form that I am using to run a query. The query name “qryUCQuery” the form name is “frmSelection” it has 2 text boxes on it ,Text0 and Text2. I am using “frmSelection” to specify the values for “qryUCQuery”. The criteria for the query is “Like "*" &...

You are right the nulls in the query are handled with this Not Is Null. I don't think I've been clear on the problem I am having. I am using frmSelection to select the Category field on the Query. I have 2 selection choices on frmSelection , if I make both selections everything works. If I Make...

I tried your suggestion Like "*" & [Forms]![frmSelection]![Text0] & "*" And Not Is Null and if I have a null value in my selection form I get all records. Doesn't seem to effect it.

I tried this: Like "*" & [Forms]![frmSelection]![Text0] This doesn't handle the nulls and doesn't show the fields with right hand wild cards.

I found one problem - if I have null values in my selection form -frmSelection -it shows all recordss. How can I handle null values to give no records?

Thanks this is what i needed . It works great!

I achieve the desired result if a put: Like "*1*" or Like "*FGR*" directly into the Query. But when I refer to the Query from my Form- [Forms]![frmSelection]![Text0] I can't find anything to give the same result.

I have a query with a field called Category with text records, one record example: "3 4 SW SRV CCR GR FAF FCO FCR SCR FGR". This example shows 11 categories. I want to use a form to specify up to 10 criteria for this Query. The output will be used to make mailing labels. any help much...

Thanks - Placing the code in the OnPrint event was the key.

I have a report where I want to activate a textboxes color when the value of another text box = 0. Example: I have a parts list when the value of [parts ordered]-[Parts recieved] = 0. I want a textbox that I have placed over the that record to hilite a color.