Search results

i need change records in table, add and remove or edit records

i need insert values from table tab_material_add to table tab_material in tab_material i have autonumber field i try this code Private Sub Form_Click() DoCmd****nSQL "Insert into tab_material (ROHS) Select ROHS From tab_material_add " Me.Requery End Sub thank you here is sample

i need copy all records(rows table) from previous record (first record) to each next record result - each record will be same

Hello, I need advice with the following code I need to have recorded any new value created in the first recorded sample

Hello need to solve the following problem: I need to insert a table of data to each record Here is a sample: me not to assign the entire table to one record can you help me please thanks

i try code : If Me.[teplota_prac].BackColor = RGB(237, 28, 36) Then Me.[zhodnotenie].Value = "Nok" Else Me.[zhodnotenie].Value = "Ok" End If and cell [zhodnotenie] is still "Ok" here is attachment :

i try this code : If Me.[teplota_prac].BackColor = RGB(237, 28, 36) Then Me.[zhodnotenie].Value = "Ok" End If and not working :(

Hello, necessary, consult the following scripts in cells is by using conditional formatting nastevena condition: 1 if the value is greater than 10 red cell will be 2, where the lower green Need data to other cells when the code will write a condition in a cell "OK" if the condition of two...

OK, thank you, I solved it, but I need to consult again with the following: • what and where I complemented my code that made a screenshot from a particular open program and how convert bmp to jpeg in my vba script I tried: Application = "FireFox" but it was not

Hello, can you help me with this code ? and how do I change the path to save the image under the order number on the form to the path "C: \ images \ "order number".bmp even if someone knew how to convert BMP to JPEG so I will be grateful:) i have this code : Private Declare Function...

yes it works, yet I had to change "," to ";" THANK YOU :)

Hello, can You help me with this code for Con formating? this function is the conditional formating my Pisa error "Syntax items matching is not valid" formula "= Right ([teplota_prac] 3)" Thank you for helping attach the picture

Hello, i need help with thisVBA script These need to insert a macro, which will be checked [temperature Papers] back color, and if so red field box [evaluation] turns red and insert it into the text "NOK" I tried these scripts, but it did not work If Me.[teplota prac].BackColor = RGB(237...

WOrking, thankssssssssssss :)

Hello, I need to consult with the following code: I need to add to an existing record using the Text button on the form in the shape of "the existing record (text) _ my added text by pressing the button" Could someone advise me? Thank you very much