Search results

report scheme Attached is the report scheme of what I get and what I need to get. I think I have to use VBA and onformat events to get this done. any ideas?

Hello Everyone, I have a weird sittuation that I need to solve. I have a report which has a subreport, and those 2 show the following info: (see attachments) The report shows records of every export that took place for a preselected product. It shows the original imported value - for example...

Hello everyone, I'm working on a project that would register workers as they come to work and go home when they are done. The output would be a simple report showing how many hours (total) has a worker spent inside the company. I made their ID cards with unique bar codes, and made a main table...

Yes, a product we produce has at least 20x3 fields to describe it. It's a large assembly, and goes by this: 1. component name/code 2. number of component (above) 2. component2 name/code... and goes on for like 20-30 components. The DB I'm making is "production warrant" when we get a purchase...

Since my form has more than 100 fields, when a user fills in all of them for each product (the first time they create a product), I want to make it easier for them - for the next time. I want to be able to let them type in a unique product code, which would be used to find a record with that...

I'v tried using your tip to get the time between two fields, but it doesnt work - "between" is not recognized etc.. Can someone please give me an example of doing this? Thanks..

MMkay Okay guys, I'v changed a few things, now I have 2 tables, 1 table containing job descriptions etc, and the other - machine status info - for my "nice lookin' machine shop floor layout" with all the green/red lights etc :) Now, I have also only 2 forms. I may add 3rd for stats buttons...

Yes, it's the shop floor layout. Okay, I have a basic idea of how this should be done, but my access2k3 hangs when I try to run my crosstab query. The sittuation: - I have 30 tables containing same field count/names. - I have to find a way of showing the values from these fields in a report...

Thanks for your support so far. I really appreciate it. Attached are requested screenshots. A few notes: - Each machine has all the same fields (same table). - No additional fields for now, but I may add more machines later?

Thanks everyone! Thanks for your tips! Here are 2 GIF's showing the main form which shows all of the machines, and another one, which exists like 30 times, with 30 tables, containing machine/production data I described in my previous post. Currently, this system works fine, but modifying...

Greetings from Bosnia! I started working on a "make my job easier" project. I have 30 machines, running 24/7, producing various products, and I have to have some stats about these machines, for example: INPUT DATA FOR EACH MACHINE: - product name that machine is currently producing - order #...