Search results

Thank You Gentlemen, Thank you for your advice. I have many times asked for help on this very forum, and am please to say that each and every time i have received the help which is great. The code examples have helped me several times but i was finding that although my db works, i was not...

Gentlemen, I have written a few db to date and all of them are woking fine and acheive exactly what it is that I wish them do which is great. Many times have I had to refer to this site and must say that each time I have received superb advice and assistance which is great. The reason for my...

Bob, That worked a treat and it seems to be working fine now. Thank you.

I have a form that displays the results of a query. the displayed results are controlled by a Combobox and this all works fine, however when i select the drop down list, there are gaps between the data that is displayed? I realise that this is more than likely due to the fact that there is...

This is exactly what I am trying to achive, I have followed what the instructions have said and change my lookup field to a text field but kept the relationship, I cannot however get the text box to populate with the correct information. My form is allready based upon a query but i only see the...

RG, I am at a loss I am afraid, I have done what you have said and changed the lookup field to a text field, This being done i am still at the point where by my forms combo box will either show the correct data but will not change record when i select a different VRN or it will show a numeric...

Rural Guy, I have just read the page which you linked to informing me of the "Evil Lookup Field". This now poses me with a different question all together, and one which you may noow be expecting. When I was learning the basics of database design, I was taught that having multiple tables with...

yes theh table is originally fueled by a lookup field for the VRN, however i have created a query on the table and form from the results of the query? I must admit, i was earlier tryign to filter records from a query based upon a lookup field and it would not allow me to do it which is...

There is no event procedure assigned when i create the form using hte standard wizard, however the form displays the contents correctly. when i create a combo box myself and tell it to find records based upon the criteria i select the following event procedure is added: Private Sub...

I have a form that i would like to display a specific record based upon what is selected in a combo box. If is generate the form using hte standard wizard then all the relevant fields appear as you would expect, however when i select and change the contents of my combo box, nothing else changes...

Brian, Thank you for your reply, I have tried this with a Like criteria and a normal sort and bot are qithout sucess. I am using a value that is exactly as it is in the table, i have even copied the criteria and pasted it in tothe query when requested to see if i was getting it wrong and...

Is it possible to have a sort criteria set on a field that is populated in a table by a lookup? The reason i am asking is that although i can get a query to show the entire contents of the table, when i try to have a criteria eg: [please enter registration] or just in case it is spelt...

Hi, Please can anyone try to help me with this problem? I have a quantity of items that are recorded by serial number and I have stored them in a table called tbl_serial-number. Associated with each item is a password, the passwords are stored in a table called tbl_password. I have created a...

Hi, Please can anyone try to help me with this problem? I have a quantity of items that are recorded by serial number and I have stored them in a table called tbl_serial-number. Associated with each item is a password, the passwords are stored in a table called tbl_password. I have created a...

Hi Guys, I have received so much help from this forum in the past and given a little back from time to time, but now it is time for me to pick your brains again. I have a field that states a date of birth in the format dd/mm/yyyy, what i would like to have is a piece of code or a macro, which...

Rural Guy, you are a gentleman, Thank you that works perfectly. Brilliant, I can now move on to getting the other pieces working the way i would like them to.. Regards Bev

Rural guy, all i have at the moment is my one table with a few linked tables and soon to have some queries. the forms and fancy user end stuff will come later i currently have two fiels side by side, field one = DOB field two = Age it goes without saying that if my end user inputs both...

Guys, Thank you for you quick responses, Howevere it seems that my knowledge is lacking enough to understand what to do with your information? Please could you give me that little more direction as to how to actually use your suggestions to get them working? Thank you again regards Bev

Hi, I have looked through the variouse posts on this subject and there are many answers, but i couldnt find the one that suited me? so i am hopeing that someone can point me in the right direction? What i would like is for when my users enter a date of birth in the format DD/MM/YYYY then my...

Thank you for your quick reply, what if anything can i do in my DB that would ensure that this error message does not appear on other machines? Regards Bev