Search results

I think I might have bigger problems because Access now is refusing to run. It just comes on for a few seconds and then quits. John

The "closer me" is a sub that closes the current form and clears db and fso objects, if any. The call to "Main_Menu" is an error, corrected, as this procedure should return to the calling routine. I can't see where this is happening. In the case of the supplied code, yes there is the calling...

Thanks MajP. The code is not actually hanging. In this particular case it is waiting for input but is not visible. In the case of the backup procedure, it performs normally and passes control to the next procedure. I have stepped through the procedure and put msgboxs in here and there. Apart...

I use .visible=true in most load events to control when the form becomes visible. This works well except for a couple of particular cases. If I run the software in develop mode or click the accde file all is good. If I run it from a shortcut with windows minimized then a couple of the...

If I'm understanding you, I need a call to a sub / function that in turn calls the afterupdate event. If so, should the sub be private in the same procedure or public in a module with reference to the form? I have implemented this, below, and the load event error has gone but the error in...

Calling afterupdate happens if there is only one result from the requery, otherwise the dropdown occurs. Commenting out that call does stop the error but the rest of the program does not run properly. The result of the requery does not appear in the cboGenus combo and the change over from...

Here is a stand alone version of the form. I have added the textbox "txtInput" to simulate the input from a previous form with a spelling mistake. Open the form "getTaxon" and you will see the error.

Hi Docman The hidden controls do not become visible until after the genus has been selected, which is after the error occurs, so there "shouldn't" be any interruption to the flow. I'm working on a stand alone version of the form and will post that asap. There will be a few work arounds...

I provided all the code in my OP and the two queries in a subsequent post. Not sure what else you need. My whole system runs to almost 36000 lines of code but what you have should stand alone .

Yes, I can do that but it's a bit complicated. The cboFamily query is fed by the first 5 characters of a possibly mis-spelt family name from a different form. Hence the loop in cboFamily_gotfocus. This reduces the number of characters in the search until a match is found. Query for cboFamily...

I don't think so because the load event has already passed control to the cboFamily_gotfocus event and on from there, before returning to the load event which, to all intents and purposes, was done and dusted.

In the code below, the sequence of events is as follows; Load event runs through all commands and set's focus to cboFamily. cboFamily gotfocus event does it's stuff. cboFamily_afterupdate runs and set's focus to cboGenus. cboGenus goes through to cboGenus.dropdown. If I'm stepping through, the...

I've got a work around for colouring the active label. It meant renaming the labels to "lbl" and the field names they're attached to, so the field "Access:" has a label "lblAccess" etc. The string going to the sub "Setindex" has " Desc" attached on the double click, so "Access Desc". That takes...

Thanks Doc_man. The double click speed seems to be ok for textboxes and labels so I don't think that's the problem but it's worth a try to speed it up a bit. The limiting factor might be my old fingers can't move fast enough!

Not a bad idea but I have 13 columns that need to be individually indexed ascending or descending depending on requirements. Any column can be indexed and it controls what happens in the other columns so it's not as simple as a checkbox as I would need one for each column. I'll continue to...

I'll have a look at that, it's a good idea. Funny that the double click works ok on the labels and on text boxes. Thank you. John

I have a series of command buttons, set up with the code below , to index a column ascending with a single click or descending with a double click. Using command buttons allows me to change the colour of the active button and enhance the form's appearance. Problem is the command buttons are...

This was for an Access db but a long time ago. someone from this forum wrote two queries. The first did the count and then was use as a data source for the second. Unfortunately I do not have copies any more. From what I know now, the second query may well have been an append query. John

Hi Mark. Not quite. The entries in error are still part of the table. I have solved the problem by using four queries; The first copies all accession numbers that have a dot point and appends both the double and integer values to a temp table. Next group and count the instances of each integer...

It's a bit complicated and specific to the data with which I am working. In plant collection, each collected specimen has an accession number. eg 123 If more than one specimen is taken from the same plant at the same time they then become 123.1 and 123.2 etc. There can be no duplicated accession...