Recent content by TelcoBT

A long shot this one, but does the database compact and repair OK? I ask because I read about a 'DECOMPILE' option that I've used a few times that suggests that not all compiled code is removed in certain circumstances and using it did solve a couple of odd problems for me. I'm certain I read...

If all fields flickering then I would guess that somewhere you have refresh/requeries cascading - I used to get this on a complex subform I inherited. The bad news is that you may have to put in break points and step through code, I did and even then I also found refreshes in the event...

If I understand you correctly, Yes, there are a few ways but being a programmer they are all in Code depending upon how I open the form. *********** If you use doCmd a) In your button to pop up the frmTestScenarios add an OpenArgs (I think that is the name - I'm not at my Access PC so can't...

I think you have made an error in keying, Note the Sum is MyValues_1 not MyValues in the original SELECT MyValues.Name, MyValues.Value, Sum(MyValues_1.Value) AS Total FROM MyValues INNER JOIN MyValues AS MyValues_1 ON MyValues.Name = MyValues_1.Name GROUP BY MyValues.Name, MyValues.Value; I...

Not sure if this maybe a registry issue, my DB only exports 32K records before complaining and aborting the export - try Microsoft sites.

It may be possible to use SQL, but I would go for code and iterate through the table records and for each record iterate through the fields. One possible design is shown below NB The syntax below is CERTAINLY incorrect, as when coding I use the IDE to the full and let it pick up my typos and...

I am assuming that 'BrowseForFile' is a function of yours, and it is there that the 'browse window' should appear? If so the code for BrowseForFile would seem to be the problem, not this code.

I had so much help from people in here when I first started Access that it's good to feel I contributed for a change! Good luck with the export.

One way is,I think, a matter of knowing the hierarchy of the sub form fields then setting the 'total field' to the sum of them, eg =[forms]![myParentForm]![subForm1]!subTotalField + [forms]![myParentForm]![subForm2]!subTotalField (my syntax above is probably not accurate, as Access isn't my...

If you have imported the CSV file, then you have it in a table, however I would then be looking at a Query to create a new table from your imported table, manipulating the data in the process. If you read up on queries and play around in the 'Query by Example' grids that appear if you select...

I think you need to return a variant from your function, as otherwise it is expecting a date variable.

Simple export into Excel wouldn't be a problem, where a new excel file is created and the data 'streamed in by Access', but exporting to a specified region, would, I think,need VBA , as I think you would need to point to each cell in the region into which you want to add the information.

I'm not at my Access PC so cannot look up the syntax of DateAdd, and not knowing how you intend to record the booking period (eg fromDate to toDate or fromDate for x days) I would look at a loop using the dateAdd function to generate the booking date, and add a new records on each iteration of...

No, but if this is claimed to do it, I would experiment with values other than 0 in the TwainSelect brackets.

Assuming that you are not setting the 'has module' properties of the forms to 'No', then suspect corruption of the database. Take a copy then look at the following site for help - maybe use 'decompile'and see if that helps. The link below is useful...