Search results

Background: I am trying to create a SQL string that when ran, will ask for a specific value in the WHERE section. For example: SELECT * FROM tblName WHERE fieldName = [fieldName] For the where portion is there a way to set the statement so that when it is run, the user will prompted to...

I am creating a Dashboard for my division at work. The underlying data will be contained in multiples databases (in general, a different database for each sector of our assignments). My general approach is to creat a blank database that links to these external databases in order to pull the...

Okay, this should be a simple one but I am not finding the right sources through searching. I have a form that is used to input records. One of the fields of the records is Permit #, which is a text field. Another field is Query Link field which is a hyperlink address that goes to a web...

I have a set of controls that are made visible upon clicking a button. When a subsequent button is pressed, these controls are made invisible again. This is what I am using right now. Private Sub cmdUpdateProfile_Click() Forms!frmWelcome.setfocus tboname.visible = false...

I want to filter values on a forms based on the ID in a query and the ID in a table. I think this should work, but it does not. Dim strFilter as string strFilter = "tblEAD.ID = qryACEA.ID" Forms_frmEngineerHome.Filter = strFilter Forms_frmEngineerHome.FilterOn = True Do I need to do a...

I have a main form acting as a container, which is holding a number of other forms. Three of these subforms are overlapping on the main form, and I want to use VBA to show the form necessary when certain actions are performed, such as a command button clicked or a link clicked, etc... Right...

Update or CancelUpdate without AddNew or Edit I have searched the forums for an answer to this, but haven't found anything quite specific enough for my situation. I have a subform with the navigation buttons enabled. When i click the button to add a new record it bring up the default values...

I have a form that contains a subform. Both the main form and the subform have the save Data source, which is a table. When I open the subform separately it loads all of the records perfectly, however, when I open the form with the subform in it, it only loads the first record. Any idea as...

Is it possible to perform a "find" function like that of the default "Find Record" command button in Access from script. Perhaps, emulate this "find" function, but specify the value to search for and specify the field to search for. This is reference to a nagivation form ("tree" style), which...

I have looked everywhere for a solution to this and I always get that same answer, set the RecordSource property of the form with FormName.RecordSource = "RecordSource", however, when I do this, I get nothing from my form. Here is some background. I created a form using the wizard and...

I have a subform that will change what it contains based on which user logs in to the database. This is done by changing the record source of the subform. It worked at one point and now it is having problems. Here is my code: Private Sub LoadNav() If currentUser = "AC" Then...

I have a dashboard program with a "navigation" menu on the left. This "navigation" menu has labels that are filled in at runtime with one field of a recordset. I want each label that is filled in to then link back to the record it represents. Is this possible to do, and if so, what is the...

Here is my problem... I have a form (frmWelcome), which contains a subform (frmNavigation). My goal is to read a bunch of values from a record source into an array. Then I want to list each of these values in the subform, but list each one in a separate label so that it can be hyperlinked...

I am designing a dashboard for our Access database that we use at work. The goal of this dashboard is to provide a more graphical view of the information in the database and make it less likely for a user to intentionally/unintentionally change values in error. The approach I am taking to...

I have an access database that has 3 tables, about 12 queries, and 1 form. The database is stored on the network at my job, and me and the other engineers use it throughout the day. Every night, the entire server is backed up by IT. Yesterday, before leaving work, the file was fine and...

I have an access database set up with a main table and several queries. This database is on a server at my work and all of the employees constantly update the status of certain things in it. I want to write some type of VBA that will automatically send me a report whenever something is...