queries

Hi, I have created an income statement form in access that has a Beginning Date, End Date text boxes followed by Income and Expense text boxes and lastly and Net Income text box. I have tables set up for income and expenses. What I want is to enter a beginning and end date on the form and...

Greetings, I'm not an access guru. I mostly do queries. A workmate has inherited a work database which mostly contains forms, queries, and tables. One of the tables has ~14000 line records. They have been finding there some records in a table (table linked to form) and their fields have been...

Hi, Just out of curiosity. How many queries we can have in a database. Is there any limit on number of queries we can assign to a table

Hi All, Looking for a 3rd party program to use as a schema for my ms access database (SQL backend) . Would like to drop in tables queries etc and create a visual link that would show me a schema what is connected to what? At present, I have a many large access databases's (Inherited) with no...

Is there a standard practice for preparing and sending workbooks so that the recipient can't dig around in the queries? My initial thought is to just delete the queries because the static result is the objective. My concerns: 1. Forgetting to delete the queries, and sending the file off. 2...

I want to make a report with multiple queries within the two separate area of a same report without influencing each other. For instance UNION function merge two queries vertically. Is there any way to do the same Horizontally?

I have an Excel file with 3 tabs that are all pulling info through queries which rotate every 40 seconds. The VBA I have for it works great. After rotating through the tabs I need the queries to refresh via VBA. However, since a macro is being ran, the queries wont refresh until I manually stop...

I would like to search through my database and return the query names of any queries that contain specific text. Is this doable? Thanks

Is there a way in Access to convert a standalone table to a linked table (without re importing it as a linked table)? I have several tables that I would like to link from Excel To Access. Ordinarily I would import the Excel tables as linked tables but I was wondering if there a quick way of...

Hi, I have an Excel sheet with around 800 search queries for instance "Therapy for Fever" and "Therapy for Pneumonia". What I've already done is extract URLs of the top 5 Google searches for these respective search queries. Now, what I want to be able to do is use these URLs and technically...

I was trying to use the Query Wizard and it said that my tables weren't related so I looked at the relationships and there are no longer any lines connecting my tables. I'm checking back through backups and they are missing there too until I get to backups I made in February 2017. However, I've...

Hi All, I wonder if anyone can resolve this annoying issue I am having. I have created a Excel Connection Table and all my columns seem to work correctly however there is one column (Employee Number) that I am having issues with. When I look the column in the source it contains both numbers...

I was wondering how I would go about making a macro which reads off a list of specific URL variables and makes a data query and a new sheet for a different name. For example in my url tab I have this: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant...

Hi All, I have a main workbook on network, for which I have created some queries. I want to use the same queries but on a different workbook. Should I do all the steps that I have done for the current workbook to create those queries?? Or there is a way to copy those queries to a different...

Good day, Is it at all possible to create a connection from another workbook to include images? As data tables work fine, but leave the images behind. Or in some way dynamically add a number of images to a sheet - possibly from a folder. Thanks in advance for any help.

VBA coding in power point

Hi guys So I have made an excel document containing the price of an asset on two different exchanges, i have a query set up so that it gets the information from the server and automatically update the two cells every minute, that all works fine. However I would like to plot the change in the...

Excel formula =COUNTIFS(OtherSheet!A:A,A1,OtherSheet!B:B,TRUE)>0 Would someone have a solution to use a function like this in Access? (I have subdatasheets I'm not sure if Queries will be a solution for me)

Good Day all, I have created a database with frequency values that are mostly monthly however their is one set of data entries that are daily. This is an issue because my preferred data format is monthly. I would like to create a query that can generate monthly averages from my data...

Hi all.. I have an issue as follows:- I created an Excel file which uses 3 ODBC queries to pull data from Sage Accounts. I (perhaps unwisely) set up a new DSN called 'WELTON',to use for this purpose and pointed it at the data folders. However, I am now using the same report for a different...