Recent content by bgmiller

The problem is, this opens up the users to be able to do anything on the local computer...install software, access settings, etc. I want to try to avoid this. Any ideas?

I know this is a forum for how to use access, although I thought since everyone uses it, you may be able to provide some help installing it. Here's the situation: I'm doing new installs of Windows 2000 SP3 and Office 2000 Professional SR1 on a bunch of computers. Under Custom install for...

THanks. I discovered the Problem with the multiple EmployeeTypes in tblPaperwork when making some moch-up tables. I also added a date field like Pat.... we must have been synched! I ended up with: tblEmployee - all employees - EmployeeID - EmployeeTypeID - etc... tblEmployeeTypeOptions- all...

I have an HR database that lists all Employees. Different types of employees require different kinds of paperwork to be turned in. And like any organization, additional paperwork and requirements are added and subtracted constantly. I currently have all the Employees in one table by ID...

?Sloppy solution I found one answer on another message board that says, make a decoy copy of the employee database on your local machine that matches the path on the host server. My host path is D:\FTP\thissite\Database\ D: drive is the CD on my local machine. I burned a Cd with the employee...

I was working on a timesheet database myself and ran into similar problems. It sounds like you want to group the values by week. Option 1. Setup a table in between Employee and timecards that will serve as the timesheetID for each week: tblEmployee - EmployeeID - LastName - FirstName -...

Need local mapping on host linking the databases using //server/database/... would work fine on my local server, although when I upload both databases to the host server, it requires a path of D:\FTP\thissite\Database\... to find the linked database. Would I be able to link using DSN?

I have a timesheet database and a Employee database. The timesheet database uses the employee database for information on making timesheets. The timesheet database runs on our web host. The employee database is constantly updated locally with new employees or changes and uploaded to the web...

Duh! But that's too easy, I'd rather make it complicated..:) I guess thats what I get when I think too much Thanks

I have a tblPaychecks with all the paychecks for each perioddate I have a tblCompensation with compensation records for each employee. Both can connect on the HireID The tblCompensation has multiple records for each HireID with effectivedates. I want to lookup the latest compensation record...

Thanks, Works like a charm!

What about Combo Dbl Click to Edit I prefer to use OnDbl_Click on the subform's combolist to open the edit form. What can I do then for launching the requry command when the edit form closes? I've tried gotfocus on both the subform and combolist with no luck. Thanks

Object not supported Thanks for the reply Rich The real names of the forms are as follows: Subform1= "frmContactSelect" ComboList1= "ContactList" I made a command button in frmContactSelect to test it and assigned the following to the Onclick event...

I have ComboList1 on Subform1 that is located in both Parent1 and Parent2 forms. The record information in ComboList1 can be edited by clicking a button on Subform1 that opens EditForm1. After changes are made, the record is saved and focus returns back to the ComboList1 on Subform1 I have...