Search:

Type: Posts; User: mcowen; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Pass-Through Query vs SQL using From IN Clause

    I've been doing some performance testing of a pass-through query to a MYSQL database compared to an SQL statement using a From IN clause with the appropriate connection string. It appears using the...
  2. Replies
    1
    Views
    371

    Creating a Code Library

    I would like to break out many code modules and put them into separate code only modules databases which would be "linked" back in via References. From my limited understanding it looks like it...
  3. Replies
    5
    Views
    1,829

    Thanks to both of you for your help. I don't...

    Thanks to both of you for your help. I don't have any boolean fields in the MySQL tables and I also don't have a timestamp field. As I continued my searching I ran across the recommendation to be...
  4. Replies
    5
    Views
    1,829

    Write conflict with MySQL

    I've created a MySQL database and uploaded two tables from an Access back-end database. To test the potential impact I created a copy of the front-end application and changed the links to point to...
  5. Replies
    3
    Views
    778

    Paul, Thanks for the insight, could you share...

    Paul,

    Thanks for the insight, could you share a vba code snip-it on how you do that?

    Marty
  6. Replies
    3
    Views
    778

    OBDC Connector Created with Empty Values

    I have an Access 2007 front-end application which links to a back-end MySQL database. I now need to distribute this to a number of users and I thought I'd add code to build the required ODBC...
  7. Replies
    0
    Views
    534

    Chrome Not Displaying recaptcha form

    I've run into an issue in which Chrome (23.0.1271.64 m) on my laptop (Win 7 64bit) does not display a website's recaptcha block, but my desktop (Win 7 64bit) Chrome (same version) does display it...
  8. Replies
    0
    Views
    456

    Hyperlink Internet photos into report

    I'm attempting to create membership directory suitable for printing from information in a web-based MySQL database. Thus far I've been able to build the OCDB connection, link the necessary MySQL...
  9. Replies
    11
    Views
    1,835

    John, Thanks for the additional thoughts. The...

    John,

    Thanks for the additional thoughts. The up side is it worked as you suggested. The downside is without reducing the height on the picture control when there is no picture every detail line...
  10. Replies
    11
    Views
    1,835

    Got a chance to try it, unfortunately no change,...

    Got a chance to try it, unfortunately no change, still get the gap.

    Marty
  11. Replies
    11
    Views
    1,835

    John, I guess I'm either not understanding...

    John,

    I guess I'm either not understanding your point or I've not made my problem clear. I'm happy with the presentation of the image in the control even if there is blank space to the right or...
  12. Replies
    11
    Views
    1,835

    John, I've tested setting just the width and...

    John,

    I've tested setting just the width and setting both width and height, no change. I have the Size Mode set to Zoom. I tried reducing the height to 1", still get the gap but it's only 1"....
  13. Replies
    11
    Views
    1,835

    Micromanaging a report format

    I have a need to try to compress a report as much as possible. Two main report controls are one displaying a table memo field and a second displaying a table OLE OBject (embedded picture). About...
  14. Replies
    2
    Views
    871

    John, Thanks much. I think I got close a...

    John,

    Thanks much. I think I got close a couple of times on the syntax, but never quite got there.
  15. Replies
    2
    Views
    871

    TextBox Datasheet Caption

    I have a need to refer to the Datasheet Caption of a TextBox in a Msgbox prompt, but have so far been unsuccessful in figuring out the proper syntax to do this. The Msgbox is in the TextBox's...
  16. Replies
    8
    Views
    2,498

    Mark, One approach would be to create a .kml...

    Mark,

    One approach would be to create a .kml file of as many locations as required and then either open that from within Access or from Google Earth. One of the nice side benefits of the .kml is...
  17. Replies
    9
    Views
    7,877

    Boyd, Ah there's the rub. I'm currently...

    Boyd,

    Ah there's the rub. I'm currently trying to figure out how to go about accomplishing either of these to projects. My initial thought has been to do the work from within Access, but as...
  18. Replies
    9
    Views
    7,877

    Boyd, Happy too, andthanks for your interest....

    Boyd,

    Happy too, andthanks for your interest.

    First somebackground, my client performs reserve studies for entities such as condoassociations, planned developments and park districts among...
  19. Replies
    9
    Views
    7,877

    Thanks for the reply. I should have included in...

    Thanks for the reply. I should have included in my original post I wish to do this work fro within Access 2007/10 using vba.
  20. Replies
    9
    Views
    7,877

    Creating OneNote Notebook for Access data

    I have a need to create OneNote notebooks with notebook, section and pages title names coming from an Access query. I've found a few examples of creating pages via vba, but have not found anything...
  21. Replies
    2
    Views
    1,682

    Create/Edit Report in mde/accde

    Is there a way using vba, to create or edit a report in a .mde or .accde database? I'm getting a "command not available" (#7802) when I attempt to open via vba a report in edit mode.

    Thanks,...
  22. Replies
    9
    Views
    1,970

    John, I believe that's exactly what I'm trying...

    John,

    I believe that's exactly what I'm trying to do. My AutoExec calls a function which tests the value/s passed through the Command function. I've a couple of shortcuts setup, one with and one...
  23. Replies
    9
    Views
    1,970

    I need to modify the properties of several...

    I need to modify the properties of several controls on a FE form. I'm attempting to put together a small Access db which when Run would execute the updates. I'm bumping into the need to provide...
  24. Replies
    9
    Views
    1,970

    Thanks John. Unfortunately I don't have the...

    Thanks John. Unfortunately I don't have the opportunity to modify the FE's to utilize the AutoExec approach.

    I'm using Access 2007 and it's not recognizing .EnableEvents. Is there a reference I...
  25. Replies
    9
    Views
    1,970

    Open Remote FE DB and Bypass Display Form

    Is there a way to remotely open, via vba, an FE database and bypass the specified Display Form (as if the Shift key was held down on a manual opening)?I've looked at Command line switches, but they...
Results 1 to 25 of 193
Page 1 of 8 1 2 3 4