Search results

here the error i get, ,, note you only get this error if you try to add another product after using the del btn , in this example there was 2 lines oringinally, i deleted one line using the delbtn then tried to add a new product snd you can see if the red box there is no ID number therefore i...

more annoyingly now the entire form seem to have gone into slow mode for some reason

i will make a change rto code and repost what i would like it to be like haha ,, ignore code in comment Private Sub delbtn_Click() If Me.Locked = False Then 'DoCmd.OpenQuery "DeleteQryForDeletingStock(NewOrder)" DoCmd.RunCommand acCmdDeleteRecord MsgBox "Stock Levels will be auto updated to...

the code provided by mintity isnt what i need as this would delete the locked reocrd which i dont want i cant use the delete command he sugests either becasue it remove it from view but the record reappears when you reopen the form :( somthing so simple as removing a record and its given me a...

HI all sorry ive been out the office for a few days, the save commands was any attempt i could think of to make the data stick, the lock is incase the line is locked, the button being pressed is the delete record button so i want the record to delete providing it isnt locked, then the form to...

note i i used docmd.runcommand accmddeleterecord this record is deleted but reapears on close and reopen form , that's why I'm using a del qry

thank you for fast reply ill add to screen shots now,. u will see as a temp fix I'm closing the form forcing the user to reopen it and then it works but obviously this isn't what I want long term.

hello all , its been a little while so here am I again wanting to pick someones brains as this issue has stumped me. i have an order form , with subform , the subform is "sold items" and the 2 forms are linked on OrderId and OrderFk nice and simple ,. Here's the snag when the user makes a...

thank you to everyone who replied sorry i didnt reply to you guys individually. so basically i took on board what you said and in the most part scrapped the dlookup , i managed to find a common field and link the qry to the totals qry via one field and then show it all on the report , therefore...

Hi all been a little while so I have a report "RptStockLocation" based on a qry "QryLocationReport" nothing fancy ,, its a list of products has in stock filtered by a stock physical location. The locations are preset in the inventory table such as "shop front" "warehouse" "Upstairs" and so...

hi all i hope everyone is well, I was asked a good question today that I wasn't sure about, my client asked me about a combi box he has on the new order form, the box at the moment has his customer list as the record source for the combi box drop-down in last name order, working great so I...

haha well, it took me all day but in the end, i had to go back to good old, format c: and reinstall, was very strange issue that is resolved now following the os reinstall,. every day is a school day lol , thanks all for advise as always.

i think this is what doc was getting at also. i might have another go at it but for now I've lost all my pritners in access not sure why ><

@The_Doc_Man hi doc after playing with the bits of code in your replies a few days ago I now find myself with a totally new issue,. for some reason I cannot print anything at all from access. i can print from other ms products such as word and outlook but not access. windows has many printers...

we did also manage to get the web SQL insert and select statements working from the website my friends had built and all seems very good my end on that front your advice @cheekybuddha was spot on. thank you very much now, delivery drivers, can add comments and close down drops from the click of...

@GP George thats a rell shame the idea looks very exciting, I would have been interesting in maybe donating towards the project but as you say 500 USD as a demo is a little steap . maybe get a few more people on board and we could so do 50usd each ?

i need to lay down o_O this has blew my brain

this is very cool im certainly going to spend some time looking into this some more , just the first video I stumbled upon , scanning receipts is something I have thought about doing for a while. thank you very much .

this looks like it might work using the .Printer above but I'm not sure how to implement it if I'm honest , I'm obviously trying to print a report, are you saying i need to create a hidden form or something before printing ?

hi this is an instresting idea howver the users can move locations also . so even if iset user a's printers if he changes office or desk his physical printers may change. this is something that needs to be tied to the computer location rather than the user ?