Search results

Rural, Thanks. As usual, you came thru. I added your 2 lines and it solved the problem. However, now that I have the popup form opening I have 2 other problems. First, when msgbox asks if I want to add to list and I choose yes, the popup form opens but displays Access default message that...

I looked at both of them and tried this code bound to the not in the list event but It isnn't reading the "openform strfrm" command. ------------------------------- Private Sub Combo18_NotInList(NewData As String, Response As Integer) Dim StringFrm As String StringFrm = "frm_Doctors"...

I have a form with a combobox based on a query of a lookup table. If the name entered is not found in the combobox, I want a popup form to open allowing the user to enter a record for this new name in the lookup table, then close. What is the best way to this? A command button? The Not in...

Thank you for your reply. I have been studying it and and mapping it out on paper on paper the past few days. I think I have come up with an answer that is not quite what you suggested but is based on your concept. First, I should put my example in context. I used the above example so the...

I have two forms bound to different tables. I will use an example to illustrate my problem. I have 4 people who have each sent me 5 documents. I do not currently know the identity of these 4 people so I can not create a lookup table. In the future they will continue to send me docuements. In...

That did it. Should have looked there first. I was trying to pull a second tab control in. I tried to cut and paste a new control like you would with a field. Tried cutting and pasting an individual page. Thank you.

I read somewhere that you can have more than one row of tab comtrols on a form. I have searched the forum for any threads or posts on the issue but can't find anything. Does anyone know how to do it?

Pat, Thank you for the reply. Let me clarify a few things that might impact your opinion. In this particular instance there would be never be a situation where we we would want a consolidated report. Unlike my other tables where we might want a report of all clients or all cases there would...

Not to beat a dead horse but here is what I am talking about. http://www.access-programmers.co.uk/forums/showthread.php?t=30370&highlight=composite+keys This is my situation. I had a natural number system already in existence outside of the db. This thread reccomends that it is preferable to...

Scott, I know your position on composite keys. I just have a hard time accepting it. Not another person on the forum has told me it is a mistake. There are threads and articles on the forum on how to do it. When I searched the web there are numerous tutorials and sites explaining how to use...

We currently have a spreadsheet to track all of a clients medical's bills and keep a running total? I'm trying to decide whether to continue to track these medical bills in the spreadsheet or create a table and make it a part of the client db. I'm leaning toward keeping the spreadsheet. It...

I see the problem. I don't quite follow your solution. How would the names table with a unique id work. One thing you should know is that I am not using the traditional autonumber PK as my unique id in each table. I reset the autonumber in my clientinfo table to begin with 200501. The next...

Well, It was something easy but I don't understand. When the bound combo first didn't work I made a new, unbound, combo, copied the code, just changed the name of combo in the new code and tested it. It ran fine. Thats when I made a post. After checking your ideas and finding everything...

Enjoy! You earned it :)

I did. I used your code as you wrote it in the new example you sent me. Its working perfectly. Thank you very much. I noticed one difference betwween the two that I'm wondering might explain why I couldn't get it working. In the first one you included 1 query. In the second, you included 2...

Meltdown, 2 questions. First, why are you using unbound textboxes in the defendants form instead of the fields? Won't this prevent me from saving saving me the defendants in the underlying table? More importantly, I can't seem to change the names you used in your code to the names of my...

Thank you very much. Exactly what I was looking for.

I have two tables in my law office db.(for purposes of this question). The first is a clientinfo table which is populated by a clientlinfo form. Then later on I have a table which stores the info on the defendants in each legal case again populated by a form populated by a form. I need to be...

If I have a form and seversubforms in tabcontrols where the relationship between the underlying tables to which the forms and subforms are bound is one to many? In other words, once I enter the data for the record on the main form and go to the subform in the first tab can I enter data for ...

I got it!!!!!!!!!!!! I'm not sure why but you have to use the actual field name and not the arguement reference. ----------- Me.Txt14 = DLookup("Birthdate", "tbl_clientinfo", "(ClientID = " & Me.AAClientID & ")") ------------- Now If I can only figure out why the combobox holds the case...