Search results

The thing is, it's in a different order to the table it relates to. If I were to use the Order By box for EngagementText, what's the format? I tried a few things but it's not worked yet.

Thanks Minty. I found it eventually, but it's already set to Yes. If I want the form in order of engagement, and within each engagement arranged in order of surname, would I need to enter something in the Order By box above?

Brilliant, thanks! I found Order By On Load, and it's already set to yes. The box above is Order By. Would that one decide the order?

Many thanks arnelgp. On another tiny and insignificant point, I notice that when I scroll through the list of payments in the form on my normal database, they are in an unusual order. You wouldn't notice this on the sample version though. Is there an easy way to make sure that the form is set...

Many thanks Minty, that works perfectly now! In order to get the form to my proper database, can I just import it somehow? I'll have a look, maybe it's self explanatory. Otherwise, by describing how to do it with words was actually very useful! Thanks again. Edit: I figured out how to import...

I see, that makes sense! I think when I finished solving this bit then I'll move on to incorporate your idea. My brain gets a bit confused otherwise! What I also aim to do, is to write VBA code, so that when I move to a new form entry, it copes the musician, engagement text and date of payment...

Many thanks for preparing that. This is just a sample, in my full database I have a query showing the totals for each musician/engagement. This form will be just for data entry. If I have a large amount of data I will import it from a spreadsheet, but for small amounts of data I think this will...

Thanks for the tip, that sounds really helpful. I've attached my database again, because I'm a struggling to create the payment type combobox. Basically, in the form I'd like the Payment Type to show the PaymentType field from the T_PaymentTypes table. Could you possibly talk me through that...

That works perfectly, thanks a lot! In my haste, I forgot to add the payment type combobox. But I'll see if I can make it work by copying what you did above. I'll let you know if I get stuck.

Unfortunately not!

Thanks. Unfortunately it's still saying Unrecognized Format. I don't know why. Maybe I can try to apply your changes by description?

Thanks a lot. I'm not able to open it though. I should have said, I'm using Access version 2007. Are you able to save it as 2007 please?

I've attached a sample version, with my attempt so far. It's work in progress though. With the F_payments, my aim is to link it to the Full_Name field in the query Q_MusiciansDetails. And with EngagementsText to link it to EngagementsText_PK in the T_Engagements table. Am I on the right...

Great, thanks a lot Minty. I'll give that a go and report back.

Hi, I have what I hope is a simple question, if I can work out how to phrase it! Basically, I have a table, and two of the fields are foreign keys. What I'd like to do is to create a form, so that I can easily add data to this table. However, in the form I would like to see a drop down list for...

Many thanks Pat. I'll try to learn more about what you mentioned there.

Thanks, that's even more helpful!

Many thanks, that was the answer I was looking for!

Thanks Gasman for your reply. Yes, I asked if I should be adapting that code. I also said I don't know about the syntax. I haven't learnt SQL yet. I'll keep researching on Google, but in the meantime, if you or anyone else can tell me how to adapt the code I'll be very grateful. Thanks.

Thanks for everyone's help yesterday. Here's my second question, which I'm hoping will be very simple. I've posted my VBA code below. I'd like to adapt the file names based on other fields in the query (Q_Totals). The problem is, I don't know how to reference them. As you can see, I've started...