Search results

I've decided that due to a few problems with the inherent restrictions with sub reports on Main reports to create a table with all the fields required to print out a Certificate. When the Certificate is to be printed I'll use a button on the Certificates form to write all the data to the single...

Thanks. I'll give that a try when I get back later. ---------- Neil

Sorry, having a bit of a senior moment there. What should have said was make everthing transparent except the text. ---------- Neil

I can't seem to make the space in between the lines of my sub report small enough to line up with my preprinted form. I've been to design view and moved the bottom up as far as it will go but it's not far enough, looking at the ruler it's about 0.6cm I've made the height of the fields smaller...

Done all that now and well on my way to getting the Certificate to print out. In your experience is it at all possible to have the combo's on my main form?

I've been battling with this for several hours now. Is it possible to make everything transparent on a sub report? If so, how? ---------- Neil

I get it now that will load my new table up with the data. I'd already done that. I'm thinking along the lines of three scenarios 1. Create a new Certificate. Add the data to the table CertAppl 2. Amend a Certificate. Change the data already present in CertAppl 3. Delete a...

I'm assuming that the code you have written is the append query and I'll need four of them for my application one to update each of the four Appliances. I'm obviously missing something simple here because however I type in the code I'm getting compile errors. ---------- Neil

Paul, I'm having a problem getting my head around the new tables, maybe it's just me. Dealing with only one table to start with, the new CertAppl. It has three fields, CertNum, ApplNum and LineID As you previously mentioned it would be a good idea to have records corresponding to each...

Thanks again

Paul, I've started on adding the new tables. I going to add two. One for the Appliances and one for the Inspections. The only problem I'm having is I'm using a back end database. How do I add the tables to my front end? --------- Neil

I've been writing certificates for 8 years and I don't think that I have ever needed to write out for more than 4 appliances. If we do, we'll do 2 Certificates, which will be really easy when this is finished. If 'issue the certificate manually' means you have to physically write one out, you...

I'm lucky, I'm the boss with the bright ideas as I'm my own boss, I designed the form as well. Coming to think of it, it was my bright idea to get this computerised 'cos I was fed up with writing these out all the time. Life's not all fun !!! ------- Neil

I take your point, normally that would be the case. I don't know if you've had a quick look at the Certificate PDF. As it shows, there can't be more than 4 appliances. However, as this project expands there will be a need to view all Certificates for a given Appliance so I can see that the new...

Paul, so I could have another table with only two fields say CertNum and AppNum. Then join CertNum to Cert ID in Certs and join AppNum with Appl ID in Appl. How do I then get the subreport to pull the Appliance data into the report. Sorry if I seem a bit stupid. -------- Neil

Paul's example worked perfectly. It lets you extract certain records from a table and display them in a simple report. I downloaded his sample db earlier and tinkered about with the code and could display a report from my Certificates form that showed all four records as I wanted, but, as he...

Yes my data does support that. In my case the Appl table hold the Appliances each with it's own ID (ID Appl) and each record in the Certs table has fields called ID Appl 1, ID Appl 2, ID Appl 3 and ID Appl 4 I've gone to my first sub report and used the master/child linker and linked...

Hi Paul, Thanks for prompt reply. I've only been using Access for a week or so, I'm just starting to get to grips with it. Would it be possible to use this as a sub report? I am building a Landlord's Certificates database. At the moment I have five tables. The main table, Certs, brings...

Hi, I don't know if this is possible. I would like my report to list different records from a table that are not necessarily connected in any way. For instance I would like to display up to four records at any one time but never more than four. The first could be maybe record 1, the second...

Thanks for that I'm well on my way now.