Recent content by TomDuCrosbie

I'd already taken look at that article too. That solved the problem only part of the time. What I found out is i have a search form that opened the main form inserting a where condition on the opening. So if the form opend blank, the forms filter read "ClientID =" so when a client...

Here's the set up The form displays customer info, with a sub form displaying the spouses info (customer and spouse are saved in tblContact each with their own ClientId and their SpouseID = their spoused ClientID). On page 2 there are 3 tabs each with subforms linked to the main form by...

I have a form for entering and viewing customer info. Once the customer's name is entered, there is and after update event to create the ClientID. There is an After Update event for ClientID Me.Requerry . I had the understanding that this would make the data show in the table, so when...

John I tried the DoCmd.RunCommand acCmdSaveRecord and I get the same error. I forgot to mention in the origonal post I'm using Access Project and Microsoft SQL Server 2000. Does that make a difference? Tom

I have a form for entering and viewing customer info. Once the customer's name is entered, there is and after update event to create the ClientID. There is an After Update event for ClientID Me.Requerry . I had the understanding that this would make the data show in the table, so when...

Thanks for the advise. I think I'm just going to rebuild the whole thing. There isn't very much data in it, since it never really worked, people didn't use it much. Whoever put this thing together the first time didn't do a good job. the whole thing is wierd. Thaks for the input though

Ok, this is probably pretty simple, but i need a fresh perspective on it. My form has 4 tabs 1st is customer profile, 2nd contacts, 3rd accts, 4th, competition accts. The subforms on the 2-4 tabs are bound to their own tables. They are all related by ClientID. Here's the problem: A user...

I put the paramaer in the Stored procedure, and it still is comming up with the same error on the same line. I should have said also that the stored procedure is the record source for a report that is emailed to the name in Customer."Referred to".

I believe that ReferralResultsMailReport is a passthrough querry on Access to a stored procedure on SQL (I'm just learning about this hole upsize thing) This is the querry: Alter Procedure ReferralResultsMailReport As SELECT Customer."First Name", Customer."Last Name&quot...

I have an application with an Access project front end and a Microsoft SQL server (both are 2000 versions) backend. The backend was recently converted to SQL using the upsizing wizard. I had this DAO code that worked prior to the upsize, now it doesn't work. Dim qdef As QueryDef Dim...

Ok, I have a question. In stead of assuming that everyting is on the access front end, how would I change it so that instead of using CurrentDb I'm calling the SQL DB?

I've been banging my head against this for about a week so I'm going to ramble for a minute to clear my thoughts. Maybee it'll help point someone in the correct direction. I used the upsizing wizard to convert the backend to MS SQL server 2000. The wizard converted the queries I had in access...

sory o'hara, same thing object variable or with block variable not set

Unfortunalty the space leaves me with the same error.

Here's what it came up with ----------------- References found ----------------------- broken = False path = C:\Program Files\Common Files\System\ADO\msado21.tlb broken = False path = C:\WINNT\system32\stdole2.tlb broken = False path = C:\Program Files\Common Files\Microsoft...