Search results

I think this is an easy one... I have two tables - one is a Master. I want to delete the records in the Master if they are in the second table. Here's my SQL and I can't get it to work: DELETE from TestMaster INNER JOIN on JoinedDupList ON TestMaster.ID=JoinedDupList.ID WHERE...

I have a form that has several fields that a user will enter data. When finished, the data is inserted into a table. Works great. What I want to do now is look at one of the fields entered and if it is equal to a certain value, I want to disable one of the other text boxes (fields) on the form...

I have a table (Master) that contains columns such as MsgLocation, MsgName, MsgScript, and MsgTxt. I want to create a form where the user would have an area to type in a 'string' and when they hit enter (or select a button), a (background) query would execute a lookup on master "where MsgTxt...

I've looked at many of the posts that already address this issue... but am still struggling. I created a form (AddrChg) with New address information (stored in AddrChg table). On the form, the user will be required to select a county (County table) from a list box (County table - has three...

There is an Access 97 Report that gets ported over to Excel. When the Excel sheet opens, soem column heading have the correct label and other columns have "Text55" or "Text29", etc. First, how do the Excel columns get the "headers" and second, how do I change the "Text" headers to meaningful...

I have a table - apparently two users were accessing the same record at the same time (someone turned record locking OFF). The record now has #ERROR in some but not all fields of the record. I ran a REPAIR but nothing happened. If I try to access the record using a query, I get error messages...

Can someone help me please... have a database, users enter/update the data using forms. I had two users that tried to update at the same time. Two of the fields show "#Error" in them and when you try to access this recird you get a message "The Microsoft Jet database engine stopped because you...

I have a database that contains change requests from users. Each change has an associated design document on our network (MS Word docs all in same directory). I want to be able to somehow link each change request with the associated document. Maybe by using a dropdown and showing the list of...