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

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

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

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

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

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