User Profile

Peter99 · Dec 19 '07, 08:26 PM

Why not set up a couple of Public variables at logon time and grab the Logon Id and which menu the logon triggered. You will have this info available until the user logs out and you can use this info anywhere you need to create an audit trail of changes. Remember - keep it simple

Peter99 · Oct 24 '07, 07:04 PM

Thanks - It worked like a charm...

Peter99 · Oct 24 '07, 04:44 PM

Could you give me an example. I can't get the double quotes around the parameter...

Peter99 · Oct 24 '07, 03:38 PM

Its all 1 parameter "99999 Gravel Chev"...

Peter99 · Aug 8 '07, 06:56 PM

Its probably me!StaffCombo

Try something like this

strSQL = "Select * from livepermits Where permit_user_id = ' " & me!staffcombo & " ' "

You can put in a tempory msgbox to check strSQL - the me!staffcombo should show the value selected in the combo box

msgbox strSQL...

Peter99 · Aug 8 '07, 03:06 PM

Try something like this:

Set mdbCurrent = CurrentDb
strSQL = "Select * from [TableName] Where [Field] = SelectionCriter ia"
Set Master = mdbCurrent.Open Recordset(strSQ L)
If Master.RecordCo unt > 0 Then
Do your thing
Else
Append your record
End If

mdbCurrent.Clos e...

Peter99 · Jul 17 '07, 11:50 AM

Thanks, I'd like to use Access as my excel micro skills are very rusty. Can you give me an example of how to code Access to pick the cells I want?

User Profile

Profile Sidebar

How do I get multiple reports in 1 PDF File

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Passing a Parameter to a .bat

Leave a comment:

Leave a comment:

Leave a comment:

Import Specific Excel cells into an Access database