Search results

P.S. don't worry I don't have any users messing about in my tables or queries-it took me long enough to figure out how to build them-don't want anyone knocking over my pretty towers for the fun of it!

Thank you! In this case, I don't think it is worth the cost to implement it correctly-the information is right there in the report already-two numbers right next to each other so If they can't compare them and see which is bigger themselves I'm pretty sure nothing is going to help them-I was...

Hi... I will try to keep this succinct. I have a query that totals a column in a sub-form. The query also gets a sum from the main form for the same record. Is it possible to have a message/colour change/warning if the total of the column in the sub-form exceeds the other number in the query...

Perfect! That should have been obvious:) Thank you.

I experimented a little with that...but either I'm confused (very likely) or I haven't been very clear about what I'm trying to do (also likely). I currently have a form and subform controlled by two tables. The database is designed to track information about contracts-including payments in...

No...actually I'm more confused now. I think i should do some more reading/searching. Thanks for responding, however.

Neil, I was just searching for information on how to make my parameter prompts more friendly and I ran across this post. Would it be possible for you to explain how I would create a form to enter information into a parameter prompt? At the moment I have several queries with strange looking...

Thanks Statsman! I didn't ask the question, but the answer worked. I just spent an hour trying to get this to work with all sorts of expressions!

I tried to give you reputation, but apparently I just gave you some...so Thank you.

That sounds like a reasonable alternative to me. I'm sort of of the mind that if anyone actually wanted to destry/modify the data then anything I could set up wouldn't stop them- esp. since the aforementioned departments do not back up their files.

Thank you. Its not the sort of think I felt I could advise on without having tried. I don't think the data is really that sensitive-I think the main concern was that they didn't want people from one department messing around with the information from another department accidentally. I have...

I have very painstakingly worked out a new database and I'm about to present it to the departments who will be using it. At various times words like 'password' and 'locked' have been thrown out but as of now I have not implemented any security measures. I started reading up on the topic this...

thanks for getting back to me, I tried it and haven't had any luck. I get an error message saying that the on current expression I have entered doesn't work and I can't see the field in the form anyway.:confused: I have someone looking at it though, maybe they can sort it out. Thanks again...

Stacy, Unfortunately, I cannot help with your problem...but I think you can help with mine. I'm trying to figure out how to create a total in my subform. I'm very new to access so any details or help you could give would be much appreciated. Thank you.

Actually, I think its our fire wall as the size of the file is fine.

Thanks for the clarification. I have tried attaching a zip file and it continues to fail.

Thanks for responding so quickly Luka and for bein so specific, its often hard to understand responses to posts as they leave out information that someone more experience would know. I am a little confused about some things 1)I don't think I have created a query yet...unless that is what I'm...

Thanks for responding so quickly Luka and for bein so specific, its often hard to understand responses to posts as they leave out information that someone more experience would know. I am a little confused about some things 1)I don't think I have created a query yet...unless that is what I'm...

I don't know anything about databases, but I'm learning quickly...in short, this is what I have. A situation where a county council has many jobs that it contracts out, so there are lots of contracts which constitute individual records on a table. I have a form that is used to enter new...

The best math teacher I ever had was named Mr. Johnson. He wasn't certified, but he could actually TEACH. He would start to explain a concept, give several different examples very slowly, writing everything down and saying it. Then he would pause and say 'Let me park here for a minute. Put a...