Search results

This might be more a windows problem than Access but I post it here on the off chance. While working on my database from home, I log into a remote server via a VPN. I have two drives mapped to the server and when I connect, neither drive is active until I open them via file explorer. I use the...

Hey DickyP. This is exactly my situation. A portable hard disk that has a full copy of the system and the accdb copy, drivetype 2. The two remote drives, type 3, have the split database and the accde files in separate folders. So the portable drive goes with me all the time and is type 2 here at...

Sorry, I must have missed that, I obviously didn't see what I was looking at! Thank you for you time and input. John

The problem was the missing "\". For Each sDrive In oFSO.Drives returns E.G. "C:" I was telling it to find "C:Images" instead of "C:\Images" I also modified the code to reduce the times "If oFSO.FolderExists(sDrive & "\Images")" has to run Private Sub getDrives() ' tempvars!drive is any...

The original code in the link has pfso set a an object and ofso = pfso. In my book they are both of type object. The code I posted is the same but without the early / late binding option. Many yeas ago I told my apprentices to "See what you're looking at"!. #If FSO_EarlyBind = True Then...

You can find the original article here. https://www.devhut.net/vba-fso-files-folders-drives-and-more/

I can't remember who wrote this originally but the idea is that you don't create the object every time. You create it once and re-use it as often as you like. oFSO and oDB behave the same. There is a slight time advantage as you only create the object on the first occasion, nor every time you...

Just to set the record straight, the following code is in a module and is called throughout the software without dimming. Public Function oDB() As DAO.Database If pCurrentDb Is Nothing Then Set pCurrentDb = CurrentDb End If Set oDB = pCurrentDb End Function Public Sub...

It seems there is a reply to this thread but I can't see it so I will answer from the email. oFSO is set up in a module as a public function so does not need to be Dimmed. I will try setting drive as "Drive" Drivetype 1 is a removable drive, I.E a floppy disc.An external drive is type 2. I fell...

I know it rankles some when I say that but let me demonstrate! I have three drives that are part of the data paths for my system. Drive "J" is a portable hard drive. Drive "Y" which is a mapped remote drive. Drive "Z" Which is a mapped remote drive. When I run the software in accdb mode access...

Hi Doc_man.. Thank you for the response. Most of my forms do have a beforeupdate event which I use for history purposes but this one doesn't, nor do any of the controls on it. All of the controls are visible at all times and none are disabled, ever. "One is that "X" already HAS the focus." My...

I think I see the logic, you're giving cboOne time to settle. Unfortunately the error persists.

I'm not sure what this will achieve, that is I don't understand what it is that you're doing. If it will have a similar effect to "doevents" then I have tried that without success.. To avoid problems with the accde version, I load the subs with on error resume next. While this gets around the...

they are all strings. I tried changing the "call cbonow_afterupdate" to "cbonext.setfocus" with the same result. I have a table with the steps through each combobox listed if that is of any interest.

I know this has been discussed countless times but here we go again. First, the form is visible as are the controls involved. The form does have a subform but it is not directly involved in this error. I have a series of comboboxes with code similar to that below. If the sequence of events is...

I have an unbound combobox with a query as the row source and limit to list = true. Is there a way to retrieve a "not in list" entry from the combobox. The idea is to use the new entry to add to the list in the notinlist event so the operator does not need to re-enter the text. Trouble is...

I recently has a situation where I had to prematurely close an accde file. This closure left a number of tempvars on the system. My opening sub checks for the existence of one such tempvar to either run the startup routine or go straight to the main menu. The result was that the main menu was...

That's pretty much what I thought, just looking for some confirmation. As an abseiler, I do jump off tall buildings and survive to tell the story!!

I have a situation where my university's IT has had to limit trusted sites within the system thanks to Microsoft's advances in technology.. To this end I have been allocated a trusted site where the Back end now resides. This has worked for us, to degree but I'm having a problem where the...

Form1 has some 90 controls and it takes a bit of time for it to open, especially over a wireless network.. If we're going back and forth, which is often the case, waiting for the Form1 to open slows down the work flow while simply hiding it means it is instantly open when needed.