Search results

I was thinking of using a DTS package for this. I guess that's what I really needed to know. How hard is it too create one of these data warehouses without using DTS Wizard? Do you have a good instructional website that could show me the starting point? I'ver read the article on SQL Server...

I have a Sybase DB that contains quote information that needs to be entered into our SQL Server 7 DB. Currently I have and Access DB that sites between both Sybase and SQL7 and links all the tables together and I can then create queries and so on and so forth, between both systems. Up to now...

The full story. We have an application in house that allows a user to upload files to the server. The application takes the file and generates a GUID and stores the file by the GUID name in a shared directory. The application also stores the GUID string in a DB and links it order or quotes...

I have a GUID string that is stored in a DB(the db is purchased and I cannot see the source), I wanted to know if there's any one out there that can help me break this GUID back to it's original string. Is this even possible, or am I way off track with these GUID?

I can't use an autonumber at this point. Is what I'm asking possible, if so, I need a little direction.

Reasons for Appending tp new table I am reading information from another DB(a) and the table I am reading from does not have a sequential numbering system. The Table I'm appending too, needs a sequential number in order to function properly. The table I am appending too is not an AccessDB, its...

I have a query that baically select quotes from one table and appends records from those quote to another table. Here's an example Quote 3533, part A100, Quote 3533, part A111, Quote 3533, part C852, Quote 3669, part B552, Quote 3669, part B663, So what I want to do, is add a field that...

Thanks for the reply Boblarson, I just figured out. Thank for your response

I have an Access97 database that links 2 other databases together. I then have a form that runs on the timer event and runs queries at certain intervals. I am also using the "DoCmd.OpenQuery" to run the queries on the interval. My issue is when I open one of the databases and open a certain...

Thanks for your reply. I think I have to look at my process and determine if there's an easier way to accomplish what I want. I really appreciate your answer. Thanks a million.

The reason I need to do this is because I'm writing from one database to another. The one database has all the instructions in a seperate table but the one I have to update does not have a seperate table and therefore requires me to enter all the instructions of the particular part in one...

I have an update query that append new instructions to a memo field. This query just randomly adds lines to the memo field in no particular order. Is ther a way to update the memo field in an orderly fashion!! Example I have a part called XYZ and it has an extended description Field(memo)...

found this!! I think i can modify this code to give me what I want! http://www.mvps.org/access/queries/qry0006.htm If I use a mod 1, it should return every record with a number Thank Rob.Mills

Rob.Mills It just looks a little funny, but the order number is 123 and i want 1 in the next column The second column is the record count order 123 188 588 record 1 2 3 It supposed to count the records. like record 1, next record will be record 2 and so on...

I am trying to run a query with a record count in one column. example order record 123 1 156 2 558 3 and so on... Can anyone help Thanks!

Thanks I will try this first thing monday! Thanks Wayne

Wayne Thanks for the reply I should have been clearer. The record is not added to the database using an access form, and I am not adding a record to an access table. I was actually wanting to monitor an SQL 7.0 dataset. You see, I want to monitor the 'order' table and look for any new...

I want to send an email to a user when an new record is added to a certain table. I found some code on this subject, but all it does is use the recordCount function to generate an email. I need to be a little more specific. I want to be able to send and email with some details on the new record...

Thanks Jon You're right , I guess there is no way of quering the table if no records exist ( cutting) I will have to take car of it at the report or form level! Thanks a million

Let me expand a little! Let's say i have order 123, and that order had 3 operations associated to it like cutting, packing, and shipping. My query result looks like this order, operation, time, then labour rate 123 Cut 1.0 10.00 123 packing 0.5 10.00 123 shipping...