Code:
Private Sub Form_Open(Cancel As Integer)
Static MouseHook As Object
Set MouseHook = NewMouseHook(Me)
End Sub
Patrickwwevans
Last Activity: Apr 28 '14, 08:13 PM
Joined: Nov 15 '13
Location:
-
I hope you can say you have already googled for this little snipit but I found this on the first try. Give it a shot and see what happens.
-
Hmm pretty vague question to go on however (and this is shooting in the dark) I would try a table based look up process.Leave a comment:
-
I think I would concur with the last response if it is true you have separate table for each doctor. Fundamentally, I think what you are trying to do is this: Based on a test, provide a specific percent value to a doctor where for each test, the percent can change.
If the above business problem is stated correctly, then I would think you would need the following. First and obviously a table for the physicians where you have a unique doctor...Leave a comment:
-
Here is the sql statement based on those two tables. I set up the first exactly like you have it. The second table, the Assignee table I assume would be a "person or people" table and have a unique ID for each person and then stuff like name, etc.
[code]
...Code:SELECT tbl_Seating.TableID, tbl_Seating.Tablenum , tbl_Attendee.AssignID FROM tbl_Seating LEFT JOIN tbl_Attendee
Last edited by zmbd; Nov 25 '13, 03:17 PM. Reason: [z{Fixed the code block. Please select the text, then Use the [CODE/] formating button.}][z{Stepped the SQL for easier reading}]Leave a comment:
-
This should be pretty easy by using a query for your data source on the combo box / drop down. Just use the event After Update to do a me.ComboBox.req uery for the combo box of attendees. SO the query feed the combo box has the criteria where their ID is NOT in the table for folks selected. You could do this with an outer join from your main table that gets the Table number and Assignee number then on the Assignee to Assignee ID do where is null...Leave a comment:
-
Just curious but is there a reason you did not build a query to resolve this in MS Access? I ask since using the query builder usually gives you a very usable sql statement and you can refer to objects on the form easily by use of criteria builder.Leave a comment:
-
Here is how I have done this before. First make sure you have the code below to know the windows / AD id. Then set up your table where there is an userID column (varchar / text) then date / time column and then a Type column for either Start or End.. then you have a form on start up that on open, goes to a new record and all they have to do is click either a clock in button or clock out button. The vba code behind each will update the form with...Last edited by NeoPa; Nov 15 '13, 05:47 PM. Reason: Please remember ALWAYS to use the [CODE] tags when posting code.Leave a comment:
-
vba code for taking an MS Access attachment pdfs save locally
Hi, I am migrating someone else's MS Access db and have a couple thousand records where they have an attachment data type saving a PDF file - in the table. So I am looking for a procedure or loop command on a form to run through the table and save those files on a shared drive. Ideally I want to be able to use the ID of my new table for part of the file name. Any help would be appreciated. Using MS Access 2010 on windows 7 environment. Than...
No activity results to display
Leave a comment: