Search results

I have the following expression in a Totals query. The error message I'm getting is "This expression is typed incorrectly or is too complicated to be evaluated...." 12MoChgs: DSum("[Charges]","[AR_Rec]","[Month]">=(DateAdd("m",-11,[Forms]![frmAR_RecDialog]![RptMonth]) And...

I have a form (frmBatchInfo) which captures Charge Batch total information (ie, total $ per batch). This form contains a subform (frmSubFormVisitDetail) which captures the $ per visit. The sum of the $ per visit should equal the total amount entered in the main form. Therefore, I want to...

I'm trying to add a calculated control to a form which includes 4 fields from my main form and one from a sub form. I can't figure out how to refer to the sub form control in the expression - here's what I've tried...

I currently have a query that calculates each Department's "Daily Average Charge as follows ([SumOfCharges] / 365). Here's the problem; 2 of the departments are new to the system and don't have 12 months of charges - so we want to divide their total charges by the number of days they've been...

I have a form which contains several controls, including command buttons and one subform. There is quite a bit of code in place to validate the data. Unfortunately, so many fields have been added that I now need to use a tab control with two tabs - I've divided the data entry fields between...

I have a report which is based on a query which uses totals. I want to add the "Comments" field to the report - which of course is a Memo Data type. The only way that I've found to be able to do so, is to select "Last" as the Total Category. However, this will only give me the last comment...

I put a control on a report that simply concatenates the values of two fields (Division and Section). Here's what I have =Trim([Division]&" - "&[Section]) It returns #Error. I think the problem is the name of the field - "Section". I experimented by replacing the Section field with another...

I have a subform named frmReturnedBatches on a main form named frmCloseBatch. Basically, if a batch is being returned due to problems, the user must enter a date of return. The subform is a tabular form which allows users to enter several reasons for the return into a field named [Problem]...

I have a combo box on a form which allows users to select only those Divisions ([Div_ID]) which have a current status of "Active." To do this, I've set the combo box's underlying query criteria for the [Inactive] field to "No". Here's the problme. After a Division status is changed from...

I need to identify criteria for a report dialog box. There are three fields in the criteria (dept, section and billing area) and I can't seem to get the syntax right. Here's what I have: strWhereCriteria = "Div_Name = """ & Forms![frmReportDialog]!cboDept _ & """ and Section = """ &...

I have two forms which are linked via the primary key ([Control#]. Users enter a Received Date in the main form and then later enter the Date Closed into the linked form. The main form is called LogBatch1 and the linked form is called frmCloseBatch. I'm trying to enter validation criteria in...

I have have two forms - frmLogBatch and frmCloseBatch. The user enters a DateReceived on the form frmLogBatch and then later enters a DateClosed on the frmCloseBatch. I have a command button on the frmLogBatch which launches the frmCloseBatch and links the two forms via the Control# field...

I'm getting a syntax error in one of my modules and I think I know what the problem is but don't know how to fix it. Here's the syntax: Dim strWhereGroupDivision strWhereGroupDivision = "Division = """ & Forms![frmDialog]!cboSelDivision & """ and Group# = """ & Forms![frmDialog]!cboSelGroup &...

I'm using Access 2000 and I'm not able to import data or create a chart. The message I'm getting is "There is no object in this control." Since there is only an "OK" button in the message box, I'm not able to reference any help files associated with this error. The spreadsheet I'm trying to...

I have a Report who's record source is determined by the selection users make in the corresponding Report Selection Dialog box. The same Dialog box also requires users to select [ReptBegin] and [ReptEnd] dates. The report is grouped by the [ReferralSource] field and a page break is forced...

I have a Dialog Form which prompts users to select any filter(s) they want applied to a report. The two filters are based on the "City" filed and the "Status" field. Users can chose not make no selection (print without a filter) or they can chose one of the two filters - or they can chose...

I produce two reports which use the same report grid (object). In order to select which report you want to use, I have a dialog box which list the selection. Depending upon the user's selection, I inserted a text box to serve as the report label which uses a simple "If" expression (if...

I need to add a control to my report which calculates the total hours required to complete projects. I have two date/time fields - one for both the date & time logged in and one for the date & time logged out. I added a calculated control which successfully calculates the difference, in hours...

I need to add a calculated control to my report with calculates the difference in hours between two dates. However, the problem I'm having is that the calculation must exclude Saturdays and Sundays. We need to track the # hours it takes to complete work in our department. I have two...