Code or Macro

[David Tro]

Hello,
As part of my db course I am trying to put together a working db for a video hire firm. Anyway what it is that when I click on the search video button, choose a video, then click on the hire button it isn't added to the order form.
I have a checkbox in place to show whether video is available or not so upon choosing the hire I need to take the details from that to the order form.
Anyway I just cannot seem to get this to work so does anyone know what piece of coding I could use or even what macro would work in this instance as I am not too familair with the workings of VBA yet.
Any help gratefully received
David

 

[AncientOne]

One way would be to have all available videos listed in a list box based on a query which shows only available ones. A command button would then do two things- first add the video to the order form and then remove the video from the available list.

Adding the video to the form simply means that you have to write a line like:

Forms!MyOrderForm!MyVideo field=Me!MyListBox

Where Me refers to the form containing your list box. Your order form must be open, but can be hidden when this line is executed.

You must then write code to uncheck the box for the current list box selection and then requery the list box.

How have you attempted this problem so far?

 

[David Tro]

Hello,
I've not had much time to get into this yet (my full-time job is getting in the way!)
Anyway I have tried as you suggested but it still seems not to work, could you explain a little more please.
Probably need to spell it out in simplified terms for me.
Is there any way a macro could be used?

Thanks
David

 

[AncientOne]

Macros are useful for a limited range of standard operations, but in this case I would say using a few lines of code gives a simpler and more flexible solution.

In order to help you further, I need to know exactly how you are attempting to solve this problem yourself. This will give an insight into where your method is faulty. I suggest you post a zip file containing your database, so I can see where you're going wrong.

 

[David Tro]

Hello,
I have tried to attach a zip file of my work done so far but I got the message that my file was too large to send.
Is there any other way that I may send on my work to you to look at? Or am I doing something wrong again?
Thanks
David

 

[ShannonMarie]

Hey David!

I sent a form not long ago for the first time. What I did to save confidentiality was copy the part of my db that I need viewed. Paste it in a db1 (or any dummy name) database. Compress it through the database utilities first and then zip it. I hope this might work for you, as it did for me. If not then I hope that maybe someone else will offer the solution you need! I am still learning as well, so I understand that there may be other ways, but I will gladly offer anything I can to help.

 

[AncientOne]

David

you can send the zip file to my private email address.

 

[David Tro]

Thanks for the tip!
I am sure I will need to do that at some point in the future and any help is welcome.
David