Search results for query: *

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?

Hello everyone, I would like to create a "search engine", through a macros if possible, so that the user can find the one thing among the hundreds of specs available to them in a form/subforms assembly. My form has two subforms built into it, hence it can be really time consuming to find the...

It's in Access . . .

Hello again, I have a report that is 3 pages long. When users check out a form and click the print button, the report is printed (I have a macro doing the work on the background). I was wondering if there is a way that the macro would ask the user which pages of the three he or she wants to...

Hey there! I made a form where I added two command buttons. The user is supposed to be able to click the command button and have the report Print. I was right-clicking on the command button and I was trying to write the code, but I am very new at this, so I think I messed it up and made it...

I am trying to create a folder inside another newly created folder. First, I create a folder named 'newvolt' using the _mkdir function: _mkdir(newvolt); Next, I try to create a subfolder named 'SG019810002-500' inside the folder 'newvolt' using the _mkdir function once again...