| Thread | Last Post | Replies |
|
| Access Ver 2.0 Adding days to a date to give target date excluding weekends? | 30 Nov 2006 02:20 GMT | 1 |
Not sure if i'm posting in the right spot so sorry if its not, please direct me to the correct location :) I have three fields in a form, [quote accepted], [days to results] and [target date]. I need to calculate the target date by adding the [quote
|
| Pause macro to enter parameter | 29 Nov 2006 22:31 GMT | 7 |
Hello to all. I need to run a query weekly with results based on beginning and end dates as criteria in one field. I then need to export the resultant dataset to Excel. Creating the macro to export the dataset was easy. However, what
|
| Truncate the first 2 characters contained in all cells within 1 column of a table in access | 28 Nov 2006 13:44 GMT | 3 |
I hope the title is descriptive enough. My problem is as follows: I am trying to truncate the first two characters from all cells contained in a specific row within a table in an Access DB. All
|
| ERROR 3011 when running a macro | 28 Nov 2006 13:30 GMT | 1 |
The Microsoft Jet database engine could not find the object Customer Order Backlog. Make sure the object exists and that you spell its name and the path name correctly. (Error 3011) I get this error when running a 23 step macro. If I take the 22 step, which
|
| Can User Input Be Used in a TransferDatabase MACRO ??? | 28 Nov 2006 13:25 GMT | 1 |
I posted a question similar to this in the Import/Linking forum....and received a possible VBA coding solution. This may be the more appropriate forum and am posting here, just in case. Since I'm not real familiar with VBA coding...I'm hoping there may be some
|
| where are wombats? | 28 Nov 2006 13:10 GMT | 1 |
Can someone tell me whether Wombats live only in Australia, or also on other continents? Apart from zoos, of course. We all know that Wombats are to be found in Zoos.
|
| Multi Select on a Form | 27 Nov 2006 22:27 GMT | 1 |
Hi everybody! I am trying to multi select in a list box but i get this error message: The field <name> cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field. (Error 3314)
|
| Select from List Box | 26 Nov 2006 21:24 GMT | 4 |
Have a list of names & Phone# in list box on Form1, want a macro to copy selected names and paste to a table. Table is a subform in Form1(no relationship). All field names and format are similar) I have
|
| Data from Access | 25 Nov 2006 15:50 GMT | 2 |
Good morning In the following Macro, we are trying to get all the fields from a connected database. If you look at the macro, you'll see that there are mising field names (refer to the portion where you only have ' ' ' ' ' ' in the Array
|
| append delete query | 25 Nov 2006 07:36 GMT | 1 |
i wrote an append and a delete query for a table to move and delete records by looking up the name field in a record by the statement like 'Enter Name". i combined the two queries into a macro. i am looking for a way to only type in the name one time to run both queries on the ...
|
| custom macros in normal.dot wont load | 24 Nov 2006 22:04 GMT | 1 |
Custom macros (keyboard) show up in macro listing in normal.dot file but they will not respond to keyboard commands. Windows XL Ofice 2003
|
| Expression builder limitation | 24 Nov 2006 17:55 GMT | 4 |
I've run into a limitation in number of characters that can be used in the Expression Builder the following expression: [Forms]![MONITORING_DATA_ENTRY]![Abbr] & "-" &
|
| Copy contents of a field does not copy complete field | 24 Nov 2006 15:16 GMT | 3 |
I have an EventProcedure to go to a field and copy the contents. The first part copies the text, then the Notify Macro is a Send Object Macro. The idea is to have the text from the ResumeTXT field in the Clipboards so it can be pasted into the Message of the Email. I
|
| Auto yes/no replies | 24 Nov 2006 14:22 GMT | 3 |
I'm trying to run queries that create/delete queries. I want the yes/no question that pops up to be automatically answered as "yes" but I don't want to use the "Tools->options" option that does this (need it for other stuff) I believe that, using a macro, theres's a macro ...
|
| exporting query with parameter | 24 Nov 2006 13:52 GMT | 4 |
I have a procedure in the access' module and I want it to export a query to an xls file:
>>> Application.DoCmd.OutputTo acOutputQuery, ExportingQuery, acFormatXLS, >>> XLSOutputFile |