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 matzos

  1. matzos

    Modifying Values in Query

    Thank you. I've been working with your suggestions for days now but nothing has seemed to work. JonFer, I tried your last suggestion but ListNum can not be unique in those tables because each list will have multiple users and multiple projections. Any other suggestions would be welcome, but...
  2. matzos

    Modifying Values in Query

    All tables have primary keys defined as follows: tblSysLists - ListNum tblLiveProjDetail - DetailID tblListAssign - AssignID There will be multiple ListNum references in tblLiveProjDetail & tblListAssign since there could be more than one user that has access to a given list and more than one...
  3. matzos

    Modifying Values in Query

    NOTE: I just noticed that I used the word "update" when describing what I want to do. I'm not using an Update query, I need to modify the field values in the query result. I can do it if I use a single table in the FROM statement but not if I link that tables.
  4. matzos

    Modifying Values in Query

    I have and haven't had any luck. HEre is the query with all of the keys: SELECT tblSysLists.ListName, tblLiveProjDetail.MoStart, tblLiveProjDetail.ActFS, tblLiveProjDetail.ActAdj, tblLiveProjDetail.DetailID, tblSysLists.ListNum, tblListAssign.AssignID FROM (tblListAssign INNER JOIN...
  5. matzos

    Modifying Values in Query

    Here is the SQL for the query I'm working with: SELECT tblSysLists.ListName, tblLiveProjDetail.MoStart, tblLiveProjDetail.ActFS, tblLiveProjDetail.ActAdj FROM (tblListAssign INNER JOIN tblLiveProjDetail ON tblListAssign.ListNum = tblLiveProjDetail.ListNum) INNER JOIN tblSysLists ON...
  6. matzos

    Modifying Values in Query

    Not sure if I can make this work, or even if I can communicate exactly what it is that I need to do but here we go: I have a continuous form to list product details that a given user has access to modify. However, the query that I have won't let me update the couple fields I need to. I...
  7. matzos

    Recordset with Continuous Form

    I've tried setting the Forms' RecordSource equal to an SQL String and the Forms' Recordset equal to a code recordset but it locks me into the same problem as if I had an Access Query...I can't modify the values. I have a solution, although I know it's probably not the most elegant solution...
  8. matzos

    Continuous Forms & Recordsets

    I've tried all of these suggestions without any clear improvment. What aobut this...is there a way to create a control array on the fly based on the number of records I have in a recordset? I know you can do this in VB6 but can it be done in Access 2000?
  9. matzos

    Recordset with Continuous Form

    Thanks PJ. That SEEMS like the answer I should be looking for but I'm still just getting one record showing the last item in the recordset. BTW - this code is in the Form_Load event. I tried your code in the beginning of the Loop (as suggested) and at the end with the same result. I tried...
  10. matzos

    Recordset with Continuous Form

    Hello all. Here's my problem: How can I use the following code in a continuous form? The result of this query gives me 288 records but when I use this as-is in my continuous form, I only get one record...the last one. dim db as DAO.Database dim rs as DAO.Recordset dim strSQL as string...
  11. matzos

    Continuous Forms & Recordsets

    The form is set to Continuous. If I put the SQL query into an ACCESS query and make that the RecordSource property on the form, it shows me all of the query result records with no problem. However, I can't update any of the records because of the query links. My ultimate goal is to be able to...
  12. matzos

    Continuous Forms & Recordsets

    Hello all! I have a recordset that I need to populate into a continuous form. When I try the normal methods to set the textboxes equal to the recordset fields in the VBA I'm only getting the last record on the form, not the 200+ records that are in the recordset. I'm sure there is a line of...
  13. matzos

    Pasting Multiple Page Excel Graphs into Word

    The subject pretty much says it all. I have survey results in Excel that I need to merge into a Word document the contains several other pages of result analysis. I have SEVERAL of them and I will be doing this several times a month. I want to be able to copy all of the graphs from Excel...
  14. matzos

    Form not opening

    I've actually developed the same error. No matter what allowances or tests I attempt in my code, I continue to get the Error: You Cancelled the Previous Operation. It occurs every time I execute code. It come up twice in a row and then I get a run time error on the action I tried to run...
  15. matzos

    Default Values on a form

    The "ME" is a shortcut for the form you are working on.
See more

Part and Inventory Search

Back
Top