Form Help 01-18-08

I have a form creating that lists a product code and a product description.  
When entering data into this form I have people scan a product code.  Is 
there a way to set up a trigger that will notify me if the product code 
listed on the form originally and the scanned product code do not match?
0
Utf
1/18/2008 8:28:00 PM
access.forms 6864 articles. 2 followers. Follow

1 Replies
834 Views

Similar Articles

[PageSpeed] 22

You need to add your own code to the BeforeUpdate event of the control or 
the form.  I haven't worked with scanners so I don't know if scanner input 
will trigger the BeforeUpdate event of the control so if that doesn't work, 
use the form level event.  You can then cancel the update if the values 
don't match.  If the field you are scanning into isn't bound, no event will 
fire when data is entered so you may need to add a button so that you will 
have an event to hang your edit code in.

"Erika" <Erika@discussions.microsoft.com> wrote in message 
news:07FFC315-F590-4CC6-AF82-F0757638FEE8@microsoft.com...
>I have a form creating that lists a product code and a product description.
> When entering data into this form I have people scan a product code.  Is
> there a way to set up a trigger that will notify me if the product code
> listed on the form originally and the scanned product code do not match? 


0
Pat
1/18/2008 9:41:12 PM
Reply:

Similar Artilces:

single user form with multiple worksheets
Pl help. I want to use single user form for data entry to multiple worksheets in a single workbook. The form has one dropdown list with each name in the list having corresponding worksheet, to which all data should be posted. Hi Rohit Refer the below link by Debra Dalgleish for detailed help. http://www.contextures.com/xlUserForm01.html AND for your requirement replace the below line of code Set ws = Worksheets("PartsData") with Set ws = Worksheets(Me.cmbSheets.Text) where cmbSheets is the combobox which has got the sheet name -- Jacob "rohit...

TREEVIEW Win Forms
I want to access on child node on click method? treview1.node.nodes(?) ... ???? Thanks ... This group is for VB6 and earlier(VB Classic). VB.Net and all dotnet groups have either "dotnet" or "vsnet" in the group name. Please use the following group instead: news://msnews.microsoft.com/microsoft.public.dotnet.languages.vb "Winforms" are .Net. This group is for VB. If you're using VB.Net you're in the wrong group. Try here: microsoft.public.dotnet.languages.vb > I want to access on child node on click method? > >...

Combo Box
Hello, I am using Excel 2007 I am trying to use the combo box - form control. I have the input range in a different sheet A1:B200 showing General Ledger Number and Description. What I want the user to see is the General Ledger number and description, but only show the account number when the user's make their selection. Currently I am only seeing the General Ledger Number when I am looking for a number. How do I do that? For example: GL Number Account Description 4550 Sales TMA I want to see both when trying to make a selection...

HTML Help not closing the file
I am using HTML Help to display help information within my Excel program. After I close HTML Help, the file system thinks that the .chm file is still being accessed, and I cannot overwrite the file (although the HTML Help process is closed). Here is the code that I have to open: Call HtmlHelp(0, ActiveWorkbook.Path & "\MyHelp.chm", HH_DISPLAY_TOPIC, 0) or Call HtmlHelp(0, ActiveWorkbook.Path & "\MyHelp.chm", HH_HELP_CONTEXT, 1001) and to close: Call HtmlHelp(0, 0, HH_CLOSE_ALL, 0) ...

Office 2007 Ultimate will NOT install in Windows 7
Hi, I bought Office 2007 Ultimate through the student deal over a year ago. I have the discs and my product key. When I put the disc in, I type in the product key and that is accepted. I choose custom installation, and then choose what I want. I keep all of the shared office files to install, I just don't install Groove, One Note, Access, or Outlook. When I click install, it goes to the progress bar, and then the installation crashes. Finally a message comes up saying there has been an error in the installation, and Windows will attempt to find the solution. After a few sec...

Conditional Formatting Help #3
Hi my problem is that i want to set a same conditional formatting for more than 50 cells but it allows me to set one at a time. How to set conditional formatting for all the cells at a time ?? -- Little Master ------------------------------------------------------------------------ Little Master's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28227 View this thread: http://www.excelforum.com/showthread.php?threadid=528036 It doesn't work when you highlight your range?? Here's a great place to learn more on CF http://www.contextures.com/xlCondFor...

Check boxes and user names in forms 03-03-10
I would like to create a checklist in Word using a form. The in-built Help gives a good description on how to create a form and add check-boxes to it, but I would like also to have fields next to the check boxes which auto-populate with the user name when the check box is set, and another field which auto-fills the time the check box was ticked. Any advice or suggestions gratefully received. -- TobyR If you assign the bookmark names checkname to the checkbox and textname to the formfield in which you want the user name to be displayed and texttime to the formfield in ...

