Search results

Removing the underscore didin't work but you did get me to thinking that there was something wrong with the file name so I mapped the webfolder as a drive. Although it is pretty slow it works. What is the best way to store the back end somewhere that can be accessed by two different computers...

Hi all, I have been playing with the 'Split' facility in Access and have succesfully moved the tables to another location on my network and updated the table links. I have tried moving the _be.mdb to a web folder I have set up which I can access from Windows Explorer. When I use the linked...

I have a table that contains all the sales information for various categories. I want to be able show sales data for each particular category on a single form. I know I could do this by having several different queries - one for each category but is it possible to supply multiple criteria to a...

Thats what I though too. I have worked round the problem using a DBLookup as the combobox default value. Thanks for the help.

I am sure this is simple but I just can't seem to find the way to do it. All I want to do is select a value in a combobox from the onclick event of a button. So far I have tried comboname.defaultvalue = "GE" comboname.value = "GE" comboname.text ="GE" All without any success Any ideas?

Good idea Ken. I will ask my partner if there are any other things she can think of as I can't at the moment. There is no point in having more than 4 digits as jewellery designs come and go very quickly and I already have a system to archeive old Product Codes releasing them for use again.

No Problem Ken. As anyone who has been following my progress over the past few months will know this is not the first mistake I have made and I very much doubt it will be my last. I have decided to bight the bullet and add an optional extended part to the Product Code. So now the Product Code...

Thought about that one too. The problem is that I would then only be able to have 99 of each Category from each Supplier and I have alredy gone over the 100 mark with a couple.

I think that maybe the easiest way to go although I was hoping to come with an alternative to save an awful lot of rewiting everything.

I have been writing a stock control database for my small Jewellery Shop and thanks to all the help and encouragement I have received here can see the light at the end of the tunnel - until I reaised a major design error! My system is based around every product having a unique Product Code in...

I have moved on quite a bit since the dark days of the time I wrote that post. The database is coming along nicely (if slowly) with all the help I have been given in these forums

Thank you very much for the two suggestions - I will try them both and get back to you.

I should have pointed out that error occurs at the line Me.Recordset.MoveFirst I suspect it has something to do with not knowing which Recordset to work with

Hello again all, I have a form which has a subform which is based on a Query. Updating a TextBox on the main form does a requery and displays the results in the subform. I am trying to continue if there are records present or open a second form if the recordset is empty. This code used to...

Think I've got it half sorted now. Changed it to Me.Recordset.ProductCode.Value = NextProductCode

I am having trouble with the line Me.Recordset.Value = NextProductCode It doesn't seem to matter what I put after the equals sign I always get this error when it runs. Runtime Error 438 Object doesn't support this property or method If I delete this line the code runs OK but obviously...

Just about. Thanks to your help I can now generate the next product code and have used an IF ELSE routine to generate a ABC0001 code for new suppliers. I am now trying to get the new product code into the table where it belongs then that section is done. I have a few ideas to try just as soon...

Thanks Keith - I'll give it a try.

Hello again All, Thanks to everyone in the Querys forum (particularly Ken) I now have a form using code to calculate my next product code. The form has a subform which in turn is based on a query. The query gets it criteria from list boxes on the main form and displays just the top 1 record...

Thanks for that Ken, So would I tend to use a custom function like this if it something I would want to use in more than one place? Presumably with it having a public scope I could use this anywhere in the database project? Sean