Recent content by AlanGNW

Thanks for the reply. I did find it eventually and you are right about the bound colums... Now having problems pulling tables into Excell with a similar result - even though the bound colums are set right...

Is it also possible to link into a querie rather than an entire table?

I guess the simle options from earlier will work best for me. Know nothing of VB. Can I put multiple tables in a workbook this way? I guess option 2 sounds better - it sounds like the data can't be refreshed using option 1...

Will option 1 allow me to refresh dat as option 2 does?

Thanks - I'll give it a try. Sounds pretty simple - I hope. It needs to be for me :)

I want to use the data contained in Access table in an Excell app. What is the best way to link them - preferably in 'real time' - is there a way excell can read directly from the tables? We need to analyse some of the data in the database through Excell.... Any suggestions welcomed...?

I'm trying to pull fields from a table into a form - and have had other problems with this..... What is textual information in one table. ie. the table I am trying to acces from a drop down will only appear as numbers instead of the text entry in the original - I have triend the bound colums...

Thats me... :-)

Despite in design view setting pages to landscape [I work on it out of hours on a laptop], when I drop it back onto the server for use they default to portrait? Any help you can offer? Another quick one whilst I'm here - when trying to change the database properties [main properties under file...

Solved it thanks. The problem lay in the fields of forms and reports. Although I had the table right - the forms were placing in the wrong column of the secondary table. Thanks for the help!

No result Sadly no result. Still responding to the number rather than the text....

The two field casing me grief are... SELECT Clients.[Record number], Clients.Company FROM Clients; SELECT [Sales contact].[Record number], [Sales contact].[Sales contact] FROM [Sales contact]; The criteria within the querie is... [Client name: example - XXX]

Tried '2' Tried 2 in the bound column as you suggested - but still getting the same result...

My mistake...! The problem seems to be the link in two combo boxes which draw on other tables. For instance the main table draws on a list of customer names from a 'customer' database for the combo box.... The queries are only responding if I put in the number of the record ID rather than the...

Tables? Would that be on both tables? What exactly does this do? Thanks for the help... A