Search results

ok... so I figured out that if I am on the last record of the form, that is the value sent to variable... so now I need to figure out how to access A) the last record B) the current record source....

is there a way to either attain the last value from a text box on a form. or to get the record count of the current object....? what I mean... let me explain it another way. I have 10 record on a form... If I assign the value from the text box to a variable, it gives me the first one. I need...

gotta be a better way... so far, best solution, is me giving the users a refresh button, in which I close and reopen the form... can anyone confirm this is only way to show new records...??? :rolleyes:

refreshing to top. because god knows there has to be a way to show my guys new records! :eek:

oops. On Change Event. this is where this would be coded... and when it reaches the length you specify, it will automatically set focus the next text box, with no tab.

start by Selecting DAO 3.6 Object Library in the references... There after do a search for writing to a table and you should get plenty of sample code. get yourself started and if you get stuck after, tell us where...

You could even get fancier as I did in my project, I passed the length I wanted each time too and tested against that. so you could pass, next control, and len to check into the function so it is even a more versatile function....

bit more....? you mean after the entry has reached 10 in length...? to go to next text box...? You can if this is the case... This calls a fucntion so you need not repeat so much code in your db. I didn't text syntax, I just copied from mine and made a few changes, so check syntax, should...

I am using... Continuous Forms because I would like all the orders to show on the screen so no clicking and searching is required, like a spread sheet layout view. I could do this in excel... but I was hoping to keep this data for referance and have other things that make access apparently...

so... I am stuck closing form and re-opening...???? :confused: This so sucks. I am searching though out the help files to no avail.... I mean really, a user shouldn't be able to view a new record...?? Is there a setting in options, or on form that could allow this or gelp me on this matter?

yes you need to replace the tblName with your tables name and use the right fields... then [YOURNUMBEROFPARTSINVOICED] = txtNoOfPart 'which is 2 [YOURPARTNUMBER] = txtPartNumber 'which is hard drives run this update.... DoCmd.RunSQL ("UPDATE tblInv SET tblInv.Qty = tblInv.Qty - "...

update Get the fields names.... You can go to queries, bring up the tables, select update query as an option. On the order form, you can use the [part no] as the parameter... ok like this. "someone does an invoice and sells one of those parts" there need to be an action, when they commit...

When they invoice... do they store this info in a table...? do the use the application.? does their pc's write to your database? If so, you could just run an update query specifying the criteria required and deucting -1 from quantity... If all the above is true, I can provide the sql vb...

also the next level is data entry... and we need to know when that is completed... the whole purpose of the little application it to track orders so we can give information back to clients without disturbing people doing their job. if I can not show the new orders as they come in to the...

I am doing tests... I am adding records and removing records from the table... (testing form) While records will not be deleted, they need to appear, so forget the deleting, but it could happen that a customer cancels an order, at which time, should be deleted from the 'order process form'...

better explanation. here is the flow of data.... our receptionist enters received orders into the interface... so second phase now. a/p need to approve the order. how do I get the new order to show up on his screen...??? without reloading the form, because he will have program always...

Thanks for fast reply but... I used query as recordset as suggested. I still get same problem.... I am using the timer function to regularly me.requery... All I am seeing is updates to data and that records have been deleted. deleted;deleted;deleted;deleted;deleted;deleted;deleted;deleted...

No need to read rest... Simple : I need other users to see new records. They all access same table, the receptionist enters new orders... Now after she has entered the orders, if there a way to have them show up on everyone elses forms??? Without.... closing and opening forms??? thanks.

this? Option Compare Database Dim vUserDate as Date sub txtDate_lostfocus() vUserDate = txtDate.text end sub sub txtDate_gotfocus() if isnull(txtDate) then ' incase they are moving around in form to not change dates txtDate.text = vUserDate end if end sub...

well if you know which table you want to write to... you can add new record using dao coding easy enough... Make your own add record button. if you don't know how. explain what table and zip you db, I will have a look at it, and code it for you and zip it back.