Recent content by cpgospi

try opening your db while holding the <shift> key down. you should be able to get back to the database window. good luck.

Thank you very much Pat, Your suggestions make sense. I very much appreciate you taking the time to respond so thoroughly. Chris

Hi all, Have a question regarding a primary key, or how to best create one. I've done some homework on keys but am having a hard time applying it to my app. Any thoughts or ideas would be appreciated. I've done a db for an ice cream shop (this is a real app and not homework BTW :) ) My...

Exactly what I needed. Thanks very much! Chris

Hi all, Not sure if I'm overlooking something simple here: I'm using a checkbox on a form as criteria for a report. If the user does not make a selection, I'd like to display all records. It's essentially for open/closed/all invoices. On form open I set the checkbox to Null. I'm trying to...

Hello StepOne, I've been around the block with these questions also. Here is a great FAQ site that can answer a lot of your questions. http://www.granite.ab.ca/access/developereditionfaq.htm I use Acc2003 and as a result, purchased Visual Studios .Net Tools to deploy runtime for my clients...

Here you go. I didn't write this code but I've been using this for some time. (I don't remember where I got it, so I apologize to the author) Function for getting file name (can paste this into a module) ' Declarations ' (Copy them to the (declarations) section of a module.) Public Type...

I'd be happy to take a look if you could post those forms. Others may have some suggestions, but I'd need to see what's happening in the hidden form. Chris

This is a bit cheesy, but I use it once in a while...(created by using the wizard to drop in a 'refresh form data' button) DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 From Acc2003, maybe a different menu command in other versions.

You could use CutePDF Writer to generate PDF's of certain pages. Not sure if that's what you're looking for but it's a nice little tool (and free). Cute PDF Writer HTH, Chris

Forms!yourformname.requery HTH, Chris

You can try opening it while holding <Shift>. This will bypass any 'startup' stuff that could be hiding toolbars, db window etc. hth, Chris

Thanks a lot guys. I'm a little embarrassed that I didn't think to try this. Have a nice day. Chris P.S. And thanks again ghudson, the timecard is working great..from a mgmnt perspective anyway ;)

Hi all, I'm a lot stumped on this one. I have a FE/BE db Acc2003, all W2k machines. 5 users max. 16 tables with decent structure in BE. Approx 4 MB in size. I run a compact&repair nightly. This morning I opened the BE and found this table (MSysCompactError). The db is still performing as...

Hello, I assume you're using unbound boxes in a form for start and end dates. That being the case, you can just set the "Default Value"s for those boxes in properties. "Date()" would give today's date. You could also assign those values via code in the OnOpen Event of that form. HTH, Chris