Recent content by electro

No they are not.

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

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

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?

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

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

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

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?

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.

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

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.

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

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

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

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