Search results

For an experienced developer I'd agree entirely. For someone who's still trying to learn to code though, making a copy of the FE and going in to each form and changing the forms setting so you can't add/edit/delete is a bit tedious but a quick way to deploy the "View only" version. This meets...

What is the table structure for how the data is stored? Do you have one record per person per day or one per month with multiple fields to hold each day's results?

ACCESS does not have native functions to sum or count values in different fields of a record. ACCESS does have native functions to sum or count values in the same field in different records. You can write your own function to return the totals.

Scott-Atkinson. Do you have a link? Sounds like a blast!

Do they fill it in by hand on a printed calendar OR do they add data in your system that shows "Complete" or "Uncomplete"? If the former, then doing this as a report is very straight forward. If the later, it is almost as easy.

This many give you your answer. If you do this every minute, I'd suggest putting this code into its own little FE that gets started every minute rather than having it internal to the code that says "Do this every minute". This would allow you to copy over a fresh FE each time, do your import...

dcavaiani, To be clear, each record holds 14 date/times so one record is used for one week? What happens if a person has to clock out for part of their normal shift? You may find it easier to use one record per in/out, thus allowing you to have an employee clock in at 8am, clock out for lunch...

Welcome to the wonderful worlds of AWF!

On the left, you have "Assigned to" above a list of names. Going to the right are dates. Where each name/date intersects (Fred Fredders/1-Jan) what should be displayed? Or is this ONLY to make a calendar that will be filled by hand after being printed?

Em, If you don't feel up to doing a lot of coding, they least "Technical" way would be to split the data base first. Second import those forms and reports you want your "Reader"s to see into a NEW "Reader" front end and set the forms to read only. You would then keep the two front ends in...

I've heard this argument before... But MOM... All the kids are jumping off bridges these days!!! Unless there is a business reason that justifies the change switching from a known and proven system isn't desirable. This is why credit card processing still uses 2400 baud modems without...

From a design standpoint, what advantage would you have doing a C&R while using the database rather than doing so when you close it? I am guessing this is for a front end that has temp tables?

Micron, Not familiar with "The Moon Is a Harsh Mistress"? There ain't no such thing as a free lunch

Scott-Atkinson I used to enjoy both Warhammer 40K and the epic version. That was a fair time ago though. For Darklands how often do new mini's come out? And do older mini's become obsolete? One reason I got out of this kind of gaming was the price tag on re-buying your army every year or two to...

What should appear for each employee/date intersection?

jeannier1975 One month at a time? And will this be in a REPORT or a FORM?

Your very welcome!

Does this only show one month at a time? What should appear for each employee/date intersection? What data will drive this?

I would try using EVAL after concatenating your NZ's and your additions signs to make a proper string. Should look like the below; =EVAL(Nz([List341].Column(0),0) & "+" & Nz([List346].Column(0),0) & "+" & Nz([List929].Column(0),0) & "+" & Nz([List931].Column(0),0)) I'd also rename your Lists...

Give ?Name, but not a big issue. Was thinking in code. What WILL happen, is if you don't tell NZ what to return you don't get what you expect. You also have to be careful since text boxes are treated as strings, so you wind up concatenating if your not careful.