Search results

It sounds to me like Access has been damaged. In your Control panel (Add/Remove Programs) try to re-install Access, see if this helps. IMO

See if this works. IMO

You forgot the attachment IMO

Try importing all your tables, forms etc. into a new blank db. HTH IMO

Picked up by the Police , these are some of the comments made by the drivers 1. I can't reach my license unless you hold my beer. 2. Sorry, Officer, I didn't realize my radar detector wasn't plugged in. 3. Aren't you the guy from the Village People? 4. Hey, you must've been...

IMO

Try exporting the table or query the report is based on rather than the report itself. IMO

Create an unbound text box on your form and in the on click event of the list box put... Me.YourTextBox = Me.YourListBox.ItemsSelected.Count In the click event of your print preview button... Me.Form.Visible = False and in the OnClose event of the report...

Private Sub YourButton_Click() FollowHyperlink "C:\MyDocuments\YourExcelBook.xls" End Sub Code is more flexible than a macro. HTH IMO

Here you are. IMO

Maybe you could adapt this example db. Don't know if this will make a difference though. IMO

Create an unbound text box in the detail section of your report and type the control source as =1 and change "Running sum" to "overall". HTH IMO

Sorry, misunderstood. Try this... DoCmd.OpenReport stDocName, acNormal, , "ID = Forms!YourformName!ID" IMO

Create a query with the same field names as your report. In the criteria of your "ID" field put... [forms]![yourformName]![ID] Now change the reports Record Source to the new query. HTH IMO

See here IMO

Glad you got it fixed, here's what I was going to suggest... DoCmd.OpenForm "frmInputtbl2004Expense", acNormal, , , acFormEdit IMO

Post the code behind the button IMO

To add another field do something like... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.YourField < 0 and Me.YourSecondField < 0 Then Me.YourField.FontBold = True Me.YourField.ForeColor = vbRed Me.YourSecondField.FontBold = True...

Sorry, my mistake, get rid of the " " from around the 0. IMO

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.YourField < "0" Then Me.YourField.FontBold = True Me.YourField.ForeColor = vbRed Else Me.YourField.FontBold = False Me.YourField.ForeColor = vbBlack End If End Sub...