Search results

Hey, My compact and repair recently been giving me a problem with my AutoNumber(primary key). I have a quiz made for every department in my company, I'm sure you all aware once the information is being typed in a form AutoNumber(primary key)set a new number. I've compact and repair the...

Try this..... Dim strDocName As String Dim strLinkCriteria As String strDocName = "ReportName" strLinkCriteria = "[FieldName] = Forms![FormName]![FieldName]" DoCmd.OpenReport strDocName, acViewPreview, , strLinkCriteria hth, Michael

Make a commad button...right click properties....event tab...place your insertion point on click event you should see 3 little black dots...click on the black dots...code builder...paste this code...DoCmd.RunCommand acCmdDeleteRecord...close the vb form and be sure to save the form before going...

Try playing around with your report width in design view. (Click and Drag the page width) hth, Michael

Try this..... =IIF([MBModel] = "MB06042","VIA C3") hth, Michael

Take a look at the link below...you will find an attachment file. http://www.access-programmers.co.uk/forums/showthread.php?t=78423 hth, Michael

Did you make a crosstab query? Michael

KPOM, There are couple of ways of doing it, you can either go to tools,startup, and select your form name in Display Form/Page or make a macro for start up be sure to name your macro AutoExec. Screen resolution will not change automatically to it original size when closing that database. If...

Take a look at the attachment. hth, Michael

Phil, Take a look at the attachment file. hth, Michael

Trucktime, Nevermind I forgot one item in my query. >=[forms]![FormName]![txtField] And <=[forms]![FormName]![txtField] Thanks again. Michael

My report is running from a query, but I'm not using any parameters because I would like the user to use a pop up form selection to enter the start date and end date. hope it not confusing. Thanks, Michael

I'm having trouble using my start date and end date. I'm using code on command click to open a report from a combo box (which is working). If IsNull(Me.Report_Selection) Then MsgBox "Please Select A Report", , "Form Missing" Else DoCmd.OpenReport Me.Report_Selection...

Try this code in report page header.... Make two unbound text boxes....Control Source for each.... =Form![frmOrderAnalysisServiceSpecific]![From Date - 00/00/00] =Form![frmOrderAnalysisServiceSpecific]![To Date - 00/00/00] hth, Michael

Trucktime, Thanks I appreciated. Michael

I made a pop up form for employees selection. I would like to know is how I can have radio button selected along with date entered and go to that specific report? Take a look at the attachment. I have 3 report to choose from, but I would like run report1 from 1/1/05 to 1/10/05. My Start Date...

Are you using the unbound text box in report footer for =sum([FieldName])? hth, Michael

Jimmy, The vb code below is only filter the selected record displaying in a form. DoCmd.OpenReport "ReportName", acViewPreview, , "FieldName = " & FieldName hth, Michael

Sorry for the delay I got held up at work. Try another way to filter your report by making a query connecting to your report. If you do a search in this forum on filter reports, I'm almost positive you'll find plenty of examples. hth, Michael

Take a look at the attached file. It a little similar to your question, so you can play around with it. hth, Michael