Search results

Yes, but @amorosik is not doing that is he? Or does his DateSQL function guarantee compliance?

I always preferred AWF to utter access but I can't believe it has just closed. Does anyone know why? On my phone, it's just hanging with no information.

In your form_load code I can't believe that the syntax of me.filteron =true line works correctly, but maybe it does. I would split that into 2 lines. I also always define dates as format(somedate,"long date") to ensure there is no ambiguity between UK and US formats, although I'm told that's...

@Magger Generally, we use a query as a forms record source, rather than a table. Even if the query is "select * from my table". You can then add the desired sort parameters (and maybe filters) to the query. Note that if you prepare a report, the query does not provide the sorting. A report...

George. Opening a csv with excel changes the data, or can change the data at any rate. I think a date can change to a date plus time, which in itself can cause an issue. Viewing the data with notepad won't change it. For what it's worth, I would much rather process a csv file than an excel file.

Could it be because you have English dates, so some dates are rejected. Are the invalid dates actually being displayed as strings, and the valid dates getting the correct numerical values? Is there an istext() function you can use to test whether the 14/07/2025 you see after the import is text...

@isladogs @Minty I always used to be able to add tags after pasting code, as Minty mentioned. I can work round it now I know anyway.

I entered the code tags manually and it worked. When I selected the code I wanted, and clicked the code tags option, it just selected the first line, and offered me a "code type" drop down. There wasn't a VBA option.

Sorry, I thought you were using an "integer" data type. I misread that you had changed it FROM integer. I expect there must be somewhere you still have integer, rather than long. Can you identify the precise point that causes the crash?

I just tried to put some code in code tags, but it just encoded the first line, and appeared to discard the rest. I used inline code, and that worked. Has something changed?

Integer will crash it. That only goes up to 32k (2^15, maybe 2^15 - 1 to be precise), so 40k is too big. I rarely define any whole number as anything other than a LONG.

And you intend this to run on Christmas day, do you?

@theDBguy I'm sure I used code very like you showed but I couldn't get it to work. I might not be able to access the Rest API I was using previously, but I might try again and see if it does work. Perhaps the line of code starting with Put avoids the array of bytes being turned into a unicode...

Is there a rest API available? That might be a possible way. I checked your link, and that's what it is, but it's hard to find VBA code to do it. I'm sure I have posted some previously though. One issue is that to download a PDF, you collect a string of bytes. But the trouble I found and I...

Bear in mind that its most likely common for users to be placed in groups, and rights and privileges are often based on the group membership rather than the user. I'm not sure whether that applies to what you are trying to do, but it does simplify things if it can be done that way.

I don't understand this. A sales processing control system ought to start with an order, and end with an invoice. Preparing a despatch note is part of this process, surely.

The best starting book I found was by Alison Balter. Covered everything you might need, although at the time it was for A97/A2003. Those versions are perfectly adequate to develop great databases, although later versions included some new bells and whistles. It's really helpful to start with a...

If you aren't careful someone will draw the short straw and get more than his fair share of work, using an alphabetical formula like that. I expect there are a lot of names starting with B for instance.

I've done this sort of stuff before by letting users enter a string and splitting it into its substrings, then searching for matches in the product descriptions on the substrings. This was an effective alternative to multiple combo boxes. So you enter something like "8 black widget" to reduce...

If you can't find a fix you could tell your users not to preview the report first, or to rerun it without the preview.