Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    6
    Views
    15,950

    I would start by just manually pasting the data...

    I would start by just manually pasting the data into an Access table and then writing VBA code in Access which makes a table and populates it from the "pasted" table. Once that works, then it's a...
  2. I think I'm onto something ....

    I see under "Access Options" I have the ability to change the Default file format for creating new databases. So, I will change this to "Access 2003", create a new database and import all the objects...
  3. User level security - how to convert from Access 2010 to Access 2003?

    I read everywhere that I must convert my .accdb file to .mdb file before the User Level Security Wizard will run. But nowhere do I see *how* that is done.

    Does anyone know how to convert from...
  4. Re: How to get data from website to desktop? (Access 2003)

    For anyone interested, here is the answer.

    Working with the website developers, we decided that the website form would publish to a Comma-separated-values (.CSV) text file, which would be sitting...
  5. Replies
    4
    Views
    423

    Re: ftp from Access ('access 2003)

    Thank you Hans. I've now successfully attached the file. Yes I did mean post 553,191 please make it editable and I will attach the code to it as well.
  6. Replies
    4
    Views
    423

    ftp from Access ('access 2003)

    Hi - the attached code will go to an ftp server, look for a file, and download it and parse it into an Access table. It can be called manually by a button click or by a timer.

    The main routine is...
  7. Re: Excel automation from Access (Access and Excel 2003 sp 2)

    <big>Thank you Hans! and goodbye brick wall </big> <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Nothing I tried would work! I spent HOURS and it was all because I went ...
  8. Re: Excel automation from Access (Access and Excel 2003 sp 2)

    Thank you Hans, especially for elegant "Set xlBook = xlApp.Workbooks.Open(strFilePath)" . Apologies the duplicate code - i sloppily edited more complicated code trying to illustrate my problem. What...
  9. Excel automation from Access (Access and Excel 2003 sp 2)

    Hi - I have code which works fine in Excel but when I try it from Access i get an error "ActiveX component cannot create object".

    In Access I have a project reference set to Excel and I'm using...
  10. Re: Not Like....Not In ('...') (VB.NET, Access 2K3)

    ... and also there's all of us who read the answers and are silently enlighteded as well! I add my thanks to yours.
  11. Replies
    2
    Views
    527

    Re: Fire NewWorkbook Event (Excel 2003)

    Thanks Hans - I'll re-think how I'm doing this.
  12. Replies
    2
    Views
    527

    Fire NewWorkbook Event (Excel 2003)

    I know I've done this before, but for the life of me, I can't figure it out now! <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    I am building an Excel app as a template. I have a...
  13. Replies
    14
    Views
    701

    Re: Networking concepts (WinXP Access 2003)

    Charlotte and Wendell - Thank you so much for this discussion. Most informative.
    <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>
  14. Replies
    5
    Views
    508

    Re: Avoiding a dialog box in Word (Word97)

    Thank you Chris - I've just spent an hour trying to figure this out.
    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
  15. Replies
    9
    Views
    1,069

    Re: Event Procedure Code (Access 2000)

    You'll also need to create a procedure to change colours for the text of Total Exposure. You'll need to do this everytime you change either Likelihood or Consequence PLUS everytime you move from one...
  16. Re: How to get data from website to desktop? (Access 2003)

    Hi Scott, First - THANK YOU <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15>

    I really like the code within your application because you're using the Windows API directly....
  17. Re: With Statements get split unnecessarily!! (Excel VBA (Macro Recording)

    Makes a lot of sense and is fascinating.
  18. Replies
    3
    Views
    607

    Re: New user ASPNET (Net 1.1)

    Hi Chris - I found this interesting reading: ASP.NET & applicational domains (AppDomain) at http://www.codeproject.com/aspnet/aspwp.asp. I guess if you really wanted to delete this account you'd have...
  19. Replies
    3
    Views
    992

    Re: 4 days of hell (vb.net)

    Is there any way you can simplify this code for us? It's a lot to read.
  20. Re: How to get data from website to desktop? (Access 2003)

    Scott - I've been busy writing the proposal as I'm sure now that I'll be able to fulfill. I haven't reviewed your code yet, but will start later in the week. Thank you!
  21. Re: How to get data from website to desktop? (Access 2003)

    I'm looking forward to seeing the code <img src=/S/eyeout.gif border=0 alt=eyeout width=15 height=15> ... does it use an ITC contol inside Access VBA to connect to the web site?
  22. Re: How to get data from website to desktop? (Access 2003)

    Hi Scott - Yes the Access database is on a website which can handle .asp.

    Please let me know how you accomplish the feat of getting the data from the database on the website and populating local...
  23. Re: How to get data from website to desktop? (Access 2003)

    hawksway ... yes, but *how* did you get the data off the website so you could parse it? Can you tell me about the 3rd party object that does this?
  24. Re: How to get data from website to desktop? (Acce

    Thanks John - I'm checking with the client to see where they host their site.
  25. Re: How to get data from website to desktop? (Access 2003)

    "a piece of cake"? - I am fascinated. What is this 3rd party object? Did you buy it somewhere?

    I'll be ever grateful for screenshots and any other info you can give me <img...
Results 1 to 25 of 109
Page 1 of 5 1 2 3 4