Search results

That worked awesome, thanks I did not know about that!

Yes the document I was given in excel had functioning hyperlinks. I wasn't sure if when importing from excel when asked what type of field I already had a hyperlink field to put them into. I also have been playing around and if I delete the last character and then reinput that character it...

I have a main table that I just imported all of my data into, I have 41k separate hyperlinks attached to each of the separate number. The problem is on the excel sheet before I imported they all would open the default browser and pull them up. Once imported they will not open, the field is set...

I am stuck right now and I am unsure what would be the best way to move forward, I have a form that is button launched from a main form. The main form and this form are linked via their id#. The problem I am at is there are two different types of information that a user would need to fill in...

The 1 and 2 are from the query that pulls the data for the combo box. The codes-Yes doesn't have a space but I see what your saying and the _ will work just the same. Thats the problem I am having from the table I am referencing for the command, do have it point towards the autonumber for the...

Alright I am still new to the VBA world but I am giving my coding a try, and so far it is no good. Here is the problem, I have a combo box that pulls down 36 different selections. Each of the 36 selections all have different responses and as well a different value. So if the user pulls down the...

I am not understanding the Predloge or the Grupa? Are these supposed to be the table name? If you could use the examples I used that might help a little better understand.

Alright I am still new to the VBA world but I am giving my coding a try, and so far it is no good. Here is the problem, I have a combo box that pulls down 36 different selections. Each of the 36 selections all have different responses and as well a different value. So if the user pulls down...

I have a subform that stays in data sheet view for entry, the form this sits on is launched by a macro. This macro on the main form launches the form and adds in the linking numbers by a setvalue. The main form has the linked number on it and this number is then linked by master and child to...

Yes, the control worked perfectly. The only way I have been able to get it to currently work is to have it go: Private Sub desc_AfterUpdate() ProvisionDescription.value = cboCode.column(1) End Sub The removal of the Me. makes it work, any reason why?

I renamed my combo box to cboCode and put this into VB but still it doesn't work. Private Sub ProvisionDescription_AfterUpdate() Me.[ProvisionDescription] = Me.[cboCode].Column(1) End Sub This is the sql of the combo box" SELECT [Code-LeaseProvisions].Code, [Code-LeaseProvisions].[Provision...

I new to VBA and I am having problems having my combo box auto fill the next text box. The table it pulls from is called Code-LeaseProvision and it has only 2 columns in it. So when built the combo box it pulls the both rows. One is labeled "Code" and other other "ProvisionDescription" I...

Thanks! I guess the docmd in front works better than the with DOCmd line header. Good to know, and also with the quotes, is there a reason when you are writing the code, underneath it is showing you that you need the ()?

I have a form that I need it to run a query when the form is being close, but I am running into a tad bit of trouble. First off this is my first VBA code so please bare with me! Here is what I have so far: Public Sub Form_Close() With DoCmd .SetWarnings False...

It has the master/child setup for the lease num1 on both the main form and also for the linking table xrf property. It does not link to the lease tract lease num1 on the old form, it is exactly how it was on the working subform.

What is your Master/Child relationship set at?

I have a database which has been in production for quite a few years, it even made the swap from .mdb and .accdb without losing any of the functionality. Well I just had to export from access to new access to start a new file for one of our projects and now one of the subforms is not adding...

I am fairly new to the Access world and i have run into a problem with my macro enabled button. The forms name is called Well Master and has an autonumber every time a new record is created. All this information is fed to a Well-Master Table, but here is where I am getting into problems. I have...

LOL...so simple it's stupid!!!

Do you know what CO-PA that my friend first suggested meant? Is it a term with sql or with another system?