Search results for query: *

I posted this in the Forms forum, but seem to have folks stumped? I am attempting to export an Access Query as a text file. The query parameters are defined by a form that has a primary key which is an autonumber [PK11] The choice of Sales Order Number defines the query result set. In the...

I am attempting to export an Access Query as a text file. The query parameters are defined by a form that has a primary key which is an autonumber [PK11] The choice of Sales Order Number defines the query result set. In the [Sales Order] parameter in the query, i have...

I am working to develop a new MS Access 2003 database. What we would like is to place all of our text boxes on forms with a transparent background, and light gray borders. When a user mouses over a text box the border will turn dark gray, and lastly if the field has the focus the border is...

I have a form, with multiple tabs. On the product catagory pricing tab, I have a button that will print the product catagory price list report. This report has 5 pricing levels. My button works great and prints the report. I have placed an unbound checkbox above each level on the form, and am...

Access 2003 I am scanning barcodes into a bound text field. After scanning is complete I want the user to click the finished button, which will count the serial numbers scanned in, and add that number to the existing inventory balance. I added an unbound text box (qty) with the following...

I have been looking at the MS Access templates that Microsoft provides: http://office.microsoft.com/en-ca/templates/TC010184581033.aspx?CategoryID=CT061995421033 If you go to that link you will see an icon that looks very much like the icons used in MS Outlook. It looks like a little TV with...

I have a form frmSalesReg that can be opened from a number of other forms (frmSales, frmPlayback, frmWinner, frmmerch). On frmSalesReg I have an unbound textbox with the following code in the OnCurrent event: me.transtype = [forms]![frmSales]![TransType] The question is how can I get the...

I have a query that calculates the pull percentage on a game. The query works perfectly when I hard code the WashStampNum for the criteria. I would like to display this percentage on a few different forms. I know I could enter [Forms]![frmSales]![WashStampNum] in the criteria to pull the...

I have the following code for a label. when the user clicks the label above a column it will resort the continuous form by the column clicked. I am getting a Syntax error message on the select statement, although when I paste the SQL into a new query it runs fine? Begin SQL...

I am creating an application to sell games. Users pick from a list of games on frmBowl20 (only one game may be sold at a time). When the user clicks the "Sell" image on the form (frmBowl20)I transfer the main game details to unbound controls on the unbound form that acts like a cash register...

Im not sure if this is the best way to do this or not? Currently I have a form with a record sourcebased on a query from tblMasterGamesList that I would like to display the game names from. I have 27 unbound text boxes in the details section of my form. What I would like to do is lookup the...

I am developing a program that uses a touch screen. I have two fields 'UserName' and 'Password' on the login screen. I have also created individual buttons A-Z for the user to press. I have been trying to figure out how to get the info into the correct field using the On Click event with no...

How can you ensure a form will not allow duplicate records to be created? My form has 6 fields that are from table 'tblemployee'. The control names and database field names are the same. name DOB position hire date/time pay rate badge # When a user enters 'BOB, SMITH' in the name field and...