Recent content by AConrad00

Set up two queries First Query, SELECT Customer and Product Code - In properties, set Unique Values to Yes Second Query, SELECT but click TOTALS Product Code and Customer - Group by Product Code and then Set Customer to Count I find it easier to split up stuff like this instead of trying hard...

Okay so I found a very easy workaround It definitely is not as "pretty", but this works well and is simple. I just created a subform that populates a table that connects the order_sequence number with the user-input typed in name, and it's as simple as creating an additional query to create...

Thanks J I was looking through this and I cannot find an instance where an unbound textbox is referred to as either the true/false return in an IIF statement I will play around with it today more. As I've come to learn, it's probably very simple and i'm just missing the obvious!!

Hi All, I have a form that runs a sequence of queries that returns a number value (1,2,3... in sequential order). I want to take that number, and turn it into an IIF statement, that returns the TRUE field to be a text box that the user can input text into to 'custom' name that particular...

I would recommend that instead of a make-table query, you switch to an append-query first create a delete-query to clear all data from your cross-tab table and then run the append query to add the current data to that table. It will make it so that you do not need to get that "delete table"...

As an Access newbie, I've found it very helpful to create multiple queries that each perform a specific step instead of one master query that is hard to spot-check and even harder to maintain a working knowledge of what needs to be done to update it should something change Name the queries with...

Hi All, Question on best practices. I have four raw files that feed a customer_master database. I will be updating these files at least once a week, and potentially within that week, as necessary. I have a spot on my C drive that I always save the most current file, that I use to currently...

Thanks for all who posted in this thread - The issue has been solved (last week, thought i'd updated for anyone with a similar situation) Bob nailed it on the head that I needed to clear all of my working tables and merely append them with new information. Being an access-newbie, it took me a...

Thanks Micheal for the input Minus the compact/repair, would you be able to point me in the right direction for the VBA code to perform either option? I am finding tons of hits in my research, but it references older code that I don't know how to change for Access 2010.

Hello, I need to do two things to my back-end DB. I need to remove the tables, and run a compact/repair to stop the annoying "this table will be deleted..." and to keep the filesize down since just a dual-run can cause the 2gb limit to be reached. 1 - From my front-end, access the back-end...

Thanks Bob The delete command works great, but the append query work-around does not fit my needs, since both my third and fourth query contain multiple fields. I tried Spike's idea of having my queries make tables into an outside DB but that seems more 'intense' then this solution. Any...

Spike, How would I go about creating a table in a separate DB? EDIT - wow so simple. surprised that I didn't catch that earlier EDIT EDIT - New question, I am having trouble accesing the new 'back-end' temporary file with my front-end DB's form. Any resource for this? It's truly a simple...

Hi Bob, thank you for the reply. I will try this method out today and see if it helps contain the filesize growth.

Spike thank you for the suggestion. The temp tables will always have the same column-headers, but the underlying data will change depending on what the particular criteria for selection might be from one day to the other. So I think I have two options: - Have the queries feed new tables into...

Hi All, First Post. I am creating a form that contains a 6 inputs PER CRITERIA (4 listbox, and 2 textbox) that feed into different queries that run in sequential order to create a listbuild for marketing purposes. The master file is created in DatabaseA and exports into DatebaseB. DatabaseB...