Recent content by SAE

That's pretty much the route I am about to try. I just need people to get out of the BE so I can add an OLE field to the table. I'll then try with either pdf or scan some docs to jpg and see how that goes.

Gina, I don't just want a list of document, I want to actually display the documents. The report is set up as you describe with a sub report linked to the main report via ID_Client field. In my subreport I have a hyperlink field with the link datafield as the Control Source. But all this shows...

Yes, this needs to be something I print out, so having a link that I click on isn't an option. As you said, I need a header followed by subsequent pdfs, then another header, then more pdfs. Also, I thought reports weren't interactive so I couldn't put an active link in a report anyway.

not sure the difference. between showing the pdf and including the pdf. I want a report that says Client A, and then has 3 letters following it. Client B then 2 letters following it. I want to show the contents of the subsequent pdfs and not just a list of names or their link reference. Hope...

I have a DB where i have a list of clients and links (via a hyperlink field) to various documents they have sent us. What i am trying to do i run some filters to filter the documents and then run a report that lists the various clients and the pdfs (usually letters) they have sent us. Query...

To be honest I generally don't go through tables with that many records. Though one of the main tables i.e. my Project ID which currently has 27 records and I have seen the IDs be reused in this table in a different DB. From there I have a number of cascading tables, ProjectOption, Project...

And .... When I "Append" 10 records, with a Code of 1,2,3,..., 10 via an append query. This time it seems to want to start the Autonumber at ID 7. So: - Record 1 doesn't get appended as there was already a record at ID 7. - 2 & 3 come in at ID 8 and 9, - 4,5,6 don't get appended as there...

And a copy of the table structure ...

@ Doc_Man, Here you go: Capture 1 is a snip of the original data table. See there are gaps as I have been playing around adding and deleting records. In Capture 2 I have added 2 records and they come in as ID 35 and 36 ... naturally ID_Rates_Labour_Base is he primary key with an Auto number...

Currently I have only a couple of hundred as I am just developing the database and keep adding and deleting temporary records as I check things over. For this particular table I would expect "thousands" to "tens of thousands" of records, one of my other DBs has a couple of million records in...

@Doc_Man, Thanks for the feedback and suggestions. The temp tables are in the FE and not the BE, i thought i had mentioned this but maybe not (too many posts to go through). Just in the very rare case that 2 users could be importing values at the same time (never say never around here ...)...

@Mark, Further explanation for reference. I have a split DB with the BE on the office server and the FE on each users C drive. As part of the working process sometimes people need to upload data from Excel. To do this I import the xlsx worksheet into a tbl_TempData table in the FE and then the...

@ArnelGP, Reading your post again you make note that a FK may point to a wrong PK after a C&R. I have never had an Auto number field get renumbered as part of a C&R. I found it just makes the numbers available to be reused. So, yes in some cases if you delete a PK record in a parent table...

Thanks, I'll have a read and try and get my head around it. I have always used the Autonumber as the value for my primary keys and never had this happen before. I will look into other solutions in the future. BTW, this isn't a parent table, it is a child table so nothing will ever point to the...

Apologies if this has been covered before. I have had a quick search and couldn't find a thread with my exact problem. The thing is I have a table with a primary key, as you should, but say I add 10 records which then have primary key values 1,2,3,..., 10 and then delete the records with keys...