Search results for query: *

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?

Hopefully, someone can help me. I have a qry that I am looking to get all resources, the total time each resource worked, and also show the resources that didn't book any time. This query works perfectly when I have no selection critera, and shows all 540 resources. When I enter selection...

It is. Still doing the same thing. Any other suggestions?

Hi there. I have a form with a combo box, cboBusJust, that I have set to AfterUpdate = mcrBusJustPopUp mcrBusJustPopUp is set to open the pop-up form, set a couple of values based on the main form, and have a field where the user enters the reasoning for the justification level. there is...

Works beautifully. Thanks!

I think I got it to work. Here is what I did. Private Sub check2_Click() If check2.Value = "-1" Then check10.Enabled = True Else If check7.Value = "-1" Then check10.Enabled = True Else check10.Enabled = False...