Search results

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...

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?

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...

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...

This may seem like a silly one but i cant think where to start, I have a table called tblCustomers and one of the columns is Mobile containing their mobile phone numbers. I need to read through the list of numbers and add each one to a comma seperated string, such as...

str = "[CustomerID] = " & Reports!rptAccountMonthly!CustomerID & " And [ControlDate] >= #" & [Forms]![frmAccountManagement]![StartDate] & "# And [ControlDate] <= #" & [Forms]![frmAccountManagement]![EndDate] & "#" varMonth1Charges = DSum("Amount", "[tblAccount]", str) The above is returning...

Im integrating a Scanpal Batch barcode scanner into my application, and need a little help with my label printing facility. at the moment the scanner imports a list of barcodes and quantitys this is merged with my product table and results in a table something like this: barcode | Description...

Im producing a statement report and the form to generate it allows you to select customer, dates etc, however Id like my StartDate and EndDate text boxes to default to the first and last dates of the previous month. ie if you open the account form on any day in march then the start date will...

Im integrated a metrologic scanpal batch barcode scanner into my application, the scanner drops a csv into my application directory, the text file is as follows. My Text File 9794022121256032,4 9794022121256032,9 9794022121256032,3 9794022121256032,5 I then use the following sub to import the...

Im trying to produce an account statement, detailing the activity between 2 dates and then giving some totals at the bottom. The report is based on a query, this lists all the transactions, and then at the bottom I have a number of dsums that calculate total payments etc However I have a...

I have a form with a data sheet that allows information to be keyed into a table, this table has a primary key that must be filled in. if you dont, you get the error message "Index or primary key cannon contain a null value" How can I trap this error and replace the message with something more...

str = "[CustomerID] = " & Reports!rptAccountMonthly!CustomerID & " And [ControlDate] > " & [Forms]![frmAccountManagement]![StartDate] & "" varMonth1Charges = DSum("Amount", "[tblAccount]", str) the above appears to be giving me the sum of all of the customers amounts rather than just those...

Dim VarCutoffDate as Date Dim Str as String VarCutoffdate = DateAdd("d",-30,date) Str = "[CustomerID] = Reports!rptAccountStatement!CustomerID and [ControlDate] => VarCutoffDate)" Me.totaldue=dsum("Amount","[tblaccount",Str) Where am I going wrong? I need to total the amounts in the account...

I have an application developped in access 2002 consisting of a mde front end, and mdb backend, and deployed with the access 2002 runtime. I have recently discovered an issue where when closing the program, the database closes but the runtime will continue to flicker. this flickering prevents...

sql = sql & " WHERE (((tblAccountBalance.DateLastPayment) < #" & reminderdate & "#))" Im trying to select all the entrys in a table where the date of the last payment is before a variable 'reminderdate' this works fine if both dates are in the same month ie, DateLastPayment = 26/11/05 and...

We have a product that is shipped as an mde front end and an mdb database, the application runs in runtime and usually the systems it runs on do not have access installed on them. Can anyone point me in the right direction with regards to creating a form with a textbox on it, and some code on a...