Search results

Thanks for the reply Plog. The similar table structures are due to a requirement to keep the data from separate sources in their own tables and the data differs greatly from one source to the next, albeit there are a few common fields. --Herbarium_Collection -- I don't know where you got the...

I have created a series of sql strings from stored queries. The object being to reduce the number of queries doing essentially the same thing with a different table. The sql strings utilise " " & sTable & " as A " construct. In the code below,the functions getMFamily, getMGenus and getMColl...

I find using the alternate "A." is the best of both worlds

Thank you both. That clears things up for me. I only ever use standard characters in my table names and have removed all of the spaces. John

I am slowly coming to grips with SQL but this is bugging me. I have resorted to using the following when using a variable in the from clause. "FROM [" & sTable & "] as A " & _ Which seems a bit clunky. Sometimes, but not always this seems to work "FROM sTable as A " & _ and other times...

Thanks Docman. Looks like I've a bit of reading to do.

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.