Search results

Hello all, Does anyone know how I can make this code search the captions instead of the Control Sources: :confused: Option Compare Database Option Explicit Dim mstrFormToSearch As String Private Sub cmdFind_Click() Static strLastFind As String Dim ctlFocus As...

Hello, The current database I am working on I made it by copying the one I was working on originally. I just realized on the VB window that there is still some relation between them. Because, if I look at the tree on the left of the code window I see it says "GCB (miniGCB)", being GCB the one I...

Is it possible to make my Splash screen invisible after someone checked the "Do not show me this screen again" just while that current session? Is there a way of using flags and a system table or query that would allow me to do so? Thank you:)

Hello all, I have this splash screen, which welcomes all the users. It has an OK command button that exits the screen, and a checkbox that says "Do not show this screen again". I still do not have the code behind the checkbox. Thus I was wondering if there is a way where I could entirelly close...

:( It says that to get rid of a "type mismatch" error I should add the DAO.lib. But I already had it and I always got the error. Set oSQL = "SELECT * FROM TableInfo WHERE Caption Like '" & strTarget & "'* " The last ampersand is the type mismatch.

I made a command button, and every time I click it, It gives me an error. I wrote some code, so I have the OnClick option on [EventProcedure]. The thing is, it never even makes it to the code. :( SOS

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

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

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

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

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

Hello all, I was wondering what should I define a chechbox as if I want to make it a variable, so that when it is checked (= -1), I can check for the -1 and loop somewhere. Thanks

Hello all, I was wondering what should I define a chechbox as if I want to make it a variable, so that when it is checked (= -1), I can check for the -1 and loop somewhere. Thanks

Hello all, I was wondering what should I define a chechbox as if I want to make it a variable, so that when it is checked (= -1), I can check for the -1 and loop somewhere. Thanks

Hello there, I'm working on creating a database in Access. This is my plan, but I am not sure if it is possible: each form represents a particular circuit breaker, and on the form are several checkboxes such as "Voltage Range" and "Seismic Capability", which represent the characteristics of the...

Hi, I have to build a database in Access. One of the forms I have to do has to have the option of printing the specs being selected. In other words, this form is going to have a bunck of Specs (labels) for a kind of product and the user has to be able to check whatever specs he wants to print...