Search results

Hi I'm wondering if anyone can help me I've tried various codes to try and get a validation to work. Basically what I want to do is change the background colour of a form based on the date in a field. The date in the field is based on the date +18 years, I'm trying to highlight a page if the...

It doesn't work :( It Shows #Name? on the form when you view it in a form.. Seriously this is doing my head in now! I thought I had a fairly good knowledge of Access and VB but I realise I am but an amateur!

Both of those would be great except the form shows all schools not just one school and the dates continuously change and aren't the same for each school. I was hoping for a IsNull or IIF type deal but to date have had _no_ luck writing anything.. I basically want it to check the "acting...

Ok so last night I regenerated the report and removed all the labels and basically just had the fields showing. I've ended up with 4 columns and 9 rows that roughly look like a spread sheet. I have removed all dividing lines and what not to make sure I am not impeding the report can shrink...

The Acting principal is the one that changes and it is only populated when there is cause to populate it. And once an acting principal is populated the dates are also entered as well as the reason for the [principal] taking leave.

With that ode you've put in the nullcolumnname you refer to is that the table column? because the field source and table have the same "names" Does that make sense? I'm having a serious blonde moment. Could you break it down further for me? Sorry :eek:

Okay dokey so the table structure looks like this School Name | Principal | Acting Principal | From Date | To Date| Reason | I originally had the table split into 2 tables School | Principal and then School | Acting Principal | From | To but thought this was a bit like reinventing the wheel...

Yes they do. The queries show all the information required. It's when you do a report and combine the information that I can't hide the superfluous fields for those records that don't have that "position" but because some schools have "all positions" I can't hide it by default. Oh the reason I...

The table is not the issue. Even if I seperated the information I would still need to report on all the fields. Which would bring me back to square one. This report encompasses all Schools regardless of whether they have 1 deputy or 4. so when producing the report, if a record does not have a 3...

HI me again! You've been extremely helpful in trying to sort out my quirky queries I thought I'd try again. I've been trying to populate a field in a form with information, but only if the field is blank. What I am trying to do is this. I have a continuous form displaying all of our...

Re: omitting blank fields from a report So there is no way to hind a field if it is blank on a report? i was thinking an IS NULL string but everything I have tried is not working..

I can't change the structure of the information because of the sheer enormity of it. Each school has one line in a table and the columns consist of principal, deputy, deputy 2, deupty 3, deputy 4, registrar, registrar 2, gardener, and then the address details. However only some schools have...

Hi I've taken two screen shots as I am unable to post a sample of the db due to the nature of the contents. However my normalisaiton is correct. The report I am trying to generate comes from a "master" table if you like there is no doubling up of information and the table is referenced by...

Hiding blank fields from a report Hi I had a look through the forums and could find a suitable answer to match what I'm looking for. I'm a bit stuck so I thought I'd throw it out there for HELP! :D I've created a report based on emergency contacts however some fields are blank as there isn't...

I'm not sure if this is the right area but I'm now going round in circles. We have recently split our database and whilst it is working on most machines it is not producing or allowing creation of reports on any machines except the admin machine. Can anyone shed some light on how to fix this...

Hiya All I'm Liz from Australia.. I've been hunting Google for days trying to get solutions and came across your amazing forums so I thought I'd join up and give it ago.. Many moons ago I used to be quite proficient at Access data-basing but haven't had to do one in a while! Now I'm dusting...

Hi I apologise I am new to this forum., I'm not sure if this is the best place for this question and if it isn't I am sorry. But I am stumped :( It has been far too long since I did any access work and I cannot figure out a query issue. I suspect its got to do with the look up fields but...