Search results

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

Thank you, But what if I have a large table with multiple collums, and want to add specific data in, from many forms? is it okay then to have multiple forms for one table?

Hello, I am new to access and still learning, I have just created my tables and have made relationships. now I want to know, what is better to make my form tables or querys, to enter new data into the tables?:confused: for displaying data I know the query is the right way to go, but...

Thank you both for the reply, I will then try to put them all in one table, because I don't know how to exactly make the relationship work atm.. Attached is the base table that is now in use and which I want to put into access. could you please take a look if possible please? many...

Hello all, I am new to access and don't yet understand the relationships between tables, with that I am having really a had time in making my access program to work. I hope some of you can have pity on an newbie like me and help me.:) because I am getting really frustrated here as I cannot...