Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Create a PDF from a DOC (Access 2K, Word 2K)

    I would like to write some simple VBA code to turn a Word document into a PDF. Can anyone take me by the hand and show it to me? It looks quite simple, but Acrobat's documentation is a reference...
  2. Re: Trouble registering ACTIVEX component (Access 2000)

    I too wish to create an Access VBA application that will invoke control of a scanner, so I can have my way with it. Did you ever complete the project to your satisfaction? Whether you did or not,...
  3. Replies
    4
    Views
    543

    Re: Thanx guys....Informative

    I forgot to answer your question -- 3 normalization rules, hence "Third-Form Normalization". Some texts quote a fourth and fifth rule, but they are really further explorations of the first rule. ...
  4. Replies
    4
    Views
    543

    Re: Normalization Rules (Access 2000 >)

    With rules 1-3 you have the right idea (partially), but #4 is not a normalization rule per se. I will add a couple of comments without trying to exhaust the topic.

    2) Not only must each table...
  5. Replies
    4
    Views
    308

    Re: Monitoring correspondence (2000)

    I would do the latter, or more to the point, avoid doing a crosstab at all costs. The key to the latter approach is creating an identifier for the time periods of interest, and grouping on it. It...
  6. Replies
    5
    Views
    439

    Re: Corrupt data (Access, all versions)

    Good thoughts, but they do not apply here. This app runs on a standalone laptop (which means SQL Server/Oracle is not a solution), and the error occurred while the app was running, not as a result...
  7. Replies
    5
    Views
    439

    Corrupt data (Access, all versions)

    Every so often I have an application, as I do today, where the data is inexplicably corrupted with trash characters -- non-alphanumeric special characters of all ascii values, trashing the record --...
  8. Replies
    6
    Views
    377

    Re: Referencing a subreport control (A2K)

    You da man! Turns out that was the exact problem -- trying to reference the subreport control before opening the subreport. The event that worked was the detail format event within the subreport. ...
  9. Replies
    6
    Views
    377

    Re: Referencing a subreport control (A2K)

    That all makes sense ... but I have already checked. I verified there is no problem with the subreport and control names. That's one of the great values of dropping the de###### into Immediate Mode...
  10. Replies
    6
    Views
    377

    Re: Referencing a subreport control (A2K)

    Great! How does that translate into a change for me? What specifically do I need to do differently?

    My problem is not whether it performs as I want -- the problem is, it simply crashes when I...
  11. Replies
    10
    Views
    443

    Re: Detecting a closed Access form (A2K)

    Of course all of you are right about Access. I rarely bother to complain about non-intuitive software anymore, especially when it is produced by Microsoft (kind of like complaining about the bad air...
  12. Replies
    3
    Views
    406

    Re: Hide a control (Access 2K)

    Yes it is possible, and the approach you suggest should work fine. Have you tried it?
  13. Replies
    4
    Views
    343

    Re: Updating DB Files (2k)

    I often have to do this. My solution is not the only one, but here is what I do: I read the spreadsheet into an an empty "temp" table with the same structure as the table I want to update with this...
  14. Replies
    6
    Views
    377

    Referencing a subreport control (A2K)

    All I want to do is turn the control on and off using the .Visible method -- simplicity itself, right? I wish.

    I know how to do this with a control in form -- piece of cake. According to the...
  15. Replies
    2
    Views
    307

    Re: Turning Page Header on and off (A2K)

    Hans,

    You got all the answers! Thanks again. In this case, I'm using the report header for page 1, and the page header for subsequent pages ... we have a data item, for print on the first page...
  16. Replies
    2
    Views
    307

    Turning Page Header on and off (A2K)

    For a multi-page report, I would like to turn the page header on and off -- off for Page 1, on for subsequent pages. I have tried and tried to do this by setting me.pageheader0.visible to true or...
  17. Replies
    10
    Views
    443

    Re: Detecting a closed Access form (A2K)

    Thanks for the solution! But I stick to my guns in calling it stupid: when the action is counter-intuitive, and counter to what I need 99.44% of the time, that's exactly what I call stupid. If...
  18. Replies
    10
    Views
    443

    Detecting a closed Access form (A2K)

    I have a subroutine that 1) I want to open a form and 2) execute some code after the form is closed. Access, being incredibly stupid this way, absolutely insists on executing the code before...
  19. Double and single quotes in SQL string (A2K)

    I understand, or think I understand, all the nuances of SQL statements updating string with values that include single and double quotes. I have to update latitude and longitude values which will...
  20. Replies
    3
    Views
    340

    Re: Reading the forms (A2K)

    Thanks! Both examples are helpful and enlightening, especially the DAO version. However, neither approach seems to give me access to a form's controls. What am I missing here? I tried

    dim ctl...
  21. Replies
    3
    Views
    340

    Reading the forms (A2K)

    I need to write a routine that scans evey control in every form in a database, regardless of whether the form is already open. Is there an equivalent to TableDefs and QueryDefs, but which applies to...
  22. Replies
    1
    Views
    1,002

    GetObject (VBA 2K)

    Where can I find a complete reference for the GetObject function? I have a specific need -- to figure out how to read my local computer's user ID and password -- but I would also like to get a...
  23. Replies
    1
    Views
    411

    Running SQL statements from VBA (A2K)

    I know of two simple ways (without going to QueryDefs) to run an SQL statement --
    db.execute strSQL
    and
    docmd.runsql strSQL

    Is there any reason to prefer one approach over another? Any...
  24. Re: Field Size Limit (2002 (10.4302.4219) SP-2)

    "Virtually" unlimited length? Actually, the length limit appears to be 64K, which for my purposes is not long enough -- I need to store HTML scraped from web pages, and some exceed the 64K limit,...
  25. Replies
    1
    Views
    359

    Continuous Hourglass (A2K)

    I have an application where I invoke docmd.hourglass in order to display the hourglass while a process runs, but it does not work as satisfactorily as I would like. Many such processes open and...
Results 1 to 25 of 71
Page 1 of 3 1 2 3