Search results

I guess can someone explain what matching means here. We are comparing people on some government lists to our employee list here. I guess one list will be coming from our system and one from each web sites. HR will be setting up the Excel files for importing to Access. So about 5-6 tables. A...

Confused on how table works. I am trying to add instructor ids to an exisiting database that an outside company built years ago. So I added an Insructor ID field to what I feel is the correct table and created an insrtuctor entry form. Probably less than half of the Instructors that are in the...

I have been asked to make some modifications to a database an outside vendor built years ago for CPR training for a department here at our hospital. I am trying to figure how everything works because its a complex built Access db. Its a linked database with the data part sitting on the network...

I built this db for our HR department. When I met with them about the reports one of the ones they wanted was based off the 8 Licensure/Certification fields and the date fields associated with them. They need one report that is going to list the Licensure/Certification and the expiration date...

I built a form in Access 2007 today and when I look at in Form view part of the Form is hidden so you cannot see on the screen. If you use the scroll bar on the right you can see the rest of it. I don't remember this issuing occurring in older versions of access.

In the database I am working on in a college course for a project with we have many tables like Employees,Products, Sales, and Sale Line Item. One of the requirements was to create a form that had the Sale information(which I did lookups to other table fields to allow them to populate the...

I tried this in an unbound text box but it keeps giving me a missing ) =(((Sum([ProdUnitPrice]))-(Sum([ProdUnitCost])))/Sum([ProdUnitPrice]) Basically (total UnitPrice- total Unit cost) /Total Unit Price

A co-worker built a data access page as part of her database. When she tries to view it in Access it brings up the window saying data provider might be unsafe. the html file is not saved to a web server just her network folder. Also I tried to open the Data Acess Page html seperately by...

I set up a query originally to run by entering a employee name and a date range. I recently added another parameter to run it by employee id. I put that on the or line. Problem is that runs the query by the id field itself. I need to have it so I run it either: ID and date range Name and date...

I built a query that in turn is used in a report. The users of the database would like the option to run the report either by name or employee number along with a date range. So I added the field for Employee number to the query using Where in the total row and placing [number:] in the or row...

Hi, I have a user who would like the value from the last entry into the form's title field text box to show as the default value when he clicks on enter new issue button to bring up a new record. I do not know if this is possible but I thought I would check for him.

I have been trying to help a user calculate elapsed time. I referenced the GetElapsedTime from the following Microsoft article http://support.microsoft.com/kb/210604/ It displays ok on a form or inserting on the detail in a report like it suggests but the user would also like to total up the...

Hi all, This a general question but how much can each element(cell) of an array hold. I use them for VBA and word automation and I parse per carriage return and noticed that a paragraph's last three sentences got lopped off by the array cell when the data was put into Word. It was a pretty long...

I read the dialogue between ghudson and bikeman77. I decided to follow the route that microsoft suggested which was to use a macro to execute the form. Problem is I don't think it launch the form because it went past five minutes and didn't shut the datbase down. The way my database works is...

I found some code to delete those import tables from the Microsoft site. I think if I put it in a Macro I can run anytime I click on it. I need it run automatically eveytime before I exit the database. Anyway to do this?

Question about validation rules. I have a user who has set up a validation rule to allow certain values to be entered. Something like if the value equals 4 or equals 5 then it would accept it. Now she would like the validation be set so they can put both 4 and 5 in together. How can this be done?

When I am on my entry form and use the scroll wheel on my mouse to scroll down the form it scrolls through all my records. I do not want this happen especially if other users are the using the db. They could be making changes and do this and accidentally edit someone elses record!! :eek: I...

Hi, I am using word automation to transfer info to Word documents. Two of my buttons for some reason when a user brings it up on XP in Access 2003 for some reason do not work. I can get it to work on my 2000 machine just fine in Access 2000. All my documents have bookmarks and open with the...

Ok I used the premise of capturing the current date in the afterupdate event of the form based on a post. Will this capture the date when the form was modified or the record. Because I exited out of one record on my entry form back to my lookup form to select another record,edited that one, went...

It was suggested in one of the posts to use the following code in Form Current event to disable all the fields on a form of the current record so when I click on the yes/no field it would disable the fields if yes or enabled if it was changed to no and stay that way unless clicked on again. I...