Search results

Check out the sample database. If you try opening any data entry form it will ask you for user id and password. password is password hth, Michael

Gino, I'm not 100% sure if you can open a specific record without being filtered. My code is pretty much the same as MStef sample database. hth, Michael

Try pasting this code in a command button. On Error GoTo Err_Handler On Error GoTo Err_Handler Dim strFieldName As String Dim strForm As String strForm = "FormYouWishToOpen" strFieldName= "[FieldName]='" & Me.FieldName& "'" DoCmd.OpenForm strForm, , ...

No problem . . . Glad I can help Michael

I'm not sure if it helps, but my database has 2 reports(18 fields each) from 1 form(36 fields). I'm using the command buttons on my form to print Page 1 report for first 18 fields or print page 2 report for my last 18 fields. If you wish to do it my way than try pasting this code in a form...

Are you saying that you have to many fields it will cause your report to print so many pages or you have so many records that you wish to print only current record from a form in a report? Michael

I made a crosstab query from your table. But I made a mistake by adding a year field (manual input). I made a correction for the year field that automatically inputs that year from the date your enter in Date Entered field. (hope it make sense) Run your crosstab query you will notice that you...

Post your database. Besure to compact & repair and winzip the file. Michael

If you want try making a wizard combo box...select the third option which is Find a record on my form based....select the field that you wish to input in a drop down box...keep going till you get to finish. hth, Michael

From reading your first post it seems to me that you're having trouble with cascading combo box. Are you trying to select a record from a combo box and have the form show that record? Michael

I can't really answer all your questions but I did manage to get you a sample database for cascading combo box. hth, Michael

Try checking the screen resolution size. Compare them to your screen. I've had that problem before my screen size is 1024*768 other people in my office use 800*600. hth, Michael

You can make a crosstab query that will give the count for each fields. hth, Michael

I'm using the crosstab query and the drop down box is grayed out. Michael

I have a report(rptTopStolen) running from a query(qryTopStolen) for top stolen vehicles. My report shows me 171 records(make&model), is there an expression that I can use to shorten my search by either looking at Top 10 stolen vehicles, Top 20, and so on? Right now I'm running my report in...

Sorry to hear that & Glad I help. Michael

Try pasting this code; On Error GoTo Err_Command11_Click Dim stDocName As String stDocName = "YourReportName" DoCmd.OutputTo acReport, stDocName Exit_Command11_Click: Exit Sub Err_Command11_Click: MsgBox Err.Description Resume Exit_Command11_Click hth, Michael

Try pasting this code below in a command button...OnClick On Error GoTo Err_Command12_Click Dim stDocName As String stDocName = "YourReportName" DoCmd.OpenReport stDocName, acNormal Exit_Command12_Click: Exit Sub Err_Command12_Click: MsgBox Err.Description Resume...

You can try using the ControlTip Text...Properties...Other Tab. This will give you a pop up with a mouse pointer over the textbox. hth, Michael

Take a look at the attachment. I had to make an extra field for the year. From there you can pretty much play around. hth, Michael