FrontOffice and BackEnd (2 Viewers)

[AnneV]

I have split my database in FrontOffice and BackEnd. Recently I can add new items but they are only shown in the BackEnd and not in the FrontOffice. I am the only one to work in the BackEnd. 5 people work in the FrontOffice. How can I solve this problem ?

 

[arnelgp]

what new item? table?
you create a Linked table to the new item.
and give each user the copy of the FE with new (linked) item.

 

[Cotswold]

What do you mean FrontOffice and BackEnd?
Or, is this an Access question, or a joke?

 

[Gasman]

Even you should not be working in the back end.

 

[GPGeorge]

I have split my database in FrontOffice and BackEnd. Recently I can add new items but they are only shown in the BackEnd and not in the FrontOffice. I am the only one to work in the BackEnd. 5 people work in the FrontOffice. How can I solve this problem ?

The terms most Access developers use are "Front End" and "Back End". The Front End contains all of the interface objects (forms, reports, code, etc.) and the Back End contains only the tables with the data. I think that's what you mean here, correct?

If your users are adding new records via a form in the Front End, but not seeing them in that form later, the problem may be in the way that form is set up.

Look at the property sheet for that form in design view. Select the Data tab. Take a screenshot and show it to us, please.

 

[AnneV]

The terms most Access developers use are "Front End" and "Back End". The Front End contains all of the interface objects (forms, reports, code, etc.) and the Back End contains only the tables with the data. I think that's what you mean here, correct?

If your users are adding new records via a form in the Front End, but not seeing them in that form later, the problem may be in the way that form is set up.

Look at the property sheet for that form in design view. Select the Data tab. Take a screenshot and show it to us, please.

Yesterday I added these projects. In the front end we only see till 243. The last 2 are not visible

 

[CJ_London]

by items do you mean forms, reports, queries?

Edit: looks like they mean records

 

[AnneV]

by items do you mean forms, reports, queries?

Edit: looks like they mean records

new projects = data

 

[Gasman]

Have you issued a requery on the form? or it's recordset? Closed and reopened the form.?
What is the source of the form in question?

 

[arnelgp]

for others to see new record you added, they must Refresh the form or requery the recordset.

 

[AnneV]

Have you issued a requery on the form? or it's recordset? Closed and reopened the form.?
What is the source of the form in question?

I did it all. The source are different tables

 

[arnelgp]

if the source are from different tables, maybe use Union Query?

 

[AnneV]

if the source are from different tables, maybe use Union Query?

I don't know what a union query is. I inherited the database from someone who is now retired and inaccessible

 

[arnelgp]

Yesterday I added these projects. In the front end we only see till 243. The last 2 are not visible

you add it though form? or directly to the front-end? if direct from front end, then i think you need to add it on the back-end for everyone to see.
very confusing if you have local tables on the Front end.

 

[AnneV]

you add it though form? or directly to the front-end? if direct from front end, then i think you need to add it on the back-end for everyone to see.
very confusing if you have local tables on the Front end.

Exceptionally I added them in the back end. I can see the tables in the front end but never add something in those tables. Normally, everything is added in the forms in the front end

 

[theDBguy]

@AnneV Are you available for a screen sharing session?

 

[AnneV]

yes

 

[theDBguy]

yes

Please send me an invite via email. Thanks.

 

[AnneV]

Please send me an invite via email. Thanks.

what is your emailadress?

 

[AnneV]

what is your emailadress?

I'm sorry, they call me. Could we do this screen sharing session next monday morning or thuesday afternoon? I'm not available till then.
Have a nice day,
Anne