Stel uw vraag

matthewcb4's profiel - activiteit

2018-08-23 20:34:09 +0200 reageerde op een vraag How to do math inside of form?

Hello Ratslinger, would you be able to help with 1 more issue I have. Everything works great but it would be awesome if

2018-08-23 20:33:13 +0200 reageerde op een vraag How to do math inside of form?

Hello Ratslinger, would you be able to help with 1 more issue I have. Everything works great but it would be awesome if

2018-08-23 20:31:48 +0200 reageerde op een vraag How to do math inside of form?

Hello Ratslinger, would you be able to help with 1 more issue I am having. Everything works great but it would be awesom

2018-08-23 20:30:50 +0200 reageerde op een vraag How to do math inside of form?

Hello Ratslinger, would you be able to help with 1 more issue I am having. Everything works great but it would be awesom

2018-08-23 20:26:42 +0200 badge ontvangen  Beroemde vraag (bron)
2018-08-23 20:13:59 +0200 badge ontvangen  enthousiast
2018-08-14 21:51:20 +0200 reageerde op een antwoord How to do math inside of form?

Hello again and thank you so much for all of your work on this. That worked perfectly. I am sorry for the confusing form

2018-08-14 21:48:36 +0200 koos een beste antwoord How to do math inside of form?

Hello All, I have been creating an inventory database for a small company that I started working at. This is a seed company and we store our product in steel boxes. As these boxes with product go through the plant they can gain and lose weight depending on the process. I have a database created with 4 tables. 1 with the product numbers and descriptions. 1 with locations in the plant where they can be stored. 1 with the boxes and the last one that stores all of the weight and location adjustments to each box based on the product number and box number. All of the relations are set up and working great.

The issue: I created a form that I use when the product completes from a process and it works well enough. The problem is that when I am updating the weights of the boxes I have to figure out the math myself from the start weight of the box to the output weight.

Ex: 3100 lbs to start 2900 lbs after/ for this example I would have to figure out the difference and enter -200 in the field.

I have been trying for days to figure out how to make this entry be something like this example: 3100 lbs to start 2900 lbs after/ enter 2900 and then it will populate the adj table with the -200.

Thank you for any and all help! (also, I am not very well versed in macros so my thought was just to populate a variable that is then passed to the table but have no clue how to accomplish this.)

EDIT: Hello and thank you. I have attempted to attach my file. The structure for the file is this:

image description

My form "MISC INV UPDATE" is updating the ADJ file with the data in the populated fields. The issue is that I am having to do the math to get the difference.

image description

(From previous example) What I am shooting for is instead of having to enter "-200" in the weight column I would like to be able to enter "2900" and have a script or something run that does the math and enter's "-200" in the ADJ table for me.

Does that make any more sense?

C:\fakepath\BOX INV.odb

2018-08-14 21:48:35 +0200 badge ontvangen  Leerling (bron)
2018-08-11 11:48:57 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-08-11 00:29:22 +0200 bewerkte een vraag How to do math inside of form?

How to do math inside of form? Hello All, I have been creating an inventory database for a small company that I started

2018-08-11 00:05:15 +0200 reageerde op een antwoord How to do math inside of form?

Hello and thanks again. The "BOX" table only has the box numbers and the light weight/tare weight. I want to retain a tr

2018-08-10 23:22:50 +0200 badge ontvangen  Populaire Vraag (bron)
2018-08-10 20:54:43 +0200 beantwoorde een vraag How to do math inside of form?

Hello and thank you. I have attempted to attach my file. The structure for the file is this: My form "MISC INV UPDATE

2018-08-10 20:21:52 +0200 reageerde op een vraag How to do math inside of form?

Got-it, sorry didn't know what that meant.

2018-08-10 19:58:46 +0200 stelde een vraag How to do math inside of form?

How to do math inside of form? Hello All, I have been creating an inventory database for a small company that I started