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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dpelizzari

  1. dpelizzari

    iif else in query not exactly returning the right results

    thanks, r937, a second set of eyes always makes it easier!
  2. dpelizzari

    iif else in query not exactly returning the right results

    I have never tried this before, but I was asked to create a calculated field based on information in a query. basically, if a field is blank, then select another field, if that field is blank, select a third. Here is what I wrote: IIf (LEN( [Remedy Budget])>9 , [Remedy Budget], IIf (LEN...
  3. dpelizzari

    Conditional date filter Access 2007 form?

    Thanks, PHV! quick, easy, and I should have seen that. You deserve the star I gave you.
  4. dpelizzari

    Conditional date filter Access 2007 form?

    I have built a form that filters data between two dates (start date, end date) as well as another criteria (site code). If the user puts in the start and end date, they can retrieve all records in that range, however, if they leave the date fields blank, they get no records returned. What I...
  5. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    Prulite, not sure how this applies to the original posting, but... can you elaborate on the error at all? Can you get exclusive access to the database in Access 2007 and see what process is failing? I would suggest making a copy of the database and tinkering with it to try to figure out what...
  6. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    Well, I actually took dhookum's advise, and beat my head against the wall until I figured out how to do a form/subform. This is doing exactly what I wanted (so far). Thanks again all for your help!
  7. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    you lost me, PHV. Backing up, I created this second table (ISD_Lease2) to capture user input while leaving the asset data (ISD SACD1) alone. Since the table ISD SACD1 is purged and recreated, we wanted to keep the user input data in a second table, and link them based on serial number and part...
  8. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    The reason the current primary keys aren't a 1-1 is that the ID field. You did however lead me somewhere else. I found that in the table ISD SACD1, there are null values in those two fields. Is it possible that since I am trying to join on those tables, and they are null, this is causing the...
  9. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    I added both ID fields, and get the same results when attempting to update. note, the ID fields are not equal.
  10. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    the two tables to not share a common PK. This could be accomplished by concatenating the serial_id field and prod_id fields (sadly, the vendor doesn't believe in a unique serial number for their hardware, so we need to manufacture one using the serial number and product ID.)
  11. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    the primary keys on both tables are ID, which is a unique sequential number, different in both tables. Should the PK be changed to epserial_id & epprod_id?
  12. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    yes, Access shows the PK on both linked tables.
  13. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    I was just about to post it, PHV, since I do have a join statement see below: SELECT [dbo_ISD SACD1].epend_dt, [dbo_ISD SACD1].epasset_status, [dbo_ISD SACD1].[rStatus*], [dbo_ISD SACD1].rSite, dbo_ISD_Lease2.Luser, [dbo_ISD SACD1].smsComputerName, [dbo_ISD SACD1].smsLastLoggedOnUserName...
  14. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    PHV, thank you for the article, what I gleaned from it is that I need to cerate a specific join: "You must specify an explicit INNER or OUTER JOIN between the tables. Joins created implicitly in the WHERE clause of the SELECT statement are not updatable." I think this is where my failure lies...
  15. dpelizzari

    Access 2007 Unable to update linked SQL 2005 table

    sorry, dhookom, I should have been clearer. I am going to review what PHV posted (when I get time to blink).
See more

Part and Inventory Search

Back
Top