Recent content by Storm3

  1. S

    import and seperating dbf file

    dbf file Hi, The field with the name and address. I would like to separate the field into several columns and I am not that well versed with sql to accomplish this. Thanks for the assistance!
  2. S

    import and seperating dbf file

    I am trying to import a dbf file. My only issue is trying to seperate one column to many. This column uses carriage returns as a seperator and I have been unable to split the column I am attaching a sample to this post. Any advice GREATLY APPRECIATED! David
  3. S

    Display Page footer only once?

    just when I thought it was solved... After adding enough data to make the report got over two pages I discovered that the report generates the space for the page footer but does not display it. I have been trying to manipulate the code to adjust for this but to no avail. Do you think I could...
  4. S

    Display Page footer only once?

    I am currently working on a project that required this and what I have found so far is that the footer only appears on the first page. The one issue I did find is the if you are putting page numbers in the report you may have issues with the total page count. It seems to add an extra page. The...
  5. S

    Access enquiries - what is their worth?

    Clarification on Finders fee Jon, I was seeing it as more of a fee just to give a client a list of candidates. I wasn't sure how dirty you wanted to get your hands. Since everyone is loosely connected I would personally not want to have any culpability regarding the service that a forum member...
  6. S

    Access enquiries - what is their worth?

    Jon, I would think the best plan of action would be to create a listing of members with skill level and location and charge both the Access developer and the end-user a fixed rate for the connection service. That way you won't have to worry about how much a job is worth and also line your...
  7. S

    Who is locking a table?

    Hi Mike, I had a similar situation a few years ago and the only solution I had come up with was installing a macro that sent me an e-mail when a user opened a particular table. I don't recall exactly the exact procedure so I can't go into too much detail. The downside is that some people got...
  8. S

    Display Page footer only once?

    Thank you for your help. Although it was a great suggestion it wasn't working for me. I discovered a way to accomplish this and so far I haven't encountered any bugs with the code. Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) If [Page] Mod 2 = 0 Then...
  9. S

    Display Page footer only once?

    Does anyone have a solution for displaying the page footer only on the first page of a report?
Back
Top Bottom