Recent content by AljayB

Hello there, I would like to create a btn or something and use VBA code that can copy fields from table 1 to populate multiple fields in table 2 that use the same ID field. (see attachments). For instance table 1 contains a "charge", which has a one to many relationship with table 2. so...

I have assigned the text box to format fixed and the text box is also assigned to a control source in my table. The vba code still shows red when I try to dim as decimal, also when I try to type a number like 0.3321 in my text box it doesn't get stored it only shows 0.0000 what did I miss?

Hello, Can some one please help me, I want to perform a calculation. I have attached the file. It works fine with whole numbers, however I want to be able to add decimal places to my numbers and I have tried to dim as Decimal, but it wont let me, what did I do wrong? for my...

hello, I am just wondering if there is a way that one can create such a link between a subform and a main form, that if you select a field in the subform it would display the corresponding data to the main form? I belive that could be done with the on enter or on exit event, however I am...

please add me on google aljaz.but22@gmail.com

still shows the same error even when I removed the line. b = Me.txtChargeDatum is a date in my table.

still shows the error even if I rewrite it

I am sorry for all the questions, but thank you for your help.... I am completely new to vba hope u understand... now the message shows me run time error 13, type mismatch...:banghead: attached the file.

Private Sub btnCharge_Click() Dim a As Integer Dim b As Integer Dim c As Integer Dim d As Integer Dim e As Integer Dim resoult As Integer a = Me.cmbProduktgruppeID b = Me.txtChargeDatum c = Me.cmbLinie d = Me.cmbAbfulung e = Me.cmbExtruder resoult = (a + "/") & Format(b, "ddmmyy\/") & (c +...

thank you, One more question, how can I then formate the date in VBA to be displayed as a number value in the combined box calculation that you have posted? like 01/02/15 , by 01 being the day, 02, being the month and 15 being the year. field 2 being formatted from 2/1/2015 to 020115...

what if I would like to make a button on a form in VBA that when clicked would generate the same combination in a text box field, which data will then be stored in my table. could you guys please help me with the code? The format that I would like to display in the combined text box is...

Hello there, I am trying to make a calculation form. in there I have 7 text boxes in which the user can type down a number which then gets calculated. this now looks like this: Dim a As Double Dim b As Double Dim c As Double Dim d As Double Dim e As Double Dim f As Double Dim g As...

Thank you all !!!!!!

Hello, Thank you for the reply, where do I insert that now in so that I can create the desired format? Sorry I am a total newbie

Hello all, I am seeking help with a format for a calculated field which can be seen in the attachments I use the calculation [field1] & [field2] & [field3] & [field4] & [field5] field 1 is a number, field 2 is a date, field 3,4 and 5 are numbers. The calculated field displays the...