Search results

I afraid that backin up a db while it's open could be very dangerous. I would implement some code that runs at a specific time to log all users off and then run you batch to backup. Search for "log users off".

I use a event to lock the users out of the db to make changes. Do a search on "log users off" and posted by Autoeng.

I have a db that I'm fighting with to get it to open in shared mode. Currently it's a link to an unupdateable Excel spreadsheet that's causing the problem but I have some ODBC links to unupdateable AS400 data. Does anyone know all of the types of data that cause a db to open in exclusive mode?

I have an Excel file that is linked to a table in another Access db across our intranet (first tried direct linking to the Access table in the other db but that locked either myself or the other db users out, depending who got in the other db first. I understand that this is an intranet issue...

Go to another computer, copy system.mdw and overwrite the copy on your machine.

Just got it. Forms![frmVCB]![frmVCBsf2].SetFocus Forms![frmVCB]![frmVCBsf2]![DueDateConfirmed].SetFocus For whatever reason I had to refer to the mainform in both lines.

Here is the code I placed in the After Update Event of the combobox. Forms![frmVCBsf2].SetFocus Forms![frmVCBsf2]![DueDateConfirmed].SetFocus I am getting the error that "Cannot find form frmVCBsf2". Name is correct . I tried to clairify the from first but still no luck...

And what event Rich?

Like so?... Forms![MySybFrm].SetFocus Me.MySubFrmField.SetFocus What event would be best? I was thinking in the After Update of the combobox as the combobox never really loses focus.

I have a link to an Excel file (local) exported from another db in an offsite location that I was hoping to use in my db. However I cannot get it to refresh when accessing from within Access. Data is obtained across an intranet. At first I tried linking directly to their table and that worked...

Thanks. I'll give it a go.

Ok I'll try that. How do I set focus to a field on a subform? Forms![frmSubForm].[SubFormfield].SetFocus Yes?

I have a combobox on a form that takes a long time to populate when first selected so I coded the combobox's On Got Focus event to include Me.MyComboBox.Dropdown This works great but after selecting a record the combobox does not close even though the form fills appropriately. I have to click...

Friday: You the man! See a pm I sent ya.

Thanks for catching that error Neil. You are correct in that the relationship is between PRDNO and PartNumber in the tables.

Hi guys, Been a while since I've been on as work has been hectic to say the least. I've got a problem that I hope someone can help me out with though. Got a new db that I'm building that is linked to an AS400 mainframe db. From the mainframe db I am linking to the primary table (tblAS400Data)...

Hooi pointed out that the link was broken but if you want you can use this... http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=235625#post235625

Sam1982: I've been off the forum for a while as work has been too hectic. I will try to get a A97 sample posted soon.

CurrentUser will give you the user and search on "Tracking changes" for the other.

I've been fooling around with DAP's for a while and I would personally recommend moving to ASP as SAP's are very limited and difficult to work with. For instance you cannot select every item on a page to change the font at once but must select each item one at a time. We had to put a lot of VB...