I have a project with a number of instances of DoCmd.Hourglass -1 <various code> DoCmd.Hourglass 0 <other code> Any time there
I have 3 tables I'm trying to join, and the final table may be missing a record. I'm trying to determine if it's there or not. Notice how table 3 doesn't have a
Bought X times Name Manufacturer 19 Олівець Faber-Castell, Castell 9000 F FaberCastell 14 Наб&#
I´m exporting data to excel with the columns like ID Product Quantity Price Sum Our vendors fill in the Quantity and Price. I want to pass a simple calcul
I want to query records from the access database that matches the current date (system date) The following query works fine if I enter the date literally. SELEC
I have a data structure (array) in Access - 6 columns and 10 rows. I'm trying to write to a range in Excel ie B3:G12. I'm getting tied up in loops, literally. F
When adding a "SqlDataSource" using any version of MS Access database the app simply crashes when you "Test Connection". This happens in the designer when usin
I want to display a query but the column order needs to be sorted according to the value in the column, field with greater value as column 1, then second greate
user can select only one key number at a time and I have placed the code on the listbox in the control both under expression, didn't work- then under code build
user can select only one key number at a time and I have placed the code on the listbox in the control both under expression, didn't work- then under code build
MS Access Database: I have a report that I want to open from a form with multiple filter fields. Each filter works fine when used individually. They do not wo
I am trying to create a database from SEC filings. The filings come in .tsv files and are structured in folders by year and quarter. Ever folder contains about
I need to edit an old Access form. When a person enters information into a form field, a number associated to a name is found through a SQL SELECT statement. "S
I need to get the Application Title from an access database via C#. I have seen some samples using Office VBA: I.E: https://docs.microsoft.com/en-us/office/v
I created a form with 3 textboxes & a search button. Also a query that is setup to take the criteria in the textboxes & filter the results of a table wi
I have an XML file I'm trying to import into Access. I need help formatting the XSL transform to match the data. Right now, the XML imports as 3 separate tables
So I had to create a couple of drop-down lists in Microsoft access and all of them are supposed to have different font colors. I did write the code for a single
I have a MS Access database that has a switchboard on it that opens different forms within the database. For some reason, some of the users like to double click
There's a website that provides weather data: https://www.visualcrossing.com/weather/weather-data-services I want to import that data into a table with a butto
Assuming a table organized thus: Row | School | LocationCode2011 | LocationCode2012 | LocationCode2013 001 ABC 1000A 1000B