Recent content by Captain Chaos

docmd.save is used to save an object (query, report,Form etc). You seem to be adding values into controls and thinking that you can docmd.save. Not so. All you are doing is keep saving the form. The subject is more complex than that. Keep taking the lessons.

Ctrl + Tab under control Thanks for that. My problem resolved after adding the code and setting key preview to yes

It seems you can use ctrl+Tab to step through the pages on a tab control and bypass normal events. Is there a way to stop this?

Have tried an empty database and importing everything. No joy. There are 4 local tables in the database and about 30 linked to the backend. Have tried deleting them, compacting and reconnecting them looping thru a table of connect strings and sourcetable names. No joy though. about 25 of the...

Have tried the new database idea but that too fails. The clue seems to be in the tables themselves. It's just one of life's mysteries. Thanks again

Have tried a 3rdParty compacter without success. Have downloaded this one and will try it. To give you a bit more meat, There are two identical databases Merlin and MerlinR. They are linked to Avalon and AvalonR Datasources respectively. Merlin is worked on, upgraded etc and contains code which...

There are no changes made to the live version. Users view, report and sometimes edit the data. Why do all these users have no problems until we compact?

How about something radical. We have a number of databases that people use and we regularly need to close them for upgrade, compaction etc We have a database called Cerberus (the dog that guards the entrance to hades! you'll see the connection soon). This contains a list of database names and a...

One front end used by all. The program is constantly evolving so weekly deployment to individuals would be an issue.

There is a front-end A2k database on a central server used by about 60 people. It works fine until it has been compacted and then after a short time it becomes corrupt. People logged in can carry on but no one new can get in. It's not caused by crashes because on testing, one user has got in and...

Not sure what you're up to but, Have you tried 'Can Shrink' for the groups and controls. if you have an empty group or field it should squeeze up Set them to yes.

Your listbox should have '2' columns and the bound column as '2'. The column widths should be 3cm;0 so that only first column is visible and the list data should read "Requested";0;"In-Progress";1;"Cancelled";2;......etc That is, if you say there are 2 columns then the list must be in pairs. If...

I agree, why not use Int? I was continueing the thread but why use 3 letters when 4 will do? Using my formula of adding .5 to 683.333 would give you 683.833 which should INT to 683.

if ([SumOfRunTime]/[SumOfOccurances]) produces a number like 333.8, by adding 0.5 to it (= 334.3) and then CINTing it you get 334 which I think is how my parentheses work.

To get it to round to the nearest whole number try =CInt(([SumOfRunTime]/[SumOfOccurances]) + 0.5)