Search results

  1. M

    Alternative to DLookup

    I realized I could just use a SELECT statement in my Look Up A Record action to create a table with all my needed fields. :banghead: Problem solved!
  2. M

    Alternative to DLookup

    Hey guys, So I have been using the DLookup function in the AfterUpdate data macro to find values in other tables with relative ease. However, it turns out that DLookup is not web compatible (using Access 2010 web) :banghead:. I don't know any other simple solution to stick values in other...
  3. M

    Method to "associate" multiple records with one

    Hey guys, Just a heads up, I'm using Access 2010 Web. So for a previous task, for certain records with specified criteria, I would need to create an associated record that has the same criteria, but negative values. To do this I created a Linked ID column and assigned the ID of the original...
  4. M

    Referencing a separate table

    Hello, I'm working in the Before Change data macro of a table (call it table A) using a For Each Record loop in table B. table A has a field that contains ID's of records in table C. I'm trying to check if a certain value in table B is equal to a value in table C with a corresponding ID from...
  5. M

    Querying with NOT as a string

    Ah, I think that might solve my problem. Thanks for the help!
  6. M

    Querying with NOT as a string

    Hello, Firstly, I'd like to point out that I'm using Access 2010 Web. So I have a table of "rules" that determines if an input in a form is valid or not. For example, if I choose A for one combo box, another combo box might be filtered to only show x, y and z based on my table. However, for...
  7. M

    Data macros and message boxes

    That completely solves my problem! Thank you very much :)
  8. M

    Data macros and message boxes

    Hello guys, First of all I'd like to point out that I'm working in Access 2010 Web. I noticed that data macros can't run the MsgBox function; only normal macros can. Also, data macros can only run other data macros, so here's my problem: I need to run a message box notifying the user of an...
  9. M

    Introduction

    Hello guys! My name is Koby and I'm from Toronto, Canada. I am currently in a coop position using Access 2010 to make our database more efficient to work with. I started this job not knowing Access but am learning as I go along. So far it's pretty neat and is a great experience :)
Back
Top Bottom