Credit Card Processing
Does anyone know of any software or have any code that would allow to process credit cards.
View Complete Forum Thread with Replies
Related Forum Messages:
Validation Text For An Expiry Date On A Credit Card
Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this: MM/YY but i cant find a way of doing this! I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this: >=int(now()) So the input mask has to accept this validation... If you could help, i would be very greatful! Cheers
View Replies !
Receipts/Credit Control
Hi, I am currently building a database which holds information on insurance policies. Each policy holder has the option of paying their annual policy either monthly, quarterly or annually. At this stage I won't get too in depth, but I have built a table (TblReciepts) which the User enters each receipt as they arrive. I would like to be able to match off each receipt against the outstanding balance on a realted policy, in this instance the policyholder should give their policyno as a reference in the receipt so that is where the relationship should be. Can anyone suggest the most effective method of allocating a recipt to the outstanding balance in the table (TBLPolicy) Regards
View Replies !
Checking Credit Limit
Hi, I'm trying to do up a database for a furniture company. I used Northwinds as a guide and made a similar Orders form. However, I need another functionality which Northwinds do not seem to have. I want to check whether the currect Order would cause the customer to exceed his credit limit. WHAT I DID For this, I made a query to find the amount any single customer owes to date and the amount that he can still borrow(creditlimit-amountowed+amountpaid). I then made a button which launchs this query. PROBLEM The problem is I want when i click this button, the query prompts me for CustomerID, which i have to key in again. Then, it launchs the datasheet showing me the credit he would have remaining if this order went through. It would be better if I do not need to key in his ID again, since it is already on the form when i keyed in the Order. Further, it would be much better if I could get the button to display APPROVED/REJECT(postive/negative balance) and also display the amount of the remaining credit. Sorry for the long description. Thanks for reading and please let me know if I missed out any crucial details.
View Replies !
Credit Code Get No Return ?
Can some one help me with this code, I get no return, ??? . Private Sub cust_credit_score_1_AfterUpdate() If [Forms]![Customer Form]![cust_credit_reply_1] = " [Bad Credit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 5 ElseIf [Form]![Customer Form]![cust_credit_reply_1] = "[PoorCredit]"Then [Forms]![Customer Form]![cust_credit_score_1] = 10 Else [Forms]![Customer Form]![cust_credit_score_1] = 15 End If End Sub Thank You For Your Help Johnny C.
View Replies !
Using Form/subform For Sales & Credit
Hi, I have a table with pk- Index that stores customer details. I have a second table that stores the items sold, description, barcode number, sale price and discount. On the main Invoice form, that is linked to qrySalesInvoice, the customer records are displayed/updated by telephone operator. In a subform that is linked via Index, the sales details are displayed for that invoice. This works well, but we often need to credit one or more items. Business practice dictates that we cannot amend the original invoice, so we need the credit to be raised as a new record, but as negative values. Before I split the sales detail into another table, there used to be 10 sales fileds that were stored in the same table, and using code borrowd from the forum, I worked out how to copy the invoice, add "CR" to the invoice number and multiply all values by -1. But using the subform method I am lost as how to proceed. I have gained so much from this forum in the past, and for that Many Many Thanks. Regards dazadd
View Replies !
Payment Processing ERD Help
Hello,I'm designing a contract and payment processing database for a friends construction company. I've made an attempt at designing the data model, but wondered if anyone out there had ever come accross a similar scenario and could be of any help. I have attached a copy of my initial ERD.Entitys are as follows:CompanyHolds details of the company that are operating the system.CustomerBilling details for the customer.SiteA customer has many different sites at which work is undertaken.ContractA contract is created for all work undertaken at a customer site.PlotThe work a contract covers is carried out on various different plots at a customer site.StageWork is carried out in stages on a plot by plot basis. When a work stage is complete the stage can then be invoiced for payment.InvoiceOnce work stages are complete an invoice can be raised. An invoice can be for one or more stages (always under the same contract).Invoice_LineDetails of the different stages billed under a single invoice.PaymentStores detail of a customer payment.Payment_AllocationA single payment may be split accross multiple invoices. A single invoice may be paid through multiple payments.The main area I was hoping for help with is payment allocation, the requirements of which are listed below:1. When a payment is received it must be possible to split it accross multiple invoices (a payment will only ever be for invoices within a single contract).2. It must be possible for an invoice to be paid in part (i.e. be paid by mupltiple payments).3. If a payment isn't allocated in it's entirity, the the remainder should be put to a payment on account for allocation at a later date.4. An entire payment should be able to be put to a payment on account and then allocated later.5. It must be possible to enter credits against invoices.The reason I have Contract joined to Payment_Allocation is so that a payment on account can be created and linked back to the contract, for allocation at a later date. If a payment on account is stored as an entry in the payment_allocation table it will become difficult to then allocate the payment on account to invoices and keep an audit trail. The payment on account isn't really allocated until it is put against an invoice so I'm loathe to do it this way.On the other hand if I store the payment on account in the payment table (until allocated) it may make it harder for me to produce my statement report.I'm also having difficulty seeing how I can build a statement of account from these two tables...do I need to build up a transaction table in order to do this effectively? Or a temporary table of transations to base my report on?Any advise or pointers would be very helpful.Thanks in advance for your time.webbmatt
View Replies !
Form Pre-processing
Hi I have some code in a function that I want to run BEFORE a form (FormB) is displayed to the user. FormB is called up by clicking on a button from another form (FormA), but when I display the ActiveForm . . . Dim MyFormPO As Form Set MyFormPO = Screen.ActiveForm MsgBox "here!!-" & MyFormPO.Name . . . I get the form name of FormA, and it errors-out because the objects I'm trying to reference do NOT exist in the Active form. I've tried calling the function from every Form event ("OnOpen", "onLoad", "OnActivate" etc,,) but ActiveForm always seems to be the first form. Anyone any ideas, please Thanks ajm
View Replies !
Checking The Integrity Of Db After Processing
Hi, All, Background (questions: see below) --------------- I have a db whose one and only table has recently been split up into three tables as follows: 1Main table (containing contact column; name, tel, fax, email, etc) 2Memo table (containing long fields of type Memo) 3Non-memo table (containing short fields of non-Memo type) We now have to submit Table 1 to a data cleansing company, which inserts columns about telephone and fax suppression (people who we are not allowed to phone or fax), validity of address, etc. When we first did this (when the three tables where still only one, which should have made processing errors less likely), one of the tables came back in mangled form. Data were all right for, say, ten or 20 records, then came records where "DNA splicing" had taken place, i.e. where parts of one record had been spliced into another record. However, it had been done in such a way that it was not easy to detect by visual inspection and comparison with the original table, especially since many records looked all right. Typical splicing error: the memo field of one record had replaced the memo field of another record, but NOT that a text field of one record had replaced the memo field of another record or another text field of another record. ---------------------------- The data cleansing company (DCC) told us that it was not their fault but that we had made mistakes in the way in which we submitted our db for 'automatic' on-line cleansing. This may or may not be the case, but certainly the initial instructions from the DCC were misleading or unclear. Therefore (1)we are now taking measures to prevent this from happening again and (2) we have to check on tables which come back from the DCC to make sure they have not been corrupted again (just in case it IS the DCC's fault), since this would be absolutely disastrous for us. Step 1: we divided our one and single table in to three tables, linked by ID as Primary Key, as above. So now only Table 1 has to be sent for cleansing, but we are, of course, concerned, just in case when returned, the records in table 2 and 3 are no longer linked to the correct records in Table 1. Step 2: we altered Table 1 so that its structure corresponds as closely as possible to what is taken as normal by DCC. Step 3: We removed all commas from our Table 1 before converting it into a csv file. Note: We submit our table as a comma delimited file (csv file), using double quotes as text qualifiers. We had been told by DCC (perhaps quite mistakenly) that the occurrence of commas in our memo fields had screwed up their program. ---------------------------------------- We are now experimenting with a variety of formats for submitting our data and receiving them back. We need a convenient way of checking whether the csv file which we receive back and which we convert into an Access table and substitute for our original Table 1 has not been corrupted. *** We want to be sure that none of the records in Table 1 on its own have been spliced up and wrongly spliced together as described above. *** Secondly we want to be sure that the fields in Table 2 (memo) and Table 3 are still related to the correct fields in Table 1. We know that this SHOULD be the case if we and if DCC have done their jobs correctly, but then things have gone wrong before and therefore we want to check and confirm this positvely, rather than lose our invaluable database. Question 1 --------------- Are there any routine procedures, perhaps incorporated into Access, to compare the original related Tables with the Tables which we received back. Is there perhaps some ready-made utility to do this job? Question 2 --------------- If there is nothing ready-made, we are thinking of doing the following: Create a query which shows 26 hand-picked records (i.e. one screenful) of the 4000 records in the database, and shows of each record a few memorable fields taken from each of the three tables (as much as can be seen on one screen from left to right without scrolling). Apply this query to the original db and to the cleaned db, make screen-prints of the results, print them and compare them manually. Is that a good and workable idea, or is there a better approach to the problem? Thanks for your help. Adrian
View Replies !
How To Delay The Processing For Seconds
Is there any function to delay the system processing for a number of seconds. For the time being I am do it indirectly by using loops, however, it is un proper way, as it is not scalable. Also I dont want to use the timer control. Thanks,
View Replies !
Order Processing & Warehouse Management
Hi all. I am considering developing a purchase order and warehouse management database, to be manage a cold store in my workplace. What i have in mind is a system where the details of each pallet coming in is recorded (weight, quantity, location of pallet in warehouse etc.) is recorded, marked off against the corresponding purchase order number and then a label is printed with a barcode to quickly identify that pallet. Handheld barcode scanners would be used to record when a pallet leaves the warhouse, and where its going to(despatch, production etc.). Ideally the scanners could be used to give forklift drivers order picking info aswell. I'm fairly confident i can design the database, however, i have never done anything with barcodes, scanners or handheld devices. Is this even feasible with access? How do i go about doing it, any advice, example databases etc. greatly appreciated.
View Replies !
Processing A Single Query In Two Databases
I have two identical databases in MS Access. I have created a query in the first mdb file, which retrieves the matching records in two tables. My problem is that i want to execute the same query created in the database1, on database2, without creating the query in the database2. I think it is possible, but the query i was trying was not working file. select * from db1.[Query1] in 'C:DBDB2.mdb' where db1 is the name of the first database, db2 is the name of the second database and Query1 is the name of the query in the db1. Thanks in advance for the help.
View Replies !
VBA Code Stops Processing, Out Of Memory
Hello, I have written some VBA code in a adp in access using a SQL2K database. The code runs mostly SQL statements using the '.execute' command. There are several loops in the code which also use some recordsets in the data. The code runs fine on my machine, taking about 15 mins to run. However when i pass it to my colleague (who has the same amount of memory but a slower processer) then it stops running half way through claiming to be out of memory; other programs still can be used at this point but Access can not, closing and reopening access does not free the memory. Both machines are running Access 2003. What can i do to free the memory in Access after each loop of the program, or is there a setting that must be different between machines, or any other suggestions would be helpful Thank you greatly Barney
View Replies !
Using A * (Wild Card) In Pop Up Box?
Is it possible to use a * (Wild Card) in a pop up box for a query? I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field My criteria in my search fieled is a follows: 05-May 06-June 07-July 08-August etc... As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data. Any help would be appreciated. Thanks, Scott
View Replies !
A Solution To Manually Processing 'Entry Forms'
Hi Guys, I've been pondering over a problem for a couple of weeks now - We receive around 1000 paper entries to our competition, and these all need manually entered into the access database in a one-er. Is anyone aware of any ideas of how this could be made easier, and more automated? Thanks.
View Replies !
Fried Graphics Card. What Do I Do?
Hi, I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use. In order to retrieve the information from the harddisk, I got a cable between this computer and another one. This is my plan: When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this? second question: If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer? Fuga.
View Replies !
Magnetic Card Reader
Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated. Thanks, Matthew
View Replies !
Business Card Scanner
I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o
View Replies !
Wild Card In IIF Statement
I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using is; IIf([Forms]![Criteria Form]![Customer Account] Is Not Null,[Forms]![Criteria Form]![Customer Account],[Data]![Customer Account]). This works. However for some of the criteria I want to also use wild cards, so that the user can enter just part of the data, and the relevant records will be returned. I understand that wild cards cannot be embedded into the IIF statement above. I have tried many methods, and trawled the web for ideas, but I cannot get this to work. I either want the user to enter the wild card themselves ie "100*" returning records starting with "100", or for the query to append the wild card itself. Can someone help please?
View Replies !
Wild Card Name Searching Help
How would I make a query find a person like this: Inputted Data: Smit Outputted Data: Smith, Smithy etc.. The formula I have entered in the criteria of my query is: Like [Enter the person's last name] With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out. Thanks.
View Replies !
Wild Card Searches
Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query: [Forms]![Search]![BoxNo] So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13. How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:
View Replies !
Employee Time Card System
I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is Date Type of work Hours Rate Comments I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template. Thanks, Chrissy
View Replies !
Access Wild Card Search Help
Hi I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all). The Query is built as follow: The criteria for the field "Last Name" is Like [forms]![simform].[lastnamesearch] & "*" The criteria for the field "First name" is Like [forms]![simform].[firstnamesearch] & "*" The criteria for the field "City" is Like [forms]![simform].[city] & "*"
View Replies !
|
TRACKER
