Search results

Hi, I have the following sub that exports a column (F) from an Excel file to a text file named data.txt. This has been working, but my data set has grown and for some reason this routine does not copy all of the data from column F, stopping at 43,020 lines. I have about 180k lines that need...

Hello all, The following SQL statement works in SQL Server Management Studio as a query on my server: select p.stateID, p.personID, hm.memberID, hm.startDate as householdMemberStartDate, hm.endDate as householdMemberEndDate, hm.secondary as householdMemberSecondary, hl.locationID...

Hello all, I'm having trouble creating a MySQL query that will pull the data that I need into a recordset. I've designed an application that tracks transit routes. There is table 'tripslog' that logs the route name [tripName], [startTime], [end time], [changeType] ('NEW', 'CHG', or 'DELT')...

I have the following query to union three separate Excel File local linked tables into one query result. SELECT regtrips.[Name] As tripName, regtrips.[Schools] As schools, regtrips.[Number Stops] As numStops, regtrips.[Number Assigned] As numAssigned, regtrips.Duration as [duration]...

Hello, I have an app that is tallying transit information for dynamic invoice generation. I have a table of 'trips,' which is essentially an audit table, showing all values for each tripName key over time. The important fields are tripName and lastUpdate. My program logic is like this...

Hello, I'm trying to export to an excel via vba script that's called in a vbs script. Public Sub regedRiderUpdateExport() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "reged_rider_update", "C:\Users\Administrator\Desktop\Live Trip Files\studentUpdates\reged_rider_update.xlsx"...

Hello, I have the need to take two demographic files (personal info - address/city/state/details/etc...) and create a dif excel file from them. File 1: Demographic updates over the last x days (probably 2/3 days) - Probably no more than 2/3k records. File 2: Comprehensive demographic file...

Hello all, I have an access project that uses linked tables to MySQL Database. Using MySQL ODBC 5.1 driver (64 bit). I have a sub that copies recordset data to newly created excel files. It was working just fine and then randomly stopped working. I get the following error when attempting to...

Hello, The following statement will not correctly update my table when i run from a vba module, but works when I run from mysql workbench: VBA Code: DoCmd.RunSQL("update tripslog set coNo = 'FO-13022' WHERE coNo IS NULL AND tripName like 'C%';") SQL Code: update tripslog set coNo =...

Hey all, So I have a table that I would like to create a chart from. I am in a form, go to the chart wizard, select the table that has the data I'd like to chart, and then select the fields. Preview Chart works fine. When I click Next/Finish I get a Chart Wizard Dialogue: Object variable or...

Hello all, I stumbled upon this link on the web that has some code to modify a linked table access project to use DSN-less connections. http://www.accessmvp.com/djsteele/DSNLessLinks.html However, it's not working on my project (Access 2010/MySQL) as the code is breaking and only setting up...

Hello, I was working on some code in a form and i switch from layout mode to form mode and all of the sudden a query that's referenced by my subform isn't working. I didn't change anything releveant that should have triggered this break. I have two nav menus so the reference to the combo...

Hello, I have some processes in my user interface that take a bit of time (ie many operations), and I was wondering if I could create a popup/dialogue box that displays output from the immediate window (debug.print statements in my code). This way, it will give the user an idea what is being...

Hello all, I have an access front end app linked to a MySQL localhost config (XAMPP). I'm currently using a machine/user data source.. What exactly do I need to do to transition this app from my local machine to a hosted environment as far as data sources? Does anyone have any good...

Hello, So I have a query that references data from my form 'Change Trips'. It works inside of the form, but when I open up my navigation form and navigate to the link that references the 'Change Trips' form as it's navigation target (ie when I access the 'Changed Trips' form through the...

Hello, I am attempting to execute some code to insert values into an EMPTY linked MySQL table, 'modifications'. Here is the table structure: CREATE TABLE `modifications` ( `tripName` varchar(120) NOT NULL, `coNo` varchar(30) NOT NULL, `modDate` date NOT NULL, `modType` varchar(120) NOT...

Hello all, Is there any way to download (copy) a file from FTP to your PC via Access VBA? Thanks, B

Hello All, I have an audit table that tracks changes to 'transit routes'. The table is of the order: Name, ChangeType, ChangeDate CR01A, New, 11/5/2015 CR01AP, New, 11/5/2015 CR01AP, Chg, 11/7/2015 CR01AP, Chg, 11/8/2015 CR01B, New, 11/5/2015 CR01BP, New, 11/5/2015 CR02A, New, 11/5/2015 ...

Hey all, So I have a table that is going to be hosted for which i will automate a download. Once I click a button in a form, my backend (SQL) table will be deleted and overwritten by the hosted data, but not before I try to back up two user input columns in my backend table, which I want to...

Hello, Working on a project to generate invoices with a Mysql backend connected via ODBC (linked table) to an access front end. I have an audit table that I will be using to generate automated invoices over a specified time period. The table will be something like... name, attrib1, attrib2...