Search results

Thanks Anarkadian, done that and it works. Ill try to remember that one, and not to use "Insert Page Break" in the footer. Just to sort the VBA visibility issues now. M

Well I did have to print each page manually, and it took me a long long time. As my VBA is only slowly improving, would someone possibly help me on how to integrate my record source and what I am trying to do, with the code in Apr Pillai's function, which is here...

OK, so I rewrote the form as a report, and rewrote the VBA behind it. I then set the thing to print to pdf. Two problems. 1. The line break that I put in the footer (just as in the form) was ignored so all the report was one long stream. 2. The visibility commands that are listed in the VBA and...

And I can't programmatically print with a delay between each page that gave a second or two for the repaint? thanks for responses

because I'd have to rewrite all the VBA - wouldn't I??

I have a complicated form which is actually a letter, that I need to print out to pdf. There are a load of visibility controls that I have put in the forms "On Current" event. If I view the form on screen it is good. If I print as a multi page PDF, the form is not repainting correctly between...

Dear Apr Pillai, thank you for replying to my post. I have tried using the method you have advised, but not been too successful. I think this is because I am not experienced enough with VBA, and I am not patient enough (and do not have sufficient time at the moment) to use the Northwind samples...

Hi people. I have written a database that holds membership records, and I have a form that writes a letter to select members with content governed by their member records. I can print this to pdf and create a tidy multipage document. What I really want to do, is print to pdf as separate pages...

I am working with 2 forms, one an index, and one showing detailed data for the records on the index. My users filter the index down in a number of ways to a smaller set of records, and then choose individual records to open and edit. I have used the stlinkcriteria to relate my 2 forms. But I...

I've been struggling not getting TableDefs to work (to return a BE path), for a couple of hours. So I used the advanced search on the Forum, found your post, and bingo! Cheers, Matt

What does ".Name" mean to Access in this context? thanks

Thanks for these, Ill try when back at my desk tomorrow... The reason for wanting to close the forms is that I want some values that affect formatting and display to be requeried on the first form that have been changed when the second form was open. As I have been having trouble getting a...

I need to move between forms and get some conditional formatting to update whilst this is happening. Ive tried all sorts of requery combinations but cant get it to work, and I think I need to close one form before opening the next, and vice versa on the way back to the original form. If Form 1...

To left align right aligning text stick "!" in the format properties of the field in query design view. Matt

thanks for the reply. I had a go at shoe-horning your modified date into the function, but my vba is too novice to get any success, and I end up breaking what was working previously! I can see where code needs changing to suit my options, but adding in variables and getting the syntax right is...

Would someone be able to show me how to add the file last modified date to the fields picked up by the function "listfilestotable" the function is here http:////allenbrowne.com/ser-59alt.html I want to build my list of files on a shared data area and then sort using last modified date...

OK thanks, Ill run it twice. Matt

Oh yes, thousands.

Im using the Function "Listfilestotable" that I found here http://allenbrowne.com/ser-59alt.html to scan an area of shared drive for filenames which are then written into a table within a databse in order to populate subforms that relate to a database record via a folder name to record number...

Ok I have prompted no responses, so either my database design is so flawed that I am beyond hope, or I have not asked a clear enough question. So I will be more specific - but honestly any advice really appreciated. A form "F_Daily_overall_Time_Sheet" is based on data from "Q_Work_Days". I...