Recent content by Patchy

I can't get my update macro button to work. I'm trying to update every Product Model #10 but only if it is in product group AB on the Product table. Please note the names are correctly labelled... I have [forms]![UpdateProduct]![ProductGroup] as criteria for Product Model column in my...

I am trying to get the surnames of customers to populate based on the selected product groups, product models and first names. The expression below results in #name? error. What did I do wrong? Please note that I do not have a primary key in the query. I only have unique records...

Is there a function that will populate a field with drop down menu based on two criteria? I want the the fields with first and last name to populate with drop down lists based on the employee code I have inputted in the form and job title from a query. Path: looks at employee code from form...

Thank you...I ended up changing every report manually as I am using AS2007...

I still get syntax error...so I tried making another query based on that query to clear the SQL view... Now I get FROM clause error... I'm only using one table (the comprehensive table with everything in it) and I'm referencing this table when I entered the code you provided

Because I am prompt with "too many fields" error when I use the group option from the report wizard... I want to show all the columns (about 80 in total) as I am trying to create a comprehensive report for every employee

[solved] changing format simultaneously How do I change the background colors and text formatting in all of the reports in one database at the same time? If this is not possible, is there an easier way to change the report formatting without going through every report?

I've been working on this issue for hours...and I can't get anywhere... I have 10 tables linked in one query. 9 tables are linked to one main table (one to many relationship). I want to get rid of duplicate records that show different data in multiple columns. I want only one record of this...

Best: Spyro Worst: Too many to list

welcome another fellow newbie!

Welcome! I'm like you...wanting to learn and share my knowledge :)

I like ZEST out of all the options

The only highlight of iPhone to me is it's idiotproof

I prefer CoD over Battlefield - more players

I've never played WoW so I can't compare. It's been a while since I last touched Guild Wars too. I did enjoy Guild Wars but the gameplay is limited and it's barely updated with content. I'm assuming WoW would be better as it has a bigger player base and it's update more frequently.