Search results

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...

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?

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...

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...

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...

I have setup a query that gives me the last product code I have used by using criteria, sort by descending and top1. The resulting record is ABC0025 I want to be able to increment this by 1 in a calculated field to give ABC0026 so I know the next available product code to use. The closest I...

Thanks to all the people who have tried to help over the past few weeks in my quest to build a database for stock control of my shop. I thought Access would have been the tool of choice to do such a thing but it is just too complicated and too time consuming trying to understand how things...

I have created a form based on a Query. I have a text box which is the source for the criteria of one of the fields in the query. When I enter data into the text box it passes this to the query criteria. I know this works because if I open the query by double clicking on it the records are...

I am still trying to get started making a database to control the stock for my new jewellery shop. After spending 2 weeks getting nowhere fast I have gone back to the Northwind example database to see if I can pick up any ideas. Can anyone explain why when I create a new order using the orders...

Hello All, As a virgin member of the Access World Forums board and a new Access user I am trying to get started creating a database to run a stock control system for my recently opened jewellery shop. I started off by recording all my data in Excel so I have several workbooks containing each...