Search results

  1. S

    Split DB Woes

    Can a tool like the Jstreet relinker help you? http://www.jstreettech.com/downloads.aspx SHADOW
  2. S

    How do I get the path of my BackEnd databases?

    If it helps anyone, this is the code I use (credit to Albert Kallal): Function strBackEnd() As String Dim mytables As DAO.TableDef Dim strTempBack As String Dim strFullPath As String strFullPath = "" For Each mytables In CurrentDb.TableDefs If...
  3. S

    Tip Access Examples

    I had the same issue using Chrome. SHADOW
  4. S

    PDF Making in Access 2003

    As it exports, you get a file dialogue box that lets you enter a filename for the exported PDF. SHADOW
  5. S

    PDF Making in Access 2003

    I don't use a PDF writer. I use Lebans' solution: http://www.lebans.com/reporttopdf.htm SHADOW
  6. S

    Can not share the back end data base under Multi user enviorment

    I've encountered this annoying problem. It SEEMS to happen more in Access 2010 than other versions. One thing I've tried that sometimes helps is to set the target of the desktop shortcut that points to the FE to the location of Access rather than directly to the FE. So, it might look something...
  7. S

    Spell Check Options for Runtime

    I use Tinyspell: http://www.tinyspell.numerit.com/ They have a free version and I like that it corrects as you type, rather than having to press F7 to spell check after you finish typing. When you install it, it spellchecks everything on your computer which may be annoying, so you can set it...
  8. S

    How can I add VB code to refresh form after change?

    Set a variable that will contain the record ID of the record you want to go to, then requery, then advance to the record whose ID you've stored. Here's a simple example: Dim remember_me As Long DoCmd.Echo False remember_me = Me.ID Forms!MyForm.Requery...
  9. S

    Hi from Canada!

    Welcome from Toronto. SHADOW
  10. S

    Access 2010 form calculated field not showing

    Most welcome. Glad I could help! SHADOW
  11. S

    Access 2010 form calculated field not showing

    Does this hotfix apply to you: http://support.microsoft.com/kb/2899528 SHADOW
  12. S

    Using the cloud

    Are they being used in both locations simultaneously? If so, DropBox will not work for you. This link might help explain: http://www.vb123.com/Pages/kb/201201_gr_dropbox.aspx There are other options such as a web app or terminal service deployment but first please explain what your needs are...
  13. S

    adding a help (.chm) file to access application

    When you open the CHM file outside of the application, does it load completely or does it load the way it seems to be loading using the shell? If it doesn't load correctly then I would suspect something is wrong with the CHM file. SHADOW
  14. S

    Comm Ports without mscomm32

    I'm glad it works. You are most welcome! SHADOW
  15. S

    Comm Ports without mscomm32

    It's really hard to know without knowing what "end file" terminator they are using. Maybe it's in the documentation somewhere? SHADOW
  16. S

    Comm Ports without mscomm32

    It's hard to advise without knowing more about the device or how it's supposed to read the port, but here's the code that I use for that purpose. I put my data into a variable called DataRecord: DataRecord = "" ' Wait for data to come back to the serial port. Do DoEvents ' Read...
  17. S

    Comm Ports without mscomm32

    I can't help that much especially since I don't know what you are doing but I was able to use this: http://www.thescarms.com/vbasic/CommIO.aspx I recently built some functionality that reads a com port into an access application using those functions. I hope it helps. SHADOW
  18. S

    Israel

    The link was just to an image for reference rather than to description of tunnel activity. SHADOW
  19. S

    Israel

    The argument is that the homes/schools/hospitals/mosques have been used as weapons storage and launching facilities. The tunnels between Israel and Gaza have been intended and have been used for terrorists to sneak into Israel and attack citizens. The tunnels used for smuggling are at the...
  20. S

    Automatic Backup - Access DB

    The way I implement backups: - I use Albert Kalall's method of zipping the database: http://www.kallal.ca/zip/index.htm This puts the date on the Zip file for you and moves it to wherever you want. Zipping also keeps the file size down. - For split databases, I make the slight tweak of first...
Back
Top Bottom