Search results

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

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

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

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

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

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

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

Not sure I'm posting this in the right area or not and I'm not even sure who to phrase my question or phrase search parameters so here goes. I have a time and billing db I put together and have run into something that is going to cause a problem sooner and probably before later. The problem...

First off, to everyone (especially those who have helped me solve problems before) I would like to say Merry Christmas from my family to yours. Access 2007. On my form "Jobs" there is a button to preview the invoice once the job is complete. I've got the code working so that depending on...

Actually have a two part question concerning my form and dlookup. Using Access 2007 I have a combo box for entering the name of the person placing an order. I have another field that looks for that person's email address (also have one for their phone number). First question: how do I get...

Time and Billing db using Access 2007 I'm trying to filter the time card form using fosusername() so that time cards for the logged in user are the only one's visible. I'm stuck because I don't know squat. I created tblUserNames: UserID (pk), UserName, NetName, & AudID. NetName is the...

Access 2007 Fairly certain I have seen the answer to my question in this forum before but I sure haven't had any luck finding the solution. My apologies in advance for having to ask this question. I have a database that serves two purposes: Foremost is to build a list of contacts within...

I've got a time and billing database; Access 2007. What I would like to do is find a way where when other users are using the database they only have access to their own timesheets. Presently there are 3 of us using the system. What's been happening is on a couple of occassions a user has...

Believe me, I browsed through this forum until my fingers started bleeding!:eek: I have a timesheet report with 3 subreports; billable hours, non-charge hours and expenses. Timesheet has a page header, there is no report header. Billable hours and non-charge hours invariably with have data...

Not even sure this is the proper place for this question or not. In a timesheet form I enter hours for a job. The job may or may not be assigned to an auditor at that point. On the Jobs form I have a subform that is supposed to return the current billable charges using a query. One of the...

I'm not even sure how to ask, let alone what I'm asking, my question. I have a table/form with a field for the billing rate that invariably will change at some future date. This rate is set in the employee/auditor form and is used in timesheets which in turn relates to specific jobs. If, at...

Basically what I'm trying find out and haven't been able to find a specific answer to is whether or not I can create a report from a form? The Clients form has a subform that lists all current jobs which can be in various stages. Each job displays the current billable info; accounting fees...

I'm blaming this problem on the subform rather than on the dummy designing it, namely me! I have a time card form that has 3 subforms on pages. First subform is for billable hours, second for expenses and the third for non-chargeable hours. On the billable hours page the user selects the job...

I have two subforms residing on tabs. Each subform has a total for that tab that displays the total hours for that tab. Below the subforms is another control that returns a grand total of the two tabs. One is for billable hours and the other for non-chargeable hours. Whenever new data is...

Been a while since I last posted; two reason for that. First, I was determined to whip this database and secondly, trying to beat this database gave me a huge headache so I had to give it a rest! The time off paid off, I think, to a point. Here's my latest that I can't find an answer to. I...