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: *

  • Users: JZII
  • Order by date
  1. JZII

    Syntax Error in INTO STATEMENT.....?????

    compilation error: syntax error - I think you know what I´m trying to acomplish here... Is there an other way.... I have been stuck with this bit of code for months now... JZII
  2. JZII

    Syntax Error in INTO STATEMENT.....?????

    Sorry.... it still doesn't work... same error mess. JZII
  3. JZII

    Syntax Error in INTO STATEMENT.....?????

    Where is the problem..... It´s in swedish..... ------------------------------- Private Sub cmdCopyPost_Click() DoCmd.RunSQL ("INSERT INTO Leverantörer-Entreprenörer ([Kategori]" _ & ", [Företag], [Adress], [Postnr/Postort], [Kontaktperson], [Telefon], [Mobil], [Fax]...
  4. JZII

    Syntax Error in INTO STATEMENT.....?????

    Where is the problem..... It´s in swedish..... ------------------------------- Private Sub cmdCopyPost_Click() DoCmd.RunSQL ("INSERT INTO Leverantörer-Entreprenörer ([Kategori]" _ & ", [Företag], [Adress], [Postnr/Postort], [Kontaktperson], [Telefon], [Mobil], [Fax]...
  5. JZII

    Date field question...

    Nice...I´t works... Thanks!!! JZII
  6. JZII

    Date field question...

    OK... I know what you mean, but I don´t know some bits... I have the calcontrol invinsible in the form, so now I need the code to make the calcontrol appear on event dbclick. And how do I make the date appear in the datefield when I click on the calendar? Thanks... JZII
  7. JZII

    Date field question...

    In my form I have a datefield where user write any date they want. for now the do it manualy. My question is... Can I get the same function thats availible in outlooks calendar... when creating a new appointment, by clicking the dropdown menu, a small calendar appears where you can choose date...
  8. JZII

    Form / Subform Link?

    Anybody? Please help me! JZII
  9. JZII

    Duplicate post?

    Can´t anybody help me? Please I need this... Is there an other option? JZII
  10. JZII

    Duplicate post?

    Still doesn´t work... i get "syntax error in INSTERT INTO statement" ??? JZII
  11. JZII

    Form / Subform Link?

    So far OK... When I click on a post in the baseform the subform changes as I want... But I want to click on a post in the Subfrom to change the post in the baseform... I cant do that in the Linkmaster/child properties field.. The only thing availible is how to control the subform via the...
  12. JZII

    Duplicate post?

    OK... This Is what i´ve done...but it doesn´t seem to work.. What is wrong...As you can see I have more posts than I told you before... On my button the onclick prefs are... Private Sub cmdCopyPost_Click() DoCmd.RunSQL ("INSERT INTO tblPosts ([Kategory]" _ & ", [Company]...
  13. JZII

    Duplicate post?

    Hi... I want to duplicate a post with x fields containing "Company name" "adress" "contact" "cell" "fax" and so on... I want to duplicate that post but not the "cell" post, that I want to be empty...how do I do that? thanks! JZII
  14. JZII

    Form / Subform Link?

    Hi... In my database I have a form with misc. company information. (like a big adressbook)I use next/previous post buttons to browse the different posts. (that shows one by one) All of the companys are listed under various categories. When I click on a category the subform shows all companys in...
  15. JZII

    Duplicate post, but not all fields?

    Hi!... How can I make this?... I want to duplicate one post with example "Name, adress, phone, fax, etc... but I dont want all off the info duplicated... Lets say that I want the name and the adress duplicated, but I want the phone and fax fields to be blank. so I can add more users in a...
  16. JZII

    Reports category...?

    Hi... Thanks for the solution... It worked... But! When I select the category it prints it direct. I would like to preview it before printing... How do I do that? Thanks JZII
  17. JZII

    Reports category...?

    My database has aprox. 3000 fields that contains customer information. These are arranged in categories... Lets say that I want to print all fields in 1 category. But the users of this database are quite "stupid" so they cant type the category name in the query box... How can I make a...
  18. JZII

    What should I use???

    Hi... I have a Win2k server running, and I want to make it a backupserver... The tricky bit (for me) is that I want to backup other servers (WAN) NT4 and Novell aprox. 15 machines. What program suite should I use (max $800)... I have looked at Veritas Net backup...works fine but NOT for...
  19. JZII

    NT4 SERVER Backup ???

    Hi... I would like to know if there is any way to backup a NT4 server with NetBackup by using the client... I have NetBackup Proffesional running on Win2k server and I backup 16 2k and XP machines... Now I want to backup 2 NT4 servers...is it possible to use the client...is there any other...

Part and Inventory Search

Back
Top