Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Access Checkbox/VBA


(!)

karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 08:00 AM #1
Solved: Access Checkbox/VBA
Hi,

I have a check box on a form called "Paid" when checked i would like Access to give the record a paymentID and also disable the checkbox so i cant be changed. Is this possible?

Thanks.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 08:22 AM #2
How will the paymentID be generated, from a "payment" table/form or just a number?
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 08:37 AM #3
Which option would you suggest?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 08:46 AM #4
Well normally when someone pays you enter a "paid" date, at that point you would set the "paid" checkbox to Paid and if required give it a PaymentID as well, but that could just be an Autonumber.
But you may need to allow for multiple payments for one bill, in which a manual click of the paid checkbox would be better.
__________________
OBP
I do not give up easily
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 08:54 AM #5
so should i setup a table with paymentID, JobNo, Client, Payment Date?

but how would i go about multiple payments for one job?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 08:57 AM #6
Can you see customers paying in installments or partial payments?
I created a version of your database which had "Accounts" for both incoming stock and outgoing jobs where the setup was for partial payments and it maintained a "balance" for each Supplier or Customer.
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 09:08 AM #7
Yes they will pay in installments because a 6 month job worth 60,000 will pay 10,000 a month
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 11:07 AM #8
Take a look at this version of Invoicing. It has a Customer payment table and in the Customer table their overall Balance.
When payments are made/ammended VBA code updates the Customer Balance.
I think there is a copy of it on the forum already, but I can't remember who I posted it for or when .
Attached Files
File Type: zip Invoicing with VBA Movements v 0.1.zip (175.2 KB, 60 views)
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 11:25 AM #9
Hi OBP great work, i think this is abit out of my league. I do like the way it works though! I was just thinking some VBA to generate a number (Just an ID)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 11:27 AM #10
What sort of ID though?
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 11:29 AM #11
THES1
THES2
THES3

That sort of ID would be generated when the box is checked
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 11:33 AM #12
Where would the last THES number be stored?
You need a VBA Recordset to open the table to look it up to increment it.
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 11:36 AM #13
It will be stored in the invoice table. I suppose i could just format the autonumber something like

THES "0001"
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,615 posts.
 
Join Date: Mar 2005
Location: UK
11-Dec-2010, 11:39 AM #14
You could, let me know what you want to do.
karlhaywood's Avatar
karlhaywood karlhaywood is offline
Account Closed with 680 posts.
THREAD STARTER
 
Join Date: Jan 2010
11-Dec-2010, 12:01 PM #15
I would like to do it with the recordset please. Can we take it easy baby steps lol. I reallt like learning Access :-)
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Title Thread Starter Forum Replies Last Post
VBA "Auto Quick Info" AKA Intellisense kriswork Software Development 5 29-Oct-2009 02:31 PM
Access 2000: Remote Connection saiyanslayer Business Applications 14 19-Sep-2009 10:31 AM
How to post a Twitter update from Access VBA? pdesjardins Business Applications 0 22-May-2009 06:14 AM
Solved: Writing to Controls In An Access Subform SimonB Business Applications 8 22-Jul-2008 09:40 AM
Solved: Setting Drop Down values in VBA (Access 2003) bdavis7 Business Applications 2 25-Jun-2008 11:21 AM

WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