Search results

Worked like a charm... THANKS!!!!!!!

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'm gonna let you look.... Good morning - TGIF for sure! Before proceeding, I want to let you know I am truly grateful for your help on this! You've been really patient with me... thank you! I think the error (#Name?) is becuase I when I defined the ControlSource for the SearchPane form (where...

I'm gonna let you look.... Good morning - TGIF for sure! Before proceeding, I want to let you know I am truly grateful for your help on this! You've been really patient with me... thank you! I think the error (#Name?) is becuase I when I defined the ControlSource for the SearchPane form (where...

Getting closer... Well, I'm getting a little closer. Now don't laugh but whatever change I made now has values appearing in my text box on the SearchPane instead of the new form (SearchResults). And I get the message you see in the attached doc. I tried changing the data source for the...

Ugh! Okay - I added a text box, added the query name to the "after Update" event and created a simple macro to open the new form - put that on the "enter" event. Now bear with me... I am clueless right now.... when I type in the word "Welcome" (which will be found in several MsgTxt values) and...

Another question.... Dave - thanks! Okay... I understand what I need to do with the query (actually I already added the criteria) but not sure what kind of control I should use. I need the user to be able to type in a string and hit a button (or something) and have the query reslults returned...

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...

Woo-hoo!!!! Got it to work!!! :) :) :) :) SJ McAbney......... Thanks so much... and thank you for the examples which made it REAL easy to change.

So does this mean I will have to check each county number? (There are 99 counties.)

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...

not sure what you mean... by split the database?

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...