Search results

I had copied this code from another database I did years ago and that report opens in print preview 🤷‍♀️ maybe it's just a glitch

Hi. I am getting 2 as the result

Hi Tom, The ProjectID is an autonumber which I have formatted as "P- "000 to distinguish it from any other autonumber fields I may have in other tables. The DwgNo is alphanumeric and is noted as shown on the drawings. Ideally, I would like to sort by project but right now I only have one...

Hi. The revision box of the first edition of a drawing is usually left blank by the design consultant, however, for it to show in the report, I enter a dash ( - ) in the database to indicate that this was the first drawing. If I don't enter anything in the field, it will not show in the...

Hi, I tried the code you provided but when I run it I am being prompted to enter the ProjectID and then the report still opens in report view instead of print preview.

Hi, I have a hyperlink on a form to open a report. The below code is what I entered in the OnClick event on the form. I also have the default view for the report set to Print Preview, yet the report opens in Report View. Please help. Private Sub prntRevHistory_Click() Dim strWhere As...

I'll try this too!

No I haven't. Will try when I get home and let you know if it worked.

Thank you. Your explanation helped me understand why I was getting the incorrect count as the recordsource, which is a query, would have the drawing listed every time it was revised. I will keep the Dlookup to the query I did previously counting the number of drawings per consultant.

Thank you. That's what I've done, I was just wondering if there was another way to count the records within the report.

Good afternoon. I have a drawing register report which lists each drawing for a project and the revisions per drawing. I tried adding a count of the records per design consultant in the group header to show the total number of drawings issued per consultant (not counting the revisions per...

Good morning. I am trying to create another images database and was wondering if the type of form - Form1 in post #15 above - could be used as a sub-form? I tried by creating a main table where I would enter the project details and report date and then link it to tblFiles but when I tried to...

Thank you both! This is a great help.

Hi, I've attached the DB. It's not much, I was just trying to get the codes and modules to work so the data in there is test data. Nearly all the pictures in the current form were taken in portrait orientation and are showing as landscape in the form and report. I'm not sure if the...

Ok. I made the change. No error message this time but the image is not rotating either.

Hi. This is the full code I saved to my database. Private Sub Command55_Click() Dim strPic As String, strPath As String Dim blnRotate As Boolean strPath = "c:\Users\" strPic = Me.Image23.Picture blnRotate = WIA_RotateImage(strPath & strPic, 90, strPath & strPic) Me.Image23.Picture = strPic End...

Hi, I'm getting a compile error when I try to run this - "Expected variable or procedure, not module" and the below line of the code is highlighted. [blnRotate = WIA_RotateImage(strPath & strPic, 90, strPath & strPic)]

Hi, Just following up on the above request. Can someone help me with this?

Good morning. Sorry for not responding sooner - I was out of office for the majority of yesterday. I'm trying to understand how get this to work. I saved the module but how do I select the specific photo? Do I go back to the form and select it there? I have little experience with modules so...

Good morning. I reposted my question in the reports forum.