I have a simple question regarding Authorize.net API for PRIOR_AUTH_CAPT URE & Auth_only.
What command do you use in order to release a prior Auh_only transaction. specifically when you use PRIOR_AUTH_CAPT URE and there is still a balance on the Auth_only Transaction. I used the Credit method but it refunded the amount that i captured!!
Help!
isaace
Last Activity: Jun 16 '16, 04:47 PM
Joined: Jan 20 '12
Location:
-
Authorize.net Question - Captures
-
Permutations From Excel Cells
Hello, I have a list of 10 Variables within an MS excel worksheet. Each variable is in a separate cell (row of 10) adjacent to a number corresponding to that variable (1-10). I would like to write a script in VBA to calculate all the permutations of these 10 variables combined and separated by commas. (i.e. Cell b1 = small, b2 = medium, b3 = big...permutati ons = (1) big, small, medium; (2) big, medium, small; (3) medium, small, big; (4) medium,... -
Is it possible to pass a command from a function to a sub routine?
I am trying to pass a command to a subroutine from a function and am having some difficulty. The purpose of the function is to validate that the lead is actually a client. If so, the sub can move forward. if not, I want to exit the sub from the function's code (the function is located in separate module, but I've still been successfully able to call it). When I enter 'exit sub' in the function, I get a database error. Can anyone help? other... -
Counting a value on a form from all records in a table.
I am trying to enter a control on a form which can count the total number of entries with a particular value. For example, I have a field on my form which holds a cell phone number. I would like to create a separate field which counts the total number of entries with the same cell phone number. This will help me from entering duplicate records. I know how to count the actual field; =count(cellphon e). I found some people online mentioning to use... -
Sql - insert into
I have an sql statement which I was hoping someone may be able to help me with. I'm getting the following errors:
1 - runtime error 3346 (Number of query values and destination values are not the same
2 - Runtime Error 3075 syntax
...Code:strSql = "INSERT INTO tblConversation ( " & _ "RecordID, LeadID, Conversation, Subject, DateEntered, ContactDate, ContactTime, FollowUpDate -
isaace started a topic how to enter print preview report's filter automatically from the current formin Accesshow to enter print preview report's filter automatically from the current form
I have an agreement template in a MS access report. The report's fields are populated by the form's records. my goal is to automate the report to filter to the agreement # to what ever the current agreement # on the form is. i do not want to have to enter the agreement # every time i click on the cmd function to preview the report. below is the code i have, can someone please edit my code to what it should be?
...Code:Private Sub
-
I have a main form with all leads. I created 2 pop up forms; each contain a list box. the first popup form, has a list box of 'hot leads'. the second pop up form has a list box of all leads which became customers. Upon opening any of the pop up forms, once I double click on a record in the list box (within the form), that record ([Lead#]) is pulled up on the main form. so there are 2 popup forms; each with 1 control; the list box. each list... -
for some reason when I click on the cmd close function; it copies the list box control in one of the form's modules to the other other form's module. (i.e it copies and Ctl1stLead to the other module and replaces all 'List4' functions with 'Ctl1stLead' even though that control is not existent in that form.) It only does this for the modules which contain a list box which both originate from the same main form. very weird....Leave a comment:
-
Conflicting List Boxes
I have 2 pop up forms which come from a main data entry form. The pop up forms are populated by a list box. When double clicking on the list, that entry is then pulled up on the main form.
My problem: I've gotten both sets of code to work - BUT NOT AT THE SAME TIME. It seams that they are conflicting for some reason - but now sure why. I think it may even be changing the code once I click on the DoCmd.Close. Not sure if I am going... -
Ahhh....it worked!!! Thank you!!Leave a comment:
-
Runtime Error '3077'
I am trying to create a pop up list of all leads from a main form. upon selecting the record i would like to find, I receive a runtime error 3077 message; Syntax error in date in expression. can anyone help?!
...Code:Private Sub cmdShowActiveLeads_Click() Dim rs As DAO.Recordset Set rs = Forms!frmLeadMain1.RecordsetClone Call rs.FindFirst("Lead# =" & Me.Ctl1stLead.Value) Forms!frmLeadMain1.Recordset.Bookmark -
I think the Calendar is a control; not a form...so i was not able to add a button to close the control...I was also not able to make the control visible on a dblClick event. Not sure why it didnt work, possible because it was a control?
any other suggestions? I am using Access 2003. I'm a beginner to Access VBA so i am trying to keep up. Thanks for your help!!Leave a comment:
-
How do I hide a control when I click on anything else
I created a calendar pop up on MouseDown event. The calendar looses focus (Calendar3.Visi ble = False) only when I dblClick on a date on the calendar, at which point the date value is transferred to the field value. How do I make the calendar invisible when I click on anything else on the form. for example, If someone clicks on a field by accident, they can't get rid of the pop-up calendar until they choose a date. below is my code:
...Code:Private
No activity results to display
Leave a comment: