Search results

Hi I'm not sure if i am going about this the right way, but basically I want a message box on close to either action another message box with an iff statement or simply to close. This is what I have so far, I haven't toyed with any message box iff statements before so I'm not sure quite how...

I am having an issue getting the query below to run successfully. I have a similar modified query and it runs fine this one however is returning a syntax error and I can't find the error, and it could be a case of staring at it for too long so I've missed it. What I am trying to do is isolate...

Hi Everyone I've recently come up against a date issue in a query and I am wondering if anyone can help me I've tried several different ways and I'm not getting the result I'd hope for. What I am trying to do is cross check all the records and only isolate the most current date for each...

Hi I'm having a small issue with the below code and I have noidea what I am doing wrong. It keeps telling me I have a syntax error. Can anyone shed some light on what I am doing wrong.:banghead: I am trying to count the different genders over a selected period of time and I want to change...

Hi I''m having an issue when I run a dLookup in a form when the query runs I get a runtime error 2135 advising that the record is read only and can't be set. I've done a bit of research and can't figure it out. The Dlookup I am using is supposed to look at a table Client ID and return a...

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...

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...

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...