Search results for query: *

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...

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...

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...

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...

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...

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...

Hi, I would like to know if there is a way to check a checkbox in every record base on 1 check box outside that form? The main form has the checkbox 'chkReceivedAll' and the subform 'frmReceivedSud' has a checkbox on every record call 'chkReceived'. So when the user check the 'main'...

Hi, I am trying to return a "0" when not data is available and having trouble doing so. Here is what i am working with in the control source of the unbound text feild: =IIf(IsNull([qreCommitedMat]![SumOfQtsOptimized]),"0",[qreCommitedMat]![SumOfQtsOptimized]) it works where there is data...

Hi, I am trying to find out which page of a tab control has the focus, and can not seem to get it. i am trying 'formName.value=?' or 'formName.value=?'...trying all sort of things and not getting it. How cna i find out this info? Thanks,

Hello, Having trouble with the following: I have a function "OpenFormEdit" that opens different forms, that gets called from different places. Now i am trying to open a new "frmAddNewStockAssemblies"form in 'edit' mode and pass a link criteria to it and having trouble doing so. here is...

Hi everyone, I am trying to have a command button visible or not visible on a continuous form base on the value of a text box. So for instance, if txtQTSBO.Value > 0 then cmdBO.visible = false else cmdBO.visible = true end if the problem i am having is is either shows for all...