Search results

The following code is applied to the On Current event for a subform called SubContracts. If Me.ContractID <> "" Then Me.Parent.SubMeters.Form.RecordSource = "SELECT * FROM Budgets.MetersXContracts WHERE ContractID = " & Me.ContractID...

Is there a way to make the criteria for a query pull from excel? I have an ODBC link in Excel from a query I have in Access. I would like to be able to change the dates the query uses without going into Access to change the query. Is this possible without an extensive knowledge of VBA?

Clarification Allow certain users to have access to a field while others can't.

Is there a way to limit access to certain fields in a form without creating an additional form?

Thank you! I missed the most logical explanation. The formats got changed after some table exporting/importing. Thanks again.

:confused: Below I have listed the WHERE clause of my query. For this example, the start date and end date mentioned are 4/1/08 and 4/15/08 respectively. I am getting results that are between 4/1 and 4/15, but for different years. The odd thing about this is that this query has worked fine...

I am trying to use a combo-box on a form to limit/select records to be displayed on report. I would like to have the option of "All/Any" in the drop-down list. If All/Any is selected I would like the report query to allow all records with any result in that particular field. I hope this...

I have a query based form that will allow me to change fields in some of the records, but not all. For example, there are 100 records returned and on the first I can enter/change data in the date field. On the 5th records I cannot enter/change data in the date field. Any suggestions? Thanks.

How can you have a Yes/No format to display simply Y or N on a report? Thanks

I have a subreport in my report footer and I am trying to get the subreport to have page headers on every page except for the first page. The page headers do not appear at all on the subreport. When I run the report alone, the header shows up, but not when it is a subreport. How do I fix...

I would like to create a report like the following: Record1: Record2: Record3: Total: Field 1: Field 2: Field 3: Field 4: Field 5: This is the opposite of standard reports and I can't seem to find a way to do this.

I have a form where sales can be entered. Whenever a [salesdate] is entered, I would like the [status] to automatically change to "Sold". How can I go about doing this?

How do you format a date to display on a report as mm/dd/yy and not mm/dd/yyyy?

Is there a way to have a song play when a form is opened?

I would like to create an AutoExec macro to display a picture for 3 seconds or so when my database is opened. The best way I was able to come up with was to put the picture on a form and have a macro that opens it. How can I have the macro wait three seconds after the form is opened prior to...

Continued One home can be sold and cancelled, and then sold again, etc. I guess the only thing that I am really struggling with is how to make the date range I am looking at to be from the first of the month to the end date. For example, if the report that is trying to be run is between...

I am trying to run a query on a table [tblMain]. I have an input form where the user enters a date range. I would like to count the Month to Date Sales. The month would be that of the end date (forms!frmflash!enddate). How could I count the number of sales between the first of the month and...

Continued.... That makes perfect sense, but when I run the query now I get the error message "This expression is typed incorrectly, or is too complex to be evaluated...." I checked the spelling and that is not the error. What can I do to fix this? Thanks.

I have a report that I am trying to create that is returning some strange numbers. I am trying to count sales from an entered time frame. The first query counts the number of sales between the start date and end date that the user enters into a form (see below). The second query counts the...

Continued Would I not still have to make sure nobody is in the Front End before I could open-exclusive and make changes?