Recent content by Robert M

Thanks for your replay jdraw and SpentGeezer. However, I have solved the problem. It was not a query I needed to set but a form. What I have done is create a Form within a Form with the Master and Child links being [Address 1]; [Zip]. The Main form has the fields [IDNum], [Address 1]...

I have been working on a query to list all the people that go to the same address. I works pretty well, however I come accross addresses that have a suite or apt number that is included with the other addresses. I.E. Joe, 1st St, Apt b, Anytown, ST, 99999-9999 Flo, 1st St, Apt b, Anytown...

Solved It! The form was using qryFullListing to get all the fields in all the tables filled. What I might have done was not have all the pointer fields in the qry. I removed all tables for that qry, then reloaded the tables making sure all fields in all the tables, including the pointers...

Thanks for your help pr2, I'll double check on that and post it back on this forum.

The form was working fine when I had the Client and Address in two seperate tables. However, on merging the two tables into one, updating the quiries to reflect the single table as well as having the form in question Data pointing to the table. I am now no longer able to add anything to the form.

I had two tables, one for Client Names. One for Client Addresses. Since I have found that Client Addresses can change from time to time without affecting the other Client names with that Address, I merged the two tables into one. Now my Data entry form is not working. What have I done? Thanks...

Thank you for your Suggestion boblarson. I did not take that route because I am not having difficulty with getting my pointers agreeing to one another. I.E. RecNum = RecID. My problem was getting the correct RecNum assigned to the RecID. I have solved this problem by changing out my RSEmp...

I have a program that is supposed to take the new name entered into "tblNames" and copy the "RecNum" of the "tblNames" to the "RecID" number of the "qryStationsUnused_636" Recordset. It does copy the "RecNum" to the "RecID" but to the wrong Name in the "tblNames" For some reason it is not...

Thanks boblarson for helping me out once again. Took me a few read throughs to get the idea. But I believe you are saying one table/Query for form. other table/querry needed I would use a Combo box to load the data. Ok, I might have muddled it up in trying to relay what I am needing but I'm...

Clients has 4692 Records and Address has 3645 Records. The relationship between the Primary and Foreign key is the number both have. I do have Filters, Edits, Deletions and Addittions all set to Yes. Data Entry set to no, but that did not make any difference when I set it to yes. Here is the...

For some reason, I am unable to add records to my sub form I have a two tables tbl Address tbl Clients I have many clients to a single address "Master" tblAddress.AddID (primary key) to "Child" tblClients.AddNumm (normal field) Both are "Number" style I have tried "Data Entry" "Single Form"...

Greetings Beetle. My hobby is solving Cryptoquotes in my daily paper, that is where the editor(s) of the puzzle take a famous quote and substitute one letter for another. What my ultimate goal is to get a instants count of 1,2,3, and 4 letter words as well as double letters. At present I do...

I use recordsets as that is what I learned in my self teaching and help from others. And yes I ment tables. Sorry about that. I'll study and work out what Isskint and spikepl suggest when I understand how it works. Thank you both for your help with this matter. I'll post here to let y'all...

I am developing a program that takes a length of a word and depending on the length will enter the number of letters in the word into the "LtrCode" Field. However, in running the program, it works well until this point. WrdLen = Len(Wrd) MsgBox "WrdLen = " & WrdLen 'I am able to get the...

True, but I'm sure some mad scientist is working on just that problem. Till then, we can only control our desires to take a sledge hammer to the system.