Search results

Thanks Pat I'm still getting an error message, but this time its a syntax error. The Control# is not a date field, the DateClosed and Date Received are the date fields. So I tried to put the pound signs around thos fields and that didn't work either. Any other suggestions. Thanks again.

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

Thank You....Thank You....Thank You It worked!!! Fran

Thanks IIkhoutx, but I tried both variations and neither is working. Do you think the string variable is the problem. Obviously I don't know what the problem is, but I'm thinking that it's because the group# field is a numeric data type while the division field is text. Any other suggestions?

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

THANK YOU BarkerD - it worked perfectly. Eventually I'll get this VBA thing down....with help from people like you that is. Thanks again

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