Search results for query: *

Hi. I have recently created a quotes database, in Access upsized it to SQL and successfully replicated it across domains (UK - USA) between 2 SQL servers. In addition I've replicated (merge) out to desktops here in the UK to MS Access front ends from the UK SQL Server. The replication works...

Danvlas I seem to have Hi-Jacked Drew's thread here. Sorry Drew. Tried the suggestion but no luck, What I am trying to do is create a Quote number made up of an employees initials and a number generated automatically, in sequence if possible. Its the resultant "quote number" that I...

Can I just leap in here and please ask! Taking Drew's original question a step further. Is it possible to prefix an autonumber with the contents of another field in the same table. ie the initials of an employee so the result will be for example, DAB102? and store the result (DAB102) in...

Thanks for the pointer. Added SQL Indexes still no joy, However Your suggestion got me thinking of indexing in general. It turned out to be the relationships at the front end. When deleting some tables to allow SQL to replicate new ones the relationships were also deleted. Ive now recreated...

Hi I recently finished!!! my Access database and then got asked to put it on an SQL server for the group to use. Disaster struck. I managed to split the database ok, then using SQL created a new db and imported the tables only. Next, replicated (merge replication) the database out to the...

Thanks for the reply, although it was not quite what I was after I appreciate it. Eventually got it sorted by putting a command button on the main form with the following code. StartCode gstrWhereQuoteID = "QuoteID = " & SubfrmCustomerQuotes1!QuoteID & "" If...

Hi, need some help with this if possible. I have a Customer Details form with a subform in datasheet view showing the quotes issued against a selected customer.That was the easy part!! What Ineed to do now is: Select a record in the subform, click on a comand button in the parent form...

Vic I have just finished going through the referrences as suggested and added the ones that were missing, including an OCX from MS Common controls, missing from the system32 folder. Copied one in, registerred it and all works fine now. There's more to this than Cut & Paste. Thanks once again...

Hi and help I moved my database from a Win 2000 machine with Access 2000 to a W98 machine with Access 97 and also to a WXP Machine with Access 2000. Both come up with an error message after starting the database, opening the quotes form and selecting any one the 3 combo boxes.(The form is based...

Ssecca Thanks for the reply, I'll give this a go. Cheers Dave

I have 2 forms, Quotes and Categories. Quotes form,(I can switch from here to the categories Form) Quotes has a sub form with products,part numbers, prices etc. Categories Form, allows me to list products by selecting a category. These are then listed in a subform with all the product details...