Search results

Clara, you can't be doing Nz(some number field, "") If you have a null, the value will be set as a zls which isn't appropriate for a number data type. The values need to match the order of the fields you just described. Produce a string equivalent to your SQL insert statement and display...

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...

@Pat Hartman Surely a bad form name is an error like any other, and it needs to be tested and handled. If you did that in runtime, and didn't handle it, wouldn't it just crash the programme. I don't see why you wouldn't just error trap the docmd.openform and handle it. However, what I did...

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...

@Pat Hartman I demonstrated that you can error trap the call to an erroneous/non existent form, complete the unload and close the form gracefully, unless I was missing some other reason why there was an error. I didn't need to resort to having to terminate the Access process. My example will...

@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 don't really understand that. That code I used closes the form without complaining. Am I missing a different issue causing a problem?

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?

I'm back home now - I was away last week. I got this code to work. I kept getting errors trying to use me.openargs as an argument for docmd.openform so I used the fname variable. note that I couldn't get code tags to work, so I posted as inline code. Private Sub Form_Unload(Cancel As...

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.

I'm away for a few days holiday. I will try this properly when I can.

@Pat Hartman Just aircode, but maybe the code should be If ismissing (me.openargs) , rather than if isnull() etc. see if that fixes it.

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...