Recent content by Erik

I did create a query modifying the code you gave me, but what it returns is the number of records each month. I am looking for the number of days in each month that have loading records. For example, there would be 30 or 31 days in each month, but we might have loaded only 20 days. That is...

Thanks for the help, but are you suggesting that I group By On Month in the query I build? I have reports that group by day, but then I have to manually count the days in a month. I'm not quite understanding if this can be done in the query. I have a test query with the Totals tool in view...

I've been searching the Queries Forum for help on this issue. I have a database that records loading records for a Taconite facility. Some days contain many records and on other days there are no records because of no loading activity. I create reports that group these loading records by each...

Larry: Thanks for telling me how to work with Detail and Format. That has saved me. I simply put this code in there: Dim DBpath As String DBpath = [Forms]![frmUpdateRecord]![Path] 'If Dir$(DBpath & [ID] & "_1t.bmp") = [ID] & "_1t.bmp" Then Me.MyPic.Picture = DBpath & [ID] &...

Larry: I do not see the Detail_Format event. I only see On Open, On Close, On Activate, On Deactivate, On No Data, On Page, and On Error. Can you tell me how to get the the Detail_Format event? Thanks for you help ... Erik

In this case, the field that contains the unique ID number that links to the image is called "ID". Is that causing a problem? If so, I can change the database to have it called something else.

Linking images in reports The code that you have posted is probably what I am looking for, but I am still struggling to get it to work properly - probably confused on something. Below is how I have modified the code to work for me in a report that runs - the report needs a signature for an...

I have a report that is actually a letter generated to a specific individual identified by the database and to be signed with a signature on file as a bitmap image. I have created an image frame as you outlined previously in the report, but it is not in the footer - rather it is in the detail...

Can you tell me what the HasData method is and how to use it?

Yes - they are linked as far as I can tell. The Link Child Fields is [ID_Link] and the Link Master Fields is [ID]. I'm running this report again, and now it seems to be working correctly. The subreport with data displays, while the subreports without data only display the report label...

Hello: I have a pretty complicated report. It has five subreports within it. I used Access's Report Wizard to begin building the Report and then Finished it in Design view. The main part of the report is in the Users.LastName.Header section. Employee Work Assignments are in the...

I want to determine the time of day when a user to the database I am developing logs on. If the time is between 07:30 abd 15:30 the database will know that this is the "First" shift and make a note in the data record that is in view. But I am having trouble writing the correct conditional...

Bill: Thanks - your code worked beautifully - and I really appreciate your help. Erik Cross

I have a database in which a query creates a text entry in a field which is used to show the path to a linked file. This path needs to be transferred to an adjacent field in the form in view which is a Hyperlink field. One can simply copy and paste this text and the link works. However, if I...

I figured this out by taking bits and pieces of code from other posts similar to my problem. The answer was pretty straight forward, so I probably was not explaining what I needed clearly enough. Here is the line of code that does exactly what I want to do, and it does it perfectly...