Recent content by JZII

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

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

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

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

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

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

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

Anybody? Please help me! JZII

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

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

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

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

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

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

Up... JZII