Search results

I'm not using an autonumber. I'm developing this for the microsoft sql desktop server rather than a normal database because of its manner of handling client - server relationships. The sql tables wouldn't let me insert data unless i had a primary key, so I added the line_number field as a...

i'm still not seeing a way of assigning the id_numbers, like i said earlier i had to assign unique id numbers to use as a primary key. i can't just copy the id number since its already in use by the previous version of the quote. I need to copy all records for a given quote_id number...

Well, I want to clone the records so that a previous quote can be updated without losing the old quote. I think what you're suggesting would work though, I'll try and build a query to do it and get back to you.

well, i couldn't figure out a way to get the sql tables to auto number themselves, and so I've been numbering them myself upon insert with a random number assignment scheme. Some of my tables, this one in paticular don't have any other item that can be used as a primary key. So I'm not sure...

Yeah if I get your meaning. For a real easy way to do this I'd make a txt box on my form somewhere. Then I'd make it invisible. Now, in your combo box event for when it gets a new value, stick the new value in the text box, and take the text box's old value and put it in your message box...

Hi, I've been trying to think of a way to do this (just conceptually). I have a rather large table of price quotes from suppliers with columns: line_number (primary key) | quote_id_number | item_code | quantity i'm using an msdn sql server and access 2002. the line_numbers are just an...

Thankyou very much, I'll try that. EDIT: It worked great, thankyou! :D

Hi, this is my first post here, and like most folks, i've got a problem. I'm trying to develop a database of components for my company; all components are identified by a 10 digit primary key and have two atributes. I used some VBA code to handle insertion, let the user pick from some drop...