Sub-Forms data not saving

I have a Main form with a Tab Control with a number of bound Sub Forms, each on several tabs.



I create a New Record on the Main Form and then move to another tab and then add data to a subform on a tab on what will of course be a New Record.



Despite using the Docmd.RunCommand.accmdsaverecord line, I find that I cannot run a report from this new data unless the Main form is closed.



Essentially, the sub-form data is not creating a new record in its table until the Main form is closed.



Does anyone know why this is? I have even tried to force a Save by setting the subform to Dirty before the Docmd.RunCommand.accmdsaverecord on the subform.



It seems that I have to close the Main Form for the subform new record to be saved to the table.



If it helps, I am using a Custom Ribbon UI although I cannot imagine what this would have to do with it.



Thanks

Sub-Forms data not saving

Updating a large table

This really isn't a large table by Access standards, as it has only about 1 million records, but nevertheless it's taking a long time to run the update query. Here's the query:



UPDATE [Db] INNER JOIN [Small Table] ON [Large Table].text1=[Small Table].[text1] SET [Large Table].[text2] = [Small Table].[text2];



[Large Table] has about 1 million records and [Small Table] has 10 records.



Can someone please suggest a query that will run quicker?



Thanks.

Updating a large table

How To Perform Search From Navigation Form

OK, do I just learned about the new feature in Access 2010. I have my setup all complete and everything works great. Now, I have a subNavigation form within the Navigation form. Thing is, I am not sure how to go about the code for the query to pick up the Beginning and End Date to generate my report. Here is my Form setup:



frmNavigationForm (Main form) - Tabs on top.

NavigationSubform (first Navigation Form, where I have a tab called Admin)

frmAdminNav (where I have embedded under the Admin tab) - Tabs on left side.

NavigationSubform (Second Navigation form where I have a tab called "Search") I don't recall what the name. How do I find it, stupid question, I know...

frmSearch (where I am trying to pull a detailed report from date search criteria)



Here is one of the codes I have been trying to use in my Query and nothing seems to work.

Code:

---

Between [Forms]![frmNavigationForm]![NavigationSubform].[Form]![frmAdminNav].[Form]![frmSearch]![BeginDate] And [Forms]![frmNavigationForm]![NavigationSubform].[Form]![frmAdminNav].[Form]![frmSearch]![EndDate]

---

Any ideas?

Thanks

How To Perform Search From Navigation Form

Button to launch a form from a report

I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row.



I tried the VBA code like this on the View button on click method:



DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID



Of course, what happens is it opens the form CreateCAF with the first ItemID in the report, regardless of which row you click on. I want it to pick up the ItemId of that row.



How do I do this please? :)



thanks

James

Button to launch a form from a report

Export report to powerpoint

hi

I want to export report to powerpoint in Access 2010

Export report to powerpoint

Delete records in subform based on checkbox in parent form

Another issue that is probably easy, but for some reason did not manage to solve it on my own.



I have a parent form and connected to it is a subform. On the parent form I have a checkbox which enables and disables fields on the parent form and also hides the subform, as you can see in the attached screenshots.



What I want to do is when the user unchecks the checkbox, this action also deletes the associated subform records, if there are any.



I'm sure that this can be done with an SQL Delete query in VBA, but for some reason I was not able to figure it out.



Any help will be much appreciated. :D

Attached Images

	SubformIssue1.jpg (78.6 KB)
	SubformIssue2.jpg (38.6 KB)

Delete records in subform based on checkbox in parent form

Help with Forms

Hi, My name is Prasad. I am a novice in MS Access. I use Access 2010. May I explain what n how I am stuck. I am a sales man in a book publishing house. We give sample copies of our books to various teaching faculties in different institutions. I am trying to maintain a database of the names of the professors whom I gave the books and which book. My revisit cycle to the same institution will be every 4 to 5 months. During our next visit also we would have given the same professors some new titles.



I have tried to create a access programme with the following tables.



1. Institution Table

2. Book title table

3. Sample books table (fields: Name of the professor, department, Designation, Phone number, Email ID, book sampled ( Title fetched from Book title table), Institution details (fetched from Institution table))



It worked well during my first visit. But now, after my second visit, I am finding the following problem:



I need to re-enter all the details of many professors whose details are already existing in the database (entries made thru a form), is there any way where I could fetch the details as I enter a professors name who already exists.



Looking forward for your response



Kind regards



Prasad.:banghead:

Help with Forms