Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. IainGreen

    Adding a Prefix to an Order Number textbox

    It is a Long Integer and order number is only an number field NOT an autonumber. The the first '0' of the prefix is still cut-off, is this because it is a long integer?
  2. IainGreen

    Adding a Prefix to an Order Number textbox

    Hi, I have an order number text box field on one a form which i need to be automatically filled with the prefix: 0405/ I have tried putting it in the default value of the text box's properties but it cuts off the first '0'. Please can anyone help asap. Thanks
  3. IainGreen

    AfterUpdate Problem

    Hi, I have a form forHighways which lists job numbers & details for road repairs to be made. I have a combo box (cmbCategory) which the user selects a job category from a list which states whether the job is Misc., Kerb, Emergency etc... There is also a text box (txtCostCentre) which I want to...
  4. IainGreen

    Update Query duplicating data as well as updating in table.

    [TabIssued] is the table underlying my subform. I havent taken any measures to limit the update to just nely added employee. So how do I do that?
  5. IainGreen

    <b>Update Query duplicates data in table as well as updating</b>

    I have a problem using an update query with a subform. The subform 'IssuedTo' contains combo boxes with selection options (employee initials), representing members of staff assigned to a particular job number. There can be any number of employees assigned to one job number. All the...
  6. IainGreen

    Update Query duplicating data as well as updating in table.

    Here is the update query: Field: IssueTo Table: TabWay Update To: [TabWay]![IssueTo] & [TabHWIssued]![IssuedTo] & "/" The "/" is used to separate the different employee initials. I was running just this query on close event for the whole form on which the subform...
  7. IainGreen

    Update Query duplicating data as well as updating in table.

    I have a problem using an update query with a subform. The subform 'IssuedTo' contains combo boxes with selection options (employee initials), representing members of staff assigned to a particular job number. There can be any number of employees assigned to one job number. All the...

Part and Inventory Search

Back
Top