Serial Cash Drawer With Kick Back Interface
Nov 8, 2005does anyone know how to get a serial cash drawer with kick back interface to open through Access?
any help or a point in the right direction will be hugely appreciated
ADVERTISEMENT
Modules & VBA :: Open Cash Drawer Through Command
Jan 16, 2014I am building a database in Microsoft Access and my client has the followed USB Cash Drawers and they want to open the Cash Drawer through a command button in Microsoft Access,how to open the cash drawer through VBA command. Here are the 03 Cashdrawers links they are using.
M-S Cash Drawer - CF405 USB Connect. URL...
Epson T20 Thermal Receipt Printer - Epson ReadyPrint T20 Receipt Printer USB. URL...
and
NuRolPOS NURCDM116 Standard Duty Cash Drawer with 5 Coin/5 Bill Till. URL...
How To Open A Drawer Cache
Jan 6, 2013How to Open a drawer Cache "birch" connected to the computer via USB without printer
View 2 Replies View RelatedWhy Does App Kick Me Out Of Access???
Sep 25, 2006I wasn't sure if this is the right spot for the probelm I'm having, but....
In Access 2000, I have an application with a Report selection menu, from where you can choose one or several reports, key in a from-date / to-date range, select whether to preview or print and then click a command button that'll run the selected reports.
Each report iws based on a its own group of queries.
Until today, everything was running OK, but today, when a certain report is selected, an hourglass stays on the screen for an awfully long time, and then I'm tossed out of my application and tossed out of Access completely! There are no errors displayed, there is nothing displayed.
If anyone has a hint of an idea, I'd sure love to hear what's causing this strange behavior. Thank you to anyone or any group of people who might be able to shed light on this!!! I think I need medication!!
Kick Users Out Of DB
Feb 19, 2007Hey guys,
I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can
1) Kick a user off
2) Send them a message
3) Send a user a message and then kick them off
Troubleshooting Kick Out
Jun 17, 2005I 'm having trouble with a DB. One of the forms is a schuduler which the user clicks on a calendar control and a form opens up showing orders schuduled for that date and unschudule order. The user then can assign the order. Just recently whichout any DB changes the user gets kicked out of the db when they scroll down thru the records. This is happening on Multiple workstations and rebooting doesn't help. Tried deleting the record but its not a problem with a specific record scrolling thru other records with the same fields filled in works. The Detect and Repair did not work (believe it or not) The same happens on the query that the form get it data from and I tried to copy the table to make a backup but it kicks me out. I'm thinking the tbl might have to many fields (55) but the DB is only 39 MB.
View 1 Replies View RelatedKick Out Of Database?
Dec 12, 2006Ok this is weird but is there a way to kick everyone out of the database so you can do updates? Alot of times people tend to leave their computer on overnight with the database still open
View 2 Replies View RelatedKick Users Out Of Access
Jun 9, 2005Has anyone got any ideas of programs that are avaliable to kick users of a database in Access remotely?
Our Programmes team have a program which will do this and it doesn't involve any tables, etc within the database but they won't tell me whats it called or provide me with a copy of it!!
Anyone got any ideas?
Cash Sales Vs Invoices
Mar 25, 2007I'm creating a database where I have a customers and invoices table, obviously there is a relationship between the two tables using a customerID field where I have referential integrity enabled. However not all invoices require a customer account as some are cash sales where no customer details are required.
I'm unsure of the correct procedure, all I can think of is to create a separate table for cash sales??
POS Or Cash Register On A Form
Apr 18, 2015I am considering creating a form to use as a cash register or simple POS system. Where I could start looking into this? are there any templates or sample code I could refer to? Using access 2003 version...
View 2 Replies View RelatedForms :: Calculating Time Into Cash Value
Nov 11, 2014I have a combo box which looks up a set of values from a table, some of these I have got to store, others I merely want to work with and calculate from. These columns are:
DutyNumber
WeekendOrBHPayment
Sun-ThursNightsPayment
FriSatBHNightsPayment
OTRate
WRDRate
AHDifference
SKPayment
UnSocPayment
Now for most of these, I 'think' I have it planned where they will go or how they will be used, but the OTRate is flummoxing me a wee bit.
On the form, I have an OT(time) field - the idea being that the user will enter the hours and minutes of overtime they have done (short time format - is this correct?)
Then, I would like the form to calculate the cash value (has to be stored in a field) by multiplying the hours/mins worked by the OT Rate - - but I don't want to store the OTRate unless I really have no other option. Once the calculation has been done, if the Rate is then 'forgotten' then that is no issue, as the only time it would be needed is if the field is revisited to amend any errors (so I am thinking the calculation should be done as an After Update event on the OT(time) field?)
Forms :: Updating Cash Account Table Through A Form
Jul 14, 2013How would I update my cash account account table through a form? I have just started working on access and am fairly new to it.
What I am trying to do is to update my master table with all the daily sales through a form. Would I need to write a query into my form?
Modules & VBA :: Open Cash Drawers Attached To Receipt Printer EPSON T-20
Mar 24, 2014We have an Access database that opened some cash drawers attached to the computer through USB and it is working perfectly. We have some of the cash drawers that are attached to the EPSON Receipt printer and we also want to open those Cash Drawers attached to the receipt printer. Looking for code to open the cash drawer attached to the receipt printer, Is there any command available that I could send to the receipt printer and it would open the Cash Drawer.
I have also taken the screenshot of the utility program that will show the information regarding the printer and I am very expecting to get this working soon as we have build the Microsoft Access database that would checking the cash drawer status and also open the USB cash drawers.
VB 6 Interface
Feb 17, 2007is it possible touse visual basic 6 for example to create an interface for the finished access database so that I can create an install application for users that do nothave Access.
in other words, I want to have a standalone application through VB 6 that will manage the database application.
regards
Web Interface
Mar 24, 2007I need to develop an intranet site to allow not just read only but write access using either Access 2002 or 2007 (maybe). Does anyone have any advice to which is the best tool to use? I have Dream weaver MX already but I’m not that good with it, I have been looking at CodeCharge Studio 3.1 online Has anyone used it?
Thanks.
:)
Interface
May 18, 2007Hi People,
Another question,
My database is looking good now, but I have one question, I dont want users to view it as I do, i.e with all the wizards etc, so how do I create an interface which does not allow the user to view the backend?
Interface
Oct 26, 2005I want to create a form and connect it to a MS Access database.
Moreover I wish that whatever entries I make in the form they get transferred to the corresponding fields in the Access database.
Any link for a similar thread will be highly appreciated
User Interface
May 16, 2006Hi:
Is any way to modify the shape of a table, to make it a little more friendly for the users ??
Thanks for your support.
Nestor
Using Access With A Web Interface
Jul 26, 2006I want to use my browser to view/edit some data in a mdb file. Can someone point me in the right direction of what I need?
Thanks,
Dave
External Interface Or API
Oct 24, 2007Hi All,
I am not an Access developer so please forgive my ignorance!
We have a Quality Assurance (QA) database (Access 2003) that has a "Project" table.
Currently our QA person has to fill in project data (e.g., project name, project manager, start date, etc.) from within the Access database. I can automate this process by providing the project data from an external source.
Does Access have any integration capabilities which allows it to receive external data, like:
- a command line interface for doing SQL inserts (like isql.exe)
- a formal API
I see examples of ODBC use in the manuals, but they are from within Access to connect to an external DB. I want to connect and insert into Access from the external source.
Push into access versus pull into access.
TIA,
Matt
Multilingual User Interface
Jul 12, 2007I have just started a new job in Italy!! One of my projects is to create a database for the companies infomation. I have never used Access, and its in Italian, i have zero italian and im finding it difficult to start. Does any one know how do i activate Multilingual User Interface and does it come with all Microsoft Office software...does it have to be installed or is it installed automatically
View 5 Replies View RelatedInterface To Allow Users To Create Ad-hoc Queries
Oct 20, 2005Hi All
I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer.
I can see how to do it (a form with code that creates the SQL), but I wondered if anyone had done something like this before and had any tips or even any existing code. Have searched and can't find anything, but I suspect I'm searching on the wrong keywords.
Dave
Interface Unresponsive After Running Query
Apr 3, 2012I am executing a somewhat complex query. The query joins a local table to a third party linked VIEW table and then performs a crosstab transform to display the data in a meaningful way. I have a few other local table joins as well. The query takes about 5 seconds to run.
~20k records are displayed and the interface is COMPLETELY lagged/locked up. I click a record and access will start timing out. Scrolling down is nearly impossible... why would it still be unresponsive even after the query has finished executing?? isn't it just a result set and the interface should be fast?
Data Entry Interface (Create New Record) Help
May 1, 2005Could anyone of you give me some sugguestions on designing a nice/efficent Data Entry interface (Form design) for adding new records?:
I have bound a Form with a table and linked all the textbox with the relevant fields in the table. I created a add new record button through the wizard provided by MS-Access as: DoCmd.GoToRecord,, acNewRec.
While, each time when I opened that Data Entry Interface, the current always pointed to the first one rather than leaving the blank field for data entry. Even I changed the value in those textbox, the system didn't create a new record in the table at all, only modifying the first record.
I know how to write the VBA code to open table and add new records by retrieving data from the Form interface, but I wonder whether there is more efficent solution by combining the default function/facilities from MS-Access itself and some VBA code. Also, it can have some validation before storing data into the tables.
Many Thanks
Wizard Style List Selection Interface
Aug 15, 2005I would like to create a "wizard style" interface to allow users to Select items (staff members) by moving them from a list of "available" staff to a list of "selected" staff (and back again if they change their minds :rolleyes: ). - e.g. Like the Report Wizard, where you move table/query fields between the "Available Fields" and "Selected Fields" lists.
Does anyone have anything to help me out with this, that they could "lend" me ?
Of course I am stuck using AC97.... so I may need to borrow a hammer and chisel as well :D
File Interface From Different Source To Access Database
May 12, 2013We having this Human resource system that the company will be using however, the current payroll application will still be used as normal but the update will not be done on the same application.At the moment the current set up is that there a three database linked together that makes up the payroll application but for now one of this database will not be pupolated with data as it will now come from another source all together via extraction or file interface which is the new HR software.
The only problem I'm facing is some of those fields that i will need to transfer over to suit the current set up of the payroll application is not included on that new software file extract and i dont know where to start or what to do because abviously the file interface should consists of this mandatory field.Without seeing the relationship of what I'm talking about do you think its worth continuing this project as those wanted field are not included?And how can we go without these mandatory field?