Search results

I absolutely hate the 2010 ribbon. The whole backstage concept is bad. I like it in 2007. I modify the ribbon without any issues, and all of my navigation in this project is done in the ribbon. I've removed as much of the defaults as I can. The only default navigation I have not been able...

Here

I fixed this already by setting dirty to false. I'm not sure how this is required though.

I have an odd error occuring. I have two forms. One is frmOverview and has four subforms that give a synopsis of different missions. These subforms have hyperlinks that go to the frmMissions were data is added or edited. If I use the hyperlink to go to MissionID=1 and try to edit any field...

Don't waste your time. Having unused queries wont hurt anything. If you do go and change a bunch of stuff, make sure perform name autocorrect is off.

I'm not sure how else to help. This attachment has object names you are using and works fine.

I showed you how to do it in the sample I uploaded. If you can post an mdb I will help.

Your doing this: Forms!frmHome!frmDataSource.Form!frmDay1.Requery You need to be doing this: Forms!frmHome!frmDataSource.Form!frmDay1.Form.Requery In the first version, you are attempting to require a subform CONTROL. This is the object that houses the subform, and it cannot be requeried...

Unrecognized database format. I'm using 2007. But I showed you how to do it in my last post. You should always develop in the 2000 format to avoid issues like this. I only upconvert to the 2003 mdb version to make the mde. I don't use accdb at all. Microsoft was stupid for not changing the...

I suppose it should have been more like this: Forms!Form1.[Table1 subform].Form.[Table2 Subform].Form.Requery Here is an example. Open Form1 and Form2 and Table2. Add a new record to table2. Close the table, then click the button and the requery works.

Hmm...if you post a stripped down version I will get it for you.

Are frmDataSource and frmDay1 the name of the forms or the form's subform control?

I don't know about that but Microsoft has free software called Sync Toy. It works quite well.

You are referencing the subform incorrectly. First of all, it helps to understand the difference between ! (bang) and . (dot). The ! means you are talking about a field while a . means you are talking about method or property of an object. I'm sure someone will correct me on this though...

The inside width is 8568, which is slightly smaller than using the width of the subform control, so the result is about the same. I think the issue is that I can't tell the size of the subform once the anchoring is applied. edit- I think I got it now. Using inside width on the resize event...

I have a datasheet subform anchored to the bottom right. I want the columns in it to stretch across the whole subform. Am I able to do this? The line that is printed is: 8580 8579 but there is still plenty of room left in the subform. Private Sub Form_Load() Me.MissionID.ColumnHidden =...

So I am home now and I can duplicate the network at work. How do you propose testing the form? Also, is there a way to fill tables with dates, times, and lorem ipsum text to generate thousands of records? At work, the data was imported from other sources and goes back to 2000, so there are...

Have you ever modified the database in a newer version of access? Can you try to open it in 2013?

Did you try importing the objects into a new database one item at a time? It is probably just one form that is giving you trouble.

Is it proper? Define proper. It is great for some things. I would say it is great for small businesses, for rapid solutions, and to teach people how to code. Outside of this, other solutions are probably better.