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?

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

: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...

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...

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...

My database is on a shared server and many people are able to access the database at any time. What would be the best method to create a way for me to make design changes, etc. without having to make sure everyone is out of the file to allow me to open exclusively?

My problem started when upon running a macro that runs a report, the message "Record is Deleted" was returned and thus the report did not run. This is very strange because it worked ten minutes prior. Upon further research, I found that the table that is queried for this report could not be...

I need a query to look between two dates. The first date needs to be the first of the month of date given in [forms]![frmflash]![enddate] and the last date needs to be [forms]![frmflash]![enddate]. How can I make a between statement that looks between these two dates? Thank you in advance.

Each record in my table has six possible sale dates as a result of cancellations. My problem results when a record is sold twice during the queried time frame (SaleDate1 and SaleDate2). Currently my query uses an if statement and if they are in the same time period, it will only return...