Stephan
Member
Designed non EPOS database for retail businesses, effectively same as self service tills at larger stores with similar VB front end for GUI till, and also till supervisor options.
DOWNLOAD 1MB ZIP XLS with VB USERFORM, 1st tab, NEW SALE, SALE.
Contains VB, lower your MACRO SECURITY to open the file, and use it.
TAB > NEW SALE: button SALE, any new entries appear in tab SALES,
and then STOCKFILE totals applicable values per items in Columns T & L.
QUESTION1: USERFORM 'MULTI' SUB ROUTINE
How to edit USERFORM individual transaction for MULTI PURCHASE sub routine?
QUESTION2: WEBSITE SALES > XL REMOTE FILE UPDATE
How to add online transactions to XL worbook tab SALES?
Not actual payment process itself, just addition of specific Sale to new row in master DB.
Appreciate many possible methods of writing information generated Online updating XL file saved remotely: ONEDRIVE or GOOGLEDRIVE, at a glance perhaps Online > XL:
EXISTING XL ONLINE FILE: OPEN WORKBOOK, HOME, SURVEY, NEW SURVEY.
CREATE SURVEY: ONEDRIVE CREATE, EXCEL SURVEY, COMPLETE, SHARE SURVEY. COPY Survey WEB LINK.
Presume many website sales pages use XL sheets as their SQL datasource, hence perhaps most baskets use certain recognised Website Program, what are the best free Website Design Programs use XL sheets are their source of information? Presume this is widely referred to as SQL.
Used widely, such as Car Classifieds Autotrader, Estate Agent Classifieds, Food Supermarket Products Website, etc.
I've seen many of the widely referred Website Design Programs, their Combo Drop Down Box fuctions were poor hence so was their Data Validation methods, these definately aren't those used commercially, even though mentioned frequently.
DOWNLOAD 1MB ZIP XLS with VB USERFORM, 1st tab, NEW SALE, SALE.
Contains VB, lower your MACRO SECURITY to open the file, and use it.
TAB > NEW SALE: button SALE, any new entries appear in tab SALES,
and then STOCKFILE totals applicable values per items in Columns T & L.
QUESTION1: USERFORM 'MULTI' SUB ROUTINE
How to edit USERFORM individual transaction for MULTI PURCHASE sub routine?
QUESTION2: WEBSITE SALES > XL REMOTE FILE UPDATE
How to add online transactions to XL worbook tab SALES?
Not actual payment process itself, just addition of specific Sale to new row in master DB.
Appreciate many possible methods of writing information generated Online updating XL file saved remotely: ONEDRIVE or GOOGLEDRIVE, at a glance perhaps Online > XL:
EXISTING XL ONLINE FILE: OPEN WORKBOOK, HOME, SURVEY, NEW SURVEY.
CREATE SURVEY: ONEDRIVE CREATE, EXCEL SURVEY, COMPLETE, SHARE SURVEY. COPY Survey WEB LINK.
Presume many website sales pages use XL sheets as their SQL datasource, hence perhaps most baskets use certain recognised Website Program, what are the best free Website Design Programs use XL sheets are their source of information? Presume this is widely referred to as SQL.
Used widely, such as Car Classifieds Autotrader, Estate Agent Classifieds, Food Supermarket Products Website, etc.
I've seen many of the widely referred Website Design Programs, their Combo Drop Down Box fuctions were poor hence so was their Data Validation methods, these definately aren't those used commercially, even though mentioned frequently.