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. Aubs010

    Hosts file to access drive on another computer

    Hi Sympology, thanks for replying. I'm not sure that it would matter as it would just return an empty explorer window. I have just tried it on a new XP install (not on the network), change the hosts file to: 127.0.0.1 localhost random Then explore \\random\ and it gives me a blank window. I...
  2. Aubs010

    Hosts file to access drive on another computer

    Basically: I am developing a back-end/front-end database. The back-end will reside on a file server. The front-end will connect to the back-end (linked tables) using UNC paths, i.e. \\servername\folder\ etc. Because I am testing things at the moment and don't have access to the actual file...
  3. Aubs010

    Circular Relationships

    Thanks PHV, I found 'At Your Survey' from the thread I posted earlier. Aubs
  4. Aubs010

    Circular Relationships

    I would like to apologise. Using the search didn't bring up much to help, but third in the most recent list, I have found this thread700-1582551 which may help me. If I need more help, I will come calling. Thanks and sorry if you have already read it. Aubs
  5. Aubs010

    Circular Relationships

    Hi all, I am trying to develop a questionnaire database which seems a bit troublesome. A screen-shot of the relationships is attached/linked which may make things easier to see A project has a number of sites. A project has a number of questions There are a number of projects. Each question...
  6. Aubs010

    Backup bkf file contain empty folders (incremental-Not enough entries)

    Hi all, I have a bkf file that is currently 4.2GB. I have used to carry out a normal backup and then incremental. on a daily basis for months! Thus, I would have expected to find a copy of everything and daily updates since started. When I open the file in "Backup or Restore Wizard", I see...
  7. Aubs010

    Wireless Router/AP with 2003 Server

    Sorry for not replying sooner. Yes, it was to log all internet traffic. I have temporarily altered the layout now so to avoid the loop as above, and used Routing and Remote Access which worked pretty simply. INTERNET | Wired ADSL Router 192.168.2.1 | | | 192.168.2.2 [WAN side]...
  8. Aubs010

    Wireless Router/AP with 2003 Server

    Fair point, think I'll just leave it as it is! Thanks for your input all the same :) Aubs
  9. Aubs010

    Wireless Router/AP with 2003 Server

    Thanks for your reply M. Knorr, I obviously presumed wrongly that it was going to be a simple thing! I assumed if I enable ICS one of the NIC's on the server, the other NIC would pass all traffic through the first NIC, because enabling it on one, automatically sets the other's IP to...
  10. Aubs010

    Wireless Router/AP with 2003 Server

    As a testing environment ... I left DHCP on the Wireless router (so all clients get their correct IP 192.168.1.x but changed one client's IP to 192.168.2.123 but it doesn't connect THROUGH the server. I keep getting 'page cannot be displayed' etc. Suggestions please people. Aubs Aubs
  11. Aubs010

    Wireless Router/AP with 2003 Server

    Hi all, This should (in theory) be a pretty simple system to set up, but I can't for the life of me get it working. Current situation: INTERNET | Wireless ADSL router 192.168.1.1 [DHCP server] | |-Clients 192.168.1.2 (example) | |-2003 Server 192.168.1.3 (example)...
  12. Aubs010

    Macro opens query that isn't in the list

    Thanks pwise, that's excactly where it was ;) Aubs
  13. Aubs010

    Macro opens query that isn't in the list

    Hi Lameid, I had thought of that one already but good suggestion... Amusingly it does not! First: "You are about to run a delete query..." Second: "You are about to delete 0 rows." Third: "You are about to run an update query..." Fourth: "You are about to update 0 rows." So the queries must...
  14. Aubs010

    Macro opens query that isn't in the list

    I have a legacy database that I need to modify. The OnClick event of one of the buttons calls the macro "resetstat". Within this macro are the following: SetWarnings WarningsOn = No OpenQuery QueryName = deletestat3 View = Datasheet DataMode = Edit OpenQuery QueryName = up_2_to_1 View =...
  15. Aubs010

    Populate continuous form with temporary data from table

    PHV - Sorry for the late reply, for some reason I've not been getting email notifications even though it shows 'Turn off E-mail Notification.' (implying it is already on!). No, users do not have their own local front end. What I have done now, is create one table that stores all users search...
  16. Aubs010

    Populate continuous form with temporary data from table

    Great idea, pwise, many thanks for that :) Aubs
  17. Aubs010

    Populate continuous form with temporary data from table

    Sorry if the subject is a bit misleading, but it *is* what I'm striving for! I have a table and all the records within are accessible to all users. On a form I have a couple of search criteria that can be set which then Runs a query to gather all the records that match. I then stupidly...
  18. Aubs010

    Handling PDF files with VBA

    Thanks sxschech, but I'm doing it as a persona thing so don't want to pay! I have however found this which may help, if not do it. I've not tried it yet, but will be soon...
  19. Aubs010

    Handling PDF files with VBA

    Hi LuAlPa, Thanks for your reply. At work, I have a copy of Acrobat Professional 7 (there may be a trial version available) which has the functionality of SAVE AS, and with the pdf's I have, when I use this and change the Save as type to "Text (Plain).txt" it puts double spaces between cells...
  20. Aubs010

    VB to Compare two tables, update some records, add/delete others

    Brilliant Randy, you've answered it exactly as I was hoping. Thought it must have been an easier way! Incidently, I have now split the sections up into different tables (ADD, REMOVE, MODIFY) so the records can be checked if need be then a single button press to call each query in turn. Thanks...

Part and Inventory Search

Back
Top