mvlt
Last Activity: Oct 1 '08, 07:53 PM
Joined: Apr 19 '07
Location:
-
I have two volunteer tables. One is tblVolunteer and the other is tblHours. tblVolunteer includes the following fields [ContactID] and [email]. tblHours includes multiple entries for each ContactID that includes their task and the number of hours with the following fields [ContactID], [Task], [Hours]. The ContactID is a concatenated field - a combination of their last name and first, but the volunteer doesn't know what it is and I don't want... -
Email Data Collection - Can I autopopulate a field based on the email address?
I would like to set-up an email data collection to gather volunteer hours from our volunteers. Is there a way to auto-populate a field if I use the HTML format. Each volunteer has a Contact ID, but they don't know what it is. Can just replying to the email populate that field since their email address is linked to their Contact ID? -
Forms not behaving when opened in Access 2007!
I recently made the switch from Access 2003 to Access 2007. The rest of our office is still operating on 2003, so the database is still a 2003 file. We're having trouble with a few forms that work fine when I open them on the 2003 computers, but not on mine (2007 version).
For example. I have a form that is a simple form linked to a solicitation table. It has a combo box that allows the user to select the solicitation they want... -
Add Null Value to Combo Box
I am using Access 2003 and working on a query by form. I have a form with two unbound combo boxes. The form searches our contact list for people in a certain renewal cycle. It then gives the option of looking for a certain constituency within that group.
The first combo box, cboRenewalCycle , lets the user select from a list of Cycles (FEB, JUN, SEP). The second, cboConstituent, lets the user select from a list of Constituents (Business,... -
Troubleshoot Hyperlink
I am working with a database in Access 2003. I have set up a form with a button that pulls up the Windows File Dialog box and allows the user to search for a specific file to input into a field. The field, called FileLink is set as a hyperlink field. This process functions well - the resulting file path appears in the appropriate field in the table, but it is not actually a hyperlink. There is no data underneath it.
How can I get... -
File Dialog Box Troubleshooting
I am trying to create a button and related text box that allows a user to click, open the standard Windows File Dialog Box and populate the text box with the selected file path, which will then be a hyperlink.
I can get the button to open the File Dialog Box, but when I close it returns "FileDialog(mso FileDialogFileP icker)" instead of the actual file path. Any advice? The code I am using is:
...Code:Private Sub cmdFileDialog_Click()
Last edited by Killer42; Apr 20 '07, 03:02 AM. Reason: Please use [CODE]...[/CODE] tags around your code.
No activity results to display
Leave a comment: