Search results for query: *

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

I did double check and the querry is the record source for the report. And I also have MS DAO 3.6 object library already connecrted as a referance.

The stored procedure ReferralResultsMailReport is a passthrough query to MS SQL Server 2000 and it is the record source for the report. I'm trying to have the input ReferralID to pass to the querry so that it only pulls the info that is showing on the form

I have upsized the DB to MS SQL. In the process, it changed all my queries in access to either View's or Stored Procedures.

i'm stuck in my subform. I have a subform in datasheet view. When I enter data in the next line, I can't get out of the sub form and back to the main form unless I press ESC. The subfrom has an after update event that I know is the problem, as it didn't do this before i added it. This is the...

I'm still geting the same error on the same line. It sounds like one of the variables I've declared isn't set. any idea which one I have to set to something?