Search results

Hi Tim, I wondered about that, but where would I code "CloseDB = True"? I think I wouold need to code it in an event where the application is closing but not yet closed. I am not aware of an Application Unload event analogous to the Form Unload event, otherwise I could use that. Thanks, Keith.

If your elapsed time in the details is called ElapsedTime, the following should work (don't forget the = sign): =Avg([ElapsedTime]) HTH, Keith.

Hi, Simply copy the above code to the Form's Open or Load events. (Better programming practice would be to create a sub and call it from both places). Keith.

Hi, I have scoured the forum but not found a satisfactory answer to my query. I hope someone can advise. I have a form I want to open first when the database is opened, and not allow to close until the user closes the database. I can disable the close button using Close Button property = No...

Oh, thanks. I will look into that. I guess there is no answer to my original question! Keith.

Hi again, Sorry, I don't understand the difference between using DAO vs RunSQL, I think the result would be the same, a row is added to the SAP_MessageLog table. The size of the table will be negligible in any case compared to the other data tables I use. Thanks, Keith.

Hi, Thanks for your comments. The main need for this is to handle error logging. I have an automated "refresh" process that will run daily. Any errors need to be logged into a table without interrupting the refresh process. The refresh process needs to run unattended, so no warnings or errors...

Hi, I have a subroutine where I need to know whether SetWarnings was on or off, so I can turn it off if necessary, and restore it to its prior state before returning to the calling script. In other words, I need to suppress warnings in the subroutine, but not affect the status of warnings in...

Hi, When you say "in tables" do you mean in datasheet view? You will probably want to change the form to Continuous Forms (in the Default View property). Then you can format the record how you want it. You probably don't want Single Form because there may be many records in the subform for one...

Hi Dave, I understand from reading other threads that you can use an unbound form plus code to simulate a bound form, and in some circumstances this is the only way to achieve what is required. Pat Hartman referred to the case of a spreadsheet-type form in this thread...

Hi, I am puzzled why you created any 1:1 relationships. I would have expected the Customer table to have 1:Many relationships with each of the other tables (e.g. there could be zero or more Orders for a Customer). I think you will need to create subforms for the data on the other tabs, and...

Hi, I (think I) need to create an unbound form to implement a spreadsheet-type interface. The form needs to present a one-character value from each row of data, in a grid which will be 7 columns wide and up to about 15 rows high. The problem is the need for the number of rows to be variable. I...

Hi, No, talking about Access. There will be relationships to other data that will be too complex to represent in Excel, and the database will also be multi-user, run via Citrix, so I don't think Excel is an option. Thanks, Keith.

Hi, I am starting a new database. The database should allow users to set an attendance code for each hour of each day, for each member of a fire station's crew. The codes are = for available, blank for unavailable, and a range of other codes such as C for (Training) Course, A for Annual Leave...

Hi, I would like to open multiple instances of a form simultaneously, independent of each other. I checked out the information on this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=49847 The KB article referenced seems to depend on recursive references from one form to...

Hi, I think you need something like: [tblSickLeave subform].Recordset.AddNew if there is no blank record, or [tblSickLeave subform].Recordset.MoveNext if you are sure the next record will be blank. Hope that helps you, Keith.

Hi, Tried that in the GotFocus and no joy. I've finally bitten the bullet and created a minimal sample database with one form that illustrates the problem. If you open the database and then open form performance, you should see the problem - the first Actual value is highlighted. I've included...

Hi, Thanks for the suggestions, I tried Le's sample, and that works fine, but putting the same code into my form doesn't work - the Enter event for the field and the Current event for the form both fire before the form appears, but the field value is initially highlighted in every case...

Hi Le, Tried that, but it had no effect! Thanks, Keith.

Hi, Yup, I've done that in several forms in the application. Its to allow me to set query parameters at runtime (based on selections in other forms) without the user being prompted to enter the parameter values. Works really well, except that I now find that the Load event doesn't happen...