Search results

Won't bother you, Bob. I review your sample again and found what the problem of my inquiry form is. It is okay now. thanks! If Not IsNull(Me.cboSelectModel) Then stWhere = "[Model]='" & Me.cboSelectModel & "' And " blnTrim = True End If If Not...

Bob, can you help again check what is wrong with my form where I add on another inquiry criteria. (attachment) It just doesn't work :confused::confused: Thanks a lot! Yu

Hi Thanks! :ohere is my final code: If Me.Dates < Me.ClosingDate Then Me.Quantity.Locked = True 'The following statement shows a message box. MsgBox "Sorry! You can only change data after the closing date." Else Me.Quantity.Locked = False End If

Hi thanks! I'll try both ways. Yu

Hi, I am looking for a code that can allow me to enter a closing date on the Warehouse database, so the person who do the warehouse data entry (in Front End) can't change any of the figure that had entered before the closing date (unless I enter the password to change the closing date or release...

Oh : ) Thanks a lot! Bob. You are so great! Got a flu that my eyes are hard to open at this time. But with your help, I believe I'll get this puzzle resolved tomorrow! Have a good night. Yu

Oop, the attachment is not there. do again.

Thanks Bob. attached is the database. Yu

yeah, you are right. it is text value. I changed the code as you said, this time the report runs. But new problem appear, after I select the model number, the report that it generate is blank. hmm... Will it because the report that I set link in this form? cause in this report, I had sort it by...

hey, thanks Bob. Here is the code I use. If not select model but only date range, the report runs well and generate correct. But the error message will pop up if I select the model number. Private Sub cmdGenerateReport_Click() On Error GoTo Err_cmdGenerateReport_Click Dim stDocName...

Bob, I imitate yours and create my own form but when I hit the Generate Report button, an error message pop up showing "Data type mismatch in criteria expression." What is this problem maybe? May I have your comments again? Thanks!

Okay! got it ^_^

Oh, I found what the problem is. What I use is Access 2007, everytime when I open the database, there is always a message bar with a security warning which I ignore it every time. But just now, I get in there, and choose "Enable this content". And then I run your form again. It works! Thanks...

Hi Bob. How come there is no result comes out when I hit the "generate report" on the sample form that downloaded from your website. Can you give me some light again? thanks. Yu

Thanks! Bob.

Hi, I finally figure this out. Yeap, it is all due to the nulls in the data. Pual, Bob, thank you for all your help! It is a warm family here : ) Yu

Hi, can anyone help me make a query so that the criteria for the parameters are a drop down list of the values in that field? For example, if the field is "Product model", the user can choose from the available models via a drop down list rather than type the specific model number like...

Hi Paul, just after I send out the last email to you. I realized that the first row of the crosstab query is blank, maybe that blank top of report is because of this? ....... But where does this empty row on the crosstab query come from? and I culdn't get rid of it from the query.....

Hi Paul, The query-crosstab returns good result though... I attach it here for your reference ... maybe there is some clue you can find it from there? Thanks ! :) Yu

Hi, I am a newbie to Access (8-) just one week). Trying to create a report from the cross tab query for a warehouse report but got a problem: a blank group heading kept appeared on the top of the 1st page. I try to remove it by select function like "invisible" or "delete", but if I do so, the...