Recent content by phoenicks7

Well, I had a bit of a time following all of your code and the fact that it's in a module... so I'm not sure what the structure of your form is.... But I'll make an educated guess that the user uses a button to submit their information... I'll also guess at a few field names.. but you should...

This is probably really elementary question..... but, you ARE using a subform for the "Test Results", right? The "Tool Results" form listing the tool specs or info, and then a subform listing the individual tests (one tool to many tests)? If this is the case, then it should be a simple matter...

Is there a way (other than using Global Variables) to pass multiple OpenArgs to a subsequent form? For instance.... we have 3 different shifts listed (1,2,3) at my workplace... and when a supervisor runs a report from the startup form, would need to pass a date AND the shift number to the...

Sort of half on topic / half off topic........ JRJR stated that he preferred using queries instead of code, because it was easier. I agree.... however...... using variables is more difficult IMHO in queries... so I usually build my SQL statements in the query window.. then copy / paste to code...

Also.... did you put in the Click event for the Yes/No cbo box... Private Sub cboYesNo_AfterUpdate() If cboYesNo.Value = "Yes" Then cboMyBox.Enabled = True Else cboMyBox.Enabled = False End If End Sub

I found that I used to run into this problem quite frequently as well with linking to external databases. The work around I use is typically to load the form with VB Code INSTEAD of using a query. Simply build the query as you would normally, switch to SQL view... then copy / paste the Select...

Is there a way to get the %USERNAME% variable into Access? I am the current "designer" of an Access database, and there are certain functions that at the current time, only two of us should have access to... however, I do not want to password protect or create a security structure for the...

I'm not sure exactly what you're trying to accomplish..... but, I have a project in the works now, where we enter Operator statistics on a weekly basis (Week Beginning Monday). However, our QA department only does a Monthly Analysis of the voice records. So... from the Weekly Events Table, we...