Recent content by Steve5

John, Thank you so much just for saying "second query may well have been a append query". That is exactly the best way to handle it! I created a query of what records i needed plus added "count" to how many sales orders per year. Then converted the query into a to "Make A Table" then...

Folks, I want to use schedule a stored procedure to send a table from SQL server to a specific MS Access database. So i can utilize the power of SQL Server to create the table and send over the results to MS Access.

See attached example DB. I updated two Equipment ID's with H and D so you know what I need

I will make a little test db

Yes it will be sorted by Equipment ID

This is for a data report that has many fields with different parts on order, but the Equipment ID is what tool the parts are ordered for. We have this project and this system asked us to supply the first record with a "H" = header and the related records with a "D". Hope that helps

Update the [ID Column] field with an "H" for the first record then update [ID Column] with a "D" for the next duplicate record

Folks, below I have two columns, the [EquipmentID] is what I have in a Access table and the [ID Column] is what i need updated in code. Can someone help me with the how the code would work to update [ID Column] field? H = Header or first record unique Euipment ID D = Duplicate of Header ID...

Hello everyone, I have been a member for quite awhile here on this site and I always enjoy everyone’s input to various solutions. Therefore, I figure I would post an INSERT INTO process that deletes a APPEND query then recreates it with the filters selected by the user built into the...

How would it look if you had two queries and you wanted to export Query 1 into sheet1 and Query 2 into sheet2 of same workbook? Is this possible?

Just to help you out - you may want to place a small example of the DB on the site so we can see what your are working with? Just a few records are all that is needed (Dummy Data)

Very Helpful Bob - Thankyou

I opened your DB example and the tables and query are missing. In order to show you could we have a version that has a few records for display? Dummy data is fine

I prefer to use Access as a front end and link all the table through ODBC connections to a SQL server back-end. (SQL server 2000) is the easiest in my book. The link process is just like linking a text file to access just a few more parameters required to get through the Server security. As for...

Your not going to like my answer - :( I would transfer all the data to a SQL server back-end and then create a new front-end with access, which would have all the users working from the same data source. Create Shortcuts on each users desktop to the Access db with permissons setup on who has...