Recent content by p0welly

I have a listbox on a form, that using the keydown function, allows you to select an item and click enter to select it and run some code. Im trying to make this work in a touchscreen enviroment, so I have my up and down arrows to move about the listbox but I cant get my select button to work...

Yep just tried that but didnt seem to have any effect, its actually the windows printer driver box im trying to hide, so to be fair im not even sure if this is going to be possible. Your help is apreciated though...

are you planning on using a receipt printer? Most EPOS receipt printers have a cash drawer trigger (rj11) socket, this can easily be fires, by sending a control code to the printer?

Something along the lines of... DoCmd.OpenReport "rptMiniReceipt", A_NORMAL, , "[TransactionNumber]=" & VarTransactionNumber

I have a point of save database, that as part of the sale process prints receipts (a report). Is it possible to print a report without the windows "Now Printing" dilogue box poping up, or to hide it in some way?

Im currently unable to make an mde of my database, first thought was to compile it to check for errors, however compile is greyed out. Any Suggestions?

I have a button on a form that is hidden, the button has a label over it, both are normally hidden. When the user presses another button on the form I need these to appear but however I do it, the label appears behing the button. Ive sent the button to the back and brought the label to the...

I want to put a banner add on the switchboard form of my application, that is hosted online. So if I change the image online, my users will see the new image next time. Is this possible? if so, can somebody point me in the right direction?

Figured it out based on this thread. On Error Resume Next Dim db As DAO.Database Dim qdfNew As QueryDef Dim strSQL As String strSQL = Me.txtSQL.Value Set db = CurrentDb() With db .QueryDefs.Delete "qrySQLDump" Set qdfNew = .CreateQueryDef("qrysqldump", strSQL) .Close End With...

in my application I have a number of options where the user can transfer data out of the program into a spreadsheet, I would like to create a dynamic option to do this but Im not really sure how to go about this. strSQL = Me.txtSQL.Value If strSQL Like "Select*" Then strSQL =...

I have a point of sale application that includes the ability to print barcode labels, currently when a client need support for a new printer or a different style of label then i have to borrow the printer and build a new report to fit. Is it possible to build a report dynamically, specifically...

Thank you very Much

I cant get my head round this and I know it should be simple. I have: txtOldPrice txtIncreasePercentage txtNewPrice Customer enters his current price in txtOldPrice, enters a figure such a 15 in the txtIncreasePercentage and txtNewPrice will = txtOldPrice +15% it would be simple to enter...

Im trying to use Jon K's code to send text messages, however my database was converted from 97 to 2002 and uses DAO so when I try to use this code I get the error "User-Defined type not defined". how would I convert this code to DAO or use it in my database Thanks

that perfect thanks, and thaks to Jon K aswell