Search results

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...

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...

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...

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...

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...

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...

Dear forum members, I inhereted 10 similar non splitted databases (A2013) of which I'm told they have differences in code and form design, not in tables design. My idea is to split all db's and create one generic frond end. I've looked at some tools to compare the 10 frontends but those are...

Simplified, I have the following table: ID Registration* (primary key) ID Customer Registration date Registration type so where a customer can have 1-n registrations. I'm now looking for a way do calculate the average number of days between the consecutive registrations per customer, which of...

Hello, I have table A which is linked to table B via an additional link table AB. I'm trying to make a query which shows all table A's records but only certain table B's records which meets criteria that are set in the query in table AB's fields. If the criteria are not met, I get no table A...

Hello, Is it somehow possible to save a table's width while in table view in A2003? I tried several things and can't find it on the internet. Thanks in advance, John

Dear forum members, I need to make a report which shows the number of open orders (based on Orders fields Order 'Date Start' and 'Order Date End') per month, for 12 months (based on user input date). So, for example, the question is: how many orders were open (in progress) in september 2014...

Hi all, I'm a reasonably experienced Access user with a current focus on analysis and reporting. Hope to talk to you soon! :) John