Search results

Hi PDX_Man thanks for the reply! I've been looking at the Union function and havent been getting anywhere :( I used this method of connecting the two queries: SELECT tblApp.Time FROM tblApp WHERE (((tblApp.BranchID)=[Forms]![frmApp]![branch]) AND ((tblApp.Date)=[Forms]![frmApp]![date]))...

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

It seems the problem was a lot more difficult than previously described! I have attached the result to this post so anyone else in the future can rectify this problem if it ever arises.. One of the biggest problems was that of a prompt when executing the query. In any case, the final result...

Im not having much success on this forum. In any case, I found that the answer to my problem was using the "SET WARNINGS" command & setting it to No in my macro! This worked as intended :) However, I am hoping someone will know how to add a "CANCEL" option to a Msgbox. I have a Messagebox with...

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

For anyone else that may be experiencing this problem now or in the future, the solution lies within the relationships. You have to enforce referential integrity and cascade deletes...

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

Hi mate, I had sorted the problem out before I could get around to reading your post! If only I had read it earlier, it could have saved me a lot of bother, because that is exactly what I needed to do! Thanks for the response in any case :D

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 Stef! What can I say? You sorted my problem out 'exactly' as required!! Thank you very much I really appreciate it! Looking at your changes, it makes you think how a little problem can drive you around the bend and take you to hell and back because you dont know what to do!! The code you...

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

Adevera, In the file you edited and sent back to me.. How did you manage to get rid of the query prompt ([forms]![form1]![combo0]) when accessing the form? When I try to do this on my own db, the form asks me for the value in a dialogue. But in your database, I can go straight in and type this...

Thanks a lot mate! Your revisions have definitly deemed to be useful! Its sods law that I went and changed what I needed to do in the end! :( Only to get myself into new and other problems *sigh* I hope you can mull over this problem (as it is related to the previous 1) and fingers crossed I...

Can anyone help with this? :confused:

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 mate, Your example helped to an extent :cool: But, I think I can better explain myself by showing you what I am doing! I have attached the small db. The "Items IN" form shows the combo box and everything works fine. You select the ItemID and it all comes up. But I run into problems when...

Thanks for a quick reply! But I am a newbie at access, could you tell me where to put this code? I have created a Query that enables me to ask the user for a parameter value (productID), then it displays the record and allows me to change the quantity. I have also created a form that uses...