Search results

I am using SQLite as a backend as the speed/size is so much better. 400 Mbs down to 39 Mbs. Query time 14 seconds down to less than 1. However what would be the best way to append data. Even though the tables are linked, a normal Append does not work, and a pass thru query does not work. Local...

In Win 7 a portion of the folder name is known (xxxx\yyyy), the whole drive must be searched to return the folder path. The drive name may be different on diffent machines. Is there any code to search from the bottom up, compatible with Win 7. As a last resort, a file name is known to reside in...

I have two Oracle databases. One has a generic username and password, the other requires an individual userid and password. The following code returns data from any database, so I know the connect string is correct. Set strCon = CreateObject("ADODB.Connection") strConnection =...

I have a user who works remotely to the office PC using Communicator. To verify a valid user is allowed to open the Access database, the logged in user is compared to a list of valid users. Using Win32_ComputerSystem allows the logged in user to be identified, but only if they log into the PC...

I have a table tbl_Enabled_Routines containing the names of Subroutines and an Enabled field. When I reference the table I want only the enabled subroutines to run. Sample code-: Sub runEnabled_Routines dim db as database dim rst as recordset set db = currentdb set rst =...

I have a table containing the names of Subroutines and an Enabled field. When i reference the table I want only the enabled subroutines to run. Sample code out of my head: Sub runEnabled_Routines dimbd as database dim rst as recordset set db = currentdb set rst =...

I am generating a spreadsheet via Access. However once the spreadsheet is created I need to add code to the Excel sheet. Is there any way to access this part of the Excel application?

I know this has come up before, but the suggested solutions do not work such as setting focus etc. I am using Access 2007. There was no problem doing this with Access 2003. I need to open the form with visible set to false via VBA Current code on the Open event is Private Sub...

Hi, I believe you had a similar problem. Manipulating Excel, I get an Excel process which I can't shut down. All the references to close the file and quit Excel are there, and they are set to nothing. Everything is explicity referenced so there should be no instance hanging. I use similar code...

I have a list of usernames and wish to see what computers they are using on the lan. How do I return the list of computer names? From this I should be able to see who is running explorer.exe to get their username? All the code I can find only works on my computer and not over the lan.

Hi Despite trawling the web and this site, I can't find a simple way to return the name of the programs on the taskbar. :banghead: The reason is I can have many instances of an application running such as Excel, opened from different sources. I need to determine if a specific file is open...

I am running Access 2007 opening a 2003 database. The Nz function is not working in a normal select query. In fact Access does not recognise it as it stays in lower case. Am I missing a reference or is there some other setting?

Is there a way to make reusable VBA/VB code for different Access applications, similar to the way references work ? I have tried writing Dll's using Express 2010 with no luck.

I have a variable that must determine what field must be populated in a table. Is this possible? Sub Get_Variable_Field_Name() dim db as database dim rst as recordset set db = Currentdb set rst = OpenRecordset("MyRecordSet") VarFieldName = "Valid table field name goes here"...

I have a batch file that used to start Access successfully via the task scheduler. But it suddenly stopped working. I can still open Access manually and it compacts on close as per its settings. When I try to compact it manually I get the message it is opened by user Admin on my machine. Nothing...

When I run a pass-thru query, the data is returned, however if a make-table query is run on the pass-thru, the ORA error is returned. The pass-thru query's time out is set to 0. I don't think this is an oracle error because the pass-thru query works. Any ideas?

How do I list all files in a web folder when the page loads? I am trying the following code, but I cannot determine the path (strPath) of the webpage. <head> <script language = "vbscript"> public Sub RunScript() Dim objFSO, objFldr Set objFSO =...

I have an app that dumps time fields into Excel in format hh:mm. The problem is that the app can generate negative time e.g. -09:23. When dumped into Excel, Excel place a = sign in front and displays #VALUE!. If you click on the cell the value is displayed as =-9:23 but I cannot access the value...

Here is the code I am using in Access 2007 to manipulate Excel. The sheets are renamed, but the workbooks remain hidden, and will not copy. It fails on the Copy After command. I am using Excel 2007. Any idea what is wrong? .... DoCmd.TransferSpreadsheet acExport, 10, "tbl_A, "C:\A.xlsx, True...