Search results

Thanks RayH. I was a little disappointed though, when I found out they don't suck anymore.

I saw Ali G do an interview with David & Victoria Beckham and he mentioned "Scum 49" (or something that sounds like it) as some really horrible football team. I can't find any information on this team though. Does anyone know what I'm talking about? I figure it must be a British inside joke.

That definitely sounds like the "proper" way to do it, but for the sake of cutting entry time I'm sticking with my design. The only real advantage I see (when doing it properly) is access time speed up. I have other issues besides that so it's fast enough for my needs.

I'm building a questionnaire/survey database for my work. Everything seems pretty straightforward, but I'm a little unsure about how to store the survey configurations. I'm assuming that the survey will change sometime between now and the end of time so I'm tracking survey configurations...

Whew, that did it. Thanks Bob.

A checkbox that doesn't check is, well, useless. I know this has happened to me before and I know I've fixed it before, but right now I'm just so frustrated I hope someone knows exactly what I'm doing wrong. I tried placing a checkbox two different times, once inside an option group and once...

I was able to get a crosstab query to change this: Name Class Date --------------------------------- John Doe Orientation 1/1/2005 Jane Doe Orientation 1/1/2005 Jane Doe Shift Mgmt. 1/10/2005 to this: Name Orientation Shift Mgmt. -----------------------------------...

Lately I've been using macros to test the performance of my queries and forms. I guess you could do the same thing with a function, but this seems easier to use. To test the performance of a query you'd make a macro like this: RunCode OpenQuery RunCode Close Both of the 'RunCode' actions...

Thanks for the tip funkymonk. I was getting the error message trying to change two fields in a record. It turned out that I had indexed a memo field and a few text fields. The fields didn't even have a lot of data in them, so just to be safe I don't think you should ever index a memo field...

The cache thing that mousie mentioned makes sense. A query of mine was running slowly yesterday but suddenly it has perked up. I do recall looking at the underlying table for a little while today, so maybe more of the records were in cache. I've been messing around, trying to flush the cache...

Just to update and finalize the thread I've abandoned the current (secured) database and continued working with the older (unsecured) one. I don't get the lingering process problem using my old database so security must have something to do with it. If there is a fix for it then it's probably...

Well, maybe not the only thing, but one thing I like about VBA that I don't see anywhere else is that tabs are automatically converted to spaces.

Sounds good. I just wanted to make sure it's okay before I use it.

Most of the tables in my database have a single attribute candidate key. I have one very insignificant table that doesn't seem to warrant a surrogate key (autonumber) but a record can only be uniquely identified by all 4 of its attributes. Should I actually bother to make all of the attributes...

I thought someone would say that. It doesn't feel right to give direct access and it won't kill me to make a few more forms.

I have a database that's almost finished. I've built a few forms for the major parts of the database, but some other data is only changable through the tables directly. The remaining tables (without corresponding forms) are pretty small and shouldn't require changing that often. Assuming I...

Since it was so long ago you probably fixed the problem, but in case someone else has the same problem (and I have recently) here's my two cents. The error can sometimes be related to a corrupt database object. I know nothing about dealing with corrupt objects so do a different search for...

I found this thread in microsoft.public.access and it sounds kinda like my problem. I'm starting to think the problem has something to do with the data I'm passing in and not what happens inside the function. I'm calling the function like this: =GetEmployeeStore([EID])This goes into the...

Jeez, it's worse than I thought. I cut down my code to see which line was causing the process to hang. It turns out, this code causes my process to linger as well: Public Function GetEmployeeStore(lngEmployee As Long) As Long GetEmployeeStore = 111 End Function Yes, that gives me the...

Sorry, that was actually a bit of code I forgot to remove. I tried getting an application reference before getting my connection reference. If it makes any difference the database I'm using is a secured one. I've used code like this hundreds of times and never had trouble. Again, if this...