Search results

Gotta love when terminology and real life clash :-) In "tblStatusAspects" I have 10 records, two fields - AspectID and ProjectAspect. This table is used by several other tables/forms/reports, including the one I'm interested in. Every month the user opens a form (RAPfrmStatus) linked to the...

Let's see if I can explain this without doing my head (or yours) in. I have two tables - tblStatusAspects is a list of 10 aspects (with an autonumber primary key field) RAPtblStatus is the status (and other info) of those 10 aspects for the month. I am trying to create a command button on my...

I finally managed (with a great deal of input from someone else) to write a Control Source equation that counts the number of records in the comments table, filtered by the particular aspect and the reporting month. Works beautifully. My equation looks like...

Thought I posted this, but I can't find it anywhere. Bizarre. I have a table (with a form for data entry), fields are: * ID * Project Aspect (a list of 10 set items) * Status (red/orange/green) * Month I have a 2nd table, fields are: * ID * AspectID (from the first table) * Comment, Action...

Thanks for your input. I 'think' I may have it working. Forgot to mention I have several dozen other tables already sitting in the DB. At the moment, I seem to be able to enter data in a logical manner, without double-handling, so I guess that's a good sign.

Believe me, I belong here!

Lovely. Thank you.

I have a list of project aspects (Financial, Safety, etc) that project managers must report against each month. For each aspect they assign a status (red/orange/green/NA). They can also add comments to each aspect. Some don't add any, some add multiples. Each comment includes the comment...

I see your point about the potential for the stored values becoming incorrect over time. The three yes/no fields have no purpose other than to guide users as to where their data will report. The actual reports run off queries attached to the table. Obviously if the tick is in the wrong box, a...

Thank you. It was the "isnull(me.xxx)" and "not isnull(me.xxx)" that was tripping me up. I was writing "me.xxxx = null". Thanks again.

Overview: I have two date fields - activity started, activity finished. I have three possible report options - current, future or not reporting. Future is by default ticked and there is no start or finish date; current and future are ticked if there is a start date but no finish date; current...

I am trying to write some 'if then else' code using date fields. What I have managed to get working is: Private Sub StartDate_AfterUpdate() If StartDate.Value > #1/1/1900# Then Me.Started.Value = True End If End Sub If a date is entered into the "startdate" field then the "started" check box...

Got around this a) by asking the right question in another thread :) (must have forgotten about this thread) and b) by adding a box linked to the result of the toggle options. The box is conditionally formatted to show the colour of the currently selected toggle button.

Thank you HiTech. <sigh> I think. Your off the cuff comment about not deleting records has set off a train of thought in the design team. And that train of thought is likely to translate into several days work.

Like so many things in Access we answered this issue by totally redesigning the form. <sigh> You spend a week banging your head on the table in the frustration only to realise that even if you got it do what you wanted, it wasn't what you needed anyway.

Finally convinced our IT boys to copy the Library file from a machine running Project to my machine. Hey presto, no more error. Good lesson to learn, 'cause there's every possibility to that not all the end users will have Project on their machines.

The end decision was - to create separate tables/form/reports for the overall report (ie the report that reports on ALL projects). There's some fundamental differences in the information reported on; compared with the reporting of individual projects. This gets over the security issue. The...

That's brilliant. Thank you!

I have a form that uses data from a personnel list. If a person's name isn't in the personnel table, you can't use them. What I want is: If the person isn't on the list, a message box pop up to say "they're not on the list; check your spelling or add them to the list". One button says "Add...

In my database a user creates a monthly report. The report has about 14 sections, all being controlled by various tables, forms and sub-reports. At the beginning of the process, the user chooses the report month (MAY09, JUN09, etc), and fills in the data in each section as required. Some...