Search results

Windows XP Home and Access 97 Hi, I thought I would float this thread a post because Windows Xp Home and Access 97 seem to be playing Palistinians and Israelis on my computer right now. If anyone would like to comment on this situation it would be great. Thanks, Pookatech

The Solution Hey Doc Man, Thanks for the reply. I restarted this post in the query forum when I saw that it was heading in that direction. Here is a link to that thread. http://www.access-programmers.co.uk/forums/showthread.php?p=306869#post306869. Pat answered that post just a while ago...

0 as Default Hey Pat, The defaults were the problem. The default zero in the prospect table would override the Renewal's key that had been automatically entered; this would happen at the time the prospect info was entered. Of course the opposite of this would happen if the prospect info had...

Thanks Pat Hey Pat, Thanks for the reply. I had tried defining the fk's as Pk's and the relationship was being seen as a one to one. I will try setting the defaults to nulls and removing the fields from the queries though. The query was adding the records to the appropriate tables it was...

[Sigh] Thanks for the reply. I am actualy pretty skilled with access and was just wondering why this problem occurred and if anyone knew how to stop it from occurring. I will think about the subform idea but I am leaning towards just having two seperate forms. Subforms are great for one to...

Hello Everyone, This is a D#$% wierd problem/glitch. So I have three tables: One with common information for quotes, One with information that is only for new prospective quotes, and one with information that is only for renewal quotes. So when a quote comes in it will always have info in the...

Referential Integrity Hey Doc Man, I tried the operation with and without relationships and with and without referential integrity set. The idea would be the common table with two one to many joins linking the other tables to it. Of course the one to many's are both off of the primary key...

Rethinking Three tables Hi Guys, I am back after some thinking. Here is what I have. Let's pretend the world was going to end if I did not use a tab control for the prospect renewal info on my form. Therefore I need the prospect and renewal info in one recordset. As you will see in the...

Thanks Hi Guys, First, thanks for the replies. I should have asked the question a little more carefully, but the question is answered. Doc Man, your answer hit more to home. It seems that everyone agrees that for a quoting event there should be the common table and two seperate tables. I...

Hello everyone, I am creating a database that will handle insurance quotes. There are two types of quotes, proposals and renewals. The quotes contain much of the same information: time tracking, group demographics, etc. Furthermore, renewals and prospects are both reported on in the same...

Thanks Hey, Thanks to everyone for posting back to this thread. A quick search and this was the first thread that showed up and is definitely going to save my A$$ tomorrow. These forums rock because of the people on them! Pookatech

A chicken and an egg are in a shady motel gettin it on. After 10 minutes the chicken gets off the egg and lights a smoke. The egg then turns to the chicken and says, "well, I guess that answers that question." Pookatech

Hello Everyone, The problem is simple. I have a user group account secured database. When some of my users try to open the database the logon comes up but they can not type in the logon box. When they cancel the box and reopen the program they are able to type in the logon box and go about...

Pat, Thanks so much for your help. Indeed the problem was that the Win 2000/Excel 2000 computers have Microsoft Excel 9.0 object library instead of Microsoft Excel 8.0 object library. When the 2k computers open the program the computer automatically selects the 9.0 library, but in the process...

Hello Everyone, I am using A97 and am having a peculiar problem. I have just secured a database using group and user level security. The secured copy works fine on computers with Windows NT, but computers with windows 2000 are getting an error while running a query. The error is Run-time...

Wow smoked, looks like Pat has the right answer on this one. I didn't realize you could reference columns in a combo as such. I'm sure this will come in handy soon. Thanks for the correction Pat, PookaTech

Hello, I have a question about the process being used. From time to time I want to look up values in a table I use Dlookup. I can imagine that it could be used here too. I am wondering if the sql approach suggested here is faster. Is it usually faster to use sql to find a record and then...

If I understand you there are two ways to do this. One, Make the control source for your text box: Dlookup("OrgNameFieldhere","tblOrganization", "[OrgIDFieldName] =" & Combo2.Column(2)) You will need to enter the field name where your org names are and the field name where your orgIDs are...

Thanks Fizzio. Now my question becomes: Does anyone know any VBA that can do this or do I need to use something more advanced like API? PookaTech

Hello Everyone, All I want to do is right allign the text in my combo box list. I know how to right align the actual box but not how to right align the list that drops down. I am using A97. And yes I did search the forums and help files for this. I thought it would have been answered...