Search results

  1. J

    Solved Using A Form For Data Entry

    will that keep the user from being able to view previously input data?
  2. J

    Solved Using A Form For Data Entry

    How can I have a user input data into a form and it save the input data into a table? The table currently has data in it, and I do not want the user to be able to view/edit data that has previously been input. How would I set this up?
  3. J

    Solved Filter Form On ComboBox AfterUpdate()

    How can I filter a form based off the value selected in a combobox using the afterupdate() event of the combo box?
  4. J

    Solved Display Name Instead of Id In Form

    okay that was super easy, looking at the form source, and using the queyr editor to build out my query!
  5. J

    Solved Display Name Instead of Id In Form

    Ahh....I do not want the user to be able to edit/modify just see the "pretty" name Okay, that makes sense to me. I originally clicked on the table and did build form, Maybe I should have clicked both tables and not just one
  6. J

    Solved Display Name Instead of Id In Form

    ummmm, over my head here...how would I do that?
  7. J

    Solved Display Name Instead of Id In Form

    I have a table that has a itemId column, then another table that has the itemName. I created a form for the table that has the itemId, so numeric values are displaying on the form. How can I have the form "lookup" or display the itemName so I have a meaningful name on screen for non-technical...
  8. J

    Solved VBA To Filter A Sub Form

    I've LITERALLY been sitting here for 30 minutes on that error....geez i've been out of access vba for to long
  9. J

    Solved VBA To Filter A Sub Form

    I am attempting to use this to filter a sub-form frmSaleItems.Form.Filter = "[ItemId] = '" & Me.Combo7 & "'" but i keep getting this error Datatype mismatch in criteria expression What should I change in that vba line to remedy this issue?
  10. J

    Solved Help With VBA Function

    Genius! Thank you @arnelgp
  11. J

    Solved Help With VBA Function

    @arnelgp - that is PERFECT!!! If I can, is there a way to Force both characters to be upper case?
  12. J

    Solved Help With VBA Function

    @arnelgp - that is so very close. For example, if I input "Galactic Empire" into the text box, the code returns Ga instead of GE Since there are two words I want the first letter of the first two words. Does that make sense?
  13. J

    Solved Help With VBA Function

    @GPGeorge - oh that has MachineAbbrev with a value, however it's not functioning as expected. Meaning, it's appending the entire second word twice, so if I input Jason Jones, MachineAbbrev = JonesJones instead of JJ. What would you do to clean this up/make it work as expcted?
  14. J

    Solved Help With VBA Function

    have a user form where a user must input a text value. I am wanting to check if the input string is 2 words ore more, and if the input string is one word. What I need is if the input string is 2 words or more, then I need to take the first character from the 1st word and 2nd word. If the input...
  15. J

    Run Macro Every XXX Minutes

    @plog - i like the idea of using Task Scheduler to open the Database. That is a good thought so then the database is not opened constantly!
  16. J

    Run Macro Every XXX Minutes

    If the table contains rows, then I want to run a few queries, and run a report and save the report as pdf all through VBA. If the table does not contain rows, then there is no action needed.
  17. J

    Run Macro Every XXX Minutes

    Hmmm...so this means that I must leave the access database open constantly in order for the code to execute? I was hoping for a solution that wouldn't require the DB to be open.
  18. J

    Run Macro Every XXX Minutes

    I have a user uploading excel workbooks to a website, where data is then inserted into MS SQL Server tables. These SQL Server Tables are linked tables into MS Access Database. I need a way that once records are inserted into those MS SQL Server Tables to run a MS Access VBA Module. What would...
  19. J

    Solved Split Each Locale To New Page

    I drag down the page break from the toolbar but nothing shows in the footer. Do you add that differetnly than other controls?
  20. J

    Solved Split Each Locale To New Page

    It's not splitting it to a new page with the header. It's adding in a grey filled area but that is it
Top Bottom