Search results

Yes but design allow to link more than one field, so, i can link the primary to foreign key and the field2 to fld2. However, IF i change the field2 the records on subform will disappear because of link. Anyway, i create an update query, my question is if there is any other method

Because i may still have to change the value in few records.

Hi In the example, one simple form-subform one to many I would like, once i update the combobox on form, to auto fill the field fld2 in subform. I can link parent to child but i don't want this method because i may need to change the combo to another value and then all records on subform will...

Γεια σου φίλε Γιάννη, άμα δε παίζει το Ωμέγα, βάλε Ομικρον

Hi arnelpg , many many thanks,one more time,for your help. The code worked just fine for those columns that we need to format the currency. Now, there are few more columns that need formula, this formula is a bit complicated and it is a different one if the currency is Eur or USD. Based on...

Many many thanks arnelgp I will try this code at home later today and i am sure it will work. From a simple glance, it looks just what it needs to mae my report fast perfect and good looking.

Hi CJ London On the post #5, i have outlined two pieces of code. The first one, populates the excel (but doesn't format the column C). In this excel, the column C is just number. In column D it displays S or E. My goal is to format column C based on value on column D. I am trying to add a piece...

Why confusing ? In the picture, there is a form and a button, once i click the button i get this excel, behind the button (SorE) is the code i have outlined on post #5 . Now , i want in column C to get mixed currency format. c2 and c3 as currency Eur format while , c4, c5, c6 as currency usd...

Hi, do you mean i should use a syntax like this one ? If ("D" & i).Value = "E" Then ...

Hi, the extra lines i have added If ("D" & i) = "E" Then ... doesn't change the result, no error message nothing, but excel layout is not affected, with or without these extra lines, the excel looks the same.

Hi, with the below code, i can extract date from access to excel There is a table with a field "freight" as number double and a field curre with two possible values, E or S , e stands for eur , s for dollars. Te objective is to format the freight to USD or EUR based on the value on curre...

Many thanks Now it works, no error I will open a new thread to ask the second question about how can someone format the field "freight" to USD or Eur, based on the field curre. Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim SQL...

Yes, the code create the xlBook and xlSheet, however cursor stops/freezes at A2 cell , as if it cannot run the Do While Not rsBS.EOF ....loop part of the line

Hi I get this error when i try to play with this code Error number :91 = Object variable or With variable not set The purpose, one very simple table consisted of four fields, i just want to get these fields exported in an excel sheet. Private Sub Btn1_Click() On Error GoTo SubError...

I have used also this one but doesn't work IF .Range("AF" & i).Value = "E" then

Hi In one excel report that I extract from access database, I have two columns which outline mixed currencies, usd or eur. Before, in the old report, the format was just currency “none” and I had used the below line, it worked just fine. .Range("M4", "N" & i).NumberFormat =...

Private Sub Form_AfterUpdate() Replace(Control.Text2,Chr(9)," ") End Sub Hi, i type this but it is red

Hi, In one form, I have a long text field, named text2. I copy and paste in the field text2 details in bulk, then very easily i update other fields in the same form. The problem is that the data source contains "tabs", CHR(9) I need to make one "before update event" which will kill all the...

Thank you very much, got it, i will try it home later this evening.

Yes, these areas are stored in a third table, then, the combo box retrieve exclusively data from this table only.