| Thread | Last Post | Replies |
|
| Sending Multiple Emails from Access - Security Update | 07 Aug 2005 06:59 GMT | 1 |
I would like to loop through some code and send many emails. Apparently the latest security update for Outlook forces each email to be validated before it will send. Is there a way around this? I don't want to click "yes" 200 times. Thanks
|
| limiting data in combo box based on form | 06 Aug 2005 23:40 GMT | 2 |
I have MainForm; SubForm1; SubForm2 The MainForm contains a JobNo and SubForm2 has Charge Numbers in a combo box. I want to limit the Charge Numbers in the Combo Box based on the Current Job displayed in MainForm. The Charge No and JobNo have a
|
| screen scraping question | 06 Aug 2005 23:09 GMT | 1 |
I'd like to build a small database of information by retrieving data from the Internet. *IDEALLY*, I'd like to have a button next to my field that I can click, so Access can go out and perform a Google search. Then either Access or I can pull up one or more page that the
|
| Run query for active record on form only | 06 Aug 2005 22:51 GMT | 1 |
I have two tables : invoice header and invoice line joined by the invoice number. I also have a form for the invoice header table. There users will enter comments and should have the option to run an update query which will apply
|
| Saving emails from within access | 06 Aug 2005 22:05 GMT | 2 |
I have a problem with the code listed below, my access database has Outllook EntityID's stored in it & I would like to now save the actual emails to a certain directory, the problem is that the EntityID's are from different computers, I need to be able to skip messages that cause ...
|
| Clear Checkboxes on Continuous forms | 06 Aug 2005 21:55 GMT | 6 |
How can i clear all checkboxes (to the value of 0) in a tabular, or continuous, form? These are to check items in a list to print. The tabular form is laid out like a Datasheet, so each row/record has its own checkbox. This can be nearly 100 records/rows. My user needs to be able ...
|
| How do I run an append query from a button like northwind sw/brd | 06 Aug 2005 21:40 GMT | 1 |
I am trying to run an append query the same way Northwind opens forms. The Northwind switchboard just uses =OpenForms("Suppliers") in the "On Click" event. It seems like =OpenQuery("QueryName") would work, but it doesn't. Thanks for the help.
|
| Setup logic in form field | 06 Aug 2005 21:28 GMT | 3 |
I have a question which is probably very simple to any expert. On a form, how do I setup the following logic: Field3=Field2/Field1? I tried the expression builder "afterchange" and added the logic just mentioned. Though I have no error messages I also don't see the result.
|
| Should the Choose Option value be stored? | 06 Aug 2005 18:48 GMT | 7 |
I have 2 option buttons: "In Months" = option=1 and "In Weeks"=option=2. I'm building reports and now need the value of this option button that is in the main form to determine whether my CalcEndDate will use the month or week values. Currently the enddate on my main form is in ...
|
| Using command button to importing an Excel File | 06 Aug 2005 17:47 GMT | 4 |
I am using Access 2002. My users are not techies at all. I have a Excel file in (H: directory - H:\Access\User\Upload\Audit Upload.XLS This Excel file will be properly formatted and will have the correct fields before importing. Can someone give me the code in importing the ...
|
| How to format column in Excel from code in Access form? | 06 Aug 2005 17:14 GMT | 4 |
MS Access 2000, Windows XP ====================== Hi, I have a form with a button to export data from a query into an Excel file.
|
| Listbox question | 06 Aug 2005 14:26 GMT | 2 |
I have a unbound listbox on my form that uses qryCaesID that represents all the records in a a table. I want be able to click a buttom on this form have it search through the listbox,identify all open records and placed them in another listbox. I haven't created the other listbox ...
|
| open same form in mulitiples windows | 06 Aug 2005 14:18 GMT | 1 |
I have a datasheet on each time that i double click a row I want to open the same form name in new window this will help to compare the details of each row. thanks
|
| SQL | 06 Aug 2005 13:29 GMT | 1 |
I have 4 fields in 3 tables that I want to add together, how do I do that USING sql????
|
| calculating dates in records | 06 Aug 2005 11:29 GMT | 10 |
how do i calculate dates from a current date to the next record date, is this acheivable in using macro or vba?
|