ms access runtime 2017 compact and repair

This means that problems don't arise until run-time. will cause such references to be interpreted when code is compiled. I recently posted that using Me ! will cause late bound interpretation of the reference, whereas Me. because Access can/will decipher this as a variable as in Me.comboSN.Value = Null, or better yet, Me.comboSN = NullĪgain, not properly referenced (which may be the reason for your error). So you are passing what looks like a form reference to a variant type of variable These are all variants because they have not been explicitly declared otherwise: I'll assume this is just a posting error and is in fact, 2 lines

Sorry to say many errors and omissions in this code, some of which definitely can cause your issue IMHO. 'comboSN.RowSource = 'SELECT DISTINCTROW. MsgBox ('You Must select a Gage Serial Number') If FrameGageType.Value = 4 And IsNull(Me!) Then If FrameGageType.Value = 4 And Not IsNull(Me!) Then Anyone have some ideas?Ĭode: Option Compare DatabaseOption Explicit I'm really at a loss as to what could be happening here, especially because it is only a problem for my user profile on this one particular PC. The error will occur even if the event code contains no commands other than a beginning/ending statement.If I delete code for the Form_Open event, or if I delete '' from the Property Sheet, I will get similar errors for any following events which are shown in the Property Sheet as ''.'The expression On Open you entered as the event property setting produced the following error: Variable not defined.' Switching to any other view will produce the error:.I can manually open the offending forms in Design View.Error 2501 is triggered at an OpenForm command from the calling form.After some extensive debugging this is what I can observe: I don't have a much Access experience, and I'm not proficient in VBA, but I know enough to get around a bit. I have heard reports about the default printer causing this problem, but switching to another default printer has no effect.

Since the database works for other users I really don't want to change anything about the structure or the code. To make things more interesting, if I log on as a different user on my own PC the forms work properly.

when I log onto another computer there is no problem). As far as I know I am the only one in the company having this problem, and only when using my PC (i.e. A few months ago I started having problems when trying to open some forms where the OpenForm action was being cancelled. We keep a database on a network location and it is accessed by the whole company.

Ms access runtime 2017 compact and repair