Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TomDuCrosbie

    I have a form for entering and view

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

    I have a form for entering and view

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

    I have a form for entering and view

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

    Me.Requerry not entering data into table w/o closing form

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

    Me.Requerry not entering data into table w/o closing form

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

    Creating

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

    Creating

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

    DAO beginer having problems with access front end and SQL back end

    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".
  9. TomDuCrosbie

    DAO beginer having problems with access front end and SQL back end

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

    DAO beginer having problems with access front end and SQL back end

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

    Problems setting a paramater for SQL stores procedure with code.

    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?
  12. TomDuCrosbie

    Problems setting a paramater for SQL stores procedure with code.

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

    Problems setting a paramater for SQL stores procedure with code.

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

    Problems setting a paramater for SQL stores procedure with code.

    Unfortunalty the space leaves me with the same error.
  15. TomDuCrosbie

    Problems setting a paramater for SQL stores procedure with code.

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

    Problems setting a paramater for SQL stores procedure with code.

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

    Problems setting a paramater for SQL stores procedure with code.

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

    Problems setting a paramater for SQL stores procedure with code.

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

    Can't get out of a subform in datasheet view and back to main form

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

    Problems setting a paramater for SQL stores procedure with code.

    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?

Part and Inventory Search

Back
Top