Search results

This code is from a sample mdb created by Candace Tripp. The database is on her website (http://home.earthlink.net/~ctripp1/) Private Sub cmdClear_Click() On Error GoTo Err_cmdClear_Click Dim fOK As Boolean fOK = ClearClipboardData_clt() If Not fOK Then MsgBox...

Create a query with just that field. Convert that query into an append query. (Click on Query on the menu bar and select Update Query) For Update To:, enter Null. For From:, enter Is Not Null. Run the query.

I'm not sure what fields you have, but this is the way I do it with game lengths. LenGame = DateDiff("n",[Begin],[End]) if LenGame <0 then LenGame = LenGame + 1440 I don't store LenGame in my table since it is the result of a calcuation. I use it in a form (so the user can immediately see...

I've had the same problem with the length of pro sports games. If they start before midnight and end after, I get a minus number. Rather than have my users enter the dates for the start and end times, I trap for the minus numbers. I.e. If [Length] <0, then [Length] = [Length] + 1440 'the...

If you want this to be a standalone program that your users can work with without having Access, you need to create it with Visual Basic, which is a lot harder than creating a database in Access.

I you use a form to enter the parameters, you can refer to the fields in the report. Something like this: [Label that says "Report for" [forms!yourformname!Begin] [Label that says "through"] [forms!yourformname!End]

Do these functions have to be macros? It might be easier to convert them to VBA and set up a Select Case function off of the After Update property of the combo box. (If you don't know how to convert the macros, click tools, macros, convert macros to VB).

RTF files strip the lines. To get an exact copy of your report, you could use Adobe Acrobat.

Do you want to print or see a preview of the report? If you want to print, instead of acPreview, type acViewNormal. Or, if the report is opening in preview, you can print it the same way you would any document, by clicking on the printer icon, or by clicking on File/Print.

In your table, you can indicate that the field should be Indexed with No Duplicates.

I got a report to open in front of a form by adding the line: DoCmd.Maximize after the DoCmd.OpenReport line.

I'm assuming you've selected the current record using a form. Put a command button on the form. If you use the wizard, it will ask you what the button is supposed to do. Tell it you want to do a report operation, then print preview. Then follow the wizard prompts until you are done. When the...

I put a command button on the form showing the record and limit the output in the On Click property. This is sample code: DoCmd.OpenReport "yourReportname", acPreview, , "[UniqueIdFieldName]= forms!yourFormName!UniqueIdFieldName]" That tells it to open the report in preview mode and to show...

Add this line after the code that opens the report in preview mode: DoCmd.RunCommand acCmdPrint

This code sets the calendar date to today's date: Calendar.Value = IIf(IsNull(cal), Date, cal.Value) Sorry, I don't have experience with a diary.

You use the DateDiff function. In the text box where you want the duration to appear, enter this: =Datediff("n",[Start time],[Stop time]) The "n" stands for minutes. "s" is seconds, "h" is hours. You can find the complete list under DateDiff Function in Help.