See data when entered

[kirkm]

Hi, Having a devil of a job with something that initially seemed easy.

I'm adding data into a table with .Addnew, .Update. I Have a Form based on that table open in datasheet mode.

As each new entry occurs, I'd like to check it visually. But there's no way I can make the new data appear, except by closing the Form and re-opening it. I tried the Refresh method but that has no effect, or no noticable effect.

Is there any way I can see the data as it entered ? (Just like I'd typed it in manually)

Thanks for any help.

 

[vbaInet]

If you want to see it, why don't you add directly into the form?

 

[kirkm]

jeez vbaBet, I spend about 4 hours on this, try and write an intellgent question to the forum and get a stupid bloody answer like that ?

This *IS* my way of adding it to the Form

 

[missinglinq]

Perhaps you ought to take your 'stupid bloody question' elsewhere! This kind of behavior is not tolerated here! You came here asking for our help, because you're obviously inexperienced in Access development. If you were experienced, you would be aware of the fact that Access is intended to be used with Bound Forms and have data added through those Forms, which would solve your problem and which is why vbaInet's response is more than appropriate!

Stamping your feet and saying "This *IS* my way of adding it to the Form" is childish, arrogant, and to be frank, absurd, given your obvious lack of knowledge of Access!

Linq

 

[kirkm]

It's bad enough trying to make something work, without this. Of course I don't know - or I wouldn't be asking. I don't care if you think the question stupid - it's what I'm trying to achieve.

Were I given any help I'd have more more than thankful and appreciative. Last thing is expected was a dumb answer and a squabble ! Normally I'd just ignore it, but this had been particularly time consuming and I was really hoping for a solution.

I now have worked something out.

 

[Catalina]

Great answer Linq, couldn't agree more.

Catalina

 

[vbaInet]

Perhaps you think that you cannot add records via the forms in code.

Perhaps you ought to take your 'stupid bloody question' elsewhere! This kind of behavior is not tolerated here! You came here asking for our help, because you're obviously inexperienced in Access development. If you were experienced, you would be aware of the fact that Access is intended to be used with Bound Forms and have data added through those Forms, which would solve your problem and which is why vbaInet's response is more than appropriate!

Stamping your feet and saying "This *IS* my way of adding it to the Form" is childish, arrogant, and to be frank, absurd, given your obvious lack of knowledge of Access!

Linq

I need not say more!

I shall religously ignore all your threads from now on.

 

[missinglinq]

Myself, as well! I actually keep a list and review it, weekly, to remind myself. Happily it's a very short list!

Linq

 

[kirkm]

I shall religously ignore all your threads from now on.

ROFL.... couldn't agree more vbaInet. Unhelpful meaningless answers just irritate people and discredit the Forum. Then to bitch about it and have a dig at someone's 'obvious lack of knowledge'.... why? It's sad. But c'est lavie....

 

[vbaInet]

It was simply a question that's why it ended with a question mark. If you didn't understand the question you would have asked.

 

[spikepl]

Questions are answered based on the information provided. Not based on what OP knows, intends, thinks or whatever. Because the contributors here cannot read minds.

Many posters have no clue about the basics, some do. But the contributors cannot know that, and go by the info on screen.

When you ask something apparently silly, Access-wise, without any background info, then, as always, you get the best answer back, given the info provided.

You can go through the roof, in disappointment about the poor mind-reading skills of the contributors. Good luck with that tactic.

Or you can choose not to.

 

[speakers_86]

We should sticky this as how NOT to ask a question.