Search results

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...

@ CJ, Thanks for the reply. The DB hangs and the FE seems not to be able to read the BE DB anymore. The FE opens but the login on the first form has an empty drop down where you select the project. So the FE DB will open and open the first form but can not read data from the BE. Upon opening...

@Doc_Man, Yes, we have about 100 computers in the office (not all DB users) and just got in 10 new computers running Win 10. I develop and compile on a Win 7 computer. All users have 64 bit Windows and 32 bit office. About half of the new Win 10 users run the DB and only 1 is getting issues...

@ Mark, Everyone has Win 64 bit - for the extra memory - and Office 32 bit for compatibility. Windows is a mix of Win 7 with the newer computers being on Win 10. This user is Win 10. Previously a 32 bit compiled DB wouldn't open on a 64 bit office computer and vice versa. Dunno if Access still...

@ The_Doc_Man. All forms are opened with queries. Generally I have filter fields on a main form that then filters the data shown on a sub-form. This is the case with this form too.

Sorry, forgot to add: This user recently had a new computer with upgrade to Win 10 and the problem has only started since then. I develop the DB on Win 7. Dunno if there are any issues between the 2. We all use Access 2016. Network is by blue cable. Not wireless. I queried the IT about their...