Search results

I did't mean to sound patronising. I hate communicating in text (much to my wife's dispair with SMS messages :rolleyes: ) as I lack a good enough command of the English language to express myself like I would with speach. (Even though it's my 1st, and only, language) :o Reading the above posts...

So, you've given the checkbox and the textfield the same name? How is Access supposed to tell the difference between the two?

My advice is stop what you're doing. Bin your current DB, chalk it up to experience. Read up on Normalisation and start again from scratch. I did exactly the same as you. I ignored normalisation at my peril and had to bin weeks of work. You're in a real mess with your current DB, and it'll...

What's going on with your table structure? There's tables that blatantly should have a relationship but don't. You really need to sort that out before your forms. It will make things alot easier.

:confused: You're confusing me now. Could you post your db or even a screen shot of your form. I'm not sure what you want to achieve. Do you want an object on your form that when you click it, it updates a text box with the current time and date? If so a button would be better than a check box.

This doesn't save anything. It just displays it. Assuming that is what you want, create a check box on your form then use the code: If Me.checkBoxName Then Me.txtlastupdated = Now() End If

Not sure if this question should be here or in the query forum, but here goes. On my [Enter Hours] form, I have a query as a subform. I'm allowed to type in this subform and it updates the [Hours] table with what I type ([Hours] is the table that the query is run on). I want to do the same...

Problem solved (due to typo!) :o :o :o :o :o :o :o

Thanks for the prompt reply! I'm not typing the '. It was just ment to show the begining and end of what I was typing. Yes there is a record in the table [Training] where StaffPIN = 12177 Yes, it's defined as a long integer. Sorry, I should have pre-empted those questions in my original...

SELECT Training.ID, Training.StaffPIN, Training.Module, Training.DatePassed, Training.DateExp, Training.Comments FROM TrainingModules INNER JOIN Training ON TrainingModules.[TrngModule] = Training.[Module] WHERE (((Training.StaffPIN)=[Forms]![TrainingFrm]![StaffPIN])); Does anyone know why this...

It's bad practice to store calculated data in a table, but I can see why you might want to when allocating unique reference numbers to complaints. So, you want to know what the last reference number was so you can calculate what the next should be? As Rabbie said, the 'last' record is a bit of...

Didn't the US want to put one of the stations in a Warsaw pact country and therefore protect Russia aswell? (Gen question, can't remember off top of my head and haven't got time to research) Yeah Brown signed us up to it:mad:, but it's the French and Germans pushing for it. And pushing for an...

This is not that unusual, check out BMEzine's web site, the extreme page. I can't post the link as I can't remember it off the top of my head, and there's no way I'm looking it up at work. IT IS NOT SAFE FOR WORK! Or anyone easily offended. In fact, best stay away... How did I find it? Well...

I think you're going to have to store the new value in a variable that keeps it's value between events, and possibly between shutting the computer down and starting it up the next day? Not sure, but would the only way to do this be to store it in a table? You could get the onupdate event to...

What's happening in the background between you entering a new value and it displaying the old value? Is it being entered in to a table or are you using a query of some sort? Is nothing happening, do you want it to just display it and then work with it later?

You implied that it was only people born in the 70's that are currently in power. Anyway, nothing wrong with the rest on the list?! Putin - trying to recreate the cold war. Merkel - Trying to force crazy euro-bureaucracy on the rest of Europe. Sarkozy - As above, plus he's French. :D

Gordon Brown - UK - 20/02/1951 George W Bush - USA - 06/07/1946 Angela Merkel - Germany - 17/07/1954 Nicolas Sarkozy - Frogs - 28/01/1955 Steven Harper - Canada - 30/04/1959 Giorgio Napolitano - Italy - 29/06/1925 Yasuo Fukuda - Japan - 16/07/1936 Vladimir Putin - Russia - 07/10/1952...

What format are your dates in, UK or US? I don't know if it's the same with SQL, but VBA doesn't like UK format dates where the day value is less than 12. It tries to convert it to US format but can't decide which is the day value and which is the month. I don't know much about SQL, so I may...

I’m sorry, but this article is about something called “normalization” :confused: I meant a sticky on “normalisation” :D

Isn’t it the children of the 40’s, 50’s, 60’s and 70’s that are now in power and creating a nanny state? ;) What about children of the 80’s? We had to put up with parents who got their liberal parenting skills from their parents in the 60’s. We had to attempt to learn right from wrong...