Recent content by edmiller

I would have been psyched to have come up with such an arcane answer as well. :D

From the "bang-one-gopher-head-and-another-pops-up" department... I'm not soliciting answers for this, I'm just posting it in case someone reads this thread later and takes the actions outlined above. I have the problem, and the solution. I changed the queries to have "SELECT DISTINCT" in...

A n00b's guess Maybe I'm misreading the above, but I thought you wanted it to not open the form at all if the filter returned nothing. This code appears to leave the form open and begin creating a new record. (Notice I'm a n00b.) Wait for the experienced people to weigh in here, but I'm...

Yes, and it perfectly explains away why it was working fine for Paul, but not for Wiz and I: we chose to implement the ANSI-92 syntax option. Like a typical user, I thought to myself "I'm just using the stock MS Access, I haven't got any custom settings that should make mine different from...

Paul: Sorry, you're right it's in 2K3 format, oops. You've been on this from the very beginning (like 5 mins. after I posted!) Your help has been great! Wiz: Thx for confirming the problem wasn't exclusive to my machine...led me to try it on a co-worker's machine and then I eliminated the...

omg, I have to try this immediately, will report in a few minutes... Ed

I have to make this somewhat quick, but I have been able to duplicate the error on multiple machines running OS:XP Pro/Access 2003. Paul, you said you're using Access 2000 on XP Pro, so I'll be interested to hear your experience with this new, simple db I whipped up to demonstrate the problem...

Yeah, I'm still trying to sort out the odd behavior. I am almost done with a small sample db to mimic the box. I feel it's important to duplicate the basic underlying queries without carrying over the VBA and other baggage from the original. If that works, then I know my database has internal...

I don't know whether to be excited or distraught that your example works for me. :) However, it does inspire me to copy this to a colleague's machine and see if the behavior is different with the same version of Access. I will report back tomorrow on my findings. Right now, I have to head out...

Nice, St. Mary's is a beautiful area. Clayton's got it's own nice links, too. Uh, Paul, I just tried again unsuccessfully. I went to status combo, cleared the contents, and typed Act...nothing, no auto expansion. Also, grrr...when I type Active it tells me "that ain't valid, son." Or...

Yep, no sensitive data in the tables, that I'm sure of. I went under Tools...Options to the General tab and there's a "Remove personal information from this file on save" option, I used that. I'm working in Livermore, CA but I live up closer to Walnut Creek in a little town called Clayton. :)...

I'll go to the Help right now, but to ensure that there is no "hidden" sensitive data that I think I deleted but is somehow embedded in the database, are there any steps I should take? I've finished editing the database. Ed

I'm back from lunch. :) Okay, as I "learn by inches" also it seems that I have misused a term, "autocomplete." My previous experience would take this word to mean "the behavior of presenting the user with various endings to entries they start, based on previous completed entries". But in...

Paul, I'll have to "sanitize" the data before publishing the database, but I am more than willing to do so. My next reply may be a bit later in the day. I'm grateful for your help and as I suspected when I searched and found nothing, something atypical is going on here.

Indeed, you are exactly correct (bound column width=0", column count=2). As a first stab at a solution, I tried making the PersonName field the first field returned by the query (and changed the column widths and bound column properties appropriately), alas that did not work. Ed