Search results

Thanks for your reply Ridders, The start-db takes care of backup and FE-updating actions which can not be done in the frontend itself. The 'xyz' doesn't represent code but it is just a string that is passed to determine if the main db is started from the start db or directly. I fiddled around...

Hi, in a start-accdb I'm using the following code: Shell """" & SysCmd(acSysCmdAccessDir) & "MSACCESS.EXE""" & " """ & "H:\Test-FE.accde"" /cmd" & " ""xyz" & """", vbNormalFocus to open the main database in which the value "xyz" is checked to see if the database is opened in the right way. I...

Thanks again Static. I see. I did some further testing and the sendkeys is used so that users don't have to type the prefix. And....it seems that normally they don't see the combo dropping down at all, they enter the remaining characters and hit tab after which the main form record gets...

"Can the user pick values that don't start with those characters? If not you could just filter the list." At the moment they can, by removing the prefix characters. But I'm not completely sure if there is ever a need for that. I have to check with the users. What do you mean by filter the list...

Thanks Steve for your time. I did not know that was possible. There is one difference with my situation and that is the order of the fields in the combo: 1. Ref Number 1 (not unique) (first column (not visible)) 2. Ref Number 2 (unique) first (second column (visible)) 3. ID number (primary key)...

Thanks, I was afraid of that. It's a complex form with lots of other controls, code and dependencies (to other forms). I'm afraid that I will unknowingly mess it up. But I will look into your solution anyway... John

Thanks. I did replace the characters but it didn't work. However, I did some further testing and I found that the combo box consists of 3 rows of which the first isn't shown (0cm). So I assume that when you set a value to the combo it will try to set the value for column(0) and not for...

Thanks Static, I tested this and the combo drops down, but the "foo" is not entered into the field. John

Hi all, In a inhereted db, in a form, there is field A (search category) which, in its 'after update' event, has code to set focus to field B (wich is a combobox (and set to 'only in list')). After that piece of code there is code that uses 5 sendkeys commands to send 5 letters/numbers to field...

Thanks MrHans. I didn't know that. I tested it and I can confirm that a query does the same job as a table in that respect.

Yes, that's what I mean but the article does not answer my particular question ;-)

In a backend/frontend database configuration: For performance benefits I've read that in a session it is good to have one table always open (for instance the control table in het main menu form). Is the same benefit applicable if it is not a table but a query in the control source of the main...

Thanks, but that is not an option. All departments work on the same (physical) drive. John

To deploy identical frontend db's for 9 departments, all with their own backend, I have code in my pre-deployable frontend to relink the tables automatically. But I have to do this action (opening the front end, confirm and close it) 9 times. I was wondering: could I run this relinking code from...

Excellent! It works! Thank you.

Hello, In an inherited database's module I'm trying to create one function out of 10 almost identical ones. I know how to do this except for this: In the code of every one of the 10 functions there is the following field reference: Forms![MyMainForm]![MySubForm].Form![MyFieldName08].Requery...

Thanks Ranman, though I really don't like this behavior in Access. I will check out if I can set an extra status message but I think it will be overridden by the compact action.

Thanks. My understanding is that it is good to prevent corruption by compacting and in that way fixing errors that haven't occured as corruption yet. And I thought compacting fixes corruption in stead of causing it. I understand that the most experienced developers say that a well designed db...

Hi, for our company's Access 2013 application we use a Start.accde which, daily at first startup, compacts and then backups the backend, before opening the frontend. Before the Start.accde starts compacting the backend, it shows a form with an estimation of the compacting duration (now about 3...

Yes, we're thoroughly preparing the migration to 2013 and the splitting of the db's. Thanks, I checked the tool and that will certainly help.