Recent content by electro

  1. E

    Open another form with forms data

    No they are not.
  2. E

    Open another form with forms data

    I have two tables with following structure(and a relationship is made): Company table: IDCompany strCName strWebb StrComment Contact table: IDContact IDCompany strName strTele strEmail strComment They both have a form (frmCompany and frmContact) but the frmCompany is the main form. When you...
  3. E

    Open internet explorer window from VBA..

    That doesnt work.. already tried that. " This object doesnt support this method"
  4. E

    Open internet explorer window from VBA..

    I have tried many times to open a webpage in internet explorer with some code but nothing ever happens. The code seems to be correct so there should not be any problems. Shell "c:\program files\internet explorer\iexplore.exe " & Me.Websida, vbMaximizedFocus Where do I think wrong?
  5. E

    How do I get the newly created key?

    Dont know why but replacing DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 with DoCmd.RunCommand acCmdSaveRecord solved it. Whats the difference between the two? Thanks for your help
  6. E

    How do I get the newly created key?

    I have tables which I add a new post to. But I want to find its key. DoCmd.GoToRecord , , acNewRec 'Lot of data fills out the different textboxes DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.Requery When I first save the data and the requery the you...
  7. E

    Hide "Do you want to append x rows" statement

    Thanks MStef Thanks for your answer but the problem is that I have not sucessfully transferedd it to an query.. it acctually two statements run after each other... ' This is the code for copying a record and its secondare table posts iTmp = IDOrders ' get current Orders IDOrder to copy...
  8. E

    Hide "Do you want to append x rows" statement

    I have made an own copy button that make a copy of current order to a new order and also copys all it data. I am using INSERT INTO but I get "Do you want to append " box all the time. Is there someway to allways make answer yes or block it out so it doesnt show up?
  9. E

    Copy table post and secondary table

    I dont know why but I have rewritten parts of the SQL statement but when I rewrote the entire line it worked. Possible a hidden char.
  10. E

    Copy table post and secondary table

    I have a problem... I have four tables(but my problem is limited to just two) The tables are Orders, Customers, Items and OrderedItems The two more detailed below creates the problem when trying to copy an already existing order to a new since the customers usally order the samethings over and...
  11. E

    Accessing parent combo box value

    Hey thanxs Found the answer already on the net :) The trick was to use the first combobox on change event and change the second combox controlsource with the choosen data.
  12. E

    Accessing parent combo box value

    I have some irritating problem, I have a form with a subform. Both have two comboboxes but I want the main combobox value(in my subform) to use it to filter the second combobox value. But it seems not possible. Either I get the item or the itemname of the combobox but I want the value that the...
  13. E

    Query in subform - You cancelled the previous operation

    Solved it..was that I had an onchange event that was connected to an old description of a table with columns that didnt exist anymore so when I cleaned up the code it dissaperad. No problem...
  14. E

    Query in subform - You cancelled the previous operation

    I have subform where access lists orderitems(the main form contains the order info). The subform uses a query to lookup items thats in the orderlist. Everything works fine execpt when I change something in a dropdowncombo list in the orderlist sheet(like in sample northwind db) the I get "You...
  15. E

    How do I connect two forms...

    Nope... The problem is still... Want to enter a new contact when opening the contact form but then I need to have a query to fill the form but I still need to make the selection in the query from the last form... still think I missed something. I did this in VB or VC++ I would have no problem at...
Back
Top Bottom