Search results for query: *

Brilliant, thanks!

Hi, Is there a way that I can specify the amount of copies to print of a report from within Access? I need the user to just be able to click a button and then Access prints the report in duplicate. I currently have the code: DoCmd.OpenReport stdocname, acnormal where stdocname is specified on...

I stand corrected :) It's just because, when you use FDisk, it warns you that you have to use FAT32 due to the limitations of FAT16 and I'm sure it quotes 540MB. Oh well! :)

Ok, I think you will need to reformat the drive. It looks like you originally formatted it as FAT (or FAT16). This is an old format for hard-drives that only allows a maximum capacity of 540MB (or similar). Reformat to FAT32 and see if it helps. As a golden rule you should only use FAT32 or...

I've been trying to figure this out for nearly three hours. You fixed it in three minutes!!! I love you! Ahem. That fixed it, thanks mate. I had a look at the vba code for the command button and substituted the bit where it ran the macro (something like DoCmd.macro..etc) for the code that...

Eric, I don't actually know VBA code yet so I have just made the macro with the main access screens. I clicked macro on the left, then 'new' and then on the screen that comes up i clicked setvalue and then at the bottom I entered the field name [Forms]![Table1]![datDate] and in the expression...

In fact, I've just changed it to =now() just to see what would happen. It has come up with the macro failing to run and in the arguments section of the error it says: [Forms]![Table1]![datDate], 17/03/2004 14:13:45 so therefore it is successfully fetching the date/time but it isn't posting it...

Thank you for your help but unfortunately it didn't solve it. I renamed it to datDate (in all honesty I've tried plenty of other names too) and it doesn't work. If I set the default value to =date() then yes, it does work, but this isn't appropriate for my system. I need the field updated when...

Thanks :) I'll do that in future (if i ever get this problem fixed! ;-) )

update: I have changed the test database: i have two fields on one table: ID(autonumber), date. i have created a form based on the table with the wizard. then I added a command button to run a macro on the form with the function Setvalue. It sets [Forms]![Table1]![date] with the expression...

Hi, I'm doing a project for sixth form and need to record the date that a record is created. The thing is, I have for tables linked in a query and two of the tables need the date. I have created a form based on the above query. One of the date fields has the =date() function and works great...