Search results

Hi, I am tring to create a Word VBA Mail Merge. I have a MySQL database that runs on a local machine and have a view setup called vwprintqueue. I am able to manually run the mail merge from inside Word but want the mail merge to complete automatically from a click of the button. I have created...

All, I am currently running Office XP and have a database in Access. The DB has a form that contains a textbox and a listbox. When you enter text in the textbox it automatically filters the listbox to find any data that contains the letters you type, letter by letter. This is all done using VBA...

Guys, I recently had a developer create me an acccess database for my plumbing business. It basically looks at contacts that i have with clients. On a monthly basis i run a form that looks at all my clients contracts that are ending in that month (I choose from a lstbox). It then runs the...

I found a piece of code here that works great, but have found a little bug. The code is: Dim dbs As DAO.Database Dim rstMergeThese As Recordset Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Visible = True With oApp .Documents.Open "C:\Temp\Service_Plan_Schedule.dot" '...

Hi All, I have attached a DB that I am trying to create for my small business. Every month we have renewals of the client’s yearly contracts. I have created a form called frmRenewells, on this form you need to select a month and a year (please choose October 2006) this then runs query...

I have a form that needs to enter some data into a form. I can not do this by bounding the the textbox to the table, therefore i am having to use ORs. I am using the following code in VBA but is not working: 'Save Payment Type Dim oRS As New ADODB.Recordset oRS.Open "SELECT PaymentType FROM...

I have a command button (cmbBarcodeEnter). After update i want the it clear itself of text and the be ready for the next barcode to be entered. At the moment the button updates and then tabs to next button and leaves the text in the cmbBarcodeEnter button. Thanks D

I have a DB that has a table called tblproductList. In the table i have a field called Image. I have made this field a Text Field. I have entered product details and have entered ghd.jpg in the Image field. this reflects the image i have stored in the same directory as the DB. I have a form and...

Is it possible to use F keys to call Forms/Queries. I have used the code below and found when i press F7 spell ceck runs: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyF7 Then Dim stDocName As String stDocName = "qryDepartment1"...

I am trying to create a EPOS system for a local small store. I have created 2 tables tblTransMain, which holds ID, Order Date, Order Time, Payment Type and Sales Clerk. This has a subform called tblTransactions, which holds all the transaction info. I have so far created a form called...

I have found 2 pieces of code on the internet that should open COM3 and fire a kick to open a cash drawer. The code is in VB, but I want to use this in an access database. The code is 1.) Dim iFile As Integer Dim arrbData() As Byte iFile = FreeFile Open "COM3" For Binary Access Write As...

I am trying to create a simple till system that creates transactions. I have bought a till and kick that runs on USB. The company I bought the equipment from supplied and application that allows you to test the drawer. You select the port (Comm3 in my case) and select open. This then firers the...

I have a database that works as a sales system. From a table in the database I run a query that calculates the totals for that day. i.e. Date……….Dept 1…..Dep2 07/11/05…...£10………£10 What I need is: 1. You click a button 2. It copies the date and finds it in the excel spreadsheet as the sheet...

I have a form that is bound to a table and also a subform that is also bound to a table. On the Subform I have a Plus and Minus buttons that sort of work at as a tally chart. Every time you click the plus button it adds 1 to the quantity textbox and vice versa for the subtract button. What...

I have a form that calculates the total cost. It also as an option to revoke the transaction. The code used is below: =DSum("Cost","tblTransactions","OrderID = " & [ID] & " AND Revoked = False") I have since added in the option to Discount a product. It writes back to the same table but I can...

I have a combo box that I use a barcode scanner with. I scan the barcode and it finds the product using the code below: Private Sub cmbBarCode_Click() ' ADD A TRANSACTION AUTOMATICALLY Dim RS As ADODB.Recordset Set RS = New ADODB.Recordset RS.Open "SELECT * from tblTransactions"...

I have written a basic query that looks at the date field, department field and cost the cost field on a table. What I would like is a form that you can chose a date (19/09/2005) and a it looks at the table and calculates the total sum of money for each department for this date. Ie. Date...

I have a tabular form for a sales database. i.e: Product Qty Cost Cherry Coke.........1...............0.95 Diet Coke............1...............0.95 Sprite.................1...............0.55 Cherry Coke.........1...............0.95 I want a command button to open...

I am trying to make a Sales Transactions and Stock database I have so far created a Transactions form that when you scan the barcode it enters the data in to a table (tbltransactions). What I now require is: When the order has been complete, I would like a button that opens a new form to open...

I have a simple sales form (frmSalesTransactions). When I enter a barcode number into the Barcode filed I would like the remaining fields (manufacture, Product Name and Cost) to automatically enter. All the required data is stored in tblProducts. I understand this is done via a Dlookup on the...