Search results

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

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

i have a program that sends emails at the click of a button - containing text in the - to. subject. body. and an attachment. all works fine until i use this program on another computer. it seems to send but when i look at the outlook send folder there is nothing there and neither has it been...

i have a main form with a button that opens a simple form of 2 columns. this all works fine as an .mdb file but when i create an installer package to use with access runtime i have a problem - when i open the second form it shows on the screen but has a runtime error and when the error box is...

I have a simple combo box in a form which lists corses stored in a table Since new records tend to be inserted en bloc for a particular course id llike the combo box to retain the last course name and insert it in the default value of the combo This would automatically populate the combo with...

I have a main form called frmCustomer and a button that opens a second form called frmOutstanding3. While the second form is open over the first I have a button that prints a report (rptLetter3) for all records in the second form. However the code seems to be choosing records from the...

i have a form that contains records regarding overdue payments and a button that prints a letter to all records on that form - this works fine. i want to add another command after the printing command to tick a box indicating that a letter has been sent but when i add the command (straight after...

i have a form that contains three types of records i.e. 7, 14 and 21 days overdue accounts. i click a button to batch print all overdue with the appropriate report but instead of printing the right letter to the correct overdue stage it prints all records with the first report

Consider the following -- a table with StartBalance, Payment and EndBalance. for the next record i want the end balance of the previous record to become the start balance of the next -- i use DMax("PrevousBalance","tblFloat") this works fine until i put a minus number in the payment box -- why...

i have a report that gets its data from a query -between two dates Between [Start Date (Inclusive)] And DateAdd("d",7,[Start Date (Inclusive)]) this works fine but what i want to do is place the chosen dates from the criteria results onto the report itself ie. if i typed in 01/01/09 it would...

i have a form that holds names and addresses from a table and a subform containing transactions for that name. All works well until i put a button to close the form- not a problem unless i want to close without a new record. Part of the subform contains a combo box which starts blank and the...

I have a report that is in a letter format ie. it has an address on the top right and another address lower down on the left. Both have a multi line text box to accomodate however many lines the address has. My problem is that when the right hand text box grows - it sends the left box down too...

can anyone tell me whats wrong with this code. im on access 2007 with sp3 Private Sub cmdEmail_Click() Dim stDocName As String stDocName = "rptCalculatorFax" DoCmd.SendObject acReport, stDocName, acFormatTXT, "rick@rrroberts.freeserve.co.uk", , , "Weekly Figures", , False Exit...

i want to compile a database to autorun but have the client download the runtime program seperately to make the folder size smaller. can this be done by simply omitting some files or changing the autorun script thanks in anticipation

Has anyone created a situation where you would block a program after a certian number of records have been inputted. maybe by disabling the form which cannot be again used until a password is entered. yes youve guessed it -- i want to let the program run until the client is commited -- but then...

i have a subform that contains data for each month of the year i want to place a set of buttons under the form for each month so that when a particular button is pressed the data for that month is displayed -- rather like a combo box would could anyone supply me with the vb code to do this...

i realise this is an old question but ive read through so many answers but fail to make it work i have a form with a selection of textboxes, one in particular named 'Featuring' which contains peoples names i also have an unbound combo box called 'cmbFeaturing' containing a list of names my...

i have a form that contains customer info -- address etc... and a continuous subform simillar to a bank statement. i fill in the record in the subform and it updates the balance for that customer then goes to the next line ready for the next input, creating a new line number. this works ok...

my database contains a series of pictures and a record of who is in the picture. in group pics people are named together in one box eg. Tom Dave Jane. i want to be able to choose a name from a combo box and show all pics that contain a certain person however to d othis i would have to disect...