Recent content by Adi44

I am really sorry CJ_London, but nthis is way beyond my understanding of access, where do i find the SQL of the query ? and where do i place the replacement code ? sorry, but i have no idea how to begin going about your reply. my knowledge of access is making a table and a form, and using the...

Good Morning CJ_London I re-read your original post where you kindly posted the code for me, i am afraid that I would not have a clue how to do that, I can basically create tables, make a simple search and create forms and thats about it !! I examined the sample DB you kindly posted, but...

Hi ArnelGP This is one of the examples I looked at and tried to modify, but i could not adjust the code to display just two images, and the path names were not generating images stored locally, I think i managed to get it to display the aircraft registration, type etc but that was about all...

Hi CJ London That's brilliant, but when I try to make a search box, i create a text box to enter the search value, then create a command button that when pressed opens my form to display the value of the text box. unfortunately the command button wizard only allows one field to be matched, so...

Good Morning CJ_London That sounds exactly like what I was looking to achieve, many thanks for taking the trouble to explain, however I am new to access to so any form of coding is alien to me ! I attach a copy of my DB with table, form and sample queries, would it be possible for you to have a...

Brilliant Many Thanks for that !!

Many Thanks for the reply, when i tried that access is saying that i cannot have a continious form (Ie the Master) with 2 sub-forms Many Thanks

Hi DB Guy, thanks for the welcome ! so essentially I place two sub-forms on an un-bound master form ? Many Thanks

Good Afternoon All, I have just joined this afternoon, primarily because I have been trying for several months to create a form with no luck. I have a table which consists of :- ID (Primary Key) <Autonumber> Regn <Short Text> Type <Short Text> C/No <Short Text> L/No <Short Text> Operator...