Search results

Will keep you posted - will be testing over the new few days

HI Pat, the VPN is only used at the moment because we are connecting to an Access BE. We are looking at Sharepoint Lists as an alternative to the VPN.

Thanks for your responses guys. It is only a temporary database and the Sharepoint option looks like a quick win - not as good as SQL but way better than MS Access BE and maybe good enough for what we need. Also means we only have to make minimal changes to the Front End. We are setting up a...

Hi, We have a split MS Access database, with the FE distributed to users local C drives and the BE on a shared folder accessed over a VPN. I know not recommended, but it worked well enough when the number of users was low. The problem is now there are 30+ concurrent users and we are getting...

I don't on here unfortunately. Its being developed on a machine with no internet access and no way of mailing out, for security purposes. But trust me, the structure of the tables is correct.

Hi, I have a Acc2010 database with a main table tbl_Case and half a dozen or so other tables each of which has a 1-1 relationship with tbl_Case. Each table has a field called CaseID which is the primary key. (The reason I haven't got this as one huge table is that the number of fields would be...

The margin is set is the design of the form. I tried moving the focus away and back in the form_load event, but this doesn't make a difference. It seems to be a display glitch somehow when Access renders the form. (I tried doing a repaint as well, but also no effect.)

Does anyone else have this in Access 2010? Sometimes if I set a text box or combo box control margin (say left or top) to re-position the contents within the control, if the control has the focus when the form opens, the area of the control which is taken up by the margin displays in a...

Thanks for the suggestions guys. The code in the link Micron posted worked a treat. Password gone! Just as I was about to create a new blank database....

I have an Access 2016 database split FE/BE as usual. Running in Access for Office 365. When it was created for the client, I put a password on the BE and the FE. All fine. Now I need to change the password. Changed it for the BE no problem. Opened the FE and re-linked all the tables to the BE...

Sorry for the late reply (only just got round to fixing this!) Worked a treat - thanks DBguy!

Hi Guillem, Unfortunately I don't have an offline copy. What is it you are trying to do? Basically I got it to work by running a procedure on startup which checked for the existence of the reference dB and quit the application if it wasnt found, or loaded a 2nd startup routine if it did, to do...

docmd.RunCommand acCmdOutputToExcel

Hi DBguy. I did try that - the problem is it doesn't open the dialog box to allow the user to name the output and specify the destination. It just automatically outputs with the form name as the file name into the My Documents folder.

Hi, I would like to add a command button to a form which exactly mimics a particular ribbon command being clicked. Is there a vba command to run a ribbon command, and how do I find the list of ribbon commands available etc.? Basically I want to exactly replicate what happens when you click the...

I have a table tblResponses which records responses received for each project in my database. Multiple responses per project, each with a date. Another table tblActivity stores each activity on a project. Multiple activities per project. I want to update each record in the Activity table with...

I ended up populating a temp table from the group by query, with a unique index on the Case ID, and then using this temp table in the update query. Works fine, but I would have thought Access would be smart enough to know if you are grouping on a single field, that field would be unique. I had...

Hi use the following to return a recordset of users connected to an Access 2010 database. All works fine. My question is: it returns a field called SUSPECT_STATE which I ignore. Can anyone tell me what this field represents and in what conditions it is set? Many thanks, Jim Here's the code...

I hear what you are saying, but the database was already designed this way before I took it on. There are several forms which are bound to the Activity table, and the database is operating over a slow network with far too many users, so it is easier to just have an extra field in the activity...

Hi DBguy, I know totals queries are not updateable. I am only using the totals query to get the latest response date for each case. The update query is updating fields in tbl_Activity on the many side of the join.