i have a different database that works in the way you suggest using week numbers to add the records but when I reach week 52 (end of year) I have to start again at week 1 so my dilemma still stands
will this system zero the entries on the following week if not then I have the same problem if they do then I have another problem since there are some static column figures that need to be retained
the data is for work done on different elements for each company they are billed for that particular week and so the data is returned to zero in order to start with a clean slate for the following week before data is zeroed the application is saved with the week number included
I have a table with rows of customers the customers have columns of various payments which are populated during the week. when the week is over I want to revert the figures in the columns to zero for a fresh start
the table is replicated in a form
I have a button that backs up an application with the current date and forwards the existing date by a week this all works fine but I also want to set some records to zero after backup. can anyone put me on the right track. im using access 2010 but with 2007 format
thanks
I looked through the list of fonts and am using Copper Plate Light which seems to be the widest but still not wide enough to cover the spacing. I do realise that I can pass the info a character at a time rather than by text box but that is going to be tedious work.
I am using access to fill in a ready printed form in which letters are placed in existing boxes but these boxes are not the same width as any font I've looked at. Is there any way of making the space between two characters larger i.e. spread out the length of any word?
thanks very much for your help in this matter - especially the link - that looks like what i need if i am going to split the code to use either forms of email
thanks again
as i explained that procedure doesnt actually send an email it either takes you to the outlook program to send it or it brings up a warning that an application is trying to use outllook either way it involves an extra click of the mouse and takes longer
im not sure what you mean by - immediate window
i need this to be set as a variable so i can use it in vb
my version comes up as version 12.0 (i was hoping for xp or vista etc.) is there a list somewhere that specifies which version number is which OS
I have a problem with sending email by the app. route in as much that this only works with windows xp. to email with windows 7 or vista i have to use the docmd. option
is there a way of verifying which operating system the computer is using so that i can then use an - if then - command to decide...
it appears to be a windows issue. the email routine works on other machines running windows xp but wont work with windows 7 i have yet to try it on vista
im using office 2007 to create the database
nope - doesnt seem to work for vista either
i clicked the option to allow all macros yes and all other buttons work fine
i did find that the path i used to create a temporary .rtf file as an attachment wasnt always available in the other comps (so i have now set it to c:\ which i presume all computers use) but even with that i would...