Search results for query: *

i've been working on a solution to secure the delivery of pdfs to client browsers. we're introducing an public-website element, so i've decided to use a webservice on the internal application webserver to pass a pdf as a byte array to a public webserver outside the LAN, where it can be forwarded...

argh, this makes no sense, the following code won't run: if Sum ({procSoldLoansConfByInvRpt;1.Loan Amt})>0 then sum({procSoldLoansConfByInvRpt;1.Spread}) / Sum ({procSoldLoansConfByInvRpt;1.Loan Amt}) else 0 i get an error Sum ({procSoldLoansConfByInvRpt;1.Loan Amt}) is not a number so sum(a)...

Working in Crystal for .net03: I'm having a hard time getting the current page displayed by the ASP.net CrystalReportViewer. I got the total page count via CStr(reportDocument.FormatEngine.GetLastPageNumber(crViewer.RequestContext())) but I can't figure out how to get the CURRENT page...

I'm working on some forms for a sqlserver asp.net webforms application. These forms will deal with only one db record's information at a time. It appears that only simple controls (combobox etc) and the all-powerful datagrid control have binding and committal functionality. Therefore I see my...

I'm attempting to create my own customized outtoexcel funtion, to be run client-side by users of an intranet asp.net application. Right now I'm trying to get an accurate recordcount from my ado recordset object, but it always fails due to my inability to get a non-forwardonly recordset...

I'm attempting to format an automatically output excel file before the user receives it. I've succeeded in freezing the panes as I need to, but I'm having some troubles setting the background color of the title row. I can see the code I already have does indeed set the bg color, but then it is...

I'm using different logins to my xp laptop for work and home, developing environment vs play. I'd like to share all the same outlook settings though. I've accomplished as much with the regular mail accounts via data file management, but i'd need at least the calendar too. contacts and the rest...

I'm attempting to have a yes/no messagebox appear after someone closes a report that asks if they wish to print the report to PDF. To print the just-displayed report, it needs to be closed, then opened in print mode. I put the messagebox in the onclose event of the report, and it calls a vba...

I have a simple query to pull a large comments field. the query succeeds in drawing in all the data when the query is bound to a form or report, but when I run it in query analyzer or try to output the query to excel, i only get the first 256 chars of the field. what shall i do? -g

i need a vba wait(millisec) command for access. doesn't seem to exist. suggestions? -g

I'm having trouble identifying the exact permissions I need to grant in this situation. We just moved from a single shared testing logon to individual logons for all users. Functions that previously worked are now failing. The two functions failing are: #1> DoCmd.OutputTo...

I've got an MSaccess adp that, upon clicking it or typing it's name in command shell, will open, print some reports to pdf, and quit. This much works on both my development computer and the server it will run on. When I create a scheduled task on my computer, it also works. However when i try to...

This is more properly an XP os question, but heregoes: I've got an adp that, upon clicking it or typing it's name in command shell, will open, print some reports to pdf, and quit. This much works on both my development computer and the server it will run on. When I create a scheduled task on...

I'm looking to do as the topic says, I currently use temporary real tables (not #temp tables) that i keep in existence for just long enough for an access adp frontend to issue an output to excel command, and then it's dropped. The parameters are usually 2 dates to form a range or a few char...

well, it seems acrobat 6 does not work like it's predecessors, and the same registry keys i used to specify the filename the pdfmaker printer should output in prior versions of acrobat do not work in ver6. does anyone have any insight into printing an access report to a specified location...

I'm looking to create a function in a module that calls an onclick event for a button on a form, but it's not liking the forms!formname convention. lil help? -g

What follows is a simple stored procedure that's not behaving as I expected. ----begin sp-------- ALTER PROCEDURE procTest ( @p_loan_number varchar(10) ) AS SET NOCOUNT ON IF (SELECT dbo.t_loan.loan_number FROM dbo.t_loan WHERE dbo.t_loan.loan_number = @p_loan_number) is null BEGIN select...

I have a report with 2 grouping levels, first region, then clientID. I want a report to be formatted as follows: region cliID dtl1 dtl2 dtl3 dtl1 dtl2 dtl3 dtl1 dtl2 dtl3 cliID dtl1 dtl2 dtl3 cliID dtl1 dtl2 dtl3 region cliID dtl1 dtl2...

I wanna base a subreport on a stored procedure. The subreport's recordsource is &quot;EXEC <spname>&quot;. the subreport opens fine and displays when it's open on it's own, but yields &quot;incorrect syntax near the keyword EXEC&quot; when opening the master report. I'm guessing it's in the...

i need to do: <query with insert and sumvals> <manipulate cursor> <return records from another query> and by &quot;return records&quot; i mean be able to hook the sp directly to a report. not just &quot;sp executed successfully but did not return records&quot;. these cases return records...