Search results

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...

Detail won't print if subreport in report footer has no data This one is driving me nuts! I have an invoice report, F101Invoices, with 2 subreports. Basic company info is in the report header with client name in page header. At the top of the detail section I have an array of information...

Recovering from a stroke is a barrel fun! You don't learn to appreciate just how much work and processing of information your mind does until something like this happens. I've done a bit of testing on the "solutions" above and have discovered that they really don't work at all. While I can...

Not quite sure what you are asking me or more precisely, what you are suggesting I ask myself and why. Maybe I need to explain the hierarchy. There are Trust Funds and then there are employers who belong to these Trust Funds. One employer can belong to many Trust Funds. We do payroll...

Don't be too hard on Colin, to a degree he is right, a more descriptive title might help more. One thing that has helped me deal with my toasted noodle is my sense of humor which really has gotten me through this. The title was merely that sense of humor coming through. I'm not sure I need to...

Beginning to get the feeling the mild stroke may have dumbed me down more than first thought. Got a problem with a database I'm using and for the life of me I can't seem to accomplish what should be a simple task. I have two related tables, Jobs and tblHours. The fields are as follows...