Search results

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

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

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

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

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!

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

I have a table callled orders. And I need to find out how much labor was assigned to that order. So I have a query that the labor table to find all the labour transactions to that specific order. Now what happens is that if nobody clocked into this job I will have no results, but I need a...

I have searched everywhere and have not come up with answer yet. Here we go! I have a query that gives me this result PART# INSTRUCTIONS (text) (memo) 123 Cut 2 at 5 inches 124 Cut 7 at 12 inches 123...