Search results for query: *

I guess I am just having to much fun today. First off I would like to again thank PHV for helping with the following code. But my next question, I have the user entering a date on the form in a field called txtFRMDATE and the code below will report on that week and that week -1 and -2 is there a...

I must be brain dead but it know works here is the code corrected and working PHV - Is the BEST!!!!!!!!!!!!!!!!!!!!!!! Dim strFRMDATE As String Dim strTEST As String Dim strTEST1 As String Dim strTEST2 As String strFRMDATE = "#" & Me.txtFRMDATE.Value & "#" strTEST = "12/4/2005" strTEST1 =...

PHV I have been asked this before I am not sure how to do what you are saying I have never been able to step through code and see what is happening (CTRL-G) opens the code window but does not put in the parameters. (Im sure a dumb question) However I did do this if it helps SELECT DATA.ISBN...

12/06/2005

I had tried that before and didn't work so I tried it again just to make sure and I get an error 3075 missing operator in query expression

Ok this is driving me nuts on my form I have a field called txt.FRMDATE Where I am trying to enter a date and run this code however every time I enter the date I get the famous Enter Parameter Value then if I enter the date again it works fine. I know I am missing some little thing if you see it...

Thank you worked perfect...

When using sql in vba I want to for example Select x As strTEST. I tried: Dim strTEST As String strTEST="12/04/2005" Select Somthing As "& strTEST &" Can this be done? When I try I get an Error 3141 Thanks, TboneHwd

In case what I wrote earlier doesn't make much since this maybe this will help I have a table that we store weekly sales from our customers called data I want to write a query that will pull the current weeks sales, week_2 sales, week_3 sales etc... something like sqlstr="SELECT...

I have a table called data in it we import the weekly units sold at our customers pos stations. The fields in the table are CMT_CODE(Customer Code), WEEK(mmddyyyy this date is always a sunday), ISBN(Item Number), UNITS_SOLD, INV_ON_HAND, INV_ON_ORDER. I want to enter a date for example...

When ever I run a report after the report finishes I go to file print and it starts running the query again. I never noticed this until I upgraded to Access 2003 and for one of my reports it takes 10 minutes to run and it seems another 10 minutes to print anyone know anything about requery upon...

PHV, Thanks so much your example fixed the problem... It works great. Tbonehwd

PHV, I have 118 accounts with the type of DISTFOR however with this query I am only getting 40 I am sure it is still due to the fact that they do not have orders for this year or better yet they do not have any PROOLN_M.QTY_SHP or PROOLN_M.ITM_NET records. Here is the code for this query...

Yes I am using outer joins and that didn't help until I realized that this was causing my problem. Thanks, Tbonehwd

I agree but I don't have like it... :) I know it is a stupid question but I am trying to create a five year report for customers unfortunately some customers didn't buy each year.

I am using an IIF statement to do a calculation based on the order number, in our system any order below 90000000 is an order and any order above 90000000 is a credit this code works perfect for other scenarios however I am now trying to create a report that will list net QTY_SHP for all...

First off I would like to thank the people on here that have been so helpful I have learned so much since I started posting however when you see the mess I have below please dont laugh anyway the code below builds and execute three queries. The first is to get a list of customers by cust-type...

I have queries that group by year() and by month() so I just assumed that I could group by week() well I guess I am wrong. If it can be done how do you group by week() Thanks, Terry

I have a query that outputs a single line Company_Name, 1st_net, 2nd_net, 3rd_net, 4th_net, 5th_net which is the past five years of net_dollars and I wanted to create a little chart for these numbers. When I try to create a chart using the wizard my cpu goes to 100% and Access stops responding...

Thank you both it worked perfect!