Recent content by educate889

Bob S. This is my first try at randomizing anything with Access, so I am playing catch up! But is there a way to do this inside a query and not use the form approach. What I need to do is randomly select say 5 records from an inventory table that will need to be cycle counted and verified. I...

Nevermind guys . . . I did some more searching and found enough to get it too work. me.cbosec.requery on the change event of combo 1

I need to do the same but I am having difficulty with the requerying of Combo 2. Can either of you help with a little snipit of code on how to requery when combo 1 changes? cboPri = Primary Failure = Combo 1 cboSec = Secondary Failure = Combo 2 Thanks in advance!

gwog What references did you change or more importantly, what ones have you selected . . . I am getting the same error with the date function and need a fix also.

Larry, Have you ever seen this date function cause an ODBC error? When I use Date()-1 in my criteria it causes an ODBC error, however when I remove the criteria the query runs perfectly fine. Any help would be appreciated.

Cant this be done and not have two separate tables. . . I have one table called MASTER that holds Parent#,Layer,rack,row,slot,status Relationships would mean multiple tables, how should I split or is there another way! Please advise.

This give me part of the picture . . . but some more detail would be appreciated!

Let me explain . . . I need a way for the users to enter a parent part number (once) and have it populate for multiple dies and their individual specifications . . . I was thinking of a form with subform, where you enter Parent# on Form and it populates to subform where the user enters the...

what thread did you find it in . . . I am having the same problem

Thanks for the reply but I have some questions. What did you mean by . . . "Now do whatever SQL is required to run the s.p." This is the spot I am confused! I set up the pass-through but now I'm looking at a blank dialogue box waiting for me to put in the perfect SQL statement...

I have a SQL2000 datawarehouse with a A97 FE used primarily for reporting . . . however, I have a complex report where we decided to create a stored procedure that creates a temp table and use that table for the basis of the report. If there is a way to launch the stored procedure from within a...

Kraeg and Hap How can I make it a A97 database? What are the steps that you might know? One other problem is that I have some security on the db right now that I know might get in the way. Any hints would be appreciated

What about if I built a A2000 application with FE/BE that now needs to be reduced to run on A97 since because of budget constraints. Should I have much trouble moving them to A97? Is there a reason to keep BE A2000 and just change FE? What other things do I need to keep in mind that I may be...

Thank you both . . . you have definately helped me and I hope the stars show that. . . I will try lewakin's idea tomorrow at work. . . I still am having the naming problem but will try Paul's idea . . . If that is the worst case that can't be fixed I will survive. Thanks again for all...

Paul Thanks for the idea . . . have a star I have gone through and modified all queries to accept these changes and things are running smoothly... The last thing is the naming of the excel files.. . In the code we hardcoded the name and dump it into H: Is there a way to name the file...