Recent content by mcmichael13

it has worked before now, i didnt install anything new. 1) XP 2) I just looked and no... probably would have to get IT to do it... I am not really allowed to install anything on my computer (not to say i havent)

i have the full 2007 office installed. the only program i have from 2003 is access. i never had this problem until yesterday.

I have Access 07 and Access 03 installed on my computer for various databases we have in both. The reconfiguration used to happen when you switched from one to the other to reassign the registry keys. However, even if i open access 07 5 times in a row without ever opening access 03... it must...

Hey guys, I have a couple forms with different pivot charts on them (they were the easiest to make for me). based on date selection by the user, these charts are formed, also based on the "Location", which is used as the series. the user may select to see results from both locations...

I have a form open in PivotChart view, and I would like the Title to display the Date range that i specified for the data contained within the graph displayed. Is there a way to do this? the date range was used as a filter for the query that the chart is pulling from, and i would like that...

I GOT IT!!!!!!!!!! I needed to put the ">0" under the "OR"... if someone could explain why, that'd be awesome, but this is my working code now: SELECT RMA.DateReceived, RMA.Location, RMA.TotalValue, RMA.RMA, RMA.ReasonforReturn FROM RMA WHERE (((RMA.DateReceived) Between...

yes it is numeric... this is confusing haha thanks for your help though

no, the query is still including these records... hmmm

right, thats what i realized too... but its the (RMA.TotalValue) that i want greater than 0, as you can see in my last post. however it still queries the values into the table. not sure why

oh i apologize for the confusion... that sql works just fine... i want to add another "AND" in the "WHERE" clause... something like WHERE (((RMA.DateReceived) Between [Forms]![DefectCodeRMA]![StartDate] And [Forms]![DefectCodeRMA]![EndDate]) AND...

I have an RMA database, and this particular query is used to create a pivot chart. I have the query pulling data from the table based on a "selection form" of a date range and location of RMA. Now my problem is, that associated with the RMA is the total value. I want to not include the...

thanks, yeah i changed mine to "alternate row" and it is working fine now... strange... though i guess there are situations where you would want it to become transparent. I dont know, thanks for your help though

on my computer its doing it on all comboboxes

what is happening is the background of the combo box is becoming transparent to the background of the form... i just dont know where that setting is to change it

oh right, yes, i just saw a list and thought "list in a box" haha. but i see it is a combobox. I just realized I can type in there too... nevermind, thats even better :) Thanks a lot, but still the black issue...