Search results

I'm using the code below in a database which I've inherited. It works beautifully to split long strings on a pipe delimiter and push the split values and the 'Source/Medium' values into a table. However, the origin table has an autonumber in a field called 'ID'. I'd like to pass this to the...

I understand what you're saying in principle, but I'm still a good distance away from being able to execute this myself. Apologies for the cheeky request, but would you be able to throw this into a DB, as I can usually reverse engineer! No worries if not.

Due to a quirk of our hateful website, multiple delivery address orders are split into separate orders, despite the fact that they are one transaction. To be able to analyse the data in access, I really need to understand transactions, rather than orders as the number of orders is misleading...

Yes, you're probably right!

I was moaning about it to one of our IT guys, who said he vaguely remembered something about affinity. You can set affinity through Task Manager, but it 'forgets' when you next load Access, so if you use that command either in a desktop shortcut, or a .bat file then it works without a problem.

Here's the solution; affinities have to be set so that it runs on just one processor. This needs to be added to the command line when you boot access. C:\Windows\System32\cmd.exe /c start "Microsoft Access" /Affinity 1 "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE"

They can't be any simpler I'm afraid - they're quite simple anyway. What I can't grasp is why a machine which is demonstrably more powerful is struggling with these DBs, compared to my laptop.

Bit of a strange one... I've been building a few databases this week, none of which are overly complex. They all happily run on my i5 8GB laptop, but having moved them to run on an i7 16GB, I now get a 'System Resource Exceeded' message each time they run.

That is the absolute joy of it. Hair tearing frustration until you get it though!

Nailed it - thanks to everyone for your help. Public Function Print_All_IF_FIR() Dim rs As DAO.Recordset Dim db As DAO.Database Dim stSQL As String, stDate As String, stDBpath As String, stFTPpath As String Dim stRptName As String, stLinkCriteria As String Dim stStart As String, stEnd As...

Ah, ok - that's clear. I had thought you could just create the folder by putting that in the path, but realise it's a separate process now.

This works brilliantly; Public Function Print_All_IF_FIR() Dim rs As DAO.Recordset Dim db As DAO.Database Dim stSQL As String, stDate As String, stDBpath As String, stFTPpath As String Dim stRptName As String, stParam As String, stLinkCriteria As String, stAlphabet As String, astAlpa(1...

Ah, ok - much clearer now. I think what’s thrown me was the Ship.Ship in the original example, so I couldn’t tell which way round tables and fields should be. Will give it a crack shortly.

Yes, that table does exist in the database Understood, but I've put it back in on the basis that you never quite know what rubbish users will put into the system, so it protects against a scenario, albeit unlikely Agreed, doing my best! The problem is that you're dealing with a...

I had inadvertently taken out the stLinkCriteria, thinking it did something else... This is the new code; Public Function Print_All_IF_FIR() Dim rs As DAO.Recordset Dim db As DAO.Database Dim stSQL As String, stDate As String, stDBpath As String, stFTPpath As String Dim stRptName As...

Public Function Print_All_IF_FIR() Dim rs As DAO.Recordset Dim db As DAO.Database Dim stSQL As String, stDate As String, stDBpath As String, stFTPpath As String Dim stRptName As String, stParam As String, stLinkCriteria As String, stAlphabet As String, astAlpa(1, 26) As String Dim stStart...

I use a database to import data, which is then validated and reformatted. At present, the information is exported to Excel, which is then imported into Word in a MailMerge. I use a plugin in Word called 'Split the Merge' (or something like that), which takes my MailMerge and saves individual...

I have 4 crosstab queries which I can export successfully to .xlsx, using ExportWithFormatting in a macro. However, I'd really like to be able to write the first crosstab to a new workbook, then append the following 3 crosstab queries as subsequent worksheets within the workbook. Is that possible?

So simple - thank you, this worked brilliantly. Also just tried wrapping the .AddAttachment in an If statement to see if I could conditionally turn the attachments on and off. Also worked!

Yep, I give up... https://alexfwalker.tinytake.com/tt/NDYyMjI2Ml8xNDY0OTU4NA Tried Googling the syntax, but I have hit the wall of talent.