thanks
Okay and thank you.....I figured it out.
DAO doesn't take `"' Like ' * ' & [Report].[Employee Role] & ' * '` and I was reading from query and had to change it to real table in s`trSQL = "SELECT * FROM SKSF_Req WHERE Flag IS NULL"` Statement.
Nilou
Last Activity: Aug 7 '14, 11:03 PM
Joined: Oct 7 '11
Location: 20902
-
My Sample File
Hi I have attached my file, Please see if you can figure it out ?
Thank youLeave a comment:
-
Hi thank you very much,
I have two tables that need to join base on some criteria.
table 1 loop thru table 2 record set and create a new report for each row and export into excel sheet.
I get Run-time error 3085 undefined function 'rstSKSF' in expression and point out this line:Leave a comment:
-
Join and Loop thru second table & generate new table for each row
Hi experts,
I'm very new to access and VBA, I am Looking to find a way to join two tables.
To join these two table, I need to loop through my second table and for each row exist in second table I create and insert the matching result from first table into new table.
is there an easy way to do it?
Thank you -
This one has the process too:
...Code:Public Class SoftwareSales Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click 'Declaration -------------------------- 'Declare constants for retail Price Const decOffice As Decimal = 500 Const decVisual As Decimal = 800 Const decQuick AsLast edited by Frinavale; Oct 7 '11, 09:09 PM. Reason: Added code tags...again please post code in code tags.Leave a comment:
-
no it is not :(((
here is he whole code:
...Code:Public Class SoftwareSales Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click 'Declaration -------------------------- 'Declare constants for retail Price Const decOffice As Decimal = 500 Const decVisual As Decimal = 800 Const decQuickLast edited by Frinavale; Oct 7 '11, 09:09 PM. Reason: Added code tags. PLEASE post code in code tags.Leave a comment:
-
Here is my Code:
( if it is right, i's not working :(Code:strOutOffice = "Microsoft Office Pro 2010:" & decTotalOffice.ToString("c") & vbNewLine If blnAnswer = True Then rtbSalesOrder.AppendText(strOutOffice) Else rtbSalesOrder.Clear() End IfLast edited by Frinavale; Oct 7 '11, 08:32 PM.Leave a comment:
-
Thank you Frinavale,
what would be my Boolean not display the answer in the text box? Do i have to use rtbSalesOrder.C lear()
or there is something else to not to display the output in richTextbox?
is this correct:
...Code:strOutOffice = "Microsoft Office Pro 2010:" & decTotalOffice.ToString("c") & vbNewLine If blnAnswer = True ThenLeave a comment:
-
Boolean variable Help
Hi,
I'm writing a form to get numbers in order to calculate the price. if numbers and the code of business is wrong it will give me message box error.
The result will appear on a rich text box.
My professor wants me to set declare separate string variables to displaying text in the richtextbox.
MY QUESTION :For Boolean variable, assign false to Boolean variable, when user input is invalid. Display results in the richtextbox,...Last edited by Frinavale; Oct 7 '11, 07:41 PM. Reason: Added code tags and fixed the spelling of the word please...Please refrain from using leet-speak on this forum.
No activity results to display
Leave a comment: