Recent content by outofpractice

Thanks for the reply. This was a good idea as well - I always forget about the Query Wizard functions and just go into Query Design. I bet this would have easily worked - my own fault for overlooking this.

I think that this has worked - I'll have to spot check the results but it looks 100% better than what I had been receiving. I can't think you enough!

I have which I thought would be an ultra-simple matter that is turning into nothing but trouble - I'm under a time constraint and am getting to the point where I have to look for assistance - so thought there was no better place than this forum. Basically I pulled some data into an access...

It worked! Thank you so much for walking through this with me, I appreciate it!

I'll plug that back in and see what happens. Thanks!

The first example I receive: Invalid or Unqualified reference When I used your second example it worked to pull back the record specified by the number I entered.

Thanks for that - I realized I had another problem and that is why it was only putting one report out there - I was referencing an old report as well. I updated with your suggestion to close the file and was able to get to the point where it puts each file out there dynamically named based on...

I'm getting closer - but still am not there so hopefully someone can review this code and let me now where's I'm wrong. When this code runs, it looks like it is looping through all of the records on tbl_Part3 - but it is only writing the first result. It brings up a report view as well and it...

OK - fourth time trying to write this reply. I keep getting stuck in a sign in loop where I sign in then get the sign in page over and over! Since my first post I have been playing around and have it doing what you said - I added a table with the two different test systems, affiliated each of...

A coworker has a set of test files (txt format) which they use consistently - sometimes the test region they are using changes so they have to open up each file and change a small portion of it to point to the new test region. (There will be other changes done as well sometimes, or...

I am looking to improve a current report model that consists of spreadsheets all over the place for each and every month, quarter, year, etc. One of the things that I am going to attempt to integrate is some web reporting to my companies biggest client. What we currently report to them is...

I have a macro to Requery the subform in the On Exit event for the Weekly_End_Date field of the main form. I did it this way because that should mean the dates have been entered - the query re-executes which then displays the total count for the date span. Maybe not the most elegant things but...

sneuberg - I did a compact last night, and while I haven't had a lot of chances to mess with this yet today the error has not occurred yet (So hopefully that fixed it) Galaxiom - Thanks for the suggestion. If the error starts happening again I'm going to give this resolution a try. If this...

Hello all! I'm having an issue with a DB that I'm working on which I can't figure why it is happening. So here is what is going on: I have a form: frm_WeeklyInformationEntry and on this form are two fields titled: Weekly_Start_Date & Weekly_End_Date. I have a table: tblDocSent that has...

And - the formatting of my examples did not work out at all. The example was supposed to be 3 columns across the top and then there were the rows which begin with the respective month (No heading above the month) My IT area is strict on uploads etc or I'd just post an image/pdf of exactly what...