Search results

I need help with dlookup based on two global string variable. Please help me fill in the ...........................

Thank you for the quick reply. I guess I can just add a security pop-up to ensure the proper authority is inputting the information. So, once the text box has the focus, you just scan the code and the data is filled, or there is an interface/code required?

This question is related to a restaurant POS system design. Is there a way to allow a text field in a form to be filled by a scanner only, unless an event is triggered? Rather than using a magnetic strip ones for gift cards, we're thinking of using the bar code version. However, to prevent...

Please see the image I attached earlier. The sql for this example is My browser gave me a severe warning about this link you provided concerning malware.

Hi Jiri, Actually, the I name my functions typically like OrderID_Func (). I just generically made it for the example above. I suspect the naming is not the issue, as I have seen this error message in other queries when I pass the value via functions. Again, I don't always get the errors...

Thanks for responding, Husky. I check the variable and the functions before running the query. Both returns the values I expect, but I still get that error message.

I don't know what's common practice, but I've been using functions to pass values to queries as criteria. I would often set a global variable from a dlookup function or from a record selected in a form, then I'd pass the value to a query. I'm not sure if this not a good practice or something...

Hi, I need help on the condition part of the dlookup function. Both conditions are based on variables, with one created using TempVars in Access 2010. Variable one: GstrID (a global variable) Variable two: Created by TempVars.Add "OrderType", strOrderType) So the function should like something...

I knew it was something simple. Thanks Big Booty.

It sure doesn't seem difficult, but I'm having a hard time with this. I basically want to select all data prior to a date that is entered from a form. The field is I'm sure I need to convert this or add "#" somewhere in the criteria of the query. I tried and many other syntax's, but none...

Ah, it works great now after I insert the criteria you had suggested from that the above thread to below. Thank you so much for the help.

So, in the code of Command2 event, did you set GstrPrinted = Null? If so, then I'm baffled cuz it didn't work for me. Did you change the datatype of the field to "Yes/No" as well?

My db is too big, so I created a simple one. As you can see in Form1, the two left buttons work fine. I just don't know, based on the query that is already written, provide all the records so that the yellow button would work. I tried to save it as .mdb but received "...cannot save...The...

Yes, PrintedFunc() is in the criteria. The current returned value is either "Yes" or "No". What I need now is "either" as an option so all will print.

Thanks for replying, Paul. The idea in the link you provided is sound, but for my function, it did not work. Perhaps it's the syntax? I tried below but received no data.

I have a query that has a criteria that is based on a function [PrintedFunc ()]. The field (Printed) is filtered by "Yes" or "No". The report filters fine when the function returns "Yes" or "No". What I need sometimes is to print all the records, whether the record is "Yes" or "No"...

Thank you, Paul. That worked beautifully.

How to apply multiple filters upon opening a form? I can set filter to one condition with the below code in the OnOpen event, but I actually need to apply the following conditions: [Status]="Open" and [OrderType] ="condition1" or "condition2" Me.Filter = "[Status] = 'Open' "...

I have small network setup between two computers and five receipt printers. I have .accdr front end on both computers with .accdb back end stored on Computer B. Computer A: Front end and a printer (Printer A) Computer B: Front end, back end and four printers (Printer A,B,C,D) I have gotten...

Thanks for pointing me to the right direction. I ended up using below. The function returns something like 12:12:44 PM. =TimeSerial(Mid([TimeStamp],9,2),Mid([TimeStamp],11,2),Mid([TimeStamp],13,2)) I wish I don't have to show the seconds, but I believe the function requires it.