Search results for query: *

@ZmrAbdulla thx for fast reply

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

any kind of idea would be helpfull 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)...

that is when you link two subforms together with "link master field and link child field" anyone?

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 thx for your reply! DCount was also not good, but i have manage to fix the problem with: Dim rst As Object Set rst = Me.RecordsetClone On Error Resume Next rst.MoveLast On Error GoTo 0 Me.Text106.Value = rst.RecordCount but i have still a problem with the SUM in a footers textbox...

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 kermit01de , i had done it with form after all, i just wanted to know if it can be done also with Parameters/MsgBox. Anyway, thanks for your response. Best,

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 TheAceMan1, thank you for your response. The thing is: right now i have 3 subforms one on top of the other and i am showing them accordingly! The problem comes out when i wanna to have another subform(2) on this sub form and show the record based on the selected record in subform(1) I took...

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

TheAceMan1 thank you for this FAQ It is working fine! Best to both of you.

Remou, i have been checking out several examples befor i made this post, and even NorthWind.mdb. And you are right, it should look like Customer Orders form, but with this difference that in second subform i don't wanna show first subform's children but same record as in first one just with...

Hi Remou, thx for quick response! You are right, i wasn't clear before. In first subform i am puling data from same table (record source) as in subform 2. Both subforms are linked(child and master field) by (autonuber) field "IdPrevoza" The difference is just - in first subform i am showing...

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

the problem is solved! i have used "Dlast" function case Euro me.unboundtextbox1 = input x (DLast("[Euro]","[Settings]")) at the end - so simple, but i've could not done it so fast without your pointers or hints! thank you again Best,

Hi Ian, thank you for such fast response. your suggestion is very helpfull and it is the right pointer, but still i have a question to ask. I have one form "Settings" were user can input the last currency rate (for Euro,Sit...) These calculation are being made on another form. What i would...

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