Search results

I appreciate your patience JDraw... I will provide the following, perhaps it will assist. You are essentially right in your concept... There are specific pieces of equipment (a global term used to describe a grouping of individual items). Think of it like a "Car". A car has tons of...

Thanks for the reply again... Here is a screen shot of the relationship between the tables. Two of the table have a 1 to 1 as the records should never change so no need for multiple records. They are in separate tables because not all equipment will have "wiring" or will have "buttons"...

Thanks again for taking the time to respond. I will try to be a bit clearer in my explanation... Table = Tbl_Equipment Contents of table = Equipment_ID_Number (indexed no duplicates) Contents of table = ID (Autonumber and Primary Key) Contents of table = several other text fields (no index)...

Hello All Just getting back into Access after about 7 or so years away... seems I have forgot everything!!! Back to a basic question(s)... I have a Details_Form form based on a query of a single field (Equipment_ID_Number) which is an Indexed (No Duplicates) value (but not the primary key)...

So I have been getting back into this access stuff and poppa smurf has "forced me" :) to go back to basics as you can see from these two threads. http://www.access-programmers.co.uk/...d.php?t=172219 http://www.access-programmers.co.uk/forums/showthread.php?t=172422 In my sample, the question...

Well poppa smurf...this is twice you have helped me out with very easy solutions. I seem to be trying to over complicate things. Thank you for your assistance. Cheer

Seems to be the week of asking for assistance!!! I had a thread started here which after poppa smurf sorted me out and got me back to basics it is working great!!!! http://www.access-programmers.co.uk/forums/showthread.php?t=172219 WRT to the same set of combos...What I would like to do is is...

@ jayanth1808, thank you for the link, however I am not sure what is it supposed to display. It takes me back to the current forms thread... @ Poppa Smurf, thank you for looking at it again. Of course when you stated the obvious, it seemed so simple. I think it was just an issue of not...

Well you were right that a ProductID did not help. WRT the dual prices, I believe what you are seeing is the prices for everything for that "Unit of Issue" and not the product number. You are correct that there are two prices for the same product (47174815, price per metre is .91 and price per...

Just to add another question to this...perhaps I should be adding a ProductID field (AutoNumber) to this table and incorporating this into the SQL? Would that refine my result to the required price? Thoughts? Cheers

Thank you for taking the time to look at this. The difference in price would be based on the Unit Of Issue. One price would be by the metre (which in reality would be more expensive), the second which is by the roll (which is less expensive). But you have also identified the culprit to some...

I am not sure if I am on the right track with this example... I want to select down (perhaps filter is the better term) to a specific product price. I have completed a series of cascading combos to get me to the "final price" selection, but as you might guess when certain selections are picked...

Thank you for your feedbacks so far. Not really sure what I will do about this...if anything. I may just end up locking it down for future although I do like the "snotty message" approach even if it is not functional. Cheers

Hello everybody Just a quick question about security… I have a DB that is FE/BE split with the FE being “visible” and the BE “hidden” in a directory on the server. Access is controlled via the network permissions, etc. Everything is pretty standard; nothing special has worked great for...

Thank you I will check it out. I was hoping that I just could not use the documenter properly... Cheers

I am looking for an easier way to confirm that all a queries that are in a database are being used by the database. I started going through each and every one and it is taking for ever! I have tried the documenter and either I cannot understand it properly or it does not contain the...

Thanks allot, I will give it try. It seems to be funny how something so simple tends to elude us... Cheers!

Hello All I wish those of you down south or with friends and family there best wishes. I am searching for a way to display an option group (Check Boxes) selection in a report. My example: On a form I have an option group (Check Boxes), lets say “Participate”=(1) and “Did Not Participate”=(2)...

Thank you both so far. Both have made very valid comments. It is certain that I will over the years need to add additional documents, so mresann, your point regarding table structure is well taken. Like I said, I am trying to work with what was created without trying to do a wholesale change...

One Time Qry Needed. I am attempting to further normalize a table that I have. Previously I had a check box that indicated that a document was received. As the years go by now, we have started collecting multiple documents and they are all indicated by a check box. I want to move the check...