Replies

I had another gentleman check it. It worked for him, but like you he was working with 2010 version of PPT. I tried on another 2007 machine with the same results. I checked the trust settings they are okay. I recreated a new PPT. It just doesn’t work.

Ok. I created the macro. Created an action button and assigned the macro to it. Test drove it with no crash, but didn’t get across the line either. In slideshow view I clicked a link to the Excel spreadsheet, changed data, closed and saved Excel, clicked the update button, the mouse spun, went to the next slide and the old data remains in place. If I go out of slideshow the data is automatically updated as you would expect. But I need it to do that in slideshow view.

Any further ideas?

Thanks.

Fay

Bless you. That was it. Thanks for hanging in there with me. Fay

Go ahead and send it to fay@awarenessproductions.com
I haven’t seen the PM come in. So try this address.

I tried to send it as a zipx file (latest version of winzip) and got a message that it was an illegal file type. This was after I tried to send the basic file without zipping. I got the same illegal file message.

I just brought in the older version of the database, changed the Trust settings as instructed earlier. The tab control pages work on the main form. But…
None of the buttons work.

Is there some type of control in Access options that would make buttons inoperable?

Can I send it to you via email?

Thanks for hanging with me. I really need to get this fixed so I can get this database developed.

Fay

I was redeveloping the database to make it better. But I used the coding that I used before and I am getting no where.

I let the computer completed the coding. I typed Me.frm and the options for the various forms were displayed and I was able to select it.

I wasn’t able to get the code that RetiredGeek offered. I am really getting frustrated.

Here is my code for the main form and the buttons on it.
The visible property on the property sheet is set to yes. I have changed it to know and tested it with success.

Option Compare Database
Private Sub cmdClasses_Click()
Me.frmCE.Visible = False
Me.frmClasses.Visible = True
Me.frmLearner.Visible = False
Me.frmMaintenance.Visible = False
Me.frmProviderUnit.Visible = False
Me.frmRegistration.Visible = False
Me.frmReports.Visible = False
Me.frmResources.Visible = False
End Sub
Private Sub cmdLearners_Click()
Me.frmCE.Visible = False
Me.frmClasses.Visible = False
Me.frmLearner.Visible = True
Me.frmMaintenance.Visible = False
Me.frmProviderUnit.Visible = False
Me.frmRegistration.Visible = False
Me.frmReports.Visible = False
Me.frmResources.Visible = False
End Sub

Private Sub cmdMaintenance_Click()
Me.frmCE.Visible = False
Me.frmClasses.Visible = False
Me.frmLearner.Visible = False
Me.frmMaintenance.Visible = True
Me.frmProviderUnit.Visible = False
Me.frmRegistration.Visible = False
Me.frmReports.Visible = False
Me.frmResources.Visible = False
End Sub

Private Sub Form_Load()
Me.frmCE.Visible = False
Me.frmClasses.Visible = False
Me.frmLearner.Visible = True
Me.frmMaintenance.Visible = True
Me.frmProviderUnit.Visible = False
Me.frmRegistration.Visible = False
Me.frmReports.Visible = False
Me.frmResources.Visible = False
End Sub

The message box displays as you would expect.

No I didn’t know anything about it. Thanks.

Unfortunately it didn’t make it work.

Fay

I put it in the report header. but now the header is creeping on to the first page.

One simple solution is to put the Label into the subreport itself, in the Report Header.

I was going to do some testing, but when I look at my samples I find that is what I usually do.

Sorry my brain must be on vacation. It is a subreport. Not a grouping.

Sorry I am still not clear whether you have a report with Subreport(s) or a report with Grouping.

If you have Grouping , then in the Group Header you can specify whether the header should be kept together it with its section.

The system won’t let me upload an image at the moment, so I can’t show a screen shot.

You can specify :

[*]do not keep together[*]Keep with first detail record[*]Keep whole group together

Sorry. It is a report.

It sounds like you are talking about a report, but you mention subform? Is it a subreport?

Thanks Wendell for your time and information. You given me a great set of marching orders. Now I will see what I can do with them.

There is a way – and I presume you are still working with Access 2003 – Access 2007 has a feature that makes it easier. In 2003 you need to have code running on the form Load or Open event that sets the Order By property. To do that you will probably need to track the user and store what field an in what order the sort is being done on. It will require some experimenting to get exactly what you are after – and you probably want to make sure that each user has their own copy of the database front-end.

To automatically enter records based on a major item being entered, you will probably want to create a VBA procedure based on the After Insert event that uses DAO (or ADO if you prefer) to create each of the subitems as you suggest. If you aren’t familiar with DAO or ADO, you can do it by running an append query that takes all of the subitems for a particular major item and appends them with the appropriate linkage. Using that approach I would create a table that contains each of the subitems in a sample form and then select from that table based on the major item entered. This does get a fair bit more complicated if you are actually trying to do “project management functions” where you would need to track due dates and precedences. If you have further questions on either approach, post back.

That didn’t work. Thanks for the response and your time.

Try:
txtDCDate = Null