Search results for query: *

hi just shoort question...how to do this textbox name = code dim Vcode = code but if i do it like this i get the value from textbox, insted i need name and name must be without "" Vcode should read code not "code" i hope i am clear? thx

hi, i would like to make a search form in access, so i could look up in a sql express ... if data's id is equal with id in access then copy the data from sql into an empty fields in access? can this be done and how? thank you

Hi, i am wondering if it is possible and if it is then how.. in autocad 2006(but i think in any other ..word, excel)which has the VBA inside, would like to with a click on a button to get a form previusly made in access without runing the access and then print a report , (also made in access)...

hi on a main form i have two subforms.I have tried to link them with link master and link child. It works fine if in first subform is listbox and in second subform datagrid.But when i try to link two subforms with listbox in both it does not filter the records..always shows all records so...

Hi to all, i know that this query might look long but i know where the problem is - i just don't know how to solve it! This is the query for a subform. In a form footer i would like to count all records based on this given query. In a text box control source i am useing...

Hi all, i have a query for a report as fallows: (for start date and end date i need to have separate fields) SELECT Prevoz.Destinacija,Prevoz.[Datum Odhoda], Prevoz.DatumPrihoda, Prevoz.[Dodatek Vozniku], Prevoz.Opombe, [date - from] AS Expr1, [date - to] AS Expr2 FROM Prevoz WHERE ((([date -...

Hi all, have a form with 2 unbound combo's and a subform. First combo has RowSourceType= ValueList and RowSource = "Plate";"Driver";"Company"; Second combo and i fill RowSource with VBA: If Me.cboCombo1 = "Plate" Then Sql = "SELECT [Vozilo].[IdVozilo], [Vozilo].[Plate] FROM Vozilo;"...

Hi all, i am fighting with this rooky problem for some time now. I have a form, and on this form 2 subforms. In first subform i show sums (calculated on fly - datasheet mode), second subform is in "tab control box (form view)" to view details for selected record. Yes, when in first subform a...

Dear all, my friend owns a few lorrys and i would like to help him with an expenses paid histroy! Expanses he has for one lorry on one drive for example are road taxes, gas bills etc.(for different states) This means that i have to cover at least 4 different currency. I have 12 entering...

hi to all, this problem drives me crazy. i have in a subform(Datasheet) footer, textbox "Totale" and in it's controlsource: =Sum([Stop Km]-[Start Km]) then on a form i have new textbox "Text81"(unbound) and also combobox which has in it's After_update Event: If...

Hi, i have field (type-yes/no)ammong others in a listbox i would like when specific row is selected, change this one record form default No to Yes when clicked on a button! i have tryed several different ways On_Click event but with no success thank's for your help Stan

hello to all.. i have a form1 with a listbox1 then there is form2 with listbox2 what i would like is - when i will select item in first listbox and click button ok, on the next form (form2) i will have an item (same as on listbox1) already selected thank's

i have a listbox where is one column! then i have button which has a status diabled now with the code below i wanna to enable button if there is any data - it remains disabled if there is no data but it is not working -- i have status in any case enabled or enabled- Why? Private Sub...

i have a listbox1 filled from table1 have another listbox2 filled from table2 they are on different forms on the form with the listbox2- there are 3 buttons (in list1, not in list1, show all) now, 1 and 3 button works fine but with the 2 i have a problem it returns some of the items which are...

when the combobox is pulled down you should see those values The values are not comming from no table - so how do i fill this in ?

i have 3 tables (all 3 have identical fields but different data). in a form i have textbox in which i retrieve data from table 1 and a listbox - data from table 2 based on textbox. then i am adding(copying) data from table 2 to table 3- but i get mixed data in listbox now i would like to...

hi, i have a list box in which i have data from table A , i am adding this data to table B (two tables are not in the relationship) - i would like to mark (with red) all data which are already in the table B when the form starts code so far: If IsNull(DLookup("[Stock Code]", "[BOM L1]"...

i have a tab control(box)- in first tab i have a list box (geting data from table 1) in second tab i have a subform (datasheet view) (geting data from table 2) now, i would like select the row in datasheet and with a click on the button - move to a listbox (from table 2 to table 1) any idea?

Hello, i have a listbox with boundcolumn 1 (field:StockCode) then i have a textbox in which i would like to show (when you select an item in a listbox) value from column 2 (field:Discription)! How can i do that? Couse i can always diplay in a text box the bouncolumn -StockCode!! thanks for help

Hello, i wuold like to filter subform by a character in specific field - in field [Item Type] have values "S","C" or empty my code so far: Me.[Equip-Stock Code from Work Orders subform1].Form.Filter = "[Item Type] = S" Me.[Equip-Stock Code from Work Orders subform1].Form.FilterOn = True But...