Search results

I assumed the OP was using code to import the file, not doing it manually, hence my surprise that it didn't work. Maybe excel/windows expects to see a binary format with a .dat file in particular, and treats it as a binary file. I could also see a .bat file not working correctly given that...

I opened Word the other day, and was irritated by the copilot icon getting in the way. Help explained I could turn it off in options.

Why can't you specify the full file name to import the text? I'm not saying you definitely can,but I can't imagine the option is extension specific.

Note that your A2003 databases will still run under the latest versions of Access. If you use external functions and API functions you probably want to install 32bit Access if you upgrade to the latest version, as you may get errors with 64bit. Personally I would not use A2007. It's flaky in...

So how does the computer actually represent "Empty", "Null", "0" or a zls. That would explain what is going on.

I think firms often persist using antiquated software because of the time and money invested in the legacy systems. Not so much those elements. because they are already sunk costs, but in the knowledge that duplicating the software facilities in any new system is gong to be a very expensive...

It's certainly confusing as an observer, and I am sure it would be to me as a developer at some point to have to recall that a "num" variable is defined as a "string".

Excellent analysis. I wouldn't have got that even given the error descriptions. A lesson painfully learnt at some point, I imagine. :D

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.