Search results

  1. N

    Apply filter from Sheet 1 to Sheets 2 and 3

    I have a workbook with multiple sheets and what I would like to do is be able to filter the data on Sheet 1, using the filter selections (Data > Filter), and then auto filter Sheets 2 and 3 to only show the selected filters from sheet 1. Example: I filter Column 1 on Sheet 1 and only select...
  2. N

    Solved VBA Record Editing issues

    Code worked perfect, thanks !! in seeing the code, I see why I would have to list it that way now. Just a FYI, the quantity listed is the total per servings listed, i'm updating the quantity to be reflective of 1 serving, i guess I could create another field to hold that value, but after the...
  3. N

    Solved VBA Record Editing issues

    not sure what you mean
  4. N

    Solved VBA Record Editing issues

    There are 8 records in the table and then an unbound field I am using for the Servings value, but for some reason, its only using the quantity value of the last record entered for the quantity value of all the other records, or if I select a row in the table and then click the update button...
  5. N

    Solved Append/Add Query Question

    Thanks guys, i'm going to start this DB over as I tried to take some shortcuts which are starting to bite me in the but, will be back if I need more assistance. thanks again !!
  6. N

    Solved Append/Add Query Question

    not sure what im missing, followed isladog's steps, but it doesn't appear to be doing anything even though it stats its updating records. Trying to update the list table from the list build table. thank you Updated database file
  7. N

    Solved Append/Add Query Question

    Hi all, been awhile since i've been around, but working on another Access database and have a question so I figured what better place since you guys have helped in the past!! I have 2 tables with one being a temp build table where I can do quantity calculations (Table1) before moving it to the...
  8. N

    Solved Add record in formB from formA

    Thanks for the clarification, i'll remember this for next time !!
  9. N

    Solved Add record in formB from formA

    That did it, thanks a million !!
  10. N

    Solved Add record in formB from formA

    I have a main form with a tabctrl, and on tab 7 i have 2 forms that we will call formA and formB, both linked to the main form via facilityID What I would like is to click a button in formA that will add a new record to formB. When I try either of the following...
  11. N

    User Input Validation

    Thanks a million !!! This works to validate its a numeric value, however it does still allow a blank entry, i'll work with this for now, may add a validation loop. thanks again !!
  12. N

    User Input Validation

    Is it possible to validate only numbers are entered when using a User Propmt Query? I've tried the attached and it still allows letters or nothing at all and because my SQL Table DataType is 'Int" it just leaves the filed blank without erroring.
  13. N

    Solved Query Not working

    I figured it out while looking at the SQL text, I wasn't referncing the local table anywhere other than the "Where" clause. I added it in and viola, it works.....
  14. N

    Solved Query Not working

    I have an access query built to pull a record from a SQL linked table, if it matches a value from a local table, however when I run the query, I am promted with Enter Parameter Value db_CurrentUser!UserName, which is the name of my local table and value I am trying to match. If I manually...
  15. N

    Solved Syntax Error - Brain Fart

    i knew it was something simple, I had no single quotes originally and had an extra double quote at the end that was killing me, always the little things...... Thanks again for your assistance !!
  16. N

    Solved Syntax Error - Brain Fart

    Having a brain fart and can't seem to figure this one out, please point out the obvious that I am missing :) my code is erroring with "Run-Time error '3075': Syntax error (missing operator) in query expression "InvoiceDetailID='23". Dim rs As Recordset Dim s As String Set rs =...
  17. N

    Subform On Order Not working

    I got it to work by adding OrderBy Code in the VBA vs using the form properties, not sure why it didn't work on the properties tab....
  18. N

    Subform On Order Not working

    It is an unbound form until a tabctrl is selected and then Sub Form and linking are specified. Me.FacilityMaintenanceNotes.SourceObject = "FacilityMaintenanceNotes" Me.FacilityMaintenanceNotes.LinkChildFields = "FacilityID" Me.FacilityMaintenanceNotes.LinkMasterFields = "FacilityID" and by...
  19. N

    Subform On Order Not working

    I have a main form with 2 SubForms on it. on SubForm 2, I set the Order By to MaintenanceID Desc and when I open that form on its own, it sorts correctly, however when I lauch the main form, SubForm 2 no longer sorts correctly. Please advise what I am missing thank you
  20. N

    Wierd Form Activity

    Well i'm not sure what broke when I did the compact and repair as it was working prior to that. I have remedied the situation by just loading without the subforms set and then setting the source object for them on the Form Open
Top Bottom