Recent content by hollering

Not bad. I like it. However, mine has much more functionality built in. In fact, I'm thinking maybe I should clean it up and post it somewhere for download, maybe even start a site for it. I know this is off topic, but you think you'd be interested in seeing it? It does all of the following...

That would work, however, I'm wanting to keep this app completely independent of my other databases...and to be honest I really just don't want to put a new routine in 113 databases that are done in all flavors of Access.

I need to update my signature. I just started using Access 2003. This database is one I have converted from 97. Also, I've seen the commands to do the compiling from within the database. However, in this case I'm actually looping through records of all my databases that are included in a...

Hmm...I guess even if you hide the Window it still tries to load the database after decompiling =( If anyone has any ideas for automatic decompile/recompile I'd love to hear them. For now I'll go without. Still, I need to know if I can open these databases in hidden mode so that this app can...

Shell & Wait & Hide a window? Okay, so I was using Call Shell("Access.exe SomeDatabase /compact", vbHide) in order to programmatically compact my databases. It worked great until the execution of the code got ahead of itself. So I came across Shell & Wait, or CreateProcess or whatever you...

Gilrucht, As for which is better, I can only state my own opinion, which with my level of knowledge is not all that important...but I would choose Access. Why? Convenience, organization of your data, and an easy-to-use interface for your users. This is especially true if you already have a...

mresann, Take note of the post above where I tried Bat's tip of keeping the form from redrawing until I want it to. This took care of the flickering problem completely for me.

Modest -- I got to read your post right after editing the other one. I was debating as to whether or not I should split this database into a FE/BE. I think I'm going to keep the recordsets just to be safe. The speed was not really an issue as much as the flicker. Thanks for the quick reply.

Thanks Is there any reason I should not use DCount()? It seems to work pretty well, and it would simplify the code a lot over using the recordsets. I could still stop the form from redrawing until I have my values. I just was curious since nobody who responded after WayneRyan used that...

I have a bunch of tables that are tied to a table of quotes. On my main quoting form I have tabs for each type of item and I want them to say how many items are related to that quote. So I found myself using a whole bunch of chunks of code that look like the following: Dim rs As...

Hmm...the first one looks great, and that's how I tried to do it this morning. However, when I get so many lines down I get an error about "Too many line continuations". I'm using Access 97, so I don't know if you're allowed more lines in 2000 or not, but now that I think back I remember that...

Solved the problem by using a variant variable to convert null values to the word NULL or use the rsChar value if it is not null. Just plugged that variable into the SQL statement instead of using the recordset values directly. Thanks Chris and Modest

Solved the problem by using a variant variable to convert null values to the word NULL or use the rsChar value if it is not null. Just plugged that variable into the SQL statement instead of using the recordset values directly. Thanks Chris and Modest

Actually, upon further inspection, that comma is there because the field being passed (TargetDate, which would be a date -- thanks Chris), is null. Would this cause the syntax error message? If so, how can I handle null values effectively? In this database they tend to be the rule more than...

Modest, I'm a beginner. All the points in your post regarding the form of my code are good points and I appreciate the feedback. I also VERY MUCH appreciate your help in debugging. I know this looks like a mess but to tell you the truth I didn't even think about cleaning it up...next time I...