Search results

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

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?

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

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

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

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

I have searched and not found a conclusive answer to this question. I have two tables company(IDCompany unique key) and contact(IDContact unique key and IDCompany secondary key). I Select and enter companys in companyform when I have selected a company I press a button too go contactform, but I...

I have a table of customers and have table of stuff they can buy. Those two tables I use in the next table where their ordes get registred. I have and order form where I have a listbox. When I create a new order I want to have the customersname in a listbox but I want the customersID(primary...

I have an access Query(named newSerial) : SELECT TOP 1 (Productbase.Serialnumber+1) AS Expr1 FROM ProductBase ORDER BY (Productbase.Serialnumber+1) DESC; I want to access this new value. Its not a key since an autonumber may be any number. When I create a new product. How do I get this value...

I have a table with a lot of columns. I have two columns i want to prepair to be used in a tablesheet form. One with sizenumber and another with productnumber. I have a datasheet form where I want to use the data from sizenumber and productnumber writen as one ex. "3-345767" (first number is...

I have a query "Sort String: Drawing.Size & "-" & [Drawnr]" that I want to use in a form. I havent succeded to get it to connect succesfully. If I use ="A" & [Size ] & "-" & [Drawnr] as control source you cant right click and choose descend or ascend. How should I solve this?