Search results

personally I use the standard ISO format of yyyy-mm-dd in queries to avoid any possible confusion. Also, some rdbms/systems will distinguish between M and m and D and d (uppercase are long dates and the lower case short date) although should not an issue for Access which is not case sensitive

the code converts the date, a numeric datatype to a string. Not tested by I suspect the datepicker doesn't like strings - your error message says it all. And hopefully these controls are unbound otherwise you are mixing datatypes. But why need to code anyway? why not just set the format property...

sounds like the background form just needs the buttons and 3 subforms

I created this text file which I'm guessing is something like your xyz file 11 C -0.180226841 0.360945118 -1.120304970 C -0.180226841 1.559292118 -0.407860970 C...

Provide a realist example of the file to import - variations in ‘field’ sizes, mix of letters/numbers etc Only needs to be 20-30 rows (including the top 2 rows)

You can use regex to split out the data but that requires using a udf.

what happens to the array - is it cleared down after each import? or continues to grow? Arrays take up memory..... Why not use a temp table instead of an array?

Doctor - ‘can I take a look?’ Patient - ‘why? I described the problem’

You didn’t last time either. So you are happy for us to spend time on your behalf guessing what the issue is? Only suggestion I can make is there is an issue with the file you are trying to import- perhaps too big or corrupt? Have you tried skipping that file? I’m not sure your tidbit is a...

Use a filter to exclude the records you don’t want or open the form in data entry mode

The issue with large corporates is budget - I’ve provided many apps to service perhaps 3 or 4 employees who need a solution now, not two years down the line at a high cost. Wouldn’t be a problem if the large corporate systems provided the detail actually required, but the cost of modifying the...

In terms of developing- how is it free? You either pay for a lifetime licence or by subscription. As far as free runtime is concerned, how much do you pay for a browser?

That’s when I would use a tempvar All very well saying ‘don’t use references to form controls in a query’ but without clarification as to what to use as an alternative is not helpful. I don’t see using tempvars as a solution since that still needs to be populated so there is still a ‘link’ back...

What is the user using as a reference document? A piece of paper? A pdf or excel file? Something else? And why not use a continuous form? Or a main form to capture delivery details and continuous subform to capture product details?

my understanding is hydration is simply populating a recordset - once a record is ‘full’ it is hydrated. E.g importing data from one or more sources to populate one or more tables

See this link https://stackoverflow.com/questions/8566891/force-report-footer-to-be-at-bottom-of-page#8576802

Perhaps use the report footer?

It’s dimmed as a global variable so the default is 0. It is then incremented in the code

No problem- although I was asked to do this for a client over 20 years ago to save paper labels (something like 32 labels per sheet) they stopped using it due to the time it took to count the number of labels used and to put the sheet back in the tray (the right way round!) v the cost of the sheet

I guess you could write your own wizard either to create the form and controls or to adjust the created form Would need code to find the max width of each field based on say the first 100 rows _ but this would obviously require data Would be different requirements for a continuous form v...