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!

Search results for query: *

  1. stevo1961

    Call code from Module

    Sorted If Forms![Jobs].Dirty = True Then Forms![Jobs].Dirty = False Forms![Jobs]![Delivery Dockets].Requery
  2. stevo1961

    Call code from Module

    Hi, I have this code on a cmdbutton "cmdBarcode" called from my form "Jobs". I would like to call this from a Module instead of the form. I am having problem calling this from ta Module. I think it's the Me.Dirty that might be the problem. Private Sub cmdBarcode_Click() On Error GoTo...
  3. stevo1961

    DoCmd.RunSQL Append Query

    Have it sorted now..thanks!!!
  4. stevo1961

    DoCmd.RunSQL Append Query

    I tried this but there is a syntax error Dim strSQL As String strSQL = "INSERT INTO tblManifest ( DeliveryDocketID, DeliveryDocketNo, JobID, BatchNo, Quantity, QtyType, LabelCount, NumPallets, Status, Description ) SELECT JobsDeliveryVendor.DeliveryDocketID...
  5. stevo1961

    DoCmd.RunSQL Append Query

    Hi, I have an Append query named "Append Manifest" which I call using the DoCmd.OpenQuery "AppendManifest", acNormal, acEdit INSERT INTO tblManifest ( DeliveryDocketID, DeliveryDocketNo, JobID, BatchNo, Quantity, QtyType, LabelCount, NumPallets, Status, Description ) SELECT...
  6. stevo1961

    Printing duplicates records based on number value entered into field

    Hi Duane, Worked like a charm...appreciate your reply Thanks very much.....
  7. stevo1961

    Printing duplicates records based on number value entered into field

    Hi, I have a Main form (Jobs) and subform (Delivery Docket) 1:M that runs the following code behind a print button. The code essentially takes the line record or all line records from the subform (Delivery Dockets Table) and appends this to a temp table called DeliveryDocketTemp Table. Now...
  8. stevo1961

    Odbc Connection On Linked Table Failed

    Hi All, We tried creating a new ODBC linked to the table and recreated the link but to no avail. checked Primary key and it was still intact, no bit data type in any of the fields. Unfortunately, we decided to create a new table and transferred the data across as the issue was not going away...
  9. stevo1961

    Issue with Concurrent Users

    We have an SQL server 2000 with 20 users running Microsoft Access 2003 front-and connecting via OBDC to linked-tables on the database of the server. We have been using this set up for several years now. Just until last week everyone was able to use their Access frontend to access the data on the...
  10. stevo1961

    Odbc Connection On Linked Table Failed

    We have an Access 2003 front end ODBC linked to a SQL Server 2005 backend In one of the 4 tables (1:Many relationship)we are getting this error when a user tries to add or change a record ODBC -- update on a linked table 'Delivery Dockets' failed or OBBC -- insert on a linked table 'Delivery...
  11. stevo1961

    Pass-Through Query Syntax Error

    PHV, 2nd and 3rd one worked for me. Although, I am still confused with single quotes and brackets, thought these were only Access properties and not T-SQL properties. Seems I still have a long way too go with learning this. Thank you very much again for your assistance...
  12. stevo1961

    Pass-Through Query Syntax Error

    Thanks PHV and Duane, I figured it had to be the space in the table name. Unfortunately, this an old access table created and upsized to SQL server before my time. I was asked for a solution to speed up a the printing of a Sales Invoice report which uses a query with 6 tables linked via ODBC. It...
  13. stevo1961

    Pass-Through Query Syntax Error

    Trying to learn to do a pass-through query with the following but I am getting syntax error trying to get data from a table called dbo.Sales Invoices from our SQL Server. SELECT dbo.Sales Invoices.SalesInvoiceID, dbo.Sales Invoices.SalesInvoiceDate FROM dbo.Sales Invoices; ODBC---call failed...
  14. stevo1961

    Alternative to GoToMyPC or Citrix

    @1DMF, This is perfect, same line of thought as well. Now, I just need to teach myself T-SQL and Stored Procedure and running these queries on the server side instead of the FE. Now the learning really begins... Thank you very much for the reply
  15. stevo1961

    Barcode Formatting UCC /EAN 128

    Sorry, ="00" & [A1Code] & [B] & [F] & [CheckDigit] [B] = [GSI] [F] = [PalletNo] So, ="00" & [A1Code] & [GSI] & [PalletNo] & [CheckDigit]
  16. stevo1961

    Barcode Formatting UCC /EAN 128

    With Barcode Formatting UCC /EAN 128 you need to add a check digit. Hence reason your coming up with an error code. Create a function to generate a check digit code and run the function on your query which is the source code for your report that takes this control source below from: You could...
  17. stevo1961

    Alternative to GoToMyPC or Citrix

    I have been asked to find an alternative to using GoToMyPC or Citrix to run over a WAN that spans the whole of IRELAND, UK and POLAND. Our setup: Windows 2003 Server with 2003 SQL server as a Backend Access Frontend linked to SQL server via OBDC on several desktops in the home office from...
  18. stevo1961

    Control Source Formatting

    Hi, Hoping for any assistance here. I have the following in my control source which is the source for my ActiveX control or my barcode label text on my report. =Code128("~212" & "00" & " 1 " & "" & "0123456" & " " & "999" & [DD] & " " & (4),1,True) In Windows XP the control source works fine...

Part and Inventory Search

Back
Top