Recent content by cdavisdccb

Duane -- your a bloody genius! Thanks, Chris "It doesn't matter how idiot-proof you make it, someone makes a better idiot!" - Bazooka Joe

Cool. Thanks for the code. Works great using: Date() for (dtYr). Chris "It doesn't matter how idiot-proof you make it, someone makes a better idiot!" - Bazooka Joe

Micheal Red, I've been looking for this for a while. I think you've provided the closest function that I could use. But it's giving me wrong years. When I inserted "2004" between the parenthesis, it returns data for "1905". If I could figure this syntax out, then I can take the WeekInYear of...

Scriverb, Your code was what I've been looking for. I had to modify it because my week starts on Sunday. Week#: Switch(Day([Datefield])<7,1,Day([Datefield])<14,2,Day([Datefield])<21,3,Day([Datefield])<28,4,True,5) I just dropped the <'s down one. Paul's codeInt(DatePart("d",[datefield])/7.1)+1...

Crap, I guess I was overthinking it! I added a [Week#]field in my query Week#: Switch(Day([Date])<7,1,Day([Date])<14,2,Day([Date])<21,3,Day([Date])<28,4,True,5) Which I got from Bob Scriver scriverb at thread703-840187 Then I copied the same unbound "Sum" boxes that were in the report footer...

Duane, I am using unbound fields for each department in the report's Report Footer with the Control Source =Sum([dept1]). I do have columns for each department in the crosstab. The SQL for my crosstab is: TRANSFORM Sum([qry main].Hours) AS [The Value] SELECT [qry main].Date, Sum([qry...

I have a crosstab query that returns overtime hours for 12 departments during the work week (Mon - Sat). I also have a report that displays this data. In the report, I have unbound fields to show 12 running sums (Grand Total). What I need is also the Weekly Total. I've tried several different...

I think Mike is on the right track. I dragged the {Message} field from the Control Toolbox to my form (in design mode) and my old signature appeared. I then deleted it and set the {Message} field to: VISIBLE = FALSE Then ran the form and sent it to myself. My new (since creating this form, my...

I am currently having the same problem. I created a simple form and published on our network drive so that our recieving clerk can quickly notify an individual when a personal package arrives. When that individual prints the email it has my signature on it, so the individual comes to me for...

Is there a DOS &quot;/&quot; command that will perform this same thing but also the subfolders under each? &quot;It doesn't matter how idiot-proof you make it, someone makes a better idiot!&quot;

cghoga --- This is exactly what I'm after! Didn't think to use a macro as a toolbar button. (I can't figure out why Microsoft only has template button for Printing to default printers anyway!) Thanks Again! Chris &quot;It doesn't matter how idiot-proof you make it, someone makes a better...

SonOfEmidec--- Thanks! I knew there was a simple solution. After several hours staring at a screen, my brain just wouldn't work any more! --- Thanks for reviving it! ---FYI to others, to avoid the ambiguous outer join error, I had to create seperate join queries, then a final one to show all...

I have a multilevel bill of material that I want to sort via an access query. I can't seem to get the query to pull all records. Basically, the concept is similar as below: Lev1: Assembly A Lev2: Part X Lev3: Part XX Lev3: Part YY Lev2: Part Z (Where Part XX + Part YY...

Guys, there is a really more simple solution. Just right click on the .ldb (locking database) file icon and choose <open with> - Notepad. This will show the pc name. I made it a shortcut on my desktop. It will always have the same name as your database but the suffix will be .ldb instead of...

keithskinner - compacting the database was the trick! Shame I spent over 8 hours, reading through code before i thought to check tek-tips! I'm posting a reply to get this back to the front of the forum, in case anyone else has experienced this problem. Thx again, Chris &quot;It doesn't...