Search results

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...

First off, before we can give you any advise you need to provide us some details. I have built a few scheduling systems for Sony and it is all about the data source's. 1. Where is the data coming from? 2. What format is the data in? 3. Is the database going to be a filter for viewing the data...

The IIF statements in Access are too diffacult to wrap your mind around. It would be much easier to show you if you posted the EXCEL sheet with a few of your records and results you want. Then I could build you a quicky DB with the formulas you need.

Looks like i found how (thank-you) I figured everyone on this sight have been so helpful in the past. It is my turn to add something to the group. Here is my code for calling a stored procedure from ACCESS. 'TO call the function is as follows...

Hello all, I am looking for a way to execute a Stored Procedure on SQL server 2000 from my ACCESS 2003 front end. (Using a button) Does anyone have an example Access DB or code available that could help me make this happen? I would really appreciate!!! Kind Regards Steve~

I do not if this will help but here goes. If you want to convert many files to PDF Go here http://www.daneprairie.com/download/download.htm Download: Batch2PDF V1.12 Free ware on printing or converting files to PDF