Search results

I'm unable to post the database, part of it has some confidential data and even without that it's really big.

Update: I've managed to get the update query to differentiate between types of item, but the update still changes the price of all of the same items when I only want it to place the cost in to the current record being submitted. Any thoughts?

RE: the problem is that it is updating every record in the table now.

Ok, so I managed to get this to work with an update query, and it appears to work fine, but I have a new problem now. When I click on my button to update, it tells me that multiple records will be updated (more than I have in the table currently) how is this possible?

Oh good point Bob, this would be much easier done through a query than what I was thinking of doing. Thanks! So, if I use a query all I would have to do is make the criteria like "*<the field for item type>*" and then grabbing the price. How would I then make the price the result in the text...

Thanks for the thought! Unofrtunately, the macro builder is still telling me it is unable to parse type/lst are text.

Ok, how about this....there's a syntax error here, I can't see it. Any ideas? SELECT [fldpricerperunit] FROM [tblGas/Diesel] WHERE [fldtype] =[Forms]![frmGas/Diesel Update]![lstGorD]

Thanks for the input Dave. All your thoughts have been very helpful on the matter, I should have probably explained this part earlier, but I'm not really interested in sales, our inventory is used within our group, but we need to keep records of how much is used and how much remains. For the...

I wasn't sure if I should post this here or in the code section. Relevant Info: Using Access2003, connected to: http://www.access-programmers.co.uk/forums/showthread.php?t=174345 What is involved: 3 tables. 1 Form. Tables Tableprice: Item Quantity Current Price(which changes based on...

Would a where clause work? Like: Select fldprice from tblprice Where flditem(from tblprice) = <object for item>

What I've done is created a text box which has a control source of the current price, now all I need is to be able to have a value inserted in to it based on the chosen 'type' value (in fldtype) that will correspond to it via tableprice. This is the part that I don't know how to do. In my mind...

I'm working with storing a history like you suggest, the problem I am having is that I need to keep a record of each outgoing transaction's 'current price' which is stored in a seperate table from the table of transaction histories. So like I have: Tableprice: Item Quantity Current Price(which...

If I were to do so via average cost (I know you're suggesting against it, but this program has become less about accounting and more or less just theoretical data) I figure I would need to record the 'current cost' at any time that stock is removed via a record that would include... amount of...

Well, I sorted the security and multiple data location problem. Thanks all for the advice on that. But I still have a problem that requires shutting off a form and button. There is a bunch of data that I do not want to be changed in a table(that has records viewable because it's connected to a...

Oh nevermind, I figured it out. The information confused me til I opened the Wizard.

Hey all, I've been reading up on security and yet theres still something that's not right. I can't figure out how to get my database to only open for users in the set workgroup. If they aren't within the workgroup they are able to open it on the server without getting prompted for a password...

Thanks a lot all of you! You've given me a lot to think about for security purposes. Unfortunately I've hit the end of my day, but I will be researching this in more detail again tomorrow, so I'd expect more questions. Thanks again!

Thanks again for your comments Kryst51. I'll attempt to address your points in order. 1. Only the employee name should show up in the listbox, but because I have set a security level on the table that the employee name (and wage) are located on the list box appears to be empty when a user...

Yes, it's a very useful tool. I should have probably specified my question on here more clearly too. What I need to know is: will my creation of a workgroup administrator have any affect on access itself and/or anything else associated with my network? (I know that people must pick up my...

Thank you for your response, I do agree that storing the data in 2 different tables is problematic but I cannot think of any other way to accomplish what I require. My problem is that the data is stored in a secure location (due to wages) and 1 piece of data (employeename) needs to be used to...