Search results for query: *

actually what I did is the following and it seems to be working okay - although subforms might be a better way to go 1) one form where they enter their criteria and hit submit 2) this opens the other form that has it's record source set to the nominations table and applies a filter to it to...

MajP, so if I undterstand what you are saying it is 1) I still have my form where they enter their criteria 2) this opens a form with a filter applied using the criteria that was entered. The form has combo boxes with the id's as the bound columns and displays the name field I've tried...

Majp, let me clarify my issue or question a bit we have a table called nominations that looks like salesman_id terminal_id amount now entrying the records works as we want. Users select sales person from combo box, select terminal, enter amount and all is saved to the table - id is saved...

Folks, I'm not that familiar with MS Access and was hoping that someone could point me in the right direction to determine the best way to accomplish the following the situation 1) I have a sales forecasting applicaiton 2) it has a number of cross reference tables that the users select...

thanks folks. I'll try the pass through query as it looks like it may work according to the help documents. I'm not familiar with access or vb so couldn't really find any good examples of an ado command object. JoeAtWork, do you have any links to some examples of how to use it?

folks, is it possible to execute a stored procedure in the sql server database from an ms access database. We already have the stored procedure running via a sql server job but the users want to be able to execute it on demand and already use ms access to query tables in the database. thanks

Folks, In the shop I work in we have cognos decision stream which I understand is an ETL tool. I have a requirement to retrieve some data from a sql server database and write it to an output file. The data is basically order data and when written to the file each order will create multiple...

Folks, I am quite new with access so please bear with me. The situation is as follows. I have a database with four transaction tables. I wish to delete all records in these tables that have a date before 01-oct-2006 and at the same time copy them to another database as a sort of backup...

Thanks for the responses again. One more question. Does sql server have a utility or system stored procedure that can be used to, create, open, and write to a text file. I have seen that the sp_oamethod can do this but it seems to be a performance hit but I think I am going to have to do...

nocoolhandle - thanks for the response. are you aware of why people say stay away from cursors in sql server? it bothers me a little because with the logic I am going to have to follow I can't really just write one big query to get the data and cursors are really the only way I see to...

Folks, I am relatively new to sql server (coming from more of an oracle background) and was wondering if I could get some advice on the best way to proceed with solving the following problem. I need to create a file for a trading partner using information from our database. The file has...