Search results for query: *

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

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

Have it sorted now..thanks!!!

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

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

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

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

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

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

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

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

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

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

@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

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

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

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

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