Browse by Tags - Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange .

Working with the Text Form Fields values

Hi there, In VBA, how can I work in VBA with the values of the Text Form Fields? I need to verify which one is the biggest and show it in the footer. How to show in the footer I'd already learned. Please, Cans somebody help me with this? Thx, Caio Douglas

Posted to Word (Forum) by microsoft on 03-23-2010
how to get MS Access query "description" text field via VBA

In MS Access databases, queries have a "description" field (text) that you can get at in design mode. Using VBA (~VB6) I can get at just about everything having to do with an Access query (the name of the query, the SQL statement, etc) except the one thing I WANT to get at which is the description...

Posted to Access (Forum) by microsoft on 01-14-2010
VBA code to concatenate single field values from multiple records

Hello ~ I would like to concatenate field values from Table1 FieldB into a single records in Table2 FieldB, separated with a comma space, grouped with respect to Table1 FieldA, using VBA. Could someone out there suggest a VBA routine to accomplish this? Foe example: Table1 Field A Field B 1 apples 1...

Posted to Access (Forum) by microsoft on 07-28-2009
Refer to query fields from code behind report

I have a report that gets its data from a query. I can refer to fields in the query from the report as [CustName] for exmaple. How do I refer to fields in the query from the VBA code behind the report (for example from the OnFormat code of a section of the report)? [CustName] does not work! Can someone...

Posted to Access (Forum) by microsoft on 07-04-2009
MS Access 2003 - VBA code to copy 1 field to another in the same form

Dear Experts I have a form named address. The form contains fields named: Business address Invoice Address I want to add a button to the form that will copy the details in business address to invoice address. The actual form is slightly more complicated but if I can understand the above then I will be...

Posted to Access Coding/Macros (Forum) by microsoft on 06-25-2009
Access VBA - get field names behind bound form

Hi In Access VBA how would you get the field names of a table behind a certain form Thanks

Posted to Access (Forum) by microsoft on 06-21-2009
Problem: Creating an autonumber field in VBA or quiry

Dear Experts, can you help me with this access conumdrum. I have several tables with autonumbers in each which are being used for each table as a primary key. However, I need to combine 3 of the tables as a union quiry and have a field in each table which I need to keep as the item number field in the...

Posted to Access Coding/Macros (Forum) by microsoft on 06-11-2009
Problem: VBA to populate a Drop down form field

Is there a way to populate a drop down form field using VBA instead of filling in the dialog for the form field properties? I have a document template that I use for daily generated documents. When I edit the template to simply change items in the form drop down field, I have to retype my content for...

Posted to Word (Forum) by microsoft on 06-06-2009
Problem: Modify field data types using Vba

Could someone tell me how to modify a field data type in an existing table from Long Integer to Text using Vba code in Access 2002

Posted to Access (Forum) by microsoft on 06-02-2009
Problem: parse outlook field

I have a field in tasks which says assigned to, it's automatically filled when a task is assigned to someone and as our exchange server is set up it currently displays domain\user The IT guy can't change it lose the domain bit. I would like to remove it from view though so it just says user....

Posted to Outlook (Forum) by microsoft on 06-01-2009

Page 1 of 2 (12 items) 1 2 Next >