Search results for query: *

Yes, and it seems like i can get it to do what i need. Thank you for now, will keep working at it to get the rest of the query. Thanks for your Help, Sylvain

also trying this Labor7: Mid([Parameters],InStr([Parameters],"LABOR="),Len("LABOR=15.000000")) the problem here is taht at the beginning of the string there is a TOTALLABOR, and this function pick that one up instead of the one that i want. How can i set it to the specific text that i want...

this is not giving me the correct result. here is the string taht i am working with BAND=#STET|TOTALLABOR=#M0.000000|PRICE=0.000000|LABOR=15.000000|_applyFD=#M 1.000000|RFDado=#M1.000000|HBORE_ON=#L1|MinThick=#M0.600000|HBoreDia=#M0.31...

Hello, I am trying to extract a portion of text from a string but having some difficulty. Here is how it goes: the fiels name is [Parameters] which contains a very long text string, every value is split with a "|", and has an "=" with a value. ei: ...|LABOR=15.00000|... inside that...

That's what i was doing wrong!!! thanks a million dhookom

Hi, i have looked all over and can't seem to nail this down. i am sure this is a very simple one. i have a report with a sub report, text boxes in the foorter of the main report with this as control source...

ooppss....crash and burn.... does not work so good after all using this in the query feild Expr1: IIf([installer],[Installer],"NOT ASSIGNED") works good to return all, but when i try to filter ti based on the forms combo box then it only returns all of the records, not filtered based on the...

Resolved it!!!!...use the IIF in the quwery feild insrtead of the query criteria... seems to work fine :-)

I am trying to return a value for a field and also check if the feild is NULL at the same time with this: IIf(nz([Forms]![frmInstallSchcedule]![cboInstaller].[Value],"")="",[installer],[Forms]![frmInstallSchcedule]![cboInstaller].[Value]) if the feild 'installer' has no data, then it does...

Thanks JB, Will work on this..may take a bit of time, but will try to report back with results.. Thanks again, Sylvain

Thanks for the response... read throught the comments, looks really close to what i would like..the only thing is that i don't keep front and back end into same directory.....not being an expert at code, can i have the 2 files in different folders and somehow modify this code to work that way...

Hi everyone, I would like to know if there is a way, or if something has already been done to help link the front end database(application) to the back end database(data)? I work on my project on my laptop. I take a copy of the 'data' databse from the server and bring it with me, then...

Yep...that does it perfectly...i new it had to be easy.... thanks for pointing me in the right dirrection

Hi, I am having trouble finding something...i have searched the forum, looked in the help files of both vb and Access and did not get this to work. I would like to show the first monday of the week and then the friday in another field. Basically showing something like this: 'Week of...

Thanks Guys for the hints...let me look at these possibilyties and report back....

Hi, I have a reoport that qets populated based on a Union query. The problem that i am having is that same report does not work on all computers. It work on mine (Win XP, Access 2002), but won't work on an other system same Os same version Access. It will work on a Windows 2000 Pc, with...

Got it!!!! thanks again for your help on this one Thanks to AceMan also.

those darn single quotes will get you EVERY time right???? so just to make sure i understand. when dealing with a text feild we need to have single quotes? right? if the field is numeric no single quotes? Thanks so much for your help

this is the message in the immediate window: UPDATE tblPODoorHistory SET [Received] = -1 WHERE [tblPODoorHistory]![PONumber] = 9999-003;

the msgbox says '0 records updated'