Search results

Hi This will be an easy one. I have 2 tables one called production and another called associated When I created this database 2 years ago I managed to reference a column from production to Associated i.e a field called kit number that was in production also showed the same data in associated. I...

Ta Very Much Thankyou I cannot thank the people on this forum enough for all the help thay give me - I am such a dunce, You all get me out of so many scrapes, especially you Pat. Thanks Again Brutal

Dufuss in da house Sorry Chaps, Please explain how to do this to an imbasile, I have the table and now ran simple query wizard, got all the required fields, please where and how do I enter "Select format.........." thingy. Need to have done this by the morning uk time -in deep trouble Fanks...

Thankyou Oh Ancient one Thankyou very much I will implement the usual layout changes and getting working Thanks again I couldn't have done it without you Regards Paul:D

Thankyou I have attached the database with th only relevent forms, tables and queries - please just look and don't laugh, I have buggered about with it so much it has been difficult to see where I am going now. Please realise that it is just in design mode and will not be shown to anone else...

I am sure that this question has been answered a thousand times but after 4 hours of searching the forum I couldn't find/understand the answer to my question. I have a form with a combo box, when you select an item (company departments) in the combo box it propigates a list box (department...

THANKYOU Guys you are terrific I have got it working just fine Thankyou both again for you help Paul

Thanks Both of you It is time to go for the weekend here, so I will try your suggestions/fixes 1st thing Monday Thanks again Paul

Thanks IMO UR Tops It was just the pop up bit I missed. I have set all my forms on pop and it seems o be working great, I will keep it like that unless you can advise m otherwise. Many thanks again Paul

Thanks IMO I tried your sample and yes on the face of things that is what I want so I have copied your code into my form but when I open my Db the window is minimized and everything in it, unlike yours where the time window opens?? Any clues as my vb is nonexitent Thanks Paul

I have part numbers in my database and if there are photographs in the image directory with the same number then a photograph is displayed ie P/N abc123 = abc123.jpg. This I have set up and works great - HOWEVER - if the part number in the database is abc/123 the filename cannot contain "/" so...

Thanks IMO for your input but its not quite what I mean. Let me try and explain again Whenever you open access it opens the main window, this window is there whether you just open a database or the access app itself, If you have a splashscreen, menu or whatever, it will be surrounded by the...

Howdy I am so close to finishing my project and am just making good those little anoying bits. What I would like is when a user double click the database Icon it opens my splashscreen ONLY not the surrounding Access program window, You know the one with file, edit toolbar etc. can I do this...

Thanks Lou thats very good of you I'll see what I can learn from it Paul

Thankyou Thankyou Thankyou Fizzio What more can I say Thankyou Paul

Thanks to both of you for replying DCX693, what you have written appears to be spot on, aside from that I have no vb coding experience whatsoever, the few databases that I have created although quite comprehensive were all standard access stuff. Any hints on the code required. Many thanks Paul

Hello I have a table with part numbers in it, I would like to have a field in a form that a user can type in, as he does so matching partnumbers will appear in a list in another field. Eg user types abc list shows abcdef, abcdfg, abcd12 etc. the list is to be non editable but if the user...

Thankyou Thankyou both very much It is work a treat Paul:D

Could you please tell me what the txtToday means or should i be replacing this with the table filed name that I want Date() to load in to Thanks Paul

Hello There is a field in my table called "complete" and is a controled by a yes no radio buttons i.e when a user click a radio button the field gets a 1 or 2 put into it. What I would like to do is when that field is changed is to have a date field to automatically get todays date entered in to...