Search results

Thanks for the reply. I had trouble getting the query to look at my sub form with the criteria. I have made select queries before using the "Forms" method to hold criteria from another form, but for some reason I could not figure out how to get it to only look if the the check box is true and...

I have a sub form which I use to update data in a table if the user selects the check box. This works fine except that I want to make sure that the user selects a button on the main form, so I want to update those records which have been selected on the sub form with a "Report Created" in my...

I have an issue where two fields are exactly the same but do not show as duplicates. I checked for empty spaces and next lines, which I know cause this problem but everything is fine. Has anyone come across this issue? The original data in my database which I am trying to compare to was...

Thanks, the false did it. Thanks for the help.

Thanks for the reply. I still get a data mismatch error in criteria though. I know I had fits before with the [prikey] being an autonumber, to the point where when I asked for help on that problem originally, even the normal number syntax answers did not fix it. Could this autonumber field be...

Thanks for the reply. Yea, I have tried at least to my knowledge every iteration I know of. What I posted was just where I ended. I just kept getting an error, so I thought I would post here. Thanks again.

I tried this, I actually originally had this, but I still get data mismatch in criteria. Thanks for the start.

Because when I just put the string into the statement I got errors. So I just turned them into string variables so that I could write it w/o it turning red. I know its bad.

I need help to get this syntax right. I have something similar that worked before to open a report but now I am using the same code structure on opening a form and I can't get it. [prikey] is an autonumber and that has given me trouble before with the syntax. [EstimateFlagCleared] and...

I am looking to find if a field contains a number and then build a case statement depending on which number is found. The field will contain data just like this: Here is my code that did not work: If Me.txt_work_comm1 Like "*Hybrid" Then 'Sets up auto priced based on number of...

Thanks to Minty and UncleFink for your replies. I think I need to explain the situation better. I have an action table which is inserted into from a form using SQL Insert and VBA. The form code basically searches for the last record from that customer and then pulls up that last...

I am looking to get a query to show my list of customers "Grouped By" [CustomerName], that show only the single [CurrentBalance] field for each customer based on the "Last or Highest" [RecordID]. Also, each customer can have up to 4 different [StockType]'s but at least 1 [StockType].So my...

Gina is right on here. Bart you should reduce margins to only what you need first. Your first image you posted shows you are already using blank space. Also, is there an invisible field to the right? Comparing your first image with the second it seems that the object in design view is not...

Ooops. I think this is what you where looking for. If Not IsNull(Dlookup("[serialno]", "Assets", "[serialno] = '" & Me!serialno & "'")) And Not IsNull(Dlookup("[Field2]", "TBL2", "[serialno] = '" & Me!serialno & "'"))Then msgbox "blah blah"

I imagine you are having the same trouble I did. The double quote from the begining of the "Where" condition does not close the first criteria but on the second, as can be seen that the second criteria here does not begin with the double quote but ends with it, thus closing both condition into...

I have this code that is giving me a compile error for procedure too large. Any suggestions on how I can keep the functionality but reduce the code? I already changed many If statements to case statements under the suggestion that they are more efficient. Here is just one set of code of 10 in...

Solved it. Charge: IIf([Rate] Is Not Null,Format([Rate], "currency"),"0.00")

I have this expression I created and I want to know how to format it as currency. I know how to do it with a regular field but the option is not available for an expression. Any help would be great. The expression: Charge: IIf([Rate] Is Not Null,[Rate],"0.00")

Thanks Plog, that did it! My only problem now is how to make my new expression formatted to currency. I know how to do it on a regular field but the option is gone when it is an expression. Anyways, I will probably post that problem as it's own thread. Thanks again. Cheers!!

I have 2 tables: one for repairs and the other for the billing for those repairs. There is a foreign key(record_num) in the billing table to match the primary key(prikey) in the repairs table. This works fine as long as the unit repair has been completed. Now an employee wants to see records...