Search results

  1. S

    Tip Access Examples

    I had the same issue using Chrome. SHADOW
  2. 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
  3. S

    PDF Making in Access 2003

    I don't use a PDF writer. I use Lebans' solution: http://www.lebans.com/reporttopdf.htm SHADOW
  4. 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...
  5. 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...
  6. 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...
  7. S

    Hi from Canada!

    Welcome from Toronto. SHADOW
  8. S

    Access 2010 form calculated field not showing

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

    Access 2010 form calculated field not showing

    Does this hotfix apply to you: http://support.microsoft.com/kb/2899528 SHADOW
  10. 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...
  11. 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
  12. S

    Comm Ports without mscomm32

    I'm glad it works. You are most welcome! SHADOW
  13. 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
  14. 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...
  15. 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
  16. 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...
  17. S

    disable mouse scroll wheel

    I assume you are using Access 2003 or older, as Access 2007 and newer have the mouse wheel disabled by default. The solution I use is Stephan Lebans' which you can find here: http://www.lebans.com/mousewheelonoff.htm SHADOW
  18. S

    Custom Menu Bar Won't Display In Access 2013, Access 2013

    Does this help? http://www.utteraccess.com/forum/Custom-Menu-Bar-Won-t-Dis-t2016770.html SHADOW
  19. S

    Lazy Loading

    Can you load the results of those controls using dlookup or opening the recordsource? I actually do the same in my example that I gave before. On the client's front screen it shows if the client has an outstanding balance, which is derived from the sales and payment tables. I have a query...
  20. S

    Lazy Loading

    Assuming I understand what you mean about "lazy loading", the idea is for data that's not necessary until the user clicks one of the tabs is not loaded until the tab is actually clicked. This reduces the amount of data required to access the record and can improve form performance. I usually...
Back
Top Bottom