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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by renepaulin

  1. renepaulin

    CONCAT in UPDATE query won't work

    Hi PHV, The & operator did the job, Thanks
  2. renepaulin

    CONCAT in UPDATE query won't work

    Hi, Can someone tell me why this won't work for me ? UPDATE Temp SET Field2 =('LEFT(Field2,'*-')' CONCAT '0' CONCAT 'RIGHT(Field2,' #')') WHERE Field2 LIKE '*- #'; I'm getting a syntax error on the SET line. Thanks,
  3. renepaulin

    ORDER BY a string numerically ?

    Hi all, Is it possible to order a query by a string but to order it numerically instead of alphabetically. I tried to convert the string to a number with no luck. Right now I am getting: 1,10,11,12,13,14,15,16,17,18,19,2,20,21 ... I want 1,2,3,4,5,6,7,8,9,10,11 ... Thanks Rene
  4. renepaulin

    Expected: expression ?

    Thanks PHV, it did help.
  5. renepaulin

    Expected: expression ?

    Hi all, Can someone help with this? I get an expected expression error. DoCmd.OpenReport cboReport.Column(1), acViewDesign Reports(cboReport.Column(1)).lblTitle.Caption = _ "string " & _ "string" & cboMonth & "/01/" & cboYear.Column(1) & "string" _ &...
  6. renepaulin

    unbound default value problem

    Hi all, I am trying to set a default value for a combo box that selects the year in order to print a report. I can't set it with the default value property in design view because the combo box is unbound. How could I do this ? Thanks Rene
See more

Part and Inventory Search

Back
Top