Recent content by vb9063

Oh dear, that sounds terrible...what do you mean by not justifying joins? Is that in the queries?:(

HI vbaInet , thanks for the quick response, did you see the latest post with new database, I thought I had got it the relationships to work :-( what would you say is wrong in the relationships, i thought that it was a M-M but after reading that tutorial thought that it was a 1-M so is this...

Hi vbaInet, I have managed to create what I think is the substitute for a multivalued field on each page of my supplier subform!!! WHoopeee!! I read that long tutorial which I think helped! Do you have any idea how i could restrict the fields for each supplier to not allow duplicate values...

Hi vbaInet, Apologies I should have deleted the non relevant stuff because I am trying to get away from using the "services" page so have deleted it. The example of the multiple combobox is now on the container page but I am stumped as to how to actually store the chosen container as I cant...

Hi Guys, I have been trying to create a junction table to remove the need to use multiselect fields (as they are not very transferable to anything else!) and have got a bit mixed up as to how to do it and whether I need to have a unique ID for the junction table and how the foreign key...

Hi Mailman, Thanks very much, I have copied that code in and it works but how do I distinguish between a new record that the user will enter other details in for the supplier and one that the user erases because they change their mind about putting the supplier in? I still get the sup_name...

sorry Mailman, my indenting is a bit rubbish! If i do the ( if Not isnull ) I get a message saying that I must enter a valid entry for Sup_name because before I had only SNM=Me.Sup_Name.Value and changed it to include the isnull expression. It removes the runtime error but then it is expecting...

HI Guys, I have a problem that occurs when you create a new record and start typing in the name field. If you change your mind and delete what you have written so that there is no longer any text in the box if you try and do anything else the Invalid use of Null error message comes up. How can...

Hi Guys, I have a strange problem with one of my forms that only occurs sometimes. I have a few fields in the top of the form with buttons and a set of subforms below them in a page tab layout so that you can click on different pages. The problem I have is that sometimes when you go into the...

I think when I said table i meant within the query builder where the tables are shown and in the bottom where you can choose what fields to query...if that makes sense i need to learn Access speak! So I think perhaps I need to fix the query to only show the sup_name and then sort on that...

Thanks Bob I will give that a go..although i think i did try it earlier but it didnt work for some reason. I have the query with 2 columns, the first has suppliers* (all items in supplier table) and sup_name. I tried sorting the sup_name but it didnt work. Is it worth separating it all out so...

Darn, thanks Bob I guess I will have to go with 2010 although I dont see that happening. Do you have any preferences with designing web enabled databases? Do you know what is the difference between asp.net and vb.net? Thanks again, VB

Hi guys, I have just noticed that when I perform a search based on a few criteria in comboboxes the output from the filter (sends records to textbox in the details section of my search form) are also not in alphabetical order. I have tried to find a place where the text box can be set to sort in...

Hi Bob, I have created my acccess 2007 database which has forms and tables but I need to store it somewhere where others can access it. We have a hosted sharepoint site which I have tried to store the access file in a normal shared folder. This works but if the database gets larger it will be...

THanks guys that worked! Cheers VB