Search results for query: *

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

What does this mean? This error is not descriptive at all. Can't set value of WHAT to NULL? I also set my checkbox to true and still recieve the same error message. Any ideas? There were two other posts last year with this problem, neither one were responded to, so I thought I'd try again...

I am using the following procedure on a form to - clear and refill a temporary table (temptblTree) with all sublevel parts (Toplevel = Me!ITMKEYID) - open the report which is supposed to show this table The problem is: When the report opens, only the first two records from the table show...

good lord guys! I've spent three days on treeview! Should'a come here first!!! thanks for the help &quot;It doesn't matter how idiot-proof you make it, someone makes a better idiot!&quot;

I've reposted this thread on the Access Forms forum. I've scoured the Access help feature specifically the TableDefinitions and could not find a suitable answer. &quot;It doesn't matter how idiot-proof you make it, someone makes a better idiot!&quot;

I originally posted this thread on the VBA code forum. I thought by reposting it here, I may get some more help. Thanks....... I've created a form to allow certain users to add a new field/column to an existing table. The following code is in the VB portion of the form. Dim strNEWFLD As...