Search results

I have eleven tables that have data appended via queries. All the table names start with "LOAD_". All the tables have a field named "Part Number". The queries build data for all our part numbers. Sometimes I need data for all part number and sometimes I only want data for specific part numbers...

Good morning. I have text in a table like this: Make ALFA ROMEO FREIGHTLINER - TRUCKS - MEDIUM / HEAVY DUTY HINO (MEDIUM DUTY) MERCEDES-BENZ NISSAN Some data has the make and " - " and then extra info. Some has the extra info in parentheses. Some does not have any extra info...

I have Excel files in a shared folder that I need to delete after importing the data into Access. The folder is a shared folder with co-workers files so I only want to delete the files I created. How do I select the files delete using an Authors name?

Good morning. This is what I have in Excel: This is what I want: I want to highlight the rows at each year change. I am assuming I would need to use Conditional Formatting but do not know what to use for a formula. I tried google but came up empty on this. Thanks.

I am using Allen Browne's code here. In several queries I am concatenating data from tables/other queries and the data I want to concatenate is in there multiple times. To do it in one step I changed Allen's code here: strSql = "SELECT " & strField & " FROM " & strTable to this strSql =...

I have text like this: L6 - 5.9L 359ci DIESEL DI Turbocharged vin C - 4 valve OHV V8 - 6.6L 6599cc 403ci DIESEL MFI Turbocharged vin L type LGH - 4 valve OHV I want to extract the VIN info - just the letters in bold. In these examples they are both single letters. Sometimes they can be a...

Good morning all. I have some code that updates some local tables from one Access db into another. The source db is replaced with a new version monthly. The current file name is "VCdb_AUGUST_2021.accdb". I added "VCdb_" to the table names in the destination db. This is the code: Option...

Good morning. I am using this code to move a ZIP folder from desktop to an archive folder: Dim filPath Dim folPath As String filPath = Dir(C:\Users\EzGoingKev\ & "*.zip") folPath = "C:\Users\EzGoingKev\ArchiveFolder\" Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject")...

Good afternoon. I have to build load sheets for a web based third party application my company uses. - I build the data in Access. - I export the data out to a text file using DoCmd.TransferText. - Once the text files are saved I need to manually open each one. Once open I use File -> Save As...

I have two tables. Table1 is updated once a month. I have added a date field named "last_pull". I am attempting to populated that field with data from Table2. Table2 has two fields - an autonumbered "ID" field and a "pulled" field. The pulled field is a record of all Table1's update dates. The...

Good morning all. There is an Excel file that was created and is maintained by multiple coworkers. I have to work with the data in that file so I currently have it as a linked table in my Access db. I ran my query and found empty cells where there should be data. Looking at the linked table I...

Good afternoon. I use a program that builds a data set in an Access db and then converts that data into an XML file. I modify the data in the Access db and then go into the program and run out the XML file. I have to do this multiple times as we need different XML files. The XML file is in a...

I have some data in a field. It is basically Make and Model data. Some fields have vehicle type added in: AUDI-RS5 / RS5 SPORTBACK VOLVO - TRUCKS - MEDIUM / HEAVY DUTY-VNM SERIES WHITE - TRACTORS-2-110 CASE - EXCAVATORS-688B CK I would like them to be separated into two different Make | Model...

I created a function to export five Access queries out into five sheets in the same Excel 2016 workbook using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "QueryName", C:\Path\ExcelFileName, , "SheetName" Sometimes I run it and it runs fine. It creates the workbook and...

Good evening. I have an Excel file name "data123.xls" in one folder and want to copy it into another folder. This here works fine: FileCopy "C:\OldFolder\data123.xls", "C:\NewFolder\data.xls" Sometimes the data file will have a different numerical sequence. I cannot this to work: FileCopy...

Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...

Good afternoon. I have this if statement in VBA - If (Not IsNull(DLookup("[Part Manufacturer]", "[export_sheet]"))) Then If (MsgBox("Delete PN's w/o manufacturer names?", 4) = 6) Then DoCmd.RunSQL "DELETE FROM export_sheet WHERE [Part Manufacturer] IS NULL", -1 End If...

Good afternoon. When creating a module I always have to go in and manually select the Microsoft Office 16.0 Object Library so the code will run without errors. I have to do this every time in every database. Is there a way to select it so it is automatically selected in all databases I open on...

I am not sure how I need to do this so I am posting in General. I need to upload images into a web based UI. They are loaded using a ZIP folder. The UI limits the folder size to 300mb. I have a data set that consists of an distinct ID, a distinct image part number, and the image file size in...

I imported a DBF into Access as a local table. I am trying to update the data using this: INSERT INTO local_table_name SELECT * FROM [DBF_file_name.DBF] IN '\\ServerName\FolderName' I am getting an error : "The Microsoft Access database engine cannot open or write to the file...