Recent content by RandomNeeds

This was really helpful. This is what I ended up with. I will do more detailed testing tomorrow, but I believe that all the scenarios I just ran come out with the intended result. Thanks for sticking with me! Public Function GetSwKey(varKeyOrderType As Variant, _...

This worked!!! I now need to add one more element to the new module for the last variable, which is ReplaceShip. I think I would do that by adding this to the module: If varKeyOrderType = "ReplaceSHIP" Then GetSwKey = varNewKeyNumber

Yes, it is listed as NewKeyShip.

I don't think so, but I could try

You are very helpful. I am going to try your suggestion and post the code. That last edit didn't quite do the trick. It is still prompting for the parameter: NewKeyShip. This is inherited code. I am trying to add this one parameter to it- to check the value of the Key order type before...

Are you saying that if I put this: [code] Sw key: IIf([tbl_OrderForm.KeyOrderType] like “NEWKEYSHIP”, [tbl_OrderForm.NewKeyNumber], IIf([tbl_OrderForm.KeyOrderType] like “REPLACESHIP”, [tbl_OrderForm.NewKeyNumber, IIf ([tbl_OrderFormDetailsNew.PartNumber] Like...

I am working on a query and need some help with the syntax. currently I am not getting an error, but I am getting a parameter undefined pop-up when I try to run the query. The parameter it doesn't understand is really a field value that I am trying to interrogate. NewKeyShip is one of 5...

[code] Sw key: IIf([tbl_OrderForm].[KeyOrderType]=[NEWKEYSHIP],[tbl_OrderForm].[NewKeyNumber],IIf([tbl_OrderFormDetailsNew].[PartNumber] Like "H40*",IIf([tbl_OrderForm].[AlohaKey]>0 And [tbl_OrderForm].[NewKeyNumber] Is...

I probably stated this wrong. I am not actually getting a syntax error- the query is letting me enter the way I have it. But when I run the VB script that calls the append query, it prompts me NEWKEYSHIP as a missing parameter. The exact message is: Enter Parameter Value: NEWKEYSHIP and...

Thanks, I removed the quotes and it still prompted- any other ideas? I will also take a look at the other link, too.

Hi, I am trying to create an append query and one of my field needs is quite complex. When I run this, I get prompted to enter the parameter for NEWKEYSHIP. What I expect should happen, since I am running this on an order that is using that Key Order Type, that the output should include...

That worked! Bingo! Thank you!!!!!

I have read various answers on how to open a form in Datasheet view from VBA code, but I can't get my syntax correct. Please help? Here is one of my 50 attempts to guess at the format. Removing different components, separators, variables only gets me a syntax error of missing separator...

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=33724&stc=1&d=1284505115

I don't see where to upload the screenshot, but my last try took a lot longer, but it still failed with "could not export." I do have some tables that do not have relationships to other tables. Do you think that is the problem?