Search results

Yeah, I believe this is the case. In your query criteria the field/column is different than what you are selecting in your combo box. To fix this: · check the count columns, the number of columns to show is more then 1? · also check column width, might be 0";0.5";1" etc · check the...

also on form current event if you use the same code might solve the problem (not sure not tested)

changing their passwords is other than to change the whole database password. Its beyond my knowledge why one should change the database password if others also will use the same database, this will prevent them to log in. users password can be changed by other means.

of course the reference of report (Reports!rptPCDev!PCid) in the underline query will be invalid and will produce an error. sorry for not to notice the referred report in a hurry.

try to put all your calculated field with the formula =IIf(IsNull([tblPC.InvLabel]);"";nz(DLookUp("Description";"qryDevicesPC";"PC =" & Reports!rptPCDev!PCid in query of your subreport. Note that any such control with formula will not work directly on the report. the better place to...

Try to compact and repair database, also do compile debug your VBA code and see where is the mess...

I don't understand WHY it is required to change Database password by any user? this is against the security of any database and leads to BIG mess :confused:

you can set the default value for the desire field to your choice "Grinding" While in the design mode of the form right click the desire field and goto to data tab and select the default value for that field.

you can do that in VBA code for the desired field based on the selection of a combo box. An After_Update Event of the combox box should handle this: me.YourCombo.Column(0) could be differ based on your combo values you have. it could be column(0) or column(1) or column(n)....

What is the bound column value of your combo box you are reffering in your form to filter the records? I belive it's not the same column field value you are selecting in your query criteria... is this the case? Please note that in combo box has two values to handle 1 - Bound column (use to...

It's very sad news, I was not around since long time, and we certainly will miss him for his great contribution to the forum and help. My condolences go to his family and relatives, may he rest in peace.

Okay Guys, the scenario is: I have linked tables front end application running on network drive. The data is becoming huge and the users are becoming more, as a result the application become slower. Now, It has been decided to get the necessary tables data in a local tables when application...

hover over in the code window? just hover over by mouse is not giving the exact value in VBA code sometimes. you should put break points on the code to analyse if really it is the same? The best way is to go along with your code line by line and monitor it closely for each line what's going on...

Hi, Where is the SkidID comes from? is it the Field on your form? why it is always same? Is your form is unbound? Where do you use the Dim stDocName As String, I think this is unnecessary declaration in your code? put break point on this line: If SkidID = txtSkidID.Value Then and check if it...

On which event you are using the code? On form Load OR current event of the form might solve the problem.

Welcome to AWF, you want to give the combo box value to the textbox (field) on your form? you can do this with After Update Event of the combo box: hth

Hi Lupus! Welcome to AWF, you need to create another table tblmission for: F_PilotID MissionDate ArielVictories KillsWitnessed PointsErned The above table would be one-to-many relationships with the F_PilotID as a foreign Key from tblPilot, and tblPilot should have the following fields...

This is also a good approach! usually if your queries are simple and not nested queries than the record source of the form/report/combo/listbox will provide you a this facility, and you also can write it in VBA with currentdb.openrecordset SQL statement if you have good grip on your VBA codding.

Great! That work for you ;)

Thanks dude I was thinking to use the currentdb.OpenRecordset method on before update event of the control coz Dlookup will check only the first occurness of the Result, I create the following FindDup function: On Error GoTo Err_Handler Call FindDup(Me.SOFID, Me.ItemId) Exit_Err...