Search results

Ok... So in trying to figure out this frustrating issue, I have discovered what I thought would stop the issue, really doesn't (pop up boxes, message boxes). I can however close the database and it works fine as long as I leave the attachment field alone. Here is what I have narrowed things...

It appears to me that it is standard behavior. I created a new DB from scratch, new forms, new table, new report. I can duplicate the issue every time centered around the attachment field. I am interested to see if you can duplicate it too... So far I have not been able to stop it except for...

I suppose it is possible. But it happens in a couple of DBs (just importing the objects though). I'll do the same and see if it is still there in a new scratch DB.

Things Tried (in On_Click Event of Reports Button): These do not correct the issue -Set focus to another control -Go to another record then back to prev -Form Refresh -Add new record -Form Requery Things found to stop the issue from happening: -Close first form then re-open it, run the reports...

This is a new portion of the larger database. The objects for this testing (forms, queries, tables, reports) are about 2 months old. This is the only table where I actually use the attachment field so I cannot answer your question other than to say, I think it has been there all along.

Kind of. There is a sample DB in a previous post. These objects are part of a larger DB but the same issue appears in this standalone. The process is as follows: Open the DB Open the first form (frm_CleanlinessTestData) When the form opens, I automatically go to a new record. This form is...

To answer your question, No. I only set tab stop to no when I hide a control. It's not really a subform. I actually open a new form, and then a report. So the main form in question is twice removed from the top object (my report). As mentioned, is only seems to happen when the attachment field...

Ok... after a while of trial and error I think I have it narrowed down. It has something to do with the attachment field. This field is usually the last thing I populate before printing a chart. When I add or remove a file from the field, and then immediately go to the report form to print...

Exactly as you described. Open the entry form...add data (what kind of data is irrelevant). I click "Reports" then click the Run chart button, the chart displays. Then I use the print icon on the ribbon. That's it. I'll work with it a little more today to test my theory above.

It works as it should in Access 2016. Meaning I add data, click reports, open the report, and when I print it, the chart is printed like I want.. When in Access 2010 at work, it prints the records in the opening form as previously described. On my long commute home, I began to wonder if it's...

Form2 has no record source whatsoever. It is only used for buttons to open the various reports. There is no primary key to reference. So it won't even compile like that. It's like the default print icon has no idea the report is open. Almost like the focus never leaves Form1, although form2 and...

Code to open Form2: Private Sub cmd_Reports_Click() On Error GoTo Error_Handler If Me.Dirty = True Then 'If changes have been made to the record DoCmd.RunCommand acCmdSaveRecord 'Save the record End If...

I have a weird thing going on and I can't seem to pinpoint the cause. I have Form1 used for data entry. I display the navigation buttons so I can cycle through records, etc. I have Form2 with various command buttons to open various reports in print preview mode. Keeping things to a...

I have been able find threads on moving/running averages etc, but is there a way to perform a moving range calculation in a query? I need to calculate the range between a current row and the previous row. Here is an example: I can certainly accomplish this in a couple of other ways, code...

Thank you! Told you it was simple... LOL

I wrote this several years ago.... might help https://www.access-programmers.co.uk/forums/showthread.php?t=221398

Sorry... The solution I ended up with was just trapping the error and displaying a message box alerting the user the name can't be changed because a file is open. Having multiple FE users and not knowing who may have the file open, this was the best solution I could come up with.

I have been driving myself insane with this, because I know it's something simple. I am building a SQL statement that requires the use of a string variable. For the life of me, I cannot get this to work. sSQL = "SELECT [lng_RecordID_PK], [txt_QMSCA_CAID], [txt_QMSCA_Source_FK]...

Hi Everyone, After some time away from developing databases, I find myself back into it. In the current database I am developing, I am trying to handle an error. I'm sure it's because I am rusty, but I need some guidance... I have a combo box that selects the type of action being recorded...

It's used elsewhere and in barcodes. Agreed. I generally don't allow deletions, but like I said sh.. stuff happens. So yep, over thinking... Max would certainly take care of that. Just a little more parsing to code. Explained in the original post. I have several "A's" - I handle them as...