Search results

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

Use a union query Assuming your query is called myquery and you want 5 blanks Select fld1,fld2, fld3 from myquery Union all select top 5 null, null, null from myquery

Assume you are talking about the wizard? I don’t think it’s random, but won’t necessarily be based on actual data- it might look at the data type - but if you’ve specified a 255 char string it won’t know you will only ever be putting 5 chars in the field. It also needs to take into account...

Why not export the data to excel, transform it there (presume that gives the result required) then link to the transformed data and display as a datasheet subform in your form? All done when the form is opened Can then display up to 255 columns Requires use of vba and excel automation. May...

As I thought, would have been a lot easier with a single table with additional columns to manage grouping at lower levels. As it is, this is the sql to the report recordsource called qry2024_TstNum_EFG_summary: SELECT DISTINCT [State Name], TstNum, 1 as Grp, 0 as lvl, 0 as lvl1, "Grouping Title...