Search results for query: *

I have three tables I need to compare and if differnt then update. Table1 compares to table2 if differnt then update and it works. Table1 compare to table3 and I get nothing. Any ideas

I had a working database that would check to see if the person was trained in an area and also any available personal information stored. Now I want to change some code but for some reason VB/Microsoft can't find one of the forms. It's there I can see it but the form name has changed. anyone...

This is really weird but the Me.Function in my database has stopped working. The database ignores in completely can anyone tell me how to fix this.

I have a database that is supposed to attach the Network user name to the record using an API script when the record is new. However, it does not seem to be working. can anyone give me some help with this?

Have two forms with separate tables behind each. have code that will take unique id from Form1/Table1 check to see if there is a like number on form2/table2 and if not add a new record. the problem is that when the code runs I have one more record showing on form2/table 2 nav buttons then...

I have created a database to show employee's personal information, what training they have had and any certifications they may have. I have three tables Contacts, training and Accreditation. I have three forms again contacts, Training and Accreditation. I need to show a record on the contacts...

Have a form that has controls to lock the form and unlock the form for editing records. however, the list box on this form needs to be unlocked at all times and searchable. If I put this list box on a subform tied to the main form will this keep it from being locked when the CMD button is...

I need to show on a map all the places based on a form in an access database. This is a new one for me since I have never worked with maps in access before.

I was helped yesterday in locking the form so an enduser could not update the record. Now I need to know the best way to lock only certain fields on the form while allowing others to remain editable. I am thinking a subform will have to be created with these fields or possibly setting the focus.

I have a form that the user would like to be able to turn on and off the ability to edit. I have tried the properties window but it locks the whole form. Here is the code I have tried but the trigger is not working to activate the code Private Sub cmdEditform_Click() Form.AllowAdditions =...

I have a combo box on a form called last name. I can pick people from the combo box which brings up that user and all their information. however, when I try and add a new record the combo box retains that last user I looked at. how do I set this combo box to default to null on a new record?

I have a combo box that needs to default to a new record when I push the new record button. Right now the combo box sort of does this but it retains the last selected name.

I am trying to created a searchable feild on a form I have created using Access 2003. I used the wizard to build the combo box. however, when I click on the combo box t select a record it only changed that field. how do I get the form to use the combo box to select the whole record?

I have been out of the access programming for about five years. Now I am having to use those skills again and they aren't comeing back as fast as I like. How can you make a field on a form searchable. I thought there was a way you could tell the field it was a list box and have it allow you...

have a microsoft scrolling mouse. whenever I place the pointer over a desktop icon the icon looks like a bar code how do I fix this?

I have a form based on one table and need to have a text box based of a different table. I have tried =[Forms]![Personal Data]![FName] & " " & [Forms]![Personal Data]![MI] & " " & [Forms]![Personal Data]![LName] as the control source but it's not working I get the #Name?. how can I get this...

I need to make sure that a name is selected from a list before a form will open. The enduser will pick from a list on the Main form then click on another button to enter the rest of the data in a different form. how do I make sure the user selects from the list?

Inherited this new database and found on the Main form a procedure I am unfamilar with. Can someone help me understand where this is located? Private_sub Option32_gotfocus Call SetInstruction ' this is the problem area End procedure