Search results

Off the top of my head you could put a sub in the report open and close events to hide the forms windows... [code] Private Sub Report_Close() 'show all open forms again SetVis True End Sub Private Sub Report_Open(Cancel As Integer) 'hide all open forms SetVis False End Sub Private Sub...

As I recall you need to reference the Form object of the subform control as in: [OrgID]=[Forms]![frm_sub_orgs]!Form![OrgName]

Use .Fields("FieldName")

Use an update query, be careful what records you select or you may end up more screwed up than you started.

Cosmos.. Instead of getting your combo box to look at a table select the rowsource as 'Value List' and add "Jan","Feb","Mar" etc.. as the list. You can then use the Month() expression above to return the Month number.

Don't use the select method it is slow and visible, instead directly interact with the Range object. Range("A1") = PeriodTypeStr Range("B1") = FieldStr Range("A1:B1").Font.Bold = True

Sorry to but in... Cosmos, you can achieve the same as your table structure with this expression: Month("01-" & YourCombo & "-1999") Where Me.Combo is a value list "Jan","Feb","Mar", etc... I find it unlikely that they are going to increase/decrease the number of months in a year so this...

Why not use the dateadd function to add 100 years?

try replacing ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R2C1:R" & i & "C1" with strX as string strX = "A2:A"&i ActiveChart.SeriesCollection(1).XValues = _ Worksheets("Sheet1").Range(strX)

Use a calculated control in your original query to build the prefix and autonumber: In the column header type: MyPrefixedPK: "YourPrefix"&[YourAutonumberField] Do this for each table and then run the Union query, should work.

Tools-Options under Spelling(XP anyways), button reads 'autocorrect options'

Try Ctrl-Z after exiting and see if it changes back. It may be the autocorrect thinking too hard. If it is adjust your settings if only you use it or build a contingency routine if this is common.

Re: Re: Paragraph with a field in the middle? I would correct a little syntax as: "your candidate " & [member name] & " has been found worthy to be initiated into our illustrious order." If you want to be pedantic.

delete your object variables at end of the run and see if that helps. Set db = nothing Set rs = nothing Set xl = nothing Set objwkb = nothing Set objsht = nothing

To IgorB - you are wrong about not being able to report on two tables in the wizard, you just change the drop down to look at your selected tables and all is well ensuring the relationships are set up correctly. By building a query you are simply replicating the report wizards SQL builder...

Assuming you have a structure something like: [Contracts Table] ContractID(Primary Key) ContractWith ContractTel ContactBlahBlahBlah... [Entries Table] ContractEntry(PrimaryKey) ContractID (ForeignKey link to Contracts Table) LineEntry Works Personnel Cost Blah... and if I am reading your...

In Table Design Field: Your Field Format: "YourPrefix"# This is cosmetic only, the prefix is added at runtime for presentation purposes and is not stored because it adds nothing to the key.

I think the error will be a logical one based on your 'i' counter. Step through the code line by line using a bookmark and F8 to determine which line throws the error, I'm sure it will be either: ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B" & i), or...

If selecting them is a problem, rename them aLine1 and aLine2, they will then appear at or near to the top of the dropdown in the corner of the screen which is an alternative to selecting by mouse.

following waynes advice, instead of drawing a box use four different lines, one at the very bottom of the group header, one at the very top of the group footer, and two the height of the detail section at each end to form the sides of the resultant rectangle. When run the two vertical elements...