Search results

No luck - I made it short text in both the table and on the form made sure it did not read as Hyperlink. It still added the # to the beginning of the URL. It does not need to be a link in the data table, but does on the word merge. Thanks for your input. EDIT: I had to remove the merge fields...

I am 95% there - the merge is occurring. What is happening is when i am merging a hyperlink it is appending a # at the beginning of the hyperlink My code starts as { HYPERLINK "{MERGEFIELD LinktoDocuments}" } After the merge it becomes { HYPERLINK "#HTTPS:\rest of the url" } For some reason I...

A bit more coffee this morning and google - I am getting this sorted out To get it to function in 64 bit - I had to add PtrSafe between Declare and Function Thanks all

I tried using Albert's code, I get an error that it does not work in a 64 bit system

I realize I need some VBA - I have been trying to find the VBA that gets me to the same thing as clicking the Word Merge button gets me.

I was using add-on when i should have used module. I will delve more into this tomorrow. I will look at your Modified version. The version off his site is not set up for a 64 bit environment. I do not know enough to know what changes to make. Thanks, Mark

I have, I am looking for a single button solution as I am never sure exactly who will be utilizing the database front end. I don't want to run into a scenario where they don't have the word add-on installed. Thank you though. Mark

Hello all, I have a bit of code that runs a query to generate table with a single record from the form then opens up my word template which has the merge fields already set. The problem is I then have to run through the mail merge settings in Word. Private Sub GSIITB_Click()...

No code in On Current Related data type is Long Integer I have a 50% fix - I have created a text box and used Dlookup to populate the value and placed this text box directly over the related combo box. This does not solve all the issues, but does cover the most critical one.

That did not solve the issue The data for the drop down pulls from tbl01ClientContacts On review of the record I need the data to pull the "contact"ID number from tbl_QuoteLog and display the corresponding name from tbl01ClientContacts I am not sure how to make that happen code wise

Here is a recast of the problem Data tbl_QuoteLog - this houses all the data about a bid - including the primary key values for Client, Contracting Officer and Bid Point of Contact tbl01Clients - This houses the data for the organizations - source for ClientID tbl01ClientContacts - Data for...

Clarification - I do have it bound to a control, I just started out with it unbound. The solution above didn't work - I am not sure the issue. I will noodle this a bit and see if I can get close before coming back to this fount of knowledge. Thanks much

Hello all I am trying to get records to display on a form in unbound combo boxes when I have previously selected a record. Data Structure table - QuoteLog - Primary Key - QuoteID - Subkeys ClientID, ContactCOID and BidPOCID (these last two are records of tbl_ClientContacts) table - Clients -...

Solved it! Need to learn what each event property actually does.

I have solved one of the issues In the on Load of the subform I have used this code Me.cboGC = Me.GeneralContractor In the after update of cboGC I have Me.GeneralContractor = Me.cboGC This is getting the info in the form I need. The current wall I am hitting is that when I change project...

I have 49 unbound combo boxes Essentially each "heading combo box" is a combo box for company which is filtered by company type. Under that are the typical roles we need from that company type for proposals i.e. Combo Box cboArchOrg is the combo box which returns all the companies in the...

Because I cannot figure out how to get the current value from the table to appear in the unbound combo box on loading the form. And I can't think of how to search for what I need so I can educate myself.

Hello all, I have a form full of cascading unbound combo boxes which allows me to assign companies and people to a project. I have a save button which writes the selected values to a table. To view the assignments when the record is later viewed I have placed a bound field behind the combo...

JHB - thanks that worked. Can you give me some insight as to why that worked?

If you are talking about the references menu item which ends up listing things like Visual basic for Applications, Microsoft Access 14.0 Object Library, OLE Automation, etc. The same 4 items are checked in the working database and the non-working database. Research led me to a possible activeX...