Search results

Although I am not sure and will have to wait on a response to know for sure, I believe it is ADP linked to SQL Server.

I am actually not sure how any of the back end is set up. Here is the setup that we have. We have a program on our desktops, which provide the User Interface for all of the database information. Within that program we have a tool that allows us to create Document Templates (Word Documents)...

I attempted to implement the PARAMETERS and i receive an error message saying that PARAMETERS is not a stored procedure. I'm sure this has something to do with the backend of the program I am using. Upon some further research I have found that you can declare a variable using the DECLARE...

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

I agree that using this On Click method for the text box would be appropriate, however, the goal here is to create the hyperlinks so that they show up in queries later and can be followed. This database is only used by the few people I work with and each of us has a customized query that we...

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

Well,that worked. Kind of sucks thats the only solution in this case, because there are no other controls on that form that are visible when trying to make that one invisible, so i just addeda tiny command button in one of the corners that you can't even see and just switched focus to it.

Alright I changed Form_frmwelcome.setfocus to Form_frmWelcome.cmdEditProfile.setfocus and received the same error. It runs through the set focus line, but its like it returns the focus back to the cmdUpdateProfile after I set it.

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

Okay, I will work on getting a sample, but I have a few things I have figured out since then. The dependency of the tables was off somehow, but I have that correct now. I still think the dependency of the forms is off. One thing to note, I am really only using the main form as a container...

I have a couple questions based on that. when I click on the main form, it says that it depends on the subforms...isn't this backwards? I changed the setting the subform's record source to the On Current procedure of the main form and was able to load a set of records based on a pre-existing...

Checked that. Ran it with both continuous and datasheet view. It still only populates the form with 1 single record, when there are 87 in the data source.

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

Solved! It was an issue of order. Apparently Acces Opens Subforms prior to opening the main forms that contain them. So I put the call to change the record source in the Private Sub Form_Open() of Form_frmWelcome and it worked. Now, how do I prevent it from asking for values when changing...

The Private Sub Form_Load is in the form's declarations. Let me be a little more specific, because this may be an issue of when it is changing the record source. I have a main form (Form_frmWelcome) that has two subforms on it. One subform is a left hand "navigation" type form...