| Thread | Last Post | Replies |
|
| Excel formatting | 07 Jun 2005 19:47 GMT | 2 |
I haven't done this before, so I'm not sure I can do it. I'm hoping someone can provide some guidance, before I start trying to do something that can't be done. I'm currently using Access 2000, but could *probably* get 2003, if necessary. (I've been planning on getting 2003 ...
|
| Run A Macro | 07 Jun 2005 19:46 GMT | 3 |
How can I reference to run a macro, "Macro1", which is in an external Database, from the current dataabase? This code effectively opens the external Database: Dim objAccess As Object, objFunction As Object
|
| Update Query | 07 Jun 2005 17:22 GMT | 5 |
I'm trying to change the "Update to" in an Update query from code in the module behind a form. I have build everything in the design view of the Access 2000 database window and have a limited knowledge of VBA I have Table1 with three fields, One, Two & Three. Field One is ...
|
| Remove row from array & listbox | 07 Jun 2005 17:06 GMT | 3 |
I have an array that I use to populate a listbox using the user defined RowSourceType property. I want to have the ability to remove any item that the user clicks on - Do I remove it from the listbox or remove it from the array and repopulate the listbox - How is this ...
|
| Unwanted break mode @ startup Access 2K | 07 Jun 2005 15:36 GMT | 4 |
Every time I start an application I made it goes into break mode at the same line without an error message. I can F8 through the code until it ends at which time my main form is displayed. This only happens at start up and does not happen again. I tried, "clear all break points" ...
|
| Creating a tracking number | 07 Jun 2005 15:02 GMT | 1 |
I have 5 consultants in my table called tblConsultant. I want to generate Task Order numbers for each consultant as a project is awarded to a particular consultant. I have assigned a two digit consultant code to each consultant and would like the task order number generated to ...
|
| Date sorting | 07 Jun 2005 14:56 GMT | 5 |
I have a table that stores start dates and end dates. How can I create a new table based on the original table that sorts start and end dates by month? For example, if one event covers 3 months (1/5/05 to 3/9/05), I want to
|
| Billing Question | 07 Jun 2005 14:18 GMT | 3 |
Please help me!!! I've labored over this for weeks and am stumped at how to accomplish this. I've set up a database to do quotes and invoicing. When we invoice a customer, I would like to have the ability to bill a certain percentage of
|
| Feedback from acCmdDeleteRecord & cascading deletes | 07 Jun 2005 09:45 GMT | 4 |
I have a delete button on a form that shows a bound record. I use docmd.RunCommand acCmdDeleteRecord to delete the record as required.
|
| Bookmarks in Footer filled from Access but doc NOT in PRINTVIEW ? | 07 Jun 2005 07:27 GMT | 3 |
With the following commands Bookmarks are filled out in the footer of a word doc from within access but the document is shown in normal view. I want it shown in Print View but even with the following code WORD keeps
|
| Need code to use a selection from a combo to update a textbox | 07 Jun 2005 01:23 GMT | 1 |
I am trying to use a combo box titled From_Name to automatically update two text boxes titled From_Phone and From_Fax. Please help. I know this can be done I just can't get it to work properly.
|
| Startup Hide access window &View myform,timer function, combo prop | 07 Jun 2005 00:43 GMT | 3 |
If some one give me advice I will be very grateful. I have table with ID,Code,Product_Img 3 fields. I created form with above fields and combo Box . Combo4searching Code when user enter the code. Its fine.
|
| Form load event procedure doesn't work | 06 Jun 2005 23:29 GMT | 2 |
I'm having a problem with an Access form named 'Form1' using VBA. I'm trying to set an event procedure when the form opens to initialize form attributes (e.g., enabling a check box named 'CheckAll'). The problem is that Access attempts to set the attributes before the form even ...
|
| Print Report for one form | 06 Jun 2005 21:56 GMT | 7 |
I am trying to add a button to a fromt o print a report for that one form. I am using Dim stDocName As String stDocName = "Recipe Cards"
|
| Unlocking an Access MDE file | 06 Jun 2005 21:07 GMT | 16 |
Could somebody supply me or point me to code that will unlock an MDE database file so as to have access to my code. You see, I lost my original unlocked mdb file.
|