Search results

Well go on then , solve it yourself.

Provide the actual code used, not stories. Not much help can be provided if you just submit stories. Read my signature.

It is not a question of "why" right now but "what". What gets across from Access to SQL correctly and what doesn't. You have plenty of stuff to try - strings, or perhaps strings after a date, or perhaps ... try simple queries and simple criteria to see what works and what doesn't. Once known...

OH. I thought only 30200 did not return but the others did. Again, check contents of the field in SQL and the contents of the criteria character by character, would be my advice.

Perhaps that particular code in the data is not 30200 but 3O2OO or something like that. Check all characters.

Extract the revenue center code from SQL and check the contents character by character. Sometimes weird stuff finds its way in, non-printable characters, trailing blanks ... Also provable by using Like '%30200%' presumably

Inspired by jdraw's post, I want to build on his "management issues": You have a company in business, with a mess in a number of areas. That this has been allowed to persist can be due to innocent lack of knowledge. But it could also be due to empire-building hindering dissemination of...

docmd.save does NOT save the record, but form changes. You really really need to read the online documentation for this sort of thing. You need docmd.runcommand acsomethingorothergoogleit, probably acsaverecord

Forms!nameOfThatForm.Requery But more trickery is needed, if you want to stay on a specific record and not just display record 1 after requery.

As a hint: training requirement is bound to a position (which in turn is filled by one or more persons). Training history is bound to a person. A person possesses a training history, no matter which positions the person filled.

What is your specific issue? I happen to be working on a training/SOP db, so just ask. But you need to ask something specific. "How do I build a house" cuts no ice... Oh yeah, stories are really hard to assimilate. Show tables, relations, pictures ...

Nope. Specify which to delete one by one then. As a silly patch you could temporarily rename the exceptions.

Too much in one go. Use this recipe: http://www.baldyweb.com/immediatewindow.htm You NEED to see what you do, not just blindly add a lot of stuff together and then just cry when it doesn't work :D Once you get the methodology of just doing one bite at a time, then you'll be allright - your...

I also gave you a plan B in my post which you obviously haven't executed. The answer is in fact given on AWF.

Occam's razor ...

You should put stuff like this into google as first thing. http://www.pcreview.co.uk/threads/run-time-error-16388.3275940/ Note who the responder is!

Off-hand, I do not think there is any built-in mechanism for this. But you could make the boarders of all textboxes invisible, and underneath the leftmost textbox make a horizontal line spanning the column. That line would get pushed by the highest textbox, and would in turn push those...

You have 274 posts, and I'd expect that you by now have realized, that we do not have remote vision. Show what your problem is every time: include screenshots or attachments. So that there is no doubt and no need to ask "what do you mean..." Also, skip BS-phrases like "no use". You need to...

Fixed , but only in PrintPreview - i.e. you need to go to PrintPreview to see the effect. Unfortunately I have no more time for this, so if unhappy ask someone else.

Be very careful jobwise. If you plan on becoming a full-time DBA or DB developer then fine. If you do this part time only, your company will be happy to get programming on the cheap (seemingly!) but you will in the future always get out-competed by experts on either side (programming or your...