Search results

Theres a field called CurrentUser() (or something like that, its been awhile since I've used it) but that may only work with Access's workgroups; and it sounds like you made a custom security doohickey. When I built a database many had to use (for tracking support calls) I would use this to...

I want from and to, based off the dates in the invoice subform =) Thank you again, going to sleep now - spent all day in NYC! -Lisa I'll be around Sunday afternooon/Evening ny time if you have any more questions. I really appreciate your help with this.

Is the database deisgned really badly? I wouldn't be surprised *grins* I'll catch you around I'm sure, I'm usually up til 3/4am, just now that I have a visitor til Sunday (yes, in US - NY) so I'm sort of sneaking in posts here and there... making this thing work is addicting! The one line...

Certainly, AOL: LyssaJyll MSN: Odinwoof But I'll explain. Initially I wasn't going to use subforms, so I made a form called Invoice using Access's Wizard. Then I decided to make a subform on my Company form (these are the real names, I know they should have a 'frm' before them but I dind't...

I accidentally discovered that this works from Company if I have Invoice open and hidden/minimized, or whatever, as long as it's open. is that normal? Hwo do I avoid having to open both? Thanks!

The database is too big but I'll put it on my website. Invoice is a form that I've used as a subform in Company. Dunno if that makes sense hehe. http://www.lisa-jill.com/Job%20Tracker.zip Thank again for your help! It may be a bit messy, I'm just doing this for my own personal benefit and...

Ok, I've tried both of these methods. They work -really- great when in the main form Invoice. But when I try to use them from Company (where Invoice is a subform) they bring up pop ups asking for me to input Forms!Invoice!Company, Forms!Invoice!Datefrom and Forms!Invoice!DateTo Why would they...

In addition to the above I just attempted to steal the code from the command button and do this: stDocName = "InvoiceCreator" DoCmd.OpenReport stDocName, acPreview, qryInvoiceCreator, [Forms]![Invoice]![DateFrom], acWindowNormal That killed any errors (until I hit cancel, when it asks me to...

I built myself a database to track hours. From this I create invoices and track them. Previously I had to enter the Invoice information in the form. Also, when I created the invoice I had to enter it in pop up boxes. I did some searches and found out about parameter queries. I've been...

I think I was actually going about this the wrong way. I was falling asleep ... hehe, and it occurred to me that, this isn't a 'customer' database, like the other ones I've done, but rather its prize and contest centric. The way the tables laid out now I can expand prize and see who won... and...

I wasn't sure where to post this. I have a rather sticky (to me) problem. I have a database of prize winners... the prize winners are often not repeated. However, sometimes they are. The current database is just an excel spreadsheet in Acccess so I'm rebuilding it. My thought was to Have a...

In 2000 you can go to Tools, Startup - and change the applicatino name/icon there. No idea in '97 =/ If you want to do it in windows right click on the icon and choose Properties, choose the Shortcut Tab and click "Choose Icon' near the bottom. You can browse from yours or use the system...

Brilliant, exactly what I needed to know. Thank you so so so so much!

Ok, this is fantastic, and I have it calculating total hours, thank you! The only problem is that i can't get it to caluclate total hours by company. I tried a few t hings. The way this is set up is I have a Company Form. I think have the Journal as a Subform. The Subform only shows me...

You arer fantastic, thank you. It's amazing how this personal project has grown. It was really a database to track my internship initially. But with all I've learned I've expanded it to track my job (also hourly) create and email invoices and timesheets anad am stilla dding more. I couldn't...

EMP, thank you. This is fantastic. I have one other question. I Have a form Journal built off the table Journal. I tried to put an unbound text box with =Sum([Hours]) in that form, but since its based off the table, not the query, it doesnt work. Do I need to rebuild the form based off the...

Well, the problem I was having with this was not the database. The PC reverted to 1999, if you can believe it. I'm still trying to troubleshoot exactly -why-. Anyhow, when it was set to the current date, the query (in all it's forms) worked beautifully. Sorry to waste everyone's time. Thank...

What if I just wanted this calculated in a report? So I'm entering a Time Sheet and I input the dates to generate it on... If I put in an unbound text box and just edit the Control Source in Data Sum(DateDiff("n",[fldtimestarted],[fldtimeended]) / 60 ) but it gives me bracket errors and once...

That worked beautifull, thank you. Also.. how can I manipulate this? Even if someone could piont me to a helpfile? I need to be able to sum this field up so I know how much I worked a month.. or since I started.. or whatever dates are requested. If i was storing it I would know how to...

Hi... I have, at home, a database t hat is a journal. It has multiple purposes - track hours at an internship, as well as to keep a journal of activities. I'm having some difficulties with one of the functions. I did a search here and found out how to calculate the difference in Time fields...