Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: oop94
  • Order by date
  1. oop94

    Problems with this piece of code

    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.
  2. oop94

    Problems with this piece of code

    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?
  3. oop94

    Problems with this piece of code

    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.
  4. oop94

    Problems with this piece of code

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

    Problems with this piece of code

    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...
  6. oop94

    Problems with this piece of code

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

    Problems with this piece of code

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

    Problems with this piece of code

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

    All the records are being printed from the form...Not only the one

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

    All the records are being printed from the form...Not only the one

    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...
  11. oop94

    All the records are being printed from the form...Not only the one

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

    All the records are being printed from the form...Not only the one

    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...
  13. oop94

    Trying to get rid of a couple of parameters…

    Thank you :)
  14. oop94

    Trying to get rid of a couple of parameters…

    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...
  15. oop94

    Search Engine in a Form

    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?
  16. oop94

    Search Engine in a Form

    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...
  17. oop94

    Printing Specific Pages of a Report

    It's in Access . . .
  18. oop94

    Printing Specific Pages of a Report

    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...
  19. oop94

    Help in Printing an Access Report

    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...
  20. oop94

    Creating Folder Inside Newly Created Folder

    ...'newvolt' is created successfully, but 'SG019810002-500' is not. MSDN describes the _mkdir as int _mkdir( const char *dirname ); with dirname as the path for new directory. Here's the link...

Part and Inventory Search

Back
Top