Multiple users using same table...

[BLeslie88]

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.

 

[Mile-O]

What are you requerying?

 

[Ian Mac]

What are you requerying?

Also, are they Updating the records or Deleting the records then adding a new one?????

Sounds like you should be linking your Form to a Query of the table not the actual table,
you'll have more control then.

Using Me.Requery will refresh the query for them.

 

[BLeslie88]

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

is all that shows up across the screen....

I can open close form, this would work, but has to be an easier way no..???

Thanks again for fast replies...

 

[BLeslie88]

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 running in the back...

 

[Ian Mac]

Who is deleting the records? you haven't said where this occurs.
I wouls n't recommend deleting any of your data I don't see why it's needed.

You can Filter the data the a/p uses on the form, they will type in the order number from the receptionist and have only that record.

Or am I missing something.

 

[BLeslie88]

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'.

The guy in A/P needs to see all orders / records that are not pre-approved.

He may not approve it right away, he may need to make arrangements with a customer based on their account, or hold it for other reasons...

The records need to just 'show' up on his active 'form'. Is this possible. Is this not normal? To want new records to show up on a seperate pc. (Without reloading form)

Does access not allow for this?

Thanks again.

 

[BLeslie88]

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 various people that need to indicate where the order is, it defeats the whole purpose of this project.

 

[BLeslie88]

so...

I am stuck closing form and re-opening...????

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?

 

[BLeslie88]

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 the better tool of choice, such as linking pertenant info for the company....

 

[BLeslie88]

refreshing to top.

because god knows there has to be a way to show my guys new records!

 

[BLeslie88]

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...???