Search results

  1. M

    Update data in one table, but not the other

    Hello, I have Form ALLDataUpdate based on query from two tables: tblData and tblArea. My Query works nicely until I need to update info. tblData needs to be updated based on what user inputs, but tblArea should not be updated. tblArea is only there to provided 3 combo boxes to choose Area...
  2. M

    Create Sharepoint Folder using Access VBA

    Hello, I am trying to write VBA code in Access to check if folder exists on Sharepoint site and if it doesn't the create it, if it does then just open a location of it. I managed to get it to open existing ones using some of my old codes, but can't figure out how to make it work to create and...
  3. M

    Send Report as Email body

    Hello, I have generated report from form and I need it to be dent in the body of the email. Is it possible? I have read loads of threads and put together this, see below. Currently it sends an attachment from my computer, but not report. I know there is a lot wrong, but I just figure it out...
  4. M

    Lookup a name in the table based on auto-populated field

    Hello, I have created a text box, that automatically draws name of user from system. If I am logged in on my computer it draws my internal company ID. The requirement is to display not just my internal ID, but my name too. I have created a table where I have added all IDs and Names of all...
  5. M

    Update/Edit/Save some of the data into table from Form

    Hello, I have created a form called Update info, see attached file. Majority of this information is stored in table ALLGaugeDB, but Area, Location, Location Name and Location Code are stored in second table AREA. Data is linked using Location Code (that is on both tables)...
  6. M

    Updatable Multi table Query

    Hello, I have created Form based on 2 tables that allows user to update information. One has all the equipment information and the other one contains all the areas that equipment can be found with additional information about area and responsible people. I linked both tables using Location...
  7. M

    Multiple field search in Form

    Hello, I have been creating Access database for some time now and now I came across the issue I cannot find the answer for. I am trying to create a multifield search on my Form. I did it before with just using Macros, but it has limited me to only 3 fields, now I need to add more. My code so...
Top Bottom