Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VeeFour

    SQL Administration

    Is it possible to add/remove users and change passwords on SQL2000 using vbscript?
  2. VeeFour

    Form property changes

    Thanks alot fellas, your help is greatly appreciated
  3. VeeFour

    Form property changes

    I am trying to set a new background for a form using code: Forms![frmsite].Picture = "C:\example.jpg" My first problem is when I exit the database and reload it, it reverts back to the original default, how can I make the change permanent? Secondly, the code only works when a form is open...
  4. VeeFour

    SOHO 6 as internal firewall?

    Can the SOHO 6 be configured as an internal device only and police 2 internal networks? I have a server on one network 193.36.40.10 and a server on a different network 193.36.21.25. I want to connect both networks together through a SOHO 6 and use the firewall rules to allow port access from...
  5. VeeFour

    Port forwarding and domain controllers

    Due to our current setup it will not be that easy. At present we have: ADSL1--->Router--->Switch------| | ADSL2--->Router--->Switch--->Server--->Clients | ADSL3--->Router--->Switch------| This system...
  6. VeeFour

    Port forwarding and domain controllers

    Until recently I had a client machine linked to an adsl router. The router (Dlink 504T) was set to forward port 2048 to the client and everything worked. Now the client is linked to a Win2003 SBS which is connected to the internet through the router. How do I forward port 2048 from the router...
  7. VeeFour

    Setup advice

    In my internet domain I have a catchall@mydomain.com email account which I would like to forward to my exchange server. The account options has a Forwarding option which I put my routers IP address. I then forward the relevant ports to my exchange server. I can send and receive email internally...
  8. VeeFour

    Domain naming

    Basically the server will run an SQL or Jet backend, Exchange and central virus protection. It will be connected to 3 small networks of 5 to 10 client machines per network all with an Access front end. It has 3 ADSL connections, 1 for each network connected to a 4 port gigabyte network switch...
  9. VeeFour

    Domain naming

    I am setting up a server that is going to run a multi-user database and will be sending and receiving alot of emails via exchange5.5. I have an internet domain registered for the emails so do I name the domain mydomain.co.uk, or mydomain.local as suggested by the windows installer for security...
  10. VeeFour

    Domain naming and emails

    Cheers Paul, much appreciated.
  11. VeeFour

    Domain naming and emails

    My domain is currently pdc-xyz.local as suggested by the Win2003 installer for security purposes. When I send an email it displays the sender as "bill.smith.local" on the recipients email How do I get it to display "bill.smith.co.uk"? Do I re-name the domain controller to pdc-xyz.co.uk or can...
  12. VeeFour

    Office XP Mail Merge Problems.

    Is there nobody who can help with this irritating problem?
  13. VeeFour

    Office XP Mail Merge Problems.

    I currently use a Make Table Query to pass data from 2 different tables linked by Client ID number. After running the query then the mail merge the document does appear with the following message: The data source of the document you selected is different from the source you selected when...
  14. VeeFour

    Continuous Form View

    Tried that method but it does not allow me to edit the text box because it is bound to the expression and I also need to Show / Hide labels and Fields dependant on each record.
  15. VeeFour

    Continuous Form View

    Is it possible to change the contents of continuous form using a field value on a particular record without it altering the whole list of forms? I currently show records in continuous forms like this: Name Policy(LTA) Sum Term ----------------------------------------- Name...
  16. VeeFour

    Removing #Error from report

    Can you elaborate on this function and how to implement it please.
  17. VeeFour

    Removing #Error from report

    I have a series of calculated fields on my report which show #Error when there is no value generated by a query. I want to change the field value to 0 if the query/sub-report returns the #Error. Many thx in advance.
  18. VeeFour

    Passing data from a sub-report to a report

    I have 2 sub-reports each with a running total and a main report which hosts them both. My problem arises when I try to show the running totals from the sub-report on the main report which looks something like this: 1st total 10 this should display 45 in the main report Page Header 2nd total...
  19. VeeFour

    Report printing help

    Many thanks, excelent reply.
  20. VeeFour

    Report printing help

    I have searched these forums and cannot find how to remove blanks when printing a report. This is for a standart name and address on a report for 2 recipients ie. Mr J Smith and Miss B Jones 1st address line 2nd address line 3rd address line postcode 1. How do I remove the extra spaces from...

Part and Inventory Search

Back
Top