Search results

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...

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

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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

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...

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

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...

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