Search results

Thanks pbaldy. I completely overlooked that checkbox when I was linking the tables. I knew there had to be a simple solution.

I apologize if this may not be the best place for this question but I wasn't sure where to put it. I'm working in Access 2007. I have an ODBC connection to an Oracle database where I have linked to a few tables. On a daily basis I need to query the tables for a list of customers and a bit of...

It seems that CR will allow the parameter to be left null so long as the "Allow multiple values" is set to false. i.e. cannot more than one value in the field.

I have a report that contains a subreport. In the subreport I need a field where the user creating the report can enter additional information to display on the report. The text entered does not have any bearing on what records get pulled from the database or anything else. The report is ran...

I have a very similar situation as well where I need a calculated value to display in a group header. Does anyone have an answer to this?

Thank you Alansidman, that was what I was looking for. The report was being sorted by that field. I think the Grouping and Sorting was the only place I didn't look for it.

I appreciate the elementary school answer but that's just the problem, I can't find the text box. It isn't plainly visible. Is there any way I can search the database for field references in queries, forms, and reports?

I have a report based on a table. The table field names recently changed (out of my control) and when I updated the report with the new field names I apparently have a reference to an old field name that I cannot find. When I open the report it opens a dialog and asks for a value for that field...

Re: There are 10 kinds of people.......... I think the real joke here is that we all understand and discuss jokes about binary.

New development. It appears to be a problems specific to my PC as I was able to access it the exact same way through a different PC on the network. Does anybody know of some setting that would disallow connecting to the database while at the same time make it look like it's allowing it? It may...

The ODBC connection has to exist anyway. I've jumped through all the authentication hoops. The test connection is coming back successful but it isn't connecting to the tables in the database.

Thanks Bob! To complete the thread, here is the code that worked. I did have to put it in the ON FORMAT of the DETAIL section but it also didn't like the "#ED1C24" being used. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If OperationCount > 10 Then...

I want to dynamically color the text(Forecolor) of a text box in the detail section based on its value. Right now This is what I have Private Sub Report_Open(Cancel As Integer) If Counter > 10 Then DoCmd.SetProperty "OperationCount", acPropertyForeColor, "#ED1C24" Else...

I am of the "younger generation" I have heard the term Gollywog and know what it is though I've never really heard anybody use it. My father grew up in the south, they were very poor and certainly didn't put themselves above another person because of the color of their skin. Racism was a...

Works like a charm! Thanks! Could you tell me what the argument "Count" is? I understand Me means the active form and that Count is a Long but what does Count mean?

How do I get the mouse wheel to scroll to the previous/next record in Access 2007? I tried putting a GoToRecord command in the On Mouse Wheel event but this will only go to the the next/previous record (depending on which was specified in code) regardless of which direction the mouse wheel is...

Still needing an answer to my original post. Anybody? Help would be much appreciated.

I did solve this problem. I believe what was happening was that the batch file would essentially call each macro in order very quickly before they had a chance to run and there were multiple macros running at the same time possible using the same tables/queries. What I wound up having to do was...

Also, the person needing to read these instructions wouldn't understand the word "mascerated." They'd be wondering how the nuts were going to put on costumes in their mouth.

I am attempting to create an Access 2007 front-end to an existing remote SQL Server 2008 database. I created a new Access Project (adp) and connected to an existing SQL database. I entered all information in the Data Link Properties dialog and clicked Test Connection. Access said it was...