Search results

Hello. I have a problem implementing two separate SQL statements in dreamweaver from an Access 2003 database. The queries work fine in Access but is causing many problems in dreamweaver as they are separated. I very much so need help in combining these two statements to form one SQL statement...

Hello I have a problem that is really giving me great headaches. I have had no success what so ever. My gratitude goes to anyone that can provide some insight. I have two tables. One table for appointments and one table of all available time slots (ie 0900 is record 1, 0930 is record 2, 1000...

Hello all, I have a problem that is really giving me great headaches. I have had no success what so ever. My gratitude goes to anyone that can provide some insight. I have two tables. One table for appointments and one table of all available time slots (ie 0930 is record 1, 1000 is record 2...

Hello all, It can be seen from my posts that im having a lotta trouble with queries tonight! :cool: I am currently running a delete query via a form. When a command button is pressed and the delete query is activated, I want to have my own warning messages. Ive almost done this with a message...

It seems my database is a continuous array of never ending problems! My current problem is that of a DELETE query! Is there any one out there that knows how to delete a complete record from a Products table (with the ProductID as the criteria), even if there are related records in other tables...

Elo all, Firstly, sorry for the long post! Its very hard getting the right advice about this so I wanted to be thorough. Any help will be appreciated!! I have a problem with a query and just when I thought I was done! Im creating an 'on hand' inventory control system. I have a value for when I...

Hello Access World Pros! I have a problem with some errors on a form/query that has been running circles around me for 4 hours now on a saturday night!! Im trying to implement an error control message when a user does not select an employeeID on the main form, whilst they are on the subform...

Hi all, I have been browsing the forum concerning methods of implementing inventory control and came across this link. http://members.iinet.net.au/~allenbrowne/AppInventory.html I have the tables set up in the same way etc. But being a newbie!, can anyone tell me where I put this code or...

Hi, I have two queries. One query calculates the current stock level. There is an expression : Items in Stock: Sum(Items.ItemStock-Newstockpart1.Quantity) (there is one query and one table as the basis for this query/calculation). I have another query where only the Items table forms its...

Hi, I am trying to build a form that allows the user to INPUT stock as it arrives. This is simple with a product form that shows all the products in the table. I just go to the quantity field and change it. But, I want to create a 'search' function in the field. I want to allow the user to...

Hi all, I have followed the advice on this page of 'how to update stock levels automatically' in access. http://support.microsoft.com/default.aspx?scid=kb;en-us;252813 I implemented this in the Northwind database and everything was fine. I implemented this in my database (which is very...

Hi there, I am new to this forum and am currently a Degree Undergraduate. I need help on what I think is a simple problem! I am creating a stock control system. My problem to put it bluntly is Updating the Stock Table. In other words: 1.Quanity of items being bought is entered in the Order...

Hi there, I am new to this forum and am currently a Degree Undergraduate. I need help on what I think is a simple problem! I am creating a stock control system. My problem to put it bluntly is Updating the Stock Table. In other words: 1.Quanity of items being bought is entered in the Order...