jhonnyboy
Last Activity: Apr 23 '10, 04:32 PM
Joined: Mar 8 '10
Location:
-
Edit: Nvm Was fixed. -
Thanks that's what I thought but wanted to make sure. Plus fyi when I originally inserted != access changed it to =! dunno why though, but all is working great. Thanks again!...Leave a comment:
-
Thanks again for the help Neopa. Worked like a charm :)
btw I forgot what the <> means do you mind explaining that to me?Leave a comment:
-
Ok I'm back!
It's all working now, i just have to filter it out with one more thing.
In the same table that contains [DATE_JOB] there is a field named [BILLING_CONTROL].
Billing Control can either have a billing control number or "N/A"
Objective is to display all reports within the date range supplied by the user(done) and only the ones that have a billing control number.
...Leave a comment:
-
We'll I have good news for the whole team and myself. The program is working as to specifications now. I would like to thank everyone who has not given up and has helped me to the end and a Special thanks to Neopa and Smiley thank you for all your help!
Resolution: Changed the # signs to '
After this experience I have ordered 2 Access books to learn more about this program and the syntax. Thanks again and I wish you...Leave a comment:
-
Neopa,
Thank you for all the help and explanations. Number two of your explanations helped clear my confusion with that. The only error I am getting is the Runtime 30025 SQL Error.Leave a comment:
-
Neopa,
Here is a simple structure of how this program is printing the reports. My apologies for any confusion. I am a new Network Administrator in a company with very little to no documentation and no one to ask. Let's start on a fresh page.
Program Objective: Make a form with two text boxes in date forms so when the report outputs with these date ranges only.
---------------------------------------------------...Leave a comment:
-
I just finished trying to program the criteria into the query but it gives me the following error.
Hope all this info helps....Leave a comment:
-
When I run the query it makes a new table called SERVICE_JOB with all the contents inside the query that it's grabbing from other tables.
As for the SQL view this database doesn't have one as for my knowledge. Below is the Query shown w/ the SQL view missing, the query run and the error produced from the frm_BILLING_CON TROL_RANGE form and the report control source.
SERVICE_EXTENDE D Query
SERVICE_EXTENDE D...Leave a comment:
-
This is what I got from going to the QUERY > VIEW > SHOW PANES > SQL TABLE VIEW
...Code:SELECT TOP 100 PERCENT dbo.SERVICE_JOB.SERVICE_ID, dbo.SERVICE_JOB.SERVICE_NO, dbo.SERVICE_JOB.JOB_REPORT_NO, dbo.SERVICE_JOB.SERVICE_NAME_ID, dbo.SERVICE_NAME.SERVICE_NAME, dbo.SERVICE_JOB.DATE_JOB, dbo.SERVICE_JOB.ACCOUNTNO, dbo.SERVICE_JOB.CUSTOMER_NAME, dbo.SERVICE_JOB.ADDRESS1, dbo.SERVICE_JOB.ADDRESS2,Leave a comment:
-
Not that I know of bud, but I'll take any and all suggestions :)Leave a comment:
-
Ok Found the Report Control Source.
Control Source is "SERVICE_EXTEND ED" a query which grabs the info from the table "SERVICE_JO B" as said before.Leave a comment:
-
We'll by the looks of it the report is gathering all the information from the Table SERVICE_JOB.
Line #9 results in: [DATE_JOB] BETWEEN #01/01/10# AND #03/10/10#Leave a comment:
-
Here is how these forms are connected.
Table (SERVICE_JOB) -> Form(frm_BILLIN G_CONTROL_RANGE ) -> Report(rpt_Bill ing_Control)
Table has all fields for report including DATE_JOB
I hope this helps.Leave a comment:
-
Updated to DoCmd.Open Report yet still get the same error. Thanks again for all the help guys I really appreciate it. S.O.S. lol Below is the full current code in the program:
...Code:Private Sub cmdBillingPreview_Click() Dim rptName as String Dim Criteria as String rptName = "rpt_Billing_Control" Criteria = "[DATE_JOB] BETWEEN #" & Me.tbStartingDate & "# AND #" &
Leave a comment:
-
When i entered your syntax I get the exact same error only now with the # signs:
Immediate Print: [DATE_JOB] BETWEEN #01/01/10# AND #03/10/10#Leave a comment:
-
Immediate Print: [DATE_JOB] BETWEEN 01/01/10 AND 03/10/10
Date Job is the field on the report which displays the dates.Leave a comment:
-
Don't see anything :/ Pressed Control+G the Immediate Window opened empty.Leave a comment:
-
I placed debug.print before the Do.cmd but I don't get any popups or anything different. I still get the same run time error and highlighted syntax.Leave a comment:
-
Thank you all for your replies. I have used the syntax TheSmileyOne has provided and still get the runtime error. Runtime Error 30025: Invalid SQL Statement. Check filter form record source.
It highlights the same line
Do.Cmd OpenReport rptName, acViewPreview, , Criteria
I have no clue as to what to do here. Any help would be much appreciated. Thanks again everyone!Leave a comment:
No activity results to display
Leave a comment: