Recent content by starbird

Thanks! I'll try this and let you know how it works!

Hi there. Here is what I am trying to do. I have a PC that I just installed Windows 2000 Server, 10 client licenses. I am a Mac guy, but have a wireless/wired network as I often work from home with my work PC laptop. I want to use my old PC (newly imaged as STARBIRDW2K) as a file and print...

Hello. I have a report that I would like to add a button to so that the user can export the data to Excel. I have my macro all set up, and the button on the report, and the "hyperlink" for the button the macro, but I can't click the button. any ideas?

Ok, here is my set-up. I have a main form that displays data on enhancement requests. This is fed from one table. [MainForm] I have a subform that displays the areas impacted and the complexity for each of those areas, only for the given request number (from the main form). Users can add...

Great, thanks!

Thank you both for your input. BSMan - That is close, except that the user would want to see the Solution ID, as it is meaninful. is there a way to display both on the form once selected?

I will start off by apologizing for the lengthy post in advance. I have 2 tables. One table, tbl_ClientRequest, which stores requirement requests from a client. The other table, tbl_Solutions, stores solutions available. One solution can possibly solve more than one request, and one request...

Easiest thing to do is to create a macro to output the file, and then assign the macro to a button on your form. Create a new macro in the Action field, select "OutputTo" In the lower pain, fill int the: OBJECT TYPE = Table OBJECT NAME = "the name of your table" OUTPUT...

Ok, I have searched and not found anything that answers my specific question, though I found a lot that made me go back and try a few things. What I am looking to do is this. I have an Access Database (XP, but in 2000 format) that connects to 6 tables via Oracle ODBC. It works fine for me...

Thank you. Works perfectly. Thanks again.

Hello there. I am running Excel XP, and want to know if I can format a cell range (say a column) to not allow duplicate numbers. Is this possible? Thanks.

Thanks, that's what I was afraid of. Maybe I can get a trip to our Ireland office out of it!! ;) Thanks again!

Hello. I have an Access 2000 database that links to some Oracle tables. I want to share this database on a server, but when I do, anyone else who tries to access the table gets an error that they aren't connected. all the users have the rights to view the Oracle tables, so I am not sure as to...

No appology necessary. I do want all records (all resources, that is) but I only want the time calculated for the time frame given (the WHERE clause). When I remove the WHERE, I get exactly the right number or resources, and everything is fine. But I want to only look at a specific time frame...

Thanks for your reply. I do want to get resources that have never booked time. What I am not getting is the resources that, at some point, have booked time, just not in the time frame given. (for example - 10/07/2002 throught 10/11/2002) Any suggestions?