Recent content by cclark9589

Rural By today's standards you are right, 2.2 MB isn't very big at all so perhaps it would've been best to say the time it took to load the db but being the novice that I am I just sort of assumed it must be from all those forms/reports and the associated code that goes with them. My mind...

I have an A2007 database used for time and billing. As time goes on I've had to add more forms and especially more reports. I feel the because of all these "additions" the FE is getting a bit bloated, something like 2.2MB right now. What I want to inquire about is the possibility of moving...

jz I've been trying for some time now to figure out how to prevent other users from changing certain fields once a new record has been added. No luck until I stumbled across this string earlier today. The code in your first response was absolutely spot-on for what I needed. Woohoo!!!!

I don't believe so. There is 10 or 11 fields that are job specific that have already been entered on the job form and that information has to be on the status reports as well. My thought, or hope, was to get all that done without having to re-enter everything. I'd rather only have to enter...

TypeID was missing from my statement but that didn't turn the trick. I still get the same error and it stops at the same spot which is the first paste command. Might it be possible that I have to do each copy and past command one at a time i.e., copy JobID from the Jobs frm in the Time and...

I'mmm baaaaacccccckkkkk! Got another one here that is driving me buggy. I've searched the forum and I'm just not finding an answer but that could because I'm not framing my search parameters right. I digress. I have two databases. The main db holds time and billing information for jobs...

Told you I'd get that "Well, DUH" feeling. I didn't notice the link before, noticed it and gee what's the first thing I saw? GROUP BY! I did have that due to one of the fields, removed that field and what do you know? It works! Ok, now that I feel dumb all over I think I'll run to the...

I guess that makes sense but where do I find that property at? In Design I don't see any property setting to make it read-only nor do I see one in the form properties. Where might that be?

This has simply got me stumped and I'm sure it's something that is right in front of my face and well of those, "Well, duh" sort of things but I'll be darned if I can figure this one out. I have one database, time and billing, that stores information regarding jobs we do. After a job is done...

The Excel thing really won't work because I only need the status reports on a quarterly basis but I have to update the information on a nearly daily basis. As each job is completed and invoiced I need to enter certain information on the status report. What I have in mind is to store all the...

I've moved my question to a new thread hoping to get a hit because I'm an impatient SOB! :D Here is the link to the thread I was reading and refer to below: http://www.access-programmers.co.uk/forums/showthread.php?t=200248 In reading this string I am inclined to think this might be the...

:rolleyes:

I'll give WHERE a go and see what I can make of it. Thanks for the link by the way, lots of interesting stuff there that could prove to be very useful in my application.

Done some searching and sure can't find an answer to my current issue most likely because I can't figure out how to frame my search parameters. Here goes..... Timesheet form with a subform for expenses. One of the fields on the expense sfrm is Expense Type and one of the expense types is...

Sorry, forgot to post. I had gotten a response a while ago that no data was being returned, that nothing was there and I knew that had to be wrong, there had to be something there. Then it dawned on me that it most certainly must be in my queries and sure enough that is indeed what it was...