Project Accounting Series Post Form is Blank
Using 10.00.1301 I have one user who cannot see any entries in the Project Accounting Series Post form; therefore, she cannot post without going to the individual timesheet, misc., equipment batchs and posting from there. If she logs in on a different workstation - same problem. None of the other users have this problem. The form is not a modified windows form. Financial and Sales Series posting windows are fine. Any direction is sincerely appreciated. Scuba There is nothing that's going wrong in this case. Go to Tools=3D>Setup=3D>Project=3D>User and Select the User ...

Help reading XSD as embedded resource with SQLXMLCommand
I'm reading xml from SQL Server 2K with VB.net using an XSD schema file and SQLXML 3.0. I have the below code working fine, but I'd like to change the code from reading the schema file from a directory to reading the schema as an embedded resource. Here's my current code, what would I need to change?? Dim strm As Stream Dim strmReader As StreamReader Dim cmd As New SqlXmlCommand("MyConnectionString") Dim xmlDoc As New XmlDocument Dim strXML As String With cmd .CommandText = "MyXPath" .CommandType = SqlXmlCommandType.XPath .SchemaPath = "C:\MySche...

Crystal Reports Error 02-18-04
In the report screen we are getting the following error: Internal Error.{On Web Component Server:CRM] In the Event log we show the error "Exlate failed to translate EPF to HTML and returned error code 2. Any thoughts? ...

Why isn't data that is automatically generated in my form showing up in table?
Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the root of my problem. I have created a form that allows users to enter in an employee's clock number using a combo box and it automatically generates the employee's name in a text box next to it by pulling information from the Employee Data table. This data shows up fine in the form view and the datasheet view. However, when I open the table up that this data is being saved to (Weekly Data), the data that has been automatically...

Help! Links aren't updating
I have a very large spreadsheet that has cells that reference othe cells in other tabs withing the same workbook. However they hav stopped updating. These are simple links (='TAB'!CELL), but when change the value in the source cell, the linked cell is not changing. The only think I have found to work is to F2 into the cell with th link, then <enter> out and it refreshes. Due to the vast number o references in this workbook, this will take forever! Any ideas on how to get the workbook to refresh all links withi itself? Thanks! Andre -- Message posted from http://www.ExcelF...

Form Modified Date Changes when opens
I am using Access2003 and have two databases, the problem one is newly created in Access2003, the other was created in a previous version, I think 2000, but I believe was updated to 2003 before we purchased it. I make modifications to both. In both databases, I have created buttons that open forms and occasionally change settings on that form (like a background color or control enable/lock parameter). In the newer DB I have noticed that Modified date for several of the forms changes when the form is opened, and there's no pop-up mentioning changed or saving of changes. This doe...

Programmatically export/import forms and modules?
I made a VB6 app to extract forms and modules from Excel workbooks. Now I'd like to expand this app to also handle Access files (.mdb). Here's the critical parts of the code for Excel: Dim xlApp As Excel.Application Dim xlWb As Excel.Workbook Dim VBComp As VBIDE.VBComponent ' Load workbook Set xlApp = New Excel.Application xlApp.Visible = False Set xlWb = xlApp.Workbooks.Open(sWorkbook) ' Loop through all files (components) in the workbook For Each VBComp In xlWb.VBProject.VBComponents ' Export the file ...

Expense reporting-need HELP
We are using GP 7.5 and was wondering how people handle employee expense reporting. Our company wants to begin reimbursing employees for their expenses through payroll but I was wondering where do we begin. Do we still enter the invoice through payables so the detail is there and choose the payroll checkbook as where it is issued or is there an entirely separate module. Can anyone give me some input on this matter because I am confused and need to get moving on this?? Thanks so much Barb Are you processing payroll in GP? if yes, you dont have a lot of options regarding allocation...

Please help me with this XPath expression
Hi, I have a xml file like this <tab> <category name="Software" > Test purpose <subcategory name="Software"> <method url="addSoftware.aspx">Add</method> <method url="editSoftware.aspx">Edit</method> <method url="searchSoftware.aspx">Search</method> </subcategory> </category> </tab> Yesterday I asked a question about getting a node which has a specific child node. However I realised that I need to get a node with a specific name and has a specific child node as well. (e.g...

Referring to a control on another form
I have a report form which enables 16 different reports; I have managed this by using 4 different Option Groups, each with 2 buttons - no defaults. A Command button traps non-selections, contains all the if statements and executes the relevant report; that works fine. I thought that it would be useful to allow the user to determine which of the buttons should be a default. I have built a Parameter Form, arranged another set of option buttons with another Command button, but when I write the code to change the default status of one of the original buttons, I can't get it to work. ...

Problems with forms
I am having two problems with forms: 1. All of my forms go the full window. There are no borders on my forms! I am setup with Single View, as I want and all of the properties are as they should be. 2. I have three tables that have multiple Yes/No boxes on them as defined in the setup of the tables Each box Lookup in the table is set to be a checkbox. But when I put one of these fields on the form and right click on the text box and go to Change To the checkBox Option is grayed out. Can Anyone Help?? TIA -- Ron On Fri, 1 Feb 2008 19:27:01 -...

Data collection Form Edit
We have a form which will be used almost daily, for data collection, based on a query. During the test we found a typo in one of the field labels where a brief description is included. Is there some way to edit the form? (recreating it with all the custom lables is just too long a task). Another issue on this topic, every time the form is sent, the messge reverts to the default "Please fill out the form and retunr it to me". Can this default message be changed? Nothing in the help functions. Any advice, or deirection to a learning resource will be appreciated. Thanks is adva...

Help with formula #29
Can someone please help. I have several ifs statements that I need in a formula. Sheet2 has a column with square feet. Column (D:D) that totals all sq ft, with total results in Sheet2 (K4). On Sheet1 (H4) I'd like for the results to be: If Sheet2 (K4) <= 25 then Sum Sheet1 (C:C)*1, If Sheet2 (K4) >25<75 then Sum Sheet1 (C:C)*2. If Sheet2 (K4) =75<100 then Sum Sheet1 (C:C)*3 and so on... For every 25 I would like for it to Sum then multiply. Thanks in Advance!!! On Apr 11, 3:18=A0pm, Dick <bobde...@yahoo.com> wrote: > Sheet2 has a column with square feet. Column (D:D) ...

Office 2007 Help files
Did Microsoft recently change the way the Help facility <F1> works? It seems to me, as someone who used it quite a bit, that they have made a major change, which was certainly not an improvement. On May 17, 4:45=A0pm, Kelli <Ke...@discussions.microsoft.com> wrote: > Did Microsoft recently change the way the Help facility <F1> works? > It seems to me, as someone who used it quite a bit, that they have made a > major change, which was certainly not an improvement. Hi Kelli, yes I have noticed that it changed about a month ago now or so. Hi Kelli, In wh...

Open PopUp form with criteria from Subform and criteria in Main fo
Hi all, I have a main form called LOC_maintenance, a subform called Frm_MultActSelect and a Popup form called Frm_LUComplianceHistory. The LOC_Maintenance forms fields are as follows: LOC_GPO (a combo box) GPO_Name (autofills based on =Column(1) of LOC_GPO) Group_Prod_Cat (Autofills based on Column(2) of LOC_GPO) Subform Frm_MultActSelect is a datasheet form that allows users to add accounts that are affiliated with LOC_GPO from a tbl_account_Master and has a combo box field named LOCAct_AccountNo. All other field on this form autofill based on LOCAct_AccountNo entered. The Popup fo...

tabbed pages on form
I have a form which had six tabbed pages across the bottom half on which I have subforms or extra fields such as a "notes" page which won't fit on the main form. I recently added a seventh tabbed page onto which I dragged a number of fields (which hold extra data which is not always required in the record) onto it from the main form. This seemed to work fine but the fields also show on another tab, and can be used there, even though I have not put them there. Also when I leave the form and come back to it (clicking a button to preview a report and then closing the preview). I f...

Help with Outlook
How do I uninstall and reinstall the TCP/IP Stack? >How do I uninstall and reinstall the TCP/IP Stack? Why do you think this has anything to do with Outlook? Right-click on "My Network Places" (or "Network Neighborhood", depending on your version of Windows), click "Properties", find your network connection and right-click on it, click "Properties", locate the "Internet Protocol (TCP/IP)" service, click on it, then click "Uninstall". Go to the sam place, but click "Install..." instead. -- Brian Tillman Smiths Aerospa...

Payables Management: Voucher Approval form as part of Invoice Entr
In Payables Management: provide a Voucher Approval form as part of invoice entry. This would let us print a form that our dept. heads could sign or make corrections if the distributions are wrong. I can provide examples if you would like to see what we are doing currently via an customization. In article <3C47FAFD-45D8-49B1-A528-24D2760B3195@microsoft.com>, Victor@discussions.microsoft.com says... > In Payables Management: provide a Voucher Approval form as part of invoice > entry. This would let us print a form that our dept. heads could sign or > make corrections if ...