Search results

Can anyone help me in creating a field from a query which will pull the first word only from a specific field. Thanks.

DoCmd.OutputTo acOutputQuery, "ADMINQRY_test", acFormatXLS, "C:\TEST.xls" MsgBox "Your Report has been output to the path below" & vbCrLf & vbCrLf & "C:\TEST.xls", vbOKOnly This is quite good as it tells the user where the report is..

You can always try something similar to below: If Me.listbox = "test1" Then Me.Comments.Value = Me.Comments & " test1" Else If Me.listbox = "test2" Then Me.Comments.Value = Me.Comments & " test2" End If End If You can obviously extend this to as many as is in your list box.

Are you trying to populate a memo field with the value that is in your list box?

If anyone needs more information to help me with this let me know.

I've used the attached module along with 2 Macros: '------------------------------------------------------------ Function mcrHide() On Error GoTo mcrHide_Err Call fAccessWindow("Minimize", False, False) mcrHide_Exit: Exit Function mcrHide_Err: MsgBox Error$ Resume...

I found this module some time ago and has been used in most of the databases I've created since. This will calculate the time diff (currently set to minutes) between 2 dates, it also removes the time between 5:00PM and 9:00AM so only calculates the time during the working day. With the use of...

I have a database in Access 2003 which is currently in creation but keeps getting errors and changes a records font into Chinese symbols. The 'corrupt' record also jumbles the fields around so the text that doesn't turn into Chinese font is in a different field completely. I've gone through...