Search results

John, quirky but it works thanks. Steve

Help in creating output file from a table PLEASE ITS EASY I have the following info in a table - I am trying to make a file to import into a label printing program. I have qty 5 of item X13 and so need 5 labels for it, 3 of X24's and so on. The output is basically a print file that will print...

and here is the answer: stlinkcriteria = "[iso number]= '" & Me![Combo0] & "'" it won't let you enter " " " but " ' " does it. Problem solved.

It seems I am missing a set of quotes.... This is being passed to the report ([iso number]=S-59-1E-0231-02) but I need ([iso number]="S-59-1E-0231-02") What do i need to change. thanks

This little bit of code is not working for me: combo0 looks at a list of iso's (SELECT [WELDS].[ISO NUMBER] FROM WELDS; ). Format is like these: D-1-1E-0237-03 or seal-1E-0232-03 I select the iso in the combo box and get an "enter parameter value" for "D" if I selected the first example...

HELP: I was just reopend a database after loosing connection to the server and it gave me the message switchboard not found. I looked in forms and there are none - I had several. (reports also they are all gone - tables and queries there) When I try and run one of the queries I get the error...

Anyone else have any ideas. I heard that the split function for Access 2000 might help break a string down into an array of words from which I can compare from to another - would this work how do do I do this. Thanks

I am an Access dummy. Is there an easier way or can you point me right on how to use that code. thanks

I have a monthly safety slogan competition which requires back checking to a list of already submitted slogans. This takes forerver to do. I have 2 lists: this month's slogans and a master list of all slogans. Here is an example: S1Master: An unsafe behavior can bring you down S1Submitted...

that did it thank you

i am typing (C) into a text field in a table. When I have entered it, is changes to a copyright symbol (a circle with a c inside). How can I stop this. thanks

and thanks for that, it helps with something else i am working on.

thanks i missed it in the FAQ is was under de-secure. Seems like it worked. thanks

I have a database on a job site a few states away. When it has a probolem they zip it up and I fix/ modify it and send it back. Simple but it works. However somebody ran the security wizard at the job and now when they send it to me I can not get into it. I can webex on to thier computer and...

Thanks all, I think the table idea is great. I only have about 10 cable types, but several sizes of each, but in total maybe only about 40 different options. It will also tie to my cable reel list, in fact I will just add the look up fields to the reel table. Thanks for a simple solution to...

I tried the iif statement in query as shown in an earlier post and it was getting too complicated and so seeking an easier way - maybe in VBA to layout the IIF statement in a more manageable manner (I don't know how). So far I believe there are about 10 variations. Can I create a table? - Well...

OK, I am back. Here is an example of teh data I am dealing with. The left hand string is a cable identifier, what I want out of the string is to the right. The easy way would be to get the data in a more manageable way, but that will not happen. My IIf statement posted earlier is looking for...

Thanks for staying with me, I have to make a long drive home now before the hurricane traps me, i will post later. Steve

any suggestions anyone. thanks

Here is one example, I need to add 2 IIF's more to this one Terms: IIf(InStr([cable type],"CABLE")>0,10,2*(IIf((InStr(Left([cable type],6),"c"))<>0,(Left([cable type],(InStr([cable type],"c")-1))),IIf((InStr(Left([cable type],6),"T"))<>0,(Left([cable type],(InStr([cable...