Split database

[Ranger7913]

I have created a split database. When I enter data into a form on the front end side, for some reason, the newly created record is not showing up as a record in the front end but the data is being captured in the appropriate table on the back end. Any suggestions

[June7]

Not sure what you mean by 'not showing up'. If you just entered the data then the record should be showing on the form.

[ssanfu]

That is the way it is supposed to work.

The BE (back end) has only tables. The FE (front end) has everything else. Looking at the FE, the linked tables should display the link indicator (the little arrow).
Attachment 18427
See:
http://www.hitechcoach.com/index.php...split-database
http://www.access-experts.com/defaul...utorialSplitDB

http://allenbrowne.com/ser-01.html

[Ranger7913]

I may not have explained it well. This database will be used by multiple users. It is tracking employees. When someone opens the form containing the employee info, all of the employees are available for the user to cycle through the records. When I go to add a new record it allows me to enter the new employee. If I save and close out the form then open the employee records section again the record does not show up, the total records count hasn't changed. When I check the back end database though the record I entered is in the appropriate table. I want the newly created record to be available on the front end like the other similar records

[NTC]

What you are describing that you want - is the normal way that Access (and all databases...) work; so the question is why you can't see newly entered data; I would suggest the record source of the form should be inspected. What you describe is strange behavior and I also would be sure the Trust Locations are all set up ok. And sanity check that front ends are truly linking to the same/correct back end.

[Ranger7913]

The record source for the form is an extended query that links to the tables needed. I do have combo drop down boxes in the form. Could that create an issue? Again, I have verified the data entered via the form is being saved on the back end in the appropriate table but for some reason the new record does not cycle into the form records after closing out and opening the form up again. Thanks for the help

[June7]

The issue is when reopening form - that is new and helpful info. Look at the form DataEntry property. If it says Yes then the form will not show existing records. The form is set up to only allow new record entry.

Why is the RecordSource an extended query? A form can enter/edit data for only one table. If you are including lookup tables just to display related info, be sure to not allow edits of those records.

[Ranger7913]

Thanks June7. I am fairly new to creating databases. I deleted the form and re-created it using the main table. Problem was solved!!!!! One more issue, I created a query creating the "file as" field (combining first and last name) from my master employee table (similar to the Northwinds example database). I want to have a Go To field at the top of my form that users can use to find an employee. I know to use a combo box using the field from the query. Any pointers so I don't run into the same issue? Thanks for everyone's help!

[June7]

If you use a data control (combobox, textbox, etc) for users to select/enter filter criteria, the control must be UNBOUND, unless you use the intrinsic search/filter right click shortcut.

Options for customized search/filter:

1. dynamic parameter query as the form RecordSource (I don't use dynamic parameter queries at all)

2. code that sets form Filter and FilterOn properties, or uses Bookmarks and RecordsetClone to move to record - these are methods I use and I use only VBA, not macros

[Ranger7913]

June7. Thanks for your help. Can you dumb it down a little. I have created a combo box at the top of the employee form. The form is set up to allow access to all records (currently 586). Instead of using the "find" option I am using the combo box which shows all of the employees by last name, first name. I would like to be able to have the record of the employee name selected in the combo box to be displayed in the main body of the employee record. As it is now I can select a name from the combo box but it does not change the form record to that employee. I assume it needs some type of filter application to tell the form to go to the record selected in the combo box. You mentioned using a VBA code. Can you provide me an example or point to a link where I can learn how to do that. Thanks

[June7]

Here is example code to filter a form with parameters entered into unbound controls http://www.allenbrowne.com/ser-62code.html

The combobox should have a hidden first column with the employee ID. Then search/filter should use the employee ID.

[Ranger7913]

I have created a split database. I thought I had thoroughly checked it after working all of the bugs out. I have realized I made a mistake in one of the forms. I have corrected it on the original front end. I have created an accde file for the other users to use. Is there a way to update their copy of the file without them having to delete their copy and recopy the new file?

[June7]

Review https://www.accessforums.net/code-re...end-33331.html

[ssanfu]

Nope.
It doesn't matter if it is an accdb or accde, the file must be replaced.
Don't have to delete the old file - can just copy over it.


Edit - I see that June provided a link to do auto-updates. I was looking for a link like that for you.

[Ranger7913]

Thank you very much for the help.