Search results

  1. E

    Using SQLite as backend

    Ok, I will have to shift all queries to the back end as well, and create views etc. The main issue is that our company does not allow Access databases on the servers due to the traffic overheads. Compacting the Access database is done on a daily basis as the read/writes are extensive...
  2. E

    Using SQLite as backend

    Thanks Pat/Jdraw I am using SQLite because some of our Python apps use it. Very easy and compact. No size limit. I had this trouble before with pass thru queries in that they bypass Access totally, and because they only act on the remote database, you cannot refer to a local table as it...
  3. E

    Send Mail From access (VBA Code)

    or do this strBody = "<html><img src=http://www.chrysalis-beauty.co.uk/im...lisbanner4.png height=120><br><br>this is your loyalty points balance.<br><br>have a nice day</html>" and then say .HTMLBody = strBody
  4. E

    Using SQLite as backend

    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...
  5. E

    Access 2010 table export to csv

    Is there a bug in Access? It seems many people are complaining about this. The transfer text does not work as I get error 3441. Even if I create a transfer spec, the message then becomes Transfer Spec not found. The data is pure text with no funny characters except (). MyPathFileName is on...
  6. E

    Folder name known, how to determine Folder Path?

    Thank, but the folder can be anywhere on the hard drive, so the entire hard drive would have to be searched from the root
  7. E

    Folder name known, how to determine Folder Path?

    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...
  8. E

    Oracle DSN-less connection for linked table failing

    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 =...
  9. E

    Identifying user logged into remote PC using Communicator

    Solved. I used the processes to identify who was running the Access application.
  10. E

    Identifying user logged into remote PC using Communicator

    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...
  11. E

    Possible? Refer to Sub using string?

    It sees the Sub name as string, and not as a Sub
  12. E

    Possible? Refer to Sub using string?

    Thanks The issue is not to return the Sub name, but how to refer to it as a Sub to be executed, and not a string value. One solution i thought of was to write code using code, but that is clumsy
  13. E

    Possible? Refer to Sub using string?

    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 =...
  14. E

    Possible? Refer to Sub using string?

    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 =...
  15. E

    Writing Excel VBA module using Access VBA

    Resolved, I discovered the VBA Add-In Object Model
  16. E

    Writing Excel VBA module using Access VBA

    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?
  17. E

    Visible property of Form not working

    The database is in a trusted location. I can see in the Immediates window the status change. I can make it invisible when the code runs (checked by stepping thru the code). However immediately the sub stops running, it becomes visible. I tried to set the focus to another form as well in case...
  18. E

    Visible property of Form not working

    Hi, thanks for the repsonse. However the form loads automaticalty when the database is opened. It is used to supply reference data, and opens another form which is the main switchboard. I could hide the fields on the Switchboard form, but am trying to find out why I can't open the start up form...
  19. E

    Visible property of Form not working

    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...
  20. E

    sending email using dynamic body text

    .AddAttachment =
Top Bottom