Search results for query: *

I am wanting to set up a trigger on our SQL server 2000 to create a sequential order line number in the OrderLines table for OrderID. I will be inserting data from an OrderLinesAdd table into the OrderLines table but want the LineNumber field to be incremented by 1 for each group of orders...

We have an Access 2002 frontend and SQL Server 2000 backend. I am trying to get this function to work but am getting Invalid use of property, when the code gets to cmdSQL.CommandType Here is the code I have written: Public Function GetStoredProcedure() As String On Error GoTo...

I have the following set of example data: OrderID LineNo OrderQty 102 1 10 102 2 5 103 1 2 103 2 3 103 3 20 If I then add another OrderLine for example OrderID = 102, I would like to increment the LineNo...

I am needing to create order references for data that we are then going to pass into 3rd party software. So the structure of the order reference has to be in a specific format for their software. Here is some example data from the Access table 'Transactions' and the order reference that I need...

I am trying to setup a site to site VPN from an ADSL Draytek 2600 router (Remote site with Static Public IP Address, DHCP server for remote LAN) to our SBS2K server (Head Office with different Static Public IP Address). I have run the Local ISA VPN Server Wizard on the SBS and have set it up...

I am producing a product check sheet for a date range for a number of different customers. Now the product check sheet may only be 1 page for 1 customer but >1 for another. 2 copies of each check sheet go on each customer's pallet that we send out. So I need to automate the printouts so that...

Hi All This is my first attempt at any code but cannot get it to work. Please could someone help me correct the following code including the date formatting: Public Function DateCode() As String '1)If chrCoDivision = TS, then DateCode = Format([dtmDlyDate]+[dblMaxShelfLife]) as ”dd mmm”)...

Hi All Need some help generating a report. I have a table of products with their planned sales by week no & customer. I can then gather the actual sales from the Orders but I need to be able to produce a report of planned vs actual, where in some cases, there are planned but no actual sales...

Hi all Am I able to setup a dialog box (form) in order to select multiple linked criteria in order to run a series of append queries ? At the moment each customer has 2 different append queries to gather the pricing data for 2 separate tables, with the delivery date field in each query setup as...

Hi All I am trying to find the best way to work out the use by date codes for a number of products that we supply to a company. I am using Access XP. The company has 2 divisions: TS and TM that are stored in a text field called chrCoDivision. We supply different products to each division. At...

We just installed a Quantum Snap Server. It works great for everything, EXCEPT PeachTree. If one person access the data on the Snap drive, you eventually get an error that someone else is doing this function, etc. I call PeachTree Support ($159.00 for 60 minutes) with no postive results. I...

We just installed a Quantum Snap Server. It works great for everything, EXCEPT PeachTree. If one person access the data on the Snap drive, you eventually get an error that someone else is doing this function, etc. I call PeachTree Support ($159.00 for 60 minutes) with no postive results. I...

We just installed a Quantum Snap Server. It works great for everything, EXCEPT PeachTree. If one person access the data on the Snap drive, you eventually get an error that someone else is doing this function, etc. I call PeachTree Support ($159.00 for 60 minutes) with no postive results. I...