Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    6,338

    Excellent I've managed to Create a linked file...

    Excellent I've managed to Create a linked file (which is les crude than what I was Planning), I'll have to play with it a bit as it could cause a major revolution, in the way I Code.
    Hopefully I can...
  2. Replies
    6
    Views
    6,338

    Hi, Excellent Yes So I've set this up...

    Hi,

    Excellent Yes So I've set this up successfully from Administrative tools -> Data Source(ODBC) and called it DB1

    Sorry This will save me some scurrying around, do you have a sample...
  3. Replies
    6
    Views
    6,338

    Import to Access from SQL Server

    Hi Guys.

    Really Mega stumped on this one.

    I can download a table line by line after using a connection string:

    Set oConn123 = New ADODB.Connection
    oConn123.Open "Driver={SQL...
  4. OK Thanks. I Think :)

    OK Thanks. I Think :)
  5. .PST File Outlook 2007 - How to open, Read, Change and Add with VBA

    Hi,

    I'm Looking to find some way of bypassing Outlook, so I can update directly into the .PST, as I'm hung up the High Volume Gmail IMAP connection outlook bug. IE I can get at the email store it...
  6. Replies
    2
    Views
    1,728

    Your input is much appreciated (and interesting)...

    Your input is much appreciated (and interesting) I'll peruse them later, however i've used a basterdized method, which involves link harvesting from index pages that has solved my problem. Just...
  7. Replies
    2
    Views
    1,728

    Download Online Documents via HTTP

    Hi,

    I'm looking to download all documents in a Directory of a website (i'm doing this for may sins an a Access 2007 Module).

    For Example http://www.samplesite.com/documents

    I can get...
  8. Replies
    3
    Views
    1,675

    Thanks For your input. I've found a work...

    Thanks For your input.

    I've found a work around that does not involve setting the search order of the underlying table on the form. IE the form will happily hold the table format as I want it if...
  9. Thread: SFTP Libraries

    by graliv1
    Replies
    2
    Views
    999

    Thank-You Apologies for the late reply MOVED ON...

    Thank-You Apologies for the late reply MOVED ON You know how it is!!!!
  10. Replies
    3
    Views
    1,675

    Anyone know the solution for this one? I'm...

    Anyone know the solution for this one?

    I'm using:

    CurrentDb.TableDefs(1).Properties(12).Value = "[Entered]"

    The above being an attempt to change the Order BY property of the first Table in...
  11. Thanks for your response.The reason I'm avoiding...

    Thanks for your response.The reason I'm avoiding the constant is because theres are largish number of modules, however on second thoughts now I can auto recode the paths in modules it would be as...
  12. OK sorry if anyones wasted anytime on this:...

    OK sorry if anyones wasted anytime on this: sussed it. The code below is crude and I'm going to work it up, but it seems to work. Just need to use the .ReplaceLine


    Public Function...
  13. I've been working on this and and using a...

    I've been working on this and and using a reference to "Microsoft Visual Basic for Applications Extensibility 5.3" have adapted some Excel Code I found online, but how do I rewrite the line in the...
  14. Hi all, I've got a 2 part question, my end...

    Hi all,

    I've got a 2 part question, my end game is to create a module triggered by a click to prompt for Desktop Path, that will allow an operator to install a complex file processing access...
  15. Thread: SFTP Libraries

    by graliv1
    Replies
    2
    Views
    999

    Hey guys Hope I find you all well. I've had a...

    Hey guys Hope I find you all well.

    I've had a request to supply data via SFTP.

    Just wondering if anyone has got any free Libraries I'm assuming It'll use ActiveX, unless this is handled by the...
  16. This is in a form, but it also works in the...

    This is in a form, but it also works in the Table: IE if you set a Memo Field to Rich Text. You can use standard HTML Coding/Formatting. Wahay!! (and yes in Access 2007)
  17. OK Sussed it just have to use HTML color etc IE...

    OK Sussed it just have to use HTML color etc IE <font color = "RED"

    Sorry for wasting anyones time, if they read this

    Thanks for helping me focus

    Graliv
  18. Hi Again, I've managed to adjust the Field I...

    Hi Again,

    I've managed to adjust the Field I want to color to Memo in "rich text format" which Allows Text Selection and coloring: does anyone know the most Basic Formatting to color all text in...
  19. Hi all, Quick question (I suspect I will...

    Hi all,

    Quick question (I suspect I will receive a negative response)

    Is it possible to Color Individual Cells (in a Column/Row) in a Form in Access 2007 when in DataSheet View using VBA.

    IE...
  20. Replies
    4
    Views
    449

    Apologies for the delay in reply only just got...

    Apologies for the delay in reply only just got back on this project

    Peter I tried that and it searches for the [Remote_Table] Table in the current Database and gives an error message to that...
  21. Replies
    4
    Views
    449

    Hi, I'm trying to get a faster method for...

    Hi,

    I'm trying to get a faster method for Downloading a web based "SQL server" tables data to a local table for backup, currently i'm using:

    Sub ConnectDB()
    Set oConn = New...
  22. Replies
    5
    Views
    499

    The way I've resolved this is by checking that...

    The way I've resolved this is by checking that all Databases exist and are not open by looping through the known network locations of the files, and checking that the form/Db exists and that the .ldb...
  23. Replies
    5
    Views
    499

    Thanks Oooops. Oh well there goes my Professional...

    Thanks Oooops. Oh well there goes my Professional Status.

    Brain wasn't engaged.

    Graliv
  24. Replies
    5
    Views
    499

    Hi Guys, Anyone solved this one: I need to...

    Hi Guys,

    Anyone solved this one:

    I need to transfer an Access form with module to other machines on the network, during live development.

    I can detect them

    strName =...
  25. Replies
    3
    Views
    497

    Ahhh, Dirty Records!! OK thank-You that clears...

    Ahhh, Dirty Records!!

    OK thank-You that clears it up in my mind, I had a small bug in the code but I've resolved it elsewhere and thought the Exit Behavior could be the Culprit.

    Apologies for...
Results 1 to 25 of 152
Page 1 of 7 1 2 3 4