Search results

That works really well, thanks a lot for that.

If I click on R_RemittanceAdvice, I'm not given the option to select an engagement, just the musician. I'm happy to not have the option to select an individual musician by the way. But the option to select an engagement is useful. I feel like it should work with a little tweaking!

I see. So when I open the report, the first F_P1 appears (I know that form F_P1 asks me about engagement when I click on that form, but it's asks me which musician when I open the report). I'd like to select all musicians, so I press print. It then goes to report view. If I click on print...

Many thanks arnelgp. I'll need to play around with it a bit more. If I want to select all reports with engagement text 1000, do I open the report, or click on form F_P1 first? Thanks again.

I might well be able to use it, I'll check. With the other thread I was looking to save just one record, but with this one, I'm looking to loop through all the records. The criteria I have is looping through all the records belonging to the same engagement (EngagementsText_FK). I'm clear on that...

Here is my code again. I don't know how to add the where criteria, so I'm pretty sure this isn't going to work. However, are you able to suggest how I can adjust it to make it work please? Thanks. Private Sub Command1_Click() Dim rs As DAO.Recordset Dim sFolder...

Sorry, I called it by the wrong name. When I said job number, I was referring to EngagementsText_FK. Probably you're going to tell me that it should be a number, not text?! I can probably change that. I didn't know I shouldn't be using combos in the report! What should I have used instead? I...

Many thanks arnelgp. Unfortunately I'm not able to open that file. It says "unrecognized database format". Was it in a later version perhaps? I'm using 2007.

I wish that were the case, but it's asking me constantly. It asked me three times before I was able to click on print preview, then another 2 times before I could view both files. Then again when I closed print preview etc. Have you tried it your end? By the way, this report contains a sub...

Thanks Gasman. I'll have a think about how I can make that work. Edit. I've copied the code below that saves the remittance advice files to PDF. I forgot to add, I created a form with a button on (F_Modules) to initiate the event procedure. As I mentioned, I'll try to make your suggestion work...

Thanks for your help. I'm the only user, and yes, I was allowing the report to open from the navigation window. I guess I could disable that though, I hadn't thought about that.

Thanks Bob. That seems to solve exactly what I was looking for. I'll see if I can make that work. Edit. I tried it, and it worked perfectly for the query itself. However, when I open the report, it repeatedly asks me "enter the job number" (i.e. the question I set as the parameter). As soon as...

Hi, I have attached a sample of my database that'll hopefully make my question clearer. Basically, I have a report that's linked to a query. Before I open my report, I firstly have to manually filter the query based on a specific job number (otherwise the report would be meaningless). Also...

Thanks for the tip. I've deleted the do loop now. I've scrapped the "enter L for last record" idea for now. I added an InputBox for getting the invoice number from the user. It's all working well now. The only thing is, if I enter a number outside of the invoice range, it saves the first...

Ok, this seems to work now. Thanks for your help. Private Sub Command0_Click() Dim rs As DAO.Recordset Dim sFolder As String Dim sFile As String On Error GoTo Error_Handler sFolder =...

Thanks Gasman. I tried using FindFirst, but I don't know how to make it work. I've showed how I've tried below. I need to integrate your other suggestions as well, but I'd like to make this bit work first. Many thanks. Private Sub Command0_Click() Dim rs As...

I know I'm marked this thread as solved, but I've got a couple of small questions to ask. I've made a slight adjustment to the code (see below) in order to save only the last record as a PDF file. So my first question is, is the way I've gone about it the most efficient? Do I really need a loop...

Thanks for the tip Gasman.

I see, so definitely a good idea for me to change it to numbers. Thanks for explaining how to change the code.

That's weird, it's working fine for me now as well! I don't know why it wasn't working before. By the way, if I go ahead and change the data type to number, can I copy one of your above lines? Thanks for your help.