Search results

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

Thanks - I'll check out what you have to see what I can come up with. For this particular report, on the entry form I am just using a month/year selection so every entry will be associated with a combination of a month and a year. Before the report is generated there will be another form for...

This is probably simple, but I have not been using Access/VB for several years now and my skills are quite rusty. So my situation is this: My area has web reports that are put together monthly and it has always been done using Excel. This task has been handed back to me while a co-worker is...

OK - we have a person leaving our department in a couple weeks and one of the tasks she does is coming to me. Basically what this task is is: she has a list of about 30 people that she emails quarterly to remind them to review their content on the website. Each person's email has links to...

AWESOME! Thank you so much. I'm not a coder but I've been able to put this to use and it is doing exactly what I wanted!

I apologize if this has been answered - this site is loading like junk right now and I'm having a hard time navigating it (my company is stuck on IE 8 and I have problems with a lot of sites. Don't know if it is the browser or what the deal it, just know it sucks) Anyhow, this is what I have...