Search results

Thanks pr2-eugin. I'm attempting it in a report instead. I remember in earlier versions of Access creating customer letters and we'd use the 'TRIM" function to get rid of the address2 line if it was empty. I figure I give that a try but it's still giving me a blank. Any suggestions? I'm just...

Hi, I know how to concatenate fields in a query but have not done it with memos before. I have three memo fields and I want each to show up in one field with a bullet in front of each. Memo1 may be empty and memo2 and memo3 may have something or memo 3 may have some text but the others are...

Ahh, good eye! Thank you!

I have a form named form1. In the form I have two unbound text boxes formated as general date; startdate and enddate are the text box names. In my query criteria for the ContactDateTime field I put the following code [Forms]![Form1]![StartDate] And [Forms]![Form1]![EndDate] When I run it I...

I'm getting a Compile error: Method or data member not found and it's highlighting the Me.SPA text. Any ideas? ETA: I'm a dummy! I didn't realize SPA was the name of the tabCtl. I go it. Thank you!!

If I refer to Page 2 it does not work and gives me an error. The code below works but it hides the tab all the time. I need to hide it only if it is not an SPA. Private Sub Form_Load() If Me.AddToSPA = True Then Me.SPA.Visible = True Else Me.SPA.Visible = False End If End Sub

I just realized AddToSPA checkbox is on page 1. Do I need to do anything different?

My tab name is SPA and it is the third tab in my form. I want to hide it if the AddToSPA checkbox is checked. This is what I have but I'm getting error 'Compile error: Method or data member not found" Private Sub Form_Load() If Me.AddToSPA = True Then Me.SPA.Pages(2).Visible = True...

Estuardo, I know we are getting off topic but I appreciate you bringing the naming convention issue to my attention. I am importing data that the user gets from another application so I have no control how the column headings come into the dbase. I have to keep them the same since we append the...

Hi, I have a form with a subform. In the form header I have combo boxes for the user to filter data. I want to add a button that they would click to export the filtered records to a table. I have the following code and get the message that records were exported successfully but when I open the...

That worked! Thanks.

I run a report twice; once at the beginning of the quarter and once at the end. I need to check if the 'customer score' field has changed up or down in the quarter end report and count how many of each. I created this iif statement to assign a number to the rating so that I can then count the...

Thank you!

Yes, it's the first form listed under Forms. So when you select yes from the combo box to sample then click 'reset' you see the error. Thanks!

Hi pbaldy, I don't refer to a specific field in the form to clear them but instead I refer to the Text Box and Combo Box control types which are in the header. Somehow it is seeing a control named 'type' in my header but I can't find it. I deleted all controls in my header and ran the code...

I have the below code to reset my subform after I have filtered it using some combo boxes. One of my fields in the underlying table had a calculated field so I'd get an error when clicking the reset button. I edited the query to update the 'type' field and deleted the calculated field in the...

The tables appear to be hidden. I found these these insructions to unhide "In Access 2007, click on the Office logo (the big circle in the upper left-hand corner), go into Access Options, select Access Options (at the bottom) and look at the properties for the Current Database. About half-way...

Unfortunately I'm not familiar with pass through queries. Is there an obvious way to figure it out? I did go under table dependencies and sure enough I do see tables that I recognize as the Oracle database tables and also see the icon that you normally see in table view when a table is linked.

I am taking over a database someone else created but is no longer here. The tables are linked to an external oracle database. I know the links exist because when I run a query it prompts me for my user name and password. However, the tables look like regular tables. There is no icon showing it's...

Yes, here it is: