Search results for query: *

Hello, I have a report which pages by name. In that report is a subreport which has columns (20) across the page. (File / Page Setup / Column tab). The subreport shows exactly what I want when run on its own, but as a subreport in a report it gives me a new page for every column. What gives...

skipp, Do you want to do this as a one off, or redirect it regularly by code? BGE

Thanks for your help and advise, and apologies for not giving stars earlier. For quick relief I went the route of a crosstab query for my report. I have yet to successfully get a dynamic solution working... a work in progress when I have the time. Again many thanks.

Thank you for your advice. I tried Dim MyWeekhours As String and rstTarget!(MyWeeksHours) = ![PlanHours], but that gives me a Compile error of "Type-declaration character does not match declared data type", I tried surrounding with "" and []and I tried using a number in...

Hello Michael, Let me leap backwards to what I actually want out of this! I need to be able to populate a table with the info in table 'Plan': ie. Contract, Cost Code, Name and hours per week for Planned, Actual and Forecast. Then print a report, or output the data to a spreadsheet, with...

Hello, I am having some trouble with indirection. I read the thread from Aug 7 02 which referred to a control on a form, I am trying to apply it to populating a table from another table. I am in Access 97. Source Table Plan has these fields: Contract - Text 10 eg 1231231234 CC -...

Hello, I am having some trouble with indirection. I read the thread from Aug 7 02 which referred to a control on a form, I am trying to apply it to populating a table from another table. I am in Access 97. Source Table Plan has these fields: Contract - Text 10 eg 1231231234 CC -...

I actually have a number of copies of this database for different projects, and this is the only one the problem is happening to. I am running Office 97. There is a reference to Microsoft DAO 3.51 object library. I have compared line for line the module that it debugs to, and they are the...

Hello all, I have a database which worked for a long time through a number of programmers, and from version 2 to version 97 of access. Recently it has been giving a Compile Error: Automation Error message when I try to compile or click on certain buttons. It wont even let me copy and paste...

Adobe Website says you can do it in C++

I noticed a couple of sillies in my code, but it still crashes: strBookmarkText = Chr(124) & " " & strFileName now strBookmarkText = "| " & strFileName strTargetName = strTargetName & strBookmarkText now strBookmarkText = strTargetName & strBookmarkText arrMerge(0) =...

Hey Genomon, Having had success with printing to PDF, I now try to merge. Can you help with this please? I downloaded the Plus Pro version of the library, and replaced the standard one, and have registered it and removed the standard in Access. I tried what was in the sample and I have the...

tdev: Ensure the 'Size Mode' Property of the graphic object is set to stretch or zoom. The default seems to be clip, and if the top left of the graphic is white, you wont see anything. Bryan [BigEars]

Hello Geno, I had tried it that way, but it wouldnt work, so I tried all sorts of esoteric things. Getting back to basics has worked however, I removed all the crud and it now works - My IT man came down, said show me whats wrong, and it seemed to work - who knows, maybe hes a psycic or...

I just did a Google search for "ACG PDF mail Library" and picked the first result.

Hello genomon, Thank you. I have already got Acrobat 5 with PDF writer installed on my PC. I downloaded the ACG PDF library and installed it. It seems to work OK until I get clever and replace the strings with variables. It seems to get hung up - to the point of crashing Access - on the...

I need to send reports to Acrobat Writer, with a path and filename, then Acrobat to save to that path and file. I have a list of 160 reports I generate twice a month, each with a different filename which can be autogenerated. I currently set the default printer to Acrobat and manually type...