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!

Register Log in
  • 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. atmospherik

    Join not working

    Thanks for the quick answer r937 - that sorted it (can't believe it was a quotes problem.. [blush]) Thanks again, Paul
  2. atmospherik

    Join not working

    I have 5 tables: tblProducts tblSex tblManufacturer tblCondition tblGarment tblSize tblProducts is the main table and it has Access dropdowns so that tblProducts.Sex holds a number that relates to the foreign key tblSex.ID, tblProducts.Manufacturer relates to the foreign key...
  3. atmospherik

    Dreamweaver Library items in Header

    Hi, Have been trying to add library items into a header today and dreamweaver insists on adding extra <html></html> tags in a few places. Using DW MX 2004. Has anyone had a similar problem or has any ideas why? Many thanks in advance Paul
  4. atmospherik

    Unable to change from Intenet Mail Account to Exchange

    hi zbnet, thanks for the reply. Tried this but when opening control panel & mail, it takes me straight into the internet mail settings dialogue where you can add internet mail accounts - still unable to select exchange instead - any ideas?
  5. atmospherik

    Unable to change from Intenet Mail Account to Exchange

    Would be very grateful for any help on this one... Using an NT 4 net on a domain - using exchange mail accounts - when first logon to each terminal and open outlook we go through the outlook add mail account wizard. We are using exchange and not internet mail - if select exchange then there...
  6. atmospherik

    Hardware Firewall

    Thanks Xaqte, Will give it a look.
  7. atmospherik

    Hardware Firewall

    Hi, I'm currently looking into setting up a hardware firewall using an old PC I have and would be grateful for any advice and guidance on what software to use & how diificult it is to do. It's to be used at home to connect my personal PC to the net via ADSL. thanks in advance Paul
  8. atmospherik

    Initiating event problem

    Just solved it.. always the way - having to explain it has made me realise i'm being stupid - all i had to check was the opposite - instead of seeing if stockcode = -1 or if stockcode = "" all I had to do was see if stockcode >0 and put the code to generate the stockcode in the else section...
  9. atmospherik

    Initiating event problem

    I have a form which displays a product image if the 'stockcode.jpg' exists in a particular folder. The stockcode is a 'manually coded' sequential number - this is currently generated (getting the next in the sequence from another table) when the BeforeInsert event fires - therefore only *new*...
  10. atmospherik

    Add new record problem...

    ****Thanks**** PH. That was the problem! I'll remember that in future. Thanks for replying so quickly aswell... you've saved me from a very late night. Paul
  11. atmospherik

    Hard coding the source directory of batch script files

    I would like to put a shortcut to batch script onto the desktop so that with one click, the batch is run. My source and destination directories and always the same and therefore I'd like to 'hard code' the source directory into the script rather than having to navigate to it each time I run the...
  12. atmospherik

    Add new record problem...

    Forgive my ignorance (taught myself Access..) but it's not from a query but was created using the form wizard and grabbing the table fields. I've also just realised that it looks like the original autonumber (ItemID) was keeping the ordering - could it be that now I've changed the primary key...
  13. atmospherik

    Add new record problem...

    If anyone could advise I'd be very grateful - I've just replaced an autonumber field with one that uses a script to increment and keep the field [called ID_ItemAuto in the code below] sequential with no gaps (code is below) and it seems to have sorted out the missing autonumbers problem ok...
  14. atmospherik

    Recordset Sort problems

    Thanks foxbox, that works Don't know what I was doing wrong! Paul.
  15. atmospherik

    Recordset Sort problems

    Sorry, maybe I'm not explaining too well... The manufacturer table has two fields - id number and manufacturer. This is used within another MS Access table to give a drop down list of manufacturers. Unfortunately, Access requires the id number to be autonumber and therefore must be ordered by...
  16. atmospherik

    Recordset Sort problems

    Just retried the SQL and records are still in the order of the database. I have just realised that after making the query I do a recordset filter then remove it (I need to do this to lookup a manufacturer name from the id number). Then I output the records - could this be causing the problem?
  17. atmospherik

    Recordset Sort problems

    Hi FoxBox will try SQL again but didn't seem to be able to get that to work earlier. The table is actually only a list of manufacturers (text) with an ID (autonumber) so that I can use drop down boxes in Access. Paul
  18. atmospherik

    Recordset Sort problems

    I am trying to sort a recordset and i am having problems. I have tried the follwing but output is not sorted... Dim rsManufacturer Set rsManufacturer = Server.CreateObject(&quot;ADODB.Recordset&quot;) rsManufacturer.Open &quot;SELECT * FROM tblManufacturers&quot;, strConn...
  19. atmospherik

    Joining strokes so that it can be Filled

    There must be a simple solution to this problem but I cannot find it anywhere in the helpfile or on the net... I have used the line tool to construct a basic shape and now want to fill it. I have tried Combine-Union as the helpfile seems to suggest and the lines seem to disappear, the Join...
  20. atmospherik

    An object to store some variables?

    Well spotted - I should have seen that since it was my variable originally ;-) - still got an error but realised that was trying to redim to (0,itemArr) instead of (2,itemArr) and now it works! Many thanks, I'd been toiling over this all day! Paul.

Part and Inventory Search

Back
Top