Hello All and BIG THANKS for being such a wonderful community - that I only come to when in need, sadly.
I have this situation in which, I have 3 worksheets.
Sheet1 (FORM) - User inputs data here.
Sheet2 -(DATA)- Big table of products
Sheet3 - (REPORT)- Nice report for printing
Operation:
1...
Thanks. On lunch now. I'll try that later.
I was thinking that, maybe this invoice could be created from the masters sheet, by using the value on the qty colum of the MAsters table. I use that to generate a print report of the ordered items but the code only works on Print Preview.
U think...
Hi!
I'm still reading but... when I finish the query, I get all of my data in the Sheet, not a drop down menu. How do I make it to display a drop down menu in each row and then fill extra cells in the same row with the info of the item selected on the first row drop down?
Thanks again and will...
Oh wow! I am cursed! :-( I don't see a privacy setting on my profile. Oh well!
I'm currently checking your suggestion of MS Query and hopefully that's my answer. Will report back! Thank you very much for this, man.
In the meantime, will a Flickr link work...
Hello Skip!
Thanks for the quick reply!
The file is a link to a picture. It should open in your browser.
I will check into that and let you know. I would like to select an ItemID and have the item details displayed and fill up an Invoice row by row like this. Then, whatever quantity for each...
I have this workbook - that should have been a DataBase - in this new job I have, where every item properties are store in a Master worksheet. There are 3 additional worksheets in the same workbook (formatted as a big grid, crosswords type of thing so that it fits as many items as possible on a...
Hello! Its been a long time.
Well, the problem lies with IIS. I don't know how to get it back, but I formatted the server, started from scratch, and wanted to redirect the IIS to a public URL. It affected everything including Exchange. When I set it back to the default settings, the policies...
Yes. Outlook is installed in the server. It used to work fine anyways and OWA wouldn't work on the workstations either. I was able to setup IMAP accounts on workstations but then I had problem setting up SMTP server.
Anyays, I'll do the Service Pack and see how it goes.
Thanks!
-Regu
Hello! Zelandakh!
I used PFDavAdmin and well, I was able to restore access the mailboxes using Outlook... or at least it seems from the Outlook Client installed in the server. I can now open mailboxes from within my Administrator mailbox. However, I still cannot get access to Outlook Web...
Hello all!
I have this issue with Exchange 2003, where it no longer gives me access to any mailbox, but the one configured in Outlook in the server as the administrator account. However, I cannot setup this or any other account in any other computer, nor see it in OWA. If I try OWA this comes...
That sounds better. I meant, how long it takes to set up a server from scratch. No previous server involved, in a network where every PC and MAC is on its own. The system in question is a Dell PowerEdge 1900 with a 2.1GHz Xeon.
Can anyone tell me in what kind of enviroment does it take only a...
So without scripting, it takes you an hour to unpack, set the place, plug everything, promote the DC, setup users, exchange, policies and then bind every computer on the network?
Hello!
My supervisor is questioning the time it has taken to set up a server. I would like to have a response from the community instead of my own.
So please, can you answer how long does it takes to set up a server from scratch, that will be used primarily as a file server and gateway, where...
Well, check this out... now I have more issues.
I can now see the router from the server, after removing the gateway from the local connection.
Local connection IP was:
10.0.0.1
255.255.255.0
Internet Connection is:
10.0.0.74
255.255.255.0
Since you mentioned something about different...
Hey ShackDaddy!
Millon thanks again!
Yes! The DNS server is pointing to my ISP's DNS in the Forwarder's TAB. It was configured automatically, since I never touched that, so I guess it is ok.
Thanks again and have a great day!
Regu
Thanks for your quick reply, WIZ!!!
You guessed right! And now its fixed. Now, remember up there about the DNS Interfaces properties? Check this out (you should know how it works very well already...) If I set it to listen only on the local IP, then my server gets no internet access, but the...
Hello all!
ShackDaddy, I didn't see an option to add or remove RRAS from the Add or Remove program, so I did as Microsoft says in this KB 840686article. It basically didn't worked in the first place, but brought up a whole different error, which is explained in this other KB 317158 article. So...
Hello ShackDaddy and Million thanks for your helpful comment.
I did all of what you said and the services are now working fine. That led me to discover what I think is the main problem but before, I want to mention that in the Interfaces, it was marked as ALL INTERFACES. I changed it to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.