Search results

Take data source from first form and aplly it to subform. Then requery a subform. It should work. Or create a table and insert values from form to table. Then put this table as a data source to subform and requery it. This should work too. Welcome to forum.

Try setting PopUp property on other forms to true. But otherwise search web i remember that i saw some code which sync forms size with monitor resolution (peters software or somthing like this).

Hi, You have 2 possibilites: 1. put table1 as record source on form. Then right click on border between main form and child form. On properties go to data tab and chose link child field or link master fields. New form will open. On this form deternime the link (i assume its No?). Click ok...

Hi everyone, I have this situation. Main form 1 subform - child to mainform (fields are NOT connected with ID) 2 subform - child to 1 subform (fields are connected with ID) Main form is used for searchig 1 first subform shows item records 2 subform shows some data connected to items Search...

Thanks for reply I got the idea how to do it, lets hope it works

another try I tried this code and now I'm getting error no variable defined in the first MSComm1 line. I use option explicit. If i deleted then it says no object found on the same line. Dim Instring As String MSComm1.CommPort = 2 MSComm1.Settings = "9600,N,8,1" MSComm1.InputLen = 0...

Hi, I'm using this code sending data on customer display over com port: Open "Com2:" For Output As #1 Print #1, "Test" Close #1 The problem is that display is showing some strange characters. Something like: CCCCCCCC... Any ideas how to fix that? thanx in advance

Thanks, pbaldy i found your answer on a similar problem in some other thread. In WHERE clause i should include brackets '" & Me!ControlName & "'. Now the code works excellent. Thanks again.

Yes i have a problem with recordset. I can open (recordset) a table or a query or a SQL string but without WHERE clause. If i put where clause in recordset then i get error message Too few parameters. Excpeted 1. I guess its something wrong with sql then?

Thanks for reply, but link wasn't much of a help. I forgot to say that i don't use Autonumber field but a text field for increasing number. And i calculate sequential number in VBA and put it into table and then requery the subform. I want to know how to make loop (or any other code) to update...

Hi everyone I have a form and a subform both linked to the table. Subform has increment line number. 1 - first record 2 - second record 3 third record,... The question is how to reset increment line numbers in subform if i delete second record? Soo the result would be: 1 - first record 2 -...

Problem solved. Solution is Filter Thanks Sam

Problem is that, when subform gets focus the error displays

Form and subform are linked (Parent/Child with ID fields) and that works fine. I would like to open a form on a specific record from table. When the form is opened this record is shown on a form and subform, because of one to many relationship (like filtering records). Now is it possible to...

Hi, I have main form with subform. Is it possible to open form on specific record, like main form ID = 2, and then add records to subform? I keep getting error (Changes were not succesful... error 3022). For example: I would like to open form Invoce and I want it to open on Invoce number "2"...

Thanks that solves the problem.

Hi, this is not really a problem but anyway. I' m getting data into excel (pivot table) from access db. Pivot table is set to refresh data from access every time at startup, but at the startup I get this form in which I must confirm data refresh. Is it possible that this form is somehow shut...

Solution If anyone have the same problem here is solution Add watch to Keyascii and see what number is displayed as value. Then set that number to other number which shows the same letter just upper case. Or any other number if you wish to transform this letter to any other. Example: Private...

I' m not using input mask. This code worked just fine in access 2000 version. Anyway I debuged it and found out that Keyascii produce <Out of context> value. I don't know why but this is the problem. Thanks for reply If anyone gets any idea, please reply

Hi, I'm using code which convertes names of costumer into upper case when user type the name into control. But there is a problem. If letters č,š,ž are pressed they are not converted to upper case. Code: Private Sub Customer_KeyPress(KeyAscii As Integer) On Error Resume Next KeyAscii =...