Search results

Is there anyone out there who can guide me in setting up some security on a database as follows: Four levels of security each having different security permissions in the database: 1. SuperUser full access 2. Report Users with access to own timesheet records and all reports 3. Approver Users...

I'm not sure how to do the call to the database to get records between JanPrev - October for example

I have a form that the user can choose a date range, but the 'to date' field and the 'from date' field are dropdown boxes that contain the following: NovPrev;DecPrev;January;February;March;April;May;June;July;August;September;October;November;December;JanNext;FebNext. There is a filed called...

Works Great Jacob! Thank you very much!:)

I get an error "You can't calculate totals on the asterisk (*)" I have selected all of the fields.

Would I put it in a query or in VB code in an event? (The group by)

I have a table that has a field called "telephone" and another field called "Creation_date" I want to be able to check first to see if there are duplicate phone numbers and if so I want to only show the record with the latest creation_date on my report. Any ideas?

I have two listboxes (test1 and test2) and 4 buttons (add item, add all, delete item, delete all) I want the user to be able to select all items and click "add all" and the selected items to jump to the second listbox. I have it working for add item, delete item and delete all. The "add all" is...