Search results for query: *

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

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

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

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

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