Search results

I hope I've posted this issue in the correct forum. ‘ Get the ID from the list box sContactId = Me.lstHusbLast.Column(2) ‘ Convert ID to integer iContactID = Int(sContactId) DoCmd.OpenForm "ClientServicesInput", , , WhereCondition:="Clientid =" & iContactID Please see...

I have created a report that has our company logo printed in the upper left corner. The report is output to a pdf file. When someone opens the report with a different default printer from mine, the logo 'grows'. Is there either a different image file type I can embed into the report, or some...

I have created a main report that is grouped by account id. Within the group account ID footer section there are 3 subreports. The main report and subreports are printing the correct information. My 1 big remaining problem is how to print a conditional page break before the 2nd and/or 3rd...

I am using MS Access 2012 (MDB). My understanding is that my sqlstatement can be as long as 32,000 + characters. When in debug mode I can see the sql string and when longer the 256 chars it is cut off. Is there some secret switch I need to set to accept longer strings? Also I was getting an...

I have created a report that uses a table as its record source. I need to create individual pdf files for each fund in this table. There may be 2 to many pages of activity for each fund. Prior to opening the report I query the table to get distinct funid ids. I step through the query results...

I consider myself to be fairly knowledgable about Access. I've been using it for years. There is always something new to learn and that is what keeps things interesting.