Search results

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

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

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

So, should I just modify the Where clause?

:confused: 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...

Thank you.

That does exactly the same thing it did before. I was wondering if there is a way that the form would open with everything empty. Then, when people picked a value from the combo box, all the controls got populated with their respective value?

Should I change something in the combo box properties?

How can I reference the combo box in the queries?

Hello again, I created a form from a query that 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...

Ok, this might be a dumb question but, which search box??

Hello everyone, Here I am again all lost in the beyond side of Access. So, I would like to create a "search engine" , through a macros if possible, so that the users can find the one thing among the hundreds of specs available to them in this form/subforms assebly. My form has two subforms...

:confused: 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 what pages of the three he or she...

Thank you so much WhiteSmoke and Gregory. You ROCK!

I cannot get it to work. I am missing some kind of ending.:(

Hello everyone! I made a form where I added to 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 worse. I was...

Hello everyone, I have this database with a huge ammount of specs (lots of tables). I had to build a form with two subforms, so I could display ALL the specs. Now I would like to add a command button, so that the user can search among the specs. For example, if he or she is looking for the...

Issues with the code Fofa, Do you see anything obviously wrong in the code: Thanks ahead Private Sub CheckInterM_Click() Dim CheckInterM As Boolean 'If the check box is checked, the corresponding spec should be sent to the new form If Me.CheckInternM = -1 Then Print [CheckInternM.Value]...

Thanks! That helps :)

Thanks Fofa, that will help a lot. I was just wondering what does the "Me" identifier do?