Search results

Not surprised, XP was so much better. I still have one at home but they insisted on upgrading me to Windows 7 a few months ago. I don't know what causes it but it is annoying. I usually don't set my reports to pop-up for this reason. You can still disable the menu by using: DoCmd.ShowToolbar...

I have had similar issues which is why if I make a report pop-up, I set the border to dialog so that they cannot be resized.

Honestly, I am running 2007 and got a message that certain features were not compatible. The startup form did not display and I am getting an error when I try to open project details (cannot read the data in jobs) To get back to the question at hand, you would not be querying a form, just the...

I should have been clearer: in your button's code, you would output the filtered query (i.e. the current record in the form) to your excel file.

I would probably make a query with the 5 fields you need to export. Then I would set a filter on the query with a control on the form (probably the PK). So, in the query you would select the field you are filtering and put =Forms!YourFormName!YourControlName into the criteria box. Then you...

Go into design view and open the report properties to the Format tab, and click on both the detail section and on the controls themselves and set them to "Can Shrink" it should make the blank lines disappear.

I see this was a double post: http://www.access-programmers.co.uk/forums/showthread.php?t=261296 @ByteMyzer did a good job of explaining why this is happening.

Clearly I don't fully understand what you are trying to do so I am giving up. Good luck :D

Ok, did you try: Me.ControlName.Name= with whatever you declared the name to be after the = sign. Then try referring to that name and see if that works. Still not sure why you are doing this though

Yes, I agree that there are valid reasons but not to change the backcolor!!

Unless perhaps you were executing a query to make a new table or add data into new fields in an existing table. That would be one reason you might do this. But I cannot see doing this just to change the backcolor on a control...

Ok, well you didn't show it. You showed: "FieldName = "Date1"" Honestly, I don't know how or why you would declare a control name in code anyway. You make the control on the form and call it something and then use code to do things with it. I have never heard of anyone setting a control...

In VBA you can simply use Me.ControlName for most things. I guess you can use Me.Controls("ControlName") but why? If you wanted to declare a variable you would do so as you would with regular vb using a Dim declaration. As far as I know, you cannot declare a field name in VBA the way you are...

The solution from that link works like a charm.

Maybe this will work: http://www.archivum.info/microsoft.public.nl.office.access/2009-01/00087/RE-GlassBanner2.PNG-image.html Mine is actually GlassBanner2.png. Wonder why yours is different... I have wanted to do this before but the image is embedded. I guess you could use the template...

I am assuming you are referring to that bar under the form's title.... That comes with the Access templates (at least it did in 2007). In mine it is called GlassBanner.png. Yours appears to be called: office.png I have never been able to add it to forms at will but have not tried very hard...

So, when you click on ReconciliationID in WorksheetList your code will look like this: DoCmd.OpenForm "frmWorksheet", , , "ReconciliationID=" & Me.ReconciliationID DoCmd.Close acForm, "WorksheetList"

BTW, use a split form for the worksheet list

Maybe I am just being thick but I don't understand why you are using so much code to do this. from what I can tell, the record source is the same. So have one form that is a list (i.e. frmWorksheetList) that lists all the records. Then, have another form that shows all of the details...

Is this a bound control or unbound? Are you sure you are referring to your control name in your code and not the field name? Also, I had this problem once and it was because of other code. Is this all of the code?