Search results

Thank you vbaInet, that did the trick!

Hello all! I have a navigation form that will have 6-8 tabs. We were using about that many databases, but we are finally consolidating them into one. The result of us using so many databases has been the multitude of forms and reports that were necessary for each database prior to merging them...

Thank you Gina! I am reading it all now.

If this is covered elsewhere, I could not find it. I have a form that generates a .PDF attachment in an email. When Outlook opens the email, ready to be sent, it prevents the user from doing anything else with Outlook. They cannot click through other emails or copy/paste other attachments from...

We ended up importing the text files into tables in a stand alone database. We then use Windows Scheduler to append the file to the tables. We saved our import specifications so that we could preserve the table names and it seems to be working very well. So far, so good!

As it turns out, user error is almost always the issue. Embarrassingly enough, we had the file misspelled. Seriously, it pays to double and triple check everything. Lesson learned. We decided to go with a table in the backend for Maintenance, along with a form that has a checkbox (the value in...

Thank you again for the help. I think we are going to need to go in a different direction. I appreciate all the input and help!

It doesn't matter what the file name is, which it shouldn't really care as it is just checking to see if it is there or not. At least in theory, that is what it is supposed to do. I tried .doc, .csv, and .txt and it immediately goes to the shutdown mode which makes me think it isn't able to see...

I also put in the msgbox code and it returned the >>> so it is a least opening and going through that part. The problem isn't that it doesn't work, the problem is that it always works no matter what the file name is: .ozx or .old. I will try and change it to a .csv or .doc and see if that...

Thanks for your responses... The Timer Interval is set for 30000 on the Property Sheet, nothing in the VBA code as far as the timer. I added the Me.TimerInterval = 5000 to the top of the Form_Open section and it still went to the default of being "closed".

I have searched several times for a solution to this problem, but can't seem to figure out what the issue is. I have code (copied from here and the MS-Access how to) that has a hidden form that loads on the db startup. Attached to that form is code that is supposed to check for a file, if the...

Thank you for the advice!

Right, the tables are the exact same, only with more (rows) information as the new files are pushed to us every night. The issue we are running into is that the database throws an error when we try to overwrite any of the fields due to the relationships already in place in the database. We have...

Not sure how to even ask the appropriate question (don't know what I don't know), but I need help. We have three text files that are pushed to us every night. We currently have 8 different databases (some are significantly smaller than others) using the same the three sources tables in addition...

I have a table with Program names in it, and a subform that contains notes about the program. If it were working perfectly, the report would look like this: Program 1 -Date -Notes -Date -Notes (where all notes are under the program 1 entry) Instead, I get a complete new record when a new...

Thank you, thank you, thank you! I don't know what the problem was, but your version worked just fine! Thank you again!

I have a query called "Program Status Count" that keeps track of the current status of various programs. There are three statuses: Closed, Deficient, and WIP. On the Query, I used "Total:" row and have two fields: StatusID field set to "Group By" then in the next column I have the same StatusID...

Thank you, that fixed it just fine. I cannot get the Rank to show up...my Table is setup like this: RankID Rank FirstName LastName Can't figure out why it wont show the Rank in the textbox.

I have a textbox that has 3 columns in it (Rank, First Name, Last Name)...when the user selects the appropriate choice, it just shows the Rank. Ex: Lt. John Smith --> just shows Lt. To get around this I made an unbound text box and have it set to show all three choices when the selection is...

I am completely reworking the database from the ground up. Thank you again folks, I appreciate your help. I will let you all know how it goes.