Search results

Great, glad it helped. Paul

Function openoutlook() Dim txtTO As String Dim strValue As String Dim strName As String Dim strMessage As String Dim frm As Form Set frm = Forms![Work Order] txtTO = frm![emailaddress] strMessage = frm![FirstName] & ", the Work Request you submitted " & vbCr & "'" & frm![Nature of work to be...

Stuart, to get the Count of Date Enquiry Received you should be able to use a textbox in the Report Footer with the Control Source set to =Count([Date Enquiry Received]) replace [Date Enquiry Received] with the actual name of the Textbox on your Report. To get the number of Null Date...

Which way don't they fit? Left to Right or Top to Bottom. If it's left and right, the first thing I would check for is a line bleeding over into a second page. The easiest way to make sure it can fit the page you need is to open the report in Design View. Then drag the right hand edge to the...

In the AfterUpdate event for your combo box, you could test to see if "Other" was selected. If it was, you could open another form that would handle the information related to Other and store it in a seperate table. In the mean time, the original selection would be stored in the table...

Bluez, It shouldn't need any special library or anything. It's just an SQL statement. Can you post your complete code so I can look at it. Also, what version of Access are you running? Paul

You can try this in the afterupdate event for your field(s). If any information is changed, it writes the four values to the table tblPrevAddress. Private Sub StreetAddress_AfterUpdate() Dim frm As Form Set frm = Forms!YourFormName Dim strSQL As String strSQL = "INSERT INTO tblPrevAddress (...

As I said, the best thing would be to play with the function a little to see if it does what your looking for. As for the 1.1, Format("1.1", "0000.000000000000") would return 0001.100000000000 Basically it would always have 4 whole number digits and 12 decimal digits. If your whole number...

You can try playing around with the Format() function. It would look like this: Format([FieldName],"0000.000000000000") This gives you 4 digits before the decimal place and 12 after. If you need more flexability than that, you will need a custom function to accomplish what you want. Paul

Thank you Jon. My data had consecutive dates so I didn't notice any descrepancies. Adding the second Where statement does provide a more accurate return where your dates are not consecutive. Paul

H. Take a look at this thread. http://www.forumco.com/jmhare/topic.asp?TOPIC_ID=526&FORUM_ID=13&CAT_ID=13&Topic_Title=Keeping+the+Riff+Raff+out&Forum_Title=Security+Category It has a couple of solutions. Paul

Well done Jane. You'd be surprised at how many people couldn't get past the first query let alone work out something different in the second one. Paul

You could add another field to the query underlying your combobox. NewField:Mid([FieldNameHere],2) And then sort this field Ascending. That might do it depending on what the exact values in your Text field are. Paul

Not easy, but not hard. Here is the SQL for two queries. You will need to change the table names to match your table name. In this first query, I add tblBilling to the QBE grid twice. When you add the same table twice, Access automatically adds the _1 to the name so it can differenciate...

Ctl + Semicolon inserts the current date in a field (at least on my PC). Ctl + Shift + Colon (which is the only way to get the Colon) inserts the current Time, Ctl + apostrophe copies the value from the current field in the previous record to the current field in the current record, and Ctl +...

Microsoft doesn't go out of their way to make the error messages relevant to the problem either. That particular message covers a multitude of errors that don't bare a lot of resemblance to each other. Glad it helped. Paul

You Dim your form variable but you don't set it anywhere. Dim frmInputSeatUsage As Form You need to add Set frmInputSeatUsage = Forms!YourFormNameHere That should clear your error. Paul

I don't really understand exactly what you have for reports. At one point it sounds like you have one report and then all of a sudden you are saying (therefore two reports). Are you talking about seperate reports or mulitple records in a single report. The first thing to check is the address...

Here's the revised info if you want to try it. The application is called Task Scheduler and you should find an icon on the lower right side of the Task bar. Double click on it and fill in the boxes based on the example below. In the Run box, you put "PathToDatabase"/xMacroNameHere and in the...

If you are using Win98, NT or newer, you can use the built in Scheduler to do what you want, and Access can be closed. It will open Access and run the Report. To accomplish this, you would create a Macro that Prints the report you want, and then use a Command line switch to run the Macro...