Search results for query: *

Hi I have a possible project where someone will be providing an XML feed which I then have to use with a MS Access db for data analysis. This is not something I have done before so can anyone give me any pointers about this i.e. how will I access the feed and how do I link it to a MS Access...

I thought @@identity would was probaly it but how would I use this in a practical example - particularly getting the ID to display on a form before it is closed?

Hi I have an Access form bound to a SQL Server table. When a new record is created on the form I need to retrieve the newly created ID from the underlying table - what is the best way of doing this? Ideally it would be useful to have the ID appear on the from as soon as the user starts...

Hi 1. I have an Access form called frmCustomers in a 2007 db 2. On it is a list box called lisJobs. The content of this is based on a parameter query which uses the value of the current customer ID as its criteria. It takes this from the ID text box on the customer form ie...

Hi I need to do the following with an Access app 1. Create a Word Document based on a template and save it with a name generated from an Access form. 2. Some details ie address to be automatically completed on the document - again taken from the form 3. Have the ability to create a copy of...

Thanks - again that was very useful. One supplementary question - if I was to use this method for an append query with parameters how would I return the newly created ID from the relevant table if I needed to use for a second query?

Hi Duane Thanks for this - its so refreshing to get an answer with a clear and concise example. A couple of queries... 1. In the SQL line 'strNewSQL = "SELECT .... FROM ... WHERE ID =" & Me.txtID Does the from part refer to the pass thru query specified in 'strQueryName' or can it be any...

Hi I am a fairly experienced MS Access programmer but have less experience of SQL Server. I am building an Access/SQL Server client/server app and I'm looking for some advice on the best ways of dealing with parameter queries. For example I have a form in Access with a dropdown. I need to...

Hi I am a fairly experienced MS Access programmer but have less experience of SQL Server. I am building an Access/SQL Server client/server app and I'm looking for some advice on the best ways of dealing with parameter queries. For example I have a form in Access with a dropdown. I need to...