Search results

  1. C

    Query to Combine results from two tables

    Hello everyone, I've been working on trying to combine 2 queries for the last couple of weeks now and I've finally decided to give in and ask. I have 2 different tables "openCalls" and "closedCalls" . I am trying to run a query that searches both tables. I've tried Inner Join and relationships...
  2. C

    Uploading Access Database to Sharepoint

    Hello, I have a general question. I've been trying to get familiar with the process of sharing databases with additional people. Through my research I have found that its possible to publish an Access Database to SharePoint. I am still figuring it out, however, wondering if once its publish...
  3. C

    Hide Back Access Window on Load

    Hello, I know there are tons of "how to" pages on the internet on how to hide the back window. However, all the ones I've tried hide the toolbar and the database window but they do not hide the back window that has the access path up top, not sure what that is called? 'Hide database window...
  4. C

    Access Database Design

    Good Afternoon Access Experts, I was wonder if you guys wouldn't mind passing on some Database creation tips. I have a database that has 25 forms, 15 linked tables, and 60 queries. Does this sound like an excessive amount of queries? I have so many queries, sometimes I forget what I used...
  5. C

    Update Table 2 When Table 1 is Updated

    Hello, I am trying to create an "Update Query" that updates Table 2 when table 1 gets updated. This seems like it would be simple, however, I can't get it to work. I've tried various combinations of the expression in each field but nothing is working. Table 1 and Table 2 are connected by...
  6. C

    Import or link to data in an SQL Server database

    I had this question in a previous post but I don't think I communicated it properly. I have a database I've built for a company. I want to be able to upload the DB file that contains all the tables, then have the staff use the DB with the forms with the capability to update and change table...
  7. C

    Distinct Query + show other fields

    Hello, I am trying to figure out how to run a Distinct Query for a particular fields BUT also show the other fields. Basically, I have a listbox that populates a query where fields 1 to 5 are the same but fields 6 to 10 may have different values. I would like my listbox to show only Distinct...
  8. C

    Upload Access Database to hosting plan

    Afternoon, I am not sure this can be done but thought I'd ask just in case. I have a form Access Database I've built for multiple users. The tables are housed in separate database I've uploaded online. Can I use the form database to retrieve/add data to the database online? Thank you.
  9. C

    Transfer Query to Excel Spreadsheet

    Hi, I am hoping to get some code for a button click to transfer query results to an existing worksheet. So far I have the below code that opens the Excel Workbook and transfers the query to the worksheet. However, my problem is that it over rights the existing excel data previously added. Is...
  10. C

    Delete record from table based on query

    Afternoon, I've been trying to figure this out for days. I feel like its simple but I just can't get it. I have two tables, lets say Table1 and Table2. I am trying to delete duplicate records in Table 2 that are already in Table1. My query, "query1" finds the duplicate records with joined...
  11. C

    Make a Label visible when a new record is added to a table

    Hi, I am hoping someone can help. Not sure it can be done. Can't find anything online, so hoping you guys might know. I have a form with an embedded report. This report populates data from the UpdateTable. I have a requery button on my report that allows me to refresh for any new updates...
  12. C

    Form with Search Box

    Good Afternoon, I am wondering if someone can assist with a form with a Search box query. I know how to add a query for one key word with a pop up MsgBox but what Im looking for is a form with a textbox that allows the user to input a word or phrase. When the search button is clicked it will...
  13. C

    IF and Then Statement to pull records based on date match in table

    Good Afternoon, Hoping someone can assist with this simple code. I cannot get the If then statement to work. I have a table called "NIGO_Data" on the table there is a field called "SubDate" which holds the date of the record. I want my if then statement to search the NIGO_Data Table and...
  14. C

    SUM Query with IF and Then Statement

    Good Afternoon, I am new to Access and was hoping to get some help with a query. I have a form built with a sum button. When button is clicked I want it to count all records when a match is found in the HandledType_fld. Example: "HandledType_fld" can have Completed, Handled, NoAction etc...
Top Bottom