Search results for query: *

Thanks.

I have a form in Access with certain basic data. More details pertaining to the data is stored in a huge PDF file, each page containing some notes on one particular record. If I create a field which lists the PDF page number of this record, how can I get to open the PDF file to that particular...

Just curious to know as to what is the maximum number of bookmarks you can create in a single pdf file? and is there a limit on the number of pages in a pdf file?

What I do is I have created a separate table called "IDGenerator" which has 2 fields: KeyName and NextNum. I have a function in a module called GenerateID(pKeyName as String) This will pass the keyname of the ID field u require to generate a new value for. NextNum stores the next...

I would improve on the last one by adding this: If (rs.BOF AND rs.EOF) then 'Code for no records goes here Else .... End IF

Thanks a lot. That cleared my doubts and taught me something. I am really thankful to u all.

Shouldn'y ur varuable ans be an integer? since the responses vbYes and vbNo are integers.

Is it necessary to declare a connection object every-time in every module which tries to access a recordset from the the same .mdb file the module is in? e.g. dim cnn as connection Dim rst as ADODB.Recordset set cnn = New ADODB.Connection Set cnn = CurrentProject.Connection rst.Open...

See the thread on image appears as icon.

I had a similar problem which I posted yesterday. After tweaking a bit and looking at the example of Northwind db that comes with access, i found out that i needed to store my images as .bmp files. Once I did that, the image is showing well in the object control on the form. So that should help...

I have a table named companyDetails which stores the name address, phones, Director names and a logo fields. The logo field is a OLE field and I have embedded the logo of the company in it(it's a jpg file). When I load the forms I open this recordset to fill in the details in the form header and...

As I said earlier, even if I create a blank report without adding ANY control to it and using the custom page I specified, i get the same error. So what section width is Access talking about?

I have made it sure that the white page width is no more than 5.5" and also the height totals to 6.25"(1" top margin + 0.5" page header + 0.5" report footer + 0.75" bottom margin + 3.5" details section). So where am I going wrong? Any further suggestions?

I have been trying to create this report and every time i get this error: "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank" My page set-up has a custom page of 5.5"(w)x8.5"(h). Margins are set to...

I just exported some data to Adobe Acrobat 5. Now i have this problem. There are 3 pages. The data on page 2 & 3 is actually very little and can be accomodated on page 2 itself. IS there a way I can do this in acrobat? Conversely, is there a wau to split the data into 2 or more pages from...