topthebookie
Last Activity: Feb 28 '08, 03:39 AM
Joined: Feb 13 '08
Location:
-
access & website form submissions
I was wondering if there is a way that a form on a website will store the information in a access database. Please help. Thanks -
Access & Quickbooks
Looking to add quickbooks into access. Is this possible? Any help is appreciated -
Microsoft Access Processing Credit Cards
Is there a way to process credit cards within microsoft access? Any information you can provide is appreciated.
Thank You -
[code=vb]
Private Sub ScheduleEstimat e_Click()
On Error GoTo Err_ScheduleEst imate_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Client Estimate Appointments"
stLinkCriteria = "[ClientID]=" & "'" & Me![ClientID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
... -
Client Form How To Transfer ClientID to Appointments
Good Day,
I am a newbie to access. Currently running 2003 version. I have created a clients table with a command button "Schedule Estimate" which goes to my client appointments form. I am wondering if there is a way to transfer the ClientID over to the schedule estimate form when I click "Schedule Estimate". On the Client Appointments form I have ClientID, EstimateID, EstimateDate, EstimateTime. Any help is... -
Macro Update Function To Table
I have a dilemma. I created a query named QP Test, the second query I created is named QP Test Update. My table I am trying to flag with 1 is all_hx4.qp Flag. I am not sure what I have done wrong, but could use some help or an alternate method. My first query QP Test does what it should, it is the second one I am having difficulty with. Any help is greatly appreciated in advance.
>SQL BELOW FOR QP Test Update<
... -
Ohh Thank Heaven... I now have it working. You have been very helpful being that I am new to this. :) Thank You Again!!!!!...Leave a comment:
-
When I close the query and reopen it, it asks for a parameter value, ahh very frustrating but getting there, any suggestions. Here is the sql view
sql code:
[CODE=sql]SELECT DISTINCTROW Sum([HTR BY RANK BY TRACK].SumOfxWIN) AS [Sum Of SumOfxWIN], Sum([HTR BY RANK BY TRACK].CountOfnDIST) AS [Sum Of CountOfnDIST], [HTR BY RANK BY TRACK].Result AS Expr1
FROM [HTR BY RANK BY TRACK]
HAVING ((([HTR BY RANK BY...Leave a comment:
-
here is another one I need help on, Ill just post the sql view. I need another field that will divide the 2 first fields, and multiply them by 2 thank you for your help
[CODE=sql]SELECT DISTINCTROW Sum([HTR BY RANK BY TRACK].SumOfxWIN) AS [Sum Of SumOfxWIN], Sum([HTR BY RANK BY TRACK].CountOfnDIST) AS [Sum Of CountOfnDIST]
FROM [HTR BY RANK BY TRACK];[/CODE]Leave a comment:
-
not sure what I am doing wrong but I keep getting does not include the specified expression....Leave a comment:
-
Creating A Query Expression Help
I created a query that has 2 sum fields. 1st Field is the sum of orders, 2nd field is the sum of count, I need the 3rd column for my expression which I am not sure how to write. Ultimately, I want field 1 to divide by field 2, and multiply by 2 for my percentage expression in field 3. Obviously, I am learning access and this form has already been a tremendous help to me.
No activity results to display
Leave a comment: