Search results

I have a report which tracks data on a monthly basis...In my report, I group results on client and show all historical data for each client... Report looks like: Record Count ExtractionDate Value 1 31-Jul-06 $872,363.79 2 31-Aug-06 $887,975.98 3 30-Sep-06...

Thanks DV. I think I'm going to be OK with the archive version...but I was wondering if anyone had any idea why that close thing might be happening. Very odd. GR

Thanks for the response Neil...Yes, I did compact and repair. Did not help. I pulled an archived version up and it is working fine, so I'm going to try to figure out what happened, but I am least not dead in the water. Thanks, George

I have a database that has been functioning very well for nearly a year. Suddenly today, as I attempt to open a report (very complex report takes about 2 minutes to render), the database closes before displaying the report. I have moved the db from the server to my desktop and the same problem...

Thanks RG...+1 indeed. You are as usual, helpful to a poster...I've learned a ton from you, but rarely post. Great work and thanks. I've added to your Rep... G

Thanks RuralG...it was the cycle property that was set to all records. I set it to Current Record and got the answer. Thanks for the quick response...

I am tabbing to the next field....First I set the control to just jump to the desired field, but it did the same thing.

Hi All, I have a comboBox set up to locate an auction item to be able to enter winning bids. Problem comes when I select the correct choice from the comboBox, the proper record displays. When I move to the winning bid entry field to add amount of bid, the record changes to the next record in...

Moniker...THANKS so much. I found this same solution independent of this forum and forgot to come back to check it out. Thanks again for the spot on advice. Great job.

Hi, I am trying to continue the process described below. We are taking a query from an active database and creating a table in a remote db in the network...we want to take the next step in the process to now copy the destination database and have the user save it to a location of their choosing...

Still working the code Thanks grnzbra, I think you have put me on the right track. I'm trying to work it out. When I finish, I'll post how I did it... Thanks again. G

Can I move a column horizontal postion based on another column? I have column A, B, C & D I would like to have Column C slide left if no data in column B. Is this possible? Thanks, George

Thanks Jemma...You have done it again. This was the key I was looking for. I'm cleaning up someone elses work and went to the three queries used in a join sequal and added a new column iff ReportList: IIf([List] Is Null,"Fails GLP Test",[List]), I then added the replaced "List" with...

I may be missing something, but I think you might just create a FIND DUPLICATES query (pre-designed in access). Select the table that contains your project job number. look for project job number show ALL OTHER FIELDS TOO run query. You will be left with a list of all project job numbers...

Hi All, While creating a report I have a list that I have sorted in lowest to highest and then ranked accordingly. I need to keep the ranking sorted lowest to highest with one exception. I have some records that have a null value (could be zero, but currently null). I need to have this value...

Thank you so much. This is perfect. Also, the site looks like a great resource too. Thanks for the quick turn around.

Hi Everyone, I have a procedure that determines if an item is in the list or not. If not in the list, gives me a message box with the option to add the item to the list. If option to ADD is chosen, the proper form opens up and I am able to fill in the information and then when the form...

I looked at the history and I don't see my situation discussed. Sorry if I missed it. I need to get page number to reset to 1 at the end of a sequence, but I do not have grouping... This is essentially a mail merge document and at the end of the last data field, I need the report count to...

This did the trick. Thanks Jon!

I have set up two queries to generate a rank order based volume generated. The query does what I want for the most part in that if two parties have the same volume, they have a common rank (this is what I want to have happen). The problem comes that at various points throughout the data set...