Search results

As simple as that :sneaky: Many thanks for your help Minty.

I have a query that has values for different fields such as: 1 Type A 2 Type B 3 Type C (and many more) This query is used to generate a continuous sub-form from data such as: Record Description Value 008 An Item Type A 009 Another Item Type B A combo box...

Many thanks Vlad, it seems just right but I will investigate fully and get my head around what you have done :)

Oh, and Pat, you are correct the colours are terrible. I tend to deal with the operational side of things and it should therefore all be default grey black and white but I have the tendency to play with looks while I am thinking about more important things and my development work always looks a...

Hi All, Many thanks for the interesting input and the effort put into replying. Firstly I am no novice, just haven't touched it in a couple of years. I have a full understanding of bitwise as I use it for electronic equipment programming in C++, until I fully understood the idea of the...

It was to enable a lot of items to be seen in the list and more detailed data to be shown separately which is what I am trying to achieve. I want to be able to look down the list, select one and see the details.

I am getting sPath Value out of Context

I have attached the database and the issue is in frmPartsList loading the subform frmPartsListPic

Private Sub Form_Current() Me.Image202.Picture = CurrentProject.Path & "\Pictures\" & Nz(Me.Text6, "NoPhoto.jpg") End Sub I do actually have an error on form loading now of You entered an expression that has no value.

Yes, no error at all, just doesn't work.

Unfortunately Not

I am now being really stupid, how do I get the value from a text box into this code? The below does not work.

Pat, I am not the expert here but the method adds one column storing a data value between 2 and 254 and then works out what this applies to. It does work as per the attached. You may want to take it up with Arnelgp why there are technical issues but I do not see any problems. I don't ever want...

That also works a treat, many thanks again.

That seems to work a treat, many thanks.

Ok, I have a database with a picture associated to each record, I have a frame to contain the picture on a form and as you change record it displays the correct picture for each record (a bit like a contacts database). I wanted to make the database moveable so that it showed the records wherever...

A simple answer is that the bikes finished production in 1962 (before I was born!) so there will be no additions. I am looking at a build once parts database that covers all models between 1945 and 1962 so the suggestion from Arnelgp is perfect for my needs (many thanks). My theory is that I...

Many thanks for your help, I now have it working for all seven bike types. I do now have another question, I would like to search all parts for a particular type so would like to put a drop down box. For example I could have a search field and type wheel into it and get all wheels from a...

Many thanks for this, even better. I had guessed the 2* bit and it all seems to work.

Hi Arnelgp, That is spot on, exactly what I was looking for. I am thinking that I have seven types so in theory can just use 64 and 128 for the other two? Is that correct? After that I think I can work it all out (with a little thought). Many thanks for your help.