Search results

  1. T

    Import multiple files

    Has anyone here ever wrote code that could import multiple files (in this case .csv files) into different tables (in this instance 6 files, 6 different tables) and then set up the relationships correctly? The database will contain the same queries, forms and reports. Just it will be used in...
  2. T

    Importing Rich Text

    Yes, the actual RTF tags are importing into MS Access.
  3. T

    Importing Rich Text

    I have a .csv (MS Excel) file I need to import, but one of the fields contains rich text format text. Is there anyway to clean this up before or after it is imported? Thanks, T.J.
  4. T

    ADP search apostrophes

    I am banging my head against the wall, and coming up with no ideas, so I figured maybe I could give you guys a new problem :D Okay, I have a search form, that allows the users to select from 4 different combo boxes. Once they select what they want to search against, they can click the...
  5. T

    Unrecognized Format .ade 2003

    I have an MS Access .adp 2000 project I successfully converted from MS Access 2000 to MS Access 2003. It works just fine, and I am excited it was so easy. But when I create the .ade file (executible) it continues to give me the error "Unrecognized Format" when I attempt to open it up. It then...
  6. T

    Machine with both Access 2000 and 2003

    I am going to be working on my companies MS Access 2000 to MS Access 2003 conversion project. I am wanting to install MS Access 2003 on my machine (only Access not the entire office), but leave MS Access 2000 on it as well (so I can work on the old 2000 files if need be, before they are...
  7. T

    Multiple queries exported into csv files.

    I have a database with 300+ queries and I need to export them to seperate csv files. I could go through each single query and export it to a csv file, but this will take a long time, and this appears to be a new process that I will have to perform nearly every day. So I am sure there is a way...
  8. T

    Report locking up

    I get so much great help on this board, I wanted to come back and share what I have learned. I looked into this problem and found the reason the report was locking up was the "Keep Together" property. I had this set to yes on all my group levels. Once I set it to "no" on all group levels the...
  9. T

    Report locking up

    I have an MS Access report with 3 groups, and then sorted by a field within the details section. It works great, and the users are excited. The report is generated by the users selecting values from some drop down lists, a query being built by code, and the report opening up (populated by the...
  10. T

    Sorting a report via code

    Select Case Forms!frmSelectPriority.frameOrder.Value Case Is = 1 Me.GroupLevel(1).ControlSource = "MainIssueID" Case Is = 2 Me.GroupLevel(1).ControlSource = "IssueName" Case Is = 3 Me.GroupLevel(1).ControlSource = "IssueDate" Case Is = 4...
  11. T

    Can Grow memo field lock up report

    I have a report with a Memo field. The font size is Arial 10 on thie memo field and the Can Grow property is set to "yes". Most of the time this report formats just fine. But with one of the larger data return sets (query returns 88 records compared to usually 20) the report locks up. It...
  12. T

    Crystal Report Viewer Control

    I added the Crystal Report Control to my form and coded it correctly and my Crystal report opened correctly, yippee. Then I tested this over the dial in server environment and I was suprised to find this control will not work on our dial in server environment :(. So I found that the "Crystal...
  13. T

    Environ("home") through dial-in

    Since I get alot of help from this message board, I wanted to post what I found so that it may come of help to someone else in the future. I searched on the net and found the function Environ("Username"). Using Environ("Username") instead of Environ("Home") allowed me to capture the username...
  14. T

    Environ("home") through dial-in

    We have a dial-in system here at work named Citrix NFuse. It works great for us, but I have come across one error. The Environ("home") code does not work on any MS Access database when they are accessed through Citrix NFuse. If I run the exact same procedure though the database by opening it...
  15. T

    Age Field Calculated from DOB to current Date

    Thank you very much for your help with this. I have tried many different examples, and have been able to find a fix to this issue with your help. Again this message board comes through for me, and I am very appreciative. Again, thank you, TJBernard
  16. T

    Selecting last two instances of a group

    It worked for me. Thank you again for your help. This board has done alot to save me through the years, and it comes through again. Thank you, TJBernard
  17. T

    Selecting last two instances of a group

    I have a query that is required to pull in only the last two (date) instances per a certain user, and I cannot for the life of me figure it out. Here is an example of the records. John Gibson 1/2/2004 $3700 John Gibson 2/2/2004 $3500 John Gibson 3/2/2004 $3900 Brad Miller 1/2/2004...
  18. T

    Sorting a report via code

    It worked for me, thank you very much for your advice. TJBernard
  19. T

    Sorting a report via code

    I got great help here in the past with some code to sort my report through code, depending on choices a user makes on another form. Here is the code that I currently use and works correctly: Select Case Forms!frmOpenIssueReport.frameOrder.Value Case Is = 1...
  20. T

    Report will not maximize

    That worked. Not sure why it wouldn't work on the open command, but placing it in the activate command allowed the report to maximize correctly. Thank you, TJBernard
Back
Top Bottom