In Access 2000 I have a query named
qryAllContacts
I have a form named Form1, on Form1 I have a button. In the click event of that button, I would like to open a "filterd" version of the query...WHERE qryAllContacts "CompanyName" and Form1 "CompanyName" are the...
I started to design a form in Word 2000, using ActiveX textboxes, I then changed my mind and decided to go with standard Word formFields.
In design mode, I went through the document and deleted the ActiveX text boxes, and inserted my formfields.
I kept one ActiveX textbox, for Enduser notes...
If I have added 3 ActiveX TextBoxes to a word document, How do I retrieve the names of those controls via a sub procedure? I have successfully counted how many fields I have in a document, but don't know how to return a name.
Help will be most appreciated.
Does anyone know is it possible to have multiple pages in a Word doc, and do a sectional mail merge? Have the datasource for one page be different than the data source for another page?
If not in Word, does anyone know how to do this programatically?
I want to keep track of what attendees are charged for attending a meeting. They may choose what activities they do, and the fee for those activities varies.
Then based on a total I must bill or refund the Company.
I then must post varying amounts to individual General Ledger accounts...
After choosing an activity in an activity table (yes/no) field, i want to update a field in another table with the companyID and various dollar amounts.
fishing... 20 in column one, 5 column 2.
dancing... 45 column 3
and keep this tied together based on ID.
In Excel I used select case...
I would prefer to do it in Access, but haven't found a source of good guidance. I am willing (grudgingly) to link the Excel and Access if possible... at this point I am unsure how to proceed.
Access is my preference.
IF you will go to this website, there is code there for simple importing and exporting Access/Outlook and Outlook/Access, it does take some work and programming. Hope this helps.
http://www.helenfeddema.com
Is there anyone who would help me? I have a db in place with about 2300 records. These contacts attend events, I want to set up a simple AR system, charging for event items, and recording payments, and adjustments. I have previously handled this in Excel, pretty tidily by setting up an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.