Point of sale software

[hunterfan48]

Has anybody ever created a database that a business could use for a point of sale software? I've created a card database with all of the cards I have in stock with a unique ID to identify them. Now, I'm wondering if there is already a template, or even if it is possible to create a point-of-sale software in MS Access???

thanks,

 

[boblarson]

I created one for a cancer patient appearence center at a hospital. It was necessary for them as they were eventually going to go to this other software that the company was implementing but it wouldn't be available for over a year. So, I was tasked with creating one to be able to handle the store and phone sales.

I can see if I can find a copy (it isn't written the best as I've learned a whole lot more since I did write it several years ago).

 

[hunterfan48]

cool thanks...I'd appreciate that. Does anybody else have any suggestions?

 

[pkstormy]

I have several helpful coding 'snippets' you can utilize while building your application located here:
http://www.dbforums.com/microsoft-access/1605962-dbforums-code-bank.html

There are also a few full applications in the dbforums code bank.

You can look here: http://www.dbforums.com/microsoft-access/1621820-sloppy-snippets.html where I posted several applications (I called sloppy snippets) such as a Purchase Orders mdb, a checkwriter mdb, a Timesheet mdb, a Travel Voucher mdb, a CardFile mdb, etc...etc...

Otherwise MSAccess 2007 has some great built-in templates and non-2007 MSAccess versions included the Northwinds.mdb on the Office cd.

 

[boblarson]

Here's the POS that I did. I checked throught it and changed some of the information just so it wasn't showing real info. And I don't know what is up with this one thing that pops up on current for me. You can try to track down the error. I don't have time to right now.

 

[boblarson]

Oh, yes - and when you select the Admin user the password is 12345

 

[pkstormy]

Nice app Bob. The only thing I don't like is having to login (I personally like to use the getuser() routine to return the loginID automatically and utilize that with a 'user' table.) But I wanted to let you know I looked at your app since I always like to look at other programs developed by different developers. If you'd like to see any of my other type of coding snippets, they are here: http://www.dbforums.com/microsoft-access/1605962-dbforums-code-bank.html (the ones in the code bank posted by pkstormy).

 

[boblarson]

Nice app Bob. The only thing I don't like is having to login (I personally like to use the getuser() routine to return the loginID automatically and utilize that with a 'user' table.)

I had to do it this way because the store uses a single computer and they couldn't just log out and in to the computer during the times that the users were using it. So, a quick way to login and out was necessary to be able to use the app. POS applications, in a retail setting, would need that quick login and out ability because you can't keep the customers waiting while you change users.

But in most other settings I would agree with using automatic login based on the Windows login.

 

[hunterfan48]

Bob, I couldn't get it to open cause of the error. Sorry, I don't know how to fix it either. Thanks tho...

 

[boblarson]

Bob, I couldn't get it to open cause of the error. Sorry, I don't know how to fix it either. Thanks tho...

Just click END and it should open.

 

[hunterfan48]

pk....thanks for the links.

 

[boblarson]

Also, remember to hold shift key down when opening initially so you can relink to the backend.

 

[hunterfan48]

nope...tried that but it didn't work. If I posted my database online, would anybody want to check to see if they would know of a way to make it like a pos system? If someone can think of a way and let me know, I'd be willing to pay that person to help me improve my database.

thanks,
brady

 

[boblarson]

nope...tried that but it didn't work.

Please lay out the steps you took, one by one. It seems funny that you can't get it to work when pkstormy did.

 

[hunterfan48]

I opened it, clicked 'enable content' and then it gave me the error. I clicked end and then it closed the database...nothing was there.

 

[boblarson]

I opened it, clicked 'enable content' and then it gave me the error. I clicked end and then it closed the database...nothing was there.

Okay, you need to do this:

1. When clicking ENABLE CONTENT you need to hold the SHIFT KEY DOWN. If you don't it is just like opening the database without the shift key. So you have to hold the shift key down again and continue to hold it until it finishes opening.

2. Then you have to go to Linked Table Manager and relink the backend to the location you extracted.

3. Then you can close and reopen normally.

 

[Steamellar]

Hey Pals,
Can someone please re-upload the transition database that is working?

 

[Freshman]

Hey Pals,
Can someone please re-upload the transition database that is working?

Yes I know it's an old post but I was searching for something on a POS system and found this post and decided to assist.
I attached a working copy but remember to re-link the tables to the BE
I only attached the FE which contained the error.
Not having time to find the error, I simply suspended the error message so it just opens.
Works fine on my side
(Thanks Bob)