Search results

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

im having simillar problems to you - and i cant help thinking that the module is very long winded -- i wonder excactly how much of that is used in the procedure and if it warrants being in a module at all -- is it a case of not seeing the wood for the trees?

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

Just like the buses it took me ages to find these solutions and here i have two in one answer - -thanks to both of you i modified mine a little so that whatever size the form - i can change the length of the option box and the buttons will stretch or shrink accordingly

yes youre right - -thats what i was doing - and reversing it as you suggested is the answer - -thank again

i wasnt using a query -- merely printing the whole lot -- i have found out my mistake by looking at Northwind -- ive moved the GROUP ON to be above the SORT BY and this seems to have cured the problem -- thanks for your help

i think ive done as you said -- set the FORCE NEW PAGE to BEFORE SECTION and GROUP ON LastName with BY FIRST CHARACTER and KEEP WHOLE GROUP TOGETHER and a lot of other combinations to that effect but i seem to either get each single record per page or just the first record of each initial...

where would i find this force new page property excactly and how do i tie it in with each letter of the alphabet ie creating a single page full of names starting with the same letter as if i were creating a loose leaf telephone directory

im trying to do the same thing -- ive found the <Sort by first character> option in the "Group and Sort" but cant find out how to force the new page ?? Could you explain a little more please?

do you mean declare it in the table --which i already did or in the VB code - i havent declared anything in there cos the code was so simple -- and cant find a memo declaration anyway?

im still having trouble with this -it seems to work on some records and not others (have a feeling its to do with the content)- ive changed from text to memo in case it was a field size problem - i guess i should have said - -the table is imported from an excel file - also Why do i find that the...

im still stuck with this -- it seems to work for some records and not others and ive changed from text to memo in the table in case it was a field size problem - i probably should have said that the records are imported from an excel file and appended to an exisiting table

Private Sub cmdFilterBody_Click() If DCount("Body", "tblEmail", "Body = '" & Me!Body & "'") > 1 Then MsgBox "Duplicated", vbOKOnly End If End Sub ive had another lookat this -- seems to work ok if the message is short

message to Alc -- im using your code for my program -- it holds information on inported emails- i.e. -- subject, to address, from address and body -all in seperate textboxes and i use a button to check if there are any duplicates --- this works fine for all textboxes except the body box -- it...

this error seems to have righted itself in the end although i tried various options for the code -- im still using what i had originally and it seems to have righted itself -- so ill never know whether it was access or outlook that was to blame

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

it seems i didnt explain my predicament too well -- my exact needs are to place a database in a website for downloading -the owner of the site has issues with the size of the download so i want to create a download of the database only and include a link for the customer to download runtime from...

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

ive looked all over for a solution to this problem -- requery here - refresh there -- thanks for finally offering us a solution that works - -for me at any rate