Search results

Thanks for the head-up CJ. I'll certainly have a look there.

That's amazing Bob. Thank you very much. You are a star!

Hi Bob, I hope you got the attachment. This is where I am at the moment. The form [OrderFormMain] contains the customer details and the embedded subform [OrderFormsub] should contain a record of each stock allocation. The first combo contains a general description and the second should show...

Thank you for your prompt reply Bob. I will send what I have ASAP. Rob

Hello folks, I am looking into creating a stock control/allocation database and have come to a problem. I have a form which contains the customer details. I have also created a sub form based on resources allocated to that customer, with the idea that a continual record of stock allocation can...

Thanks again CJ. I think I see it now.

Many thanks CJ. If I set the textbox to [Date In]>date() it returns a numerical value -1, -1, 0, 1, 2 etc depending on the date in [dateIN]. How, using conditional formatting do I get the textbox to display "Overdue" instead of this value? I understand how to enhance the text box based on...

Hello Folks First thing I'd like to say is that the help and advice I've received on here has been tremendous. Thank you all. I have another question to ask of you, if I may. My Library database has a continuous form, each form contains the book details and the [dateOut] (the date of the...

I accessed the scanner website and lo and behold, there was a support section that dealt with exactly my question (amongst others of course). Anyway, as Minty suggested, you have to download a single page document which contains three barcodes. You have t scan each one in succession and after...

Thanks Minty. I had thought of that, however, I purchased a new scanner, same make and model as the other one, and it is simply plug and play. There is no setup involved. It's a simple USB connection. However, I will try swapping the scanners around to see if the original scanner takes the...

Thanks Steve, I'll certainly check this out tomorrow. Rob

Hello folks. A quick question if I may. I'm not sure if this is an Access issue or a general windows one, but here goes. I have a library access Database. One of the search methods is by Barcode. A form pops up upon request and the barcode of the book is scanned in. As soon as this is...

Many thanks to both CJLondon and JHB for your fantastic help with this. Personally I had my doubts as to whether or not such a thing could be done, especially given my personal Access limitations. But once again the solution was out there!

Many thanks JHB. I got it this time. This is exactly what I need. It looks a bit complicated so I'll spend some time to see if I can safely incorporate this into what I already have. Nice work!

Thanks JHB, unfortunately I cannot open this file. Is there any format other than PHP that you could send this?

Good Moring Folks I have a question. In my library database I have a field entitled 'Summary' within a table called 'SynTitleTbl'. The field is a memo and it contains a summary or synopsis of each book. My question is this: Is it possible for Access to highlight Key Words within this memo...

Wow!!!!! Many thanks Static. I tried this and it does work! I'd have never thought of that!

Hello folks I wonder if anyone here can help with this potential problem. In my school library database beside each book title there is a combobox that lists all the student names and classes. The librarian scrolls down to the book title then selects the borrower (student name) from the...

Thanks to everyone who replied. The problem can be resolved if I modify the database structure. There are several fields that logically do not belong in the tables that they are in, as pointed out by some of you. See what happens when you don't plan well beforehand!!!! At least it can...

I think I understand what you're saying. When the record of borrowing is created the student ID is inserted into the book title table and this indeed can be changed (I think this is what you were getting at). But the record is also appended to the [BookStudentTbl] at the same time. Not a new...