Recent content by oop94

while communicating with the OLE server or ActiveX control: - The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure] - There may have been an error evaluating the function, event, or macro.

I added a command and set the on click event to [EventProcedure] and for some reason it gives me an error message. Thus, I does not even make it to the code. Any ideas?

I am not getting any messages but I cannot step through (I bet I am missing something). It's the "InputScreen" form, and the macro is the printer next to the "Operating Mechanism" textbox.

I think it is not even making it to the code because I added a STOP command and it never did :S

For some reason this is still not printing only what it's shown on the screen. Should I do some kind of query definition? I was just wondering if I was missing something because OperatingMechanism is a table that is linked to the main table. So it is just printing all the records in the...

This is giving me one too: DoCmd.OpenReport "OperatingMechanism", acViewPreview, , "[OperatingMechanism =]" & OperatingMechanism.Operating_Mechanism & AAAAAAAAAAAAAAAAH

Thanks traingamer. Do you have any idea by this code is giving me an error? DoCmd.OpenReport(OperatingMechanism, [acViewPreview], , "[OperatingMechanism =]" & OperatingMechanism.Operating_Mechanism &,)

For some reason it does not like the percent sign: oSQL = "SELECT*" FROM TableInfo WHERE Caption Like "' & strTarget & "%'" oResults = oSQL.Execute Any ideas...

I did not fix it. But thank you for trying.

Should this code work (because it isn't really): Private Sub Print_OperatingMechanism_Click() On Error GoTo Err_Print_OperatingMechanism_Click 'Dim stReportName As String 'stReportName = "OperatingMechanism" DoCmd.OpenReport "OperatingMechanism", acViewPreview, , "Operating...

I have never done a filter. I am very new at this. So, may you help me witht that?

Hi, I have a form that loads from a menu option. The form has two subforms. All the specs are divided in groups within the forms and subforms. The forms depend on 3 queries that have all the tables correctly gathered. So, every title has a little print button next to it if the user wants to only...

Thank you :)

Hello again, I created a form from a query which before loading all the controls asks for the Item ID (parameter). This form has two subforms that depend on another two queries; since I want them to show the info for the same item, all three ask for the Item ID, which can be kind of annnoying...

Hello Thomas, I am very new at VB, so I was wondering do I have to declare the variables in a specific special manner, given that they will be part of an array?