Search results for query: *

Thanks Darrylle~! I decided to have the user input the sales order number with a prompt. A star for your help!

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

Yes I do. I am launching from a cmdButton on the sales form. If I hard code a sales number in the query, the file exports great from the button. Thanks

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

Another option is to hide the objects you do not want seen. Right click the Query, or Table and select properties and check the "Hidden" box. Cheers!

Maybe someone can point out where I am going wrong? 2 Functions Public Function Gray() Dim ctrl As Control For Each ctrl In Me.Controls On Error Resume Next ctrl.BorderColor = 8421504 Next End Function Public Function DBlue() Dim ctrl As Control On Error Resume Next...

Hello jbl1167, As I understand it, the tablet PC is nothing more than a touch screen where the stylus mimics a mouse click. I have created a few touch screen applications with MS Access. I imagine this would be very similar. As far a handwriting recognition, that sounds a little futuristic. If...

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

A star for you!!! I was assuming the name of the form was what I was seeing in design mode, when in fact it was 'child19'. Fixed the name of the subform and all is well, thanks as always!

I was able to resolve this by placing an additional 5 checkboxes on the main form and updating those based on the subform checkboxes. I refferenced the main form checkboxes in the OnFormat section of the report and all worked great! If someone can help with with the correct syntax to refference...

Thanks Duane, Did as advised, and the report errors saying cannot find the control "chklevel1". Just for clariffication: chklevel1 is on: Form name: F0004_YourCompany Tab/Page:tabCatagory SubForm: AF01_MajorCatagory Thanks

Great information, that I will follow, didn't know that! A zillion thanks for this site and all teh people who post/respond!

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

Thanks Alex, Tried the syntax as you posted, which returne an error stating it could not find the form? Triple checked and the form name is correct. I changed to this: strSQL = "UPDATE T11_Item_Master set T11_57_StockTakeQty = T11_57_StockTakeQty + " & me.qty.Value & ";" DoCmd.RunSQL strSQL...

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

Many thanks sir, Works like a champ! A star for you!!

Thanks rjoubert, In the module (MyGlobalVariable) would the code look like: me.transtype = [forms]![frmSales]![TransType] me.transtype = [forms]![frmPlayback]![TransType] me.transtype = [forms]![frmWinner]![TransType] me.transtype = [forms]![frmPlayBack]![TransType]

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