Search results for query: *

hi Golom If I could just get the first name of the eldest wouldbe good as I also have a field DOB in there.

Hi can anyone help. I am trying to insert more than one first name into the firstname field where address1 is the same for the names. This is so I do't send the same information to the same address more than once. I hope to mail merge the data. qrypromo...

If you are a novice with access forms the best way to get data onto a form is by using the form wizard. Go onto new form then select form wizard, then select the table where you want the data from then select the column from the table, then select columnar, then hit next,name your form then hit...

I have set it up now and when i double click to view I get an error saying "had difficulty communicating with the ole server" start it outside of access and try the process again. Any ideas?

In the table it is an OLE object

I haven't assigned a data type to it yet as I am not sure what type to assign but it will be something like a bound object frame? I am I heading in the right ditrection?

I am trying to insert a picture on an Access97 form using data from SQL 2000 using ODBC to access the data. The pictures in the SQL 2000 are Blobs. Is there anyway that I can solve this problem.

Thats fantastic. Is it possible to do a select into an exsisting table as apposed to create a new table?

Using SQL what is the quickest way of copying a table

nicsin That is a fantastic idea. The reason why I am doing it like this is the trans table is actually a query from a table which is ODBC. I need to import these tables and make them work soley on Access tables as I am demonstrating how a program works and have no access to the network to use...

here is the strucuture Insert into Transactdetail (trdReference,trdTransDate,trdMembNo,trdCasualNo,trdActCode,trdDesc,trdHeads,trdValue) SELECT* FROM Trans WHERE Trans.trdReference > Transactdatail.trdReference Great Joke by the way

I am trying to do a simple append query to update a table. What I am trying to achieve is update a table when changes have been made to the table that I am appending from. INSERT INTO TransactDetail SELECT * FROM Trans; I would like to put a WHERE clause in WHERE Trans.trdreferenceNo >...