Search results

Does anyone know where I can find a list of error codes for Access? A user had a problem in one of my databases today. When I compacted/repaired it using Access' utility I received these errors in a table called MSysCompactError: -1206 Could not find field 'Description' -1053 Could not find...

Yes, that did the trick! Thank you SO much. I had tried putting that code in other events on the report, but not the header. Whew! Thank you again...Laurie

Thanks! I will give that a try ... I was just about ready to give up on this one! Will let you know if it works...thanks again...Laurie

Thanks for your response. I did as you suggested, but my title comes up blank on the report. Below is part of the code I have on my form button. On the report I have an unbound text box with the name "txtTitle". Any ideas why this isn't working? I checked the line MyReportTitle =...

I have two forms where the user can choose what should appear on the report. For example, the user can select a date range or a date type. On these two forms there are several text boxes that fill using VB Code, depending on what is chosen on the form. One of these text boxes (txtReportTitle)...

SUCCESS!! I tried making a new query as you suggested with only the SQL statement and received an error that my Where clause had a problem. I checked my SQL book and the problem was with the field name "Group" which is a reserved word in SQL. I changed the field name and code and everything...

Yes, those fields ARE in the query already. Thanks...

Just to let you know ... that doesn't work. I don't get any names in my combo box; it's totally blank. Have tried it in many events and alterations, but no go! Thanks anyway...

Thanks for your suggestion ... I'll give it a whirl!

I have a form where the user selects the records they want to see before going to the data entry form. The code on the selection form is on the On Click Event of a frame and is as follows: If frameSelectSite = 1 Then DoCmd.OpenForm "frmDataEntry", , , "Group = 'Central/Scat Management'" Else...

Doesn't work I already tried the "DoCmd.SetWarnings False" and it doesn't work. I still keep getting this "The DoMenuItem Action was canceled" error box after my message box closes. Any other ideas?

I have this code on my form's BeforeUpdate event. It is checking to make sure 2 required fields are filled before saving: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Status) Then MsgBox "Status is required; please select a Status from the list.", vbExclamation...

Never mind! I figured this out...never mind. Here's what I've got that works just fine: Private Sub StatusDate_BeforeUpdate(Cancel As Integer) If Month(StatusDate) = 1 And Day(StatusDate) <> 31 Then MsgBox "Date must be end of month", vbExclamation Cancel = True End If...

I need to check a date field to be sure the user enters an end-of-month date (e.g., 1/31, 2/28, etc.) I've started writing the code, but keep getting an error about saving the field. I don't want to save the field. What I want to have happen is: if the date is not an end-of-month date, show...

I figured out why jatfill's code doesn't work. It's because my concatenated Name field had a space in it and was not null. When I say IIf([ContactName]=" " ... then it works. Glad I figured that out; what a struggle!

This is what I've found now ... the code from jatfill works fine IF you just use records from straight from a table. I am getting my report data from a query, that is combining [Last Name] and [First Name] fields to make [ContactName]. This must have something to do with it. Anyone have any...

I don't understand ... my text box is named "text2". I am typing the code into the control source of the text box. Is this incorrect??? Thanks....

I've already tried all that stuff ... it doesn't work. If there is no name and a title it puts a comma space and title like this: , News Director !!! That's why I tried the function thing. Thought it would be easier! Ha! Any other thoughts or ideas? Thanks for your help....

I am trying to format 2 fields on a labels report and can't quite get it... The 2 fields are ContactName and Title. If the ContactName is blank, I just want the title and vice versa. But if both fields have data, I want to put comma space between them. This is what I have currently as code...