Search results

I wish for the user to directly interact with the sub form and physically click on a click box or fill in the delivered quantity at this point I wish for the visibility to be altered. I presume running a query would be looking at information that had already been entered into the table. I may...

PO solution In no way confessing in anyway to know huge amounts as these guru's do I had a similar problem with purchase orders. I simply created a purchase order with full delete rights in the sub form also in the main form I disabled the page up / down buttons and the mouse wheel plus...

sub form visibility defined by check box validation Here's a doozy for everybody.... I have a sub form which is part of a purchase order. This sub form is also used in part of my >>booking in form. The reason being employees would view the contents of an order to fill in the quantity delivered...

wow thanks for your time doc man I shall give this a go...... Such a seemingly simple question generates a fairly complex answer as I suspected. A most ingenious way.... As far as the tables; I have structured them in a similar way to your. The functionality of the tables are fine it is just...

thanks people Sorry Rich could you elaborate on this one.... I'm not the sharpest knife in the draw. Regards Ade

Humble apologies and my lack of details the purchase order has an option of a datasheet view or formatted report form. Depending on what solution I can come up with depends on my final output. By the looks of the query you mentioned this will give me a running sequencial numbers. I wish for...

I wondered if anyone had an idea for this problem. We currently use a purchase order system designed by my good self my only draw back at the moment although not essential it would really put the icing on the cake. Basically when a user chooses which items they wish to order they are created in...

I have had a look around and couldn't really see a solid solution to this problem. Basically I would have this scenario A user would make a purchase order and fax it to a supplier this being done through winfax. What I would like to do is when the purchase order is printed send the PO to both...

This may help you Full_Williams http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50744&highlight=URGENT+Security+bug Regards Ade

Yes I'm at that awkward stage.....oh well I have helped a few people out with postings but having only been doing access in my spare time for 9 weeks now the leanring curve is fairly steep. It all started when my boss asked me to create an ordering and inventory system for him. I have done...

Many thanks fizzio Again and again you provide me with superfluous information. Much obliged. Adrian.

The second API method sounds great If you could strip down a DB then it would be great. Cheers Fizzio.

Hyperlink I wish to give the ability to change the URL address within the record. I currently allow a designer to add a url to a file on his terminal e.g \Alans Comp\C:\Drawings\1553.skd Should he change the location of this skd file then I would like him to have the ability to change the...

Just wondered if it is possible to have a form button edit the url of a hyperlink? I say this because I the right mouse button disabled but would still like a user to edit / update the location of a hyperlink. Regards Ade

Thanks Pat Thank you for your insight.... Much appreciated

Thanks Pat So essentially from reading what I have written what incorrect information was I providing Knowledge? I would just like to know for future reference. I was trying to get across that the secured file resides with the within the DB directory although maybe I made it unclear. And that...

I have reached my limit I'm only going by past experience that the best route is to run the sec wizard on your DB and create the secured.mdw file this will hold all user related rights. If you have not done this then I suggest you do. Other than that I have reached the limits of my technical...

Not really You have to go to the users terminal and run the Wrkgadm.exe (assuming the terminal has this program installed if not then this must be installed or copied onto the local drive). It is then a case of running the program and going through your network to the secure.mdw file that was...

I may be way off here Have you gone to the users terminal and added them to the security file using the application Wrkgadm.exe located usually in the C:\Program Files\Microsoft Office\Office\1033 folder (this may vary according to installation just do a search for it.) Hopefully you...

Question I don't know if you mis-understood me here, I mean that after the report is successfully sent to WINFAX and previewed the check box graphics (and any bitmap graphics) fail to appear. The microsoft link you gave me just gives me how to get information out of access and into WINFAX or...