Search results

I'm trying to use a button to close a database which has compact-on-exit set. However docmd.RunCommand acCmdCompactDatabase won't run from a form (there are lots of threads about this here), and both Access.RunCommand acCmdExit and DoCmd.Quit both ignore the flag. Is there a way around this...

My table has an auto generated key as a string. So on the offchance that two clients are trying to autogenerate a key at exactly the same time, I'm trying to trap the 3022 error raised when a duplicate key is entered so that I can repeat the operation with a goto. I'm raising the error with...

I have a "number" field which is 12 characters long, called CID held as a string. In the first record it has the value 360126474291 Basically, I wanted to do nextCID = val(lastCID) + 167, but obviously (:o) I get an overflow, so I can't. What can I expect if I use nextCID = CDbl(lastCID) +...

continuous form, ordinal index by function, where? I want the recordnumber displayed on a continuous form. The code below works with the command button, but not afterinsert. Here's the code: (function GetPosition() is the control source) Private Sub Command28_Click() numbers End Sub...

I need to disable a custom goto next record button. How do I find out if the current record is both the last and new or if a new record is possible? Many thanks in advance, Aidan

I have a table with some combo selections with row source No;Yes, bound column 1, column count 1, and default value "No", limit to list set to yes, required = yes, allow zero length = no. When I create a new record though, all of the combos show 0, and I have to select No or Yes manually. The...

I have a tabbook on a bound form, and an unbound combobox just before the tabbook. Whenever I tab or enter out of the combobox the form goes to the next record. Is this supposed to happen? If so, how do I stop it. Many thanks in advance, Aidan

Up until now I've put a tabbook on my main forms and subforms on each page of a tabbook when I want to display various tabledata related to the main form. Now though I want to put the tabbook on a subform, so that I can include it from two different parent forms, but I thought perhaps I should...

How do I find a record number from arbitrary criteria so that I can use gotoRecord? I just can't find which function. Thanks in advance, Aidan

I have a combobox which needs to call a function f(combobox.value) during its onChange event. Currently though, combobox.value appears not to change before the onChange event, and so the function receives the wrong (last) value. Note - the actual text in the text field of the combobox *has*...

Basically I have a table Customers and a table Accounts. #customer is the sole primary key of Customers, and #account+#customer is the composite key of Accounts. A customer cannot create a new account without being a customer, and so normally I would enforce referential integrity and in access...