| Thread | Last Post | Replies |
|
| table structure | 27 Nov 2007 04:04 GMT | 1 |
I'm new in access. in visual foxpro you have a command list struct that would display the structure of the table. How can I do that in access?
|
| Phantom break point in VBA module | 27 Nov 2007 00:57 GMT | 1 |
Access 2003, stand-alone single-file .MDB (while developing). If I open the application and select a button on a form that causes some code in a module to run, the application opens up the VBA window with a line of code highlighted in yellow as if I had planted a breakpoint. ...
|
| Supress Import Error table generation? | 26 Nov 2007 22:18 GMT | 1 |
Is there a setting in Access that stop it from creating a table when there is a type mismatch?
|
| Code Issues | 26 Nov 2007 21:01 GMT | 5 |
I was trying to do the following: 1. get the user to import a spreadsheet from some location on the drive (location changes). 2. data from spreadsheet imports to a table named Random
|
| VBA to format excel columns | 26 Nov 2007 19:48 GMT | 3 |
Access03/WinXP I have set up an export to Excel and have done some formatting thanks to some great help from other threads. I understand that I could set a specific column width using .Range(x,y).ColumnWidth = SomeNumber.
|
| Email notifications of database updates | 26 Nov 2007 19:00 GMT | 3 |
Is there any way to set up my Access 2003 database to send me an email when any other user updates a form or table? Any help would be appreciated!
|
| Set excel cell validation using access generated workbook | 26 Nov 2007 17:16 GMT | 1 |
I have a workbook and associated worksheet generated using access that I would like to set validation onto a range of cells. The code I'd expect to use directly in excel vba would be: With ExcelAppObj.ActiveSheet.range(rng).Validation
|
| Creating a query with Multi select list boxes | 26 Nov 2007 16:38 GMT | 10 |
Hi Group, In a bind here; I have a form with 4 multi select list boxes. What I would like to do is create a query that utilizes the values selected in the 4 list boxes. I have gotten as far as creating a text box on
|
| GetSchema - need Columns in Ordinal Position | 26 Nov 2007 14:13 GMT | 1 |
I'm writing a small utility to assist my coding when using access tables. In this phase, I want to get the schema columns when creating a datatable of columns and attributes using the statement: dtc = cn.GetSchema("Columns", dtcRest) I retrieve all the columns OK, but I want them ...
|
| CREATING TASKS IN PUBLIC FOLDERS | 26 Nov 2007 13:40 GMT | 1 |
I have created a task in Outlook Public Folders from Access, except some of the fields are not set correctly, namely 'Importance' .Importance = Medium or
|
| Office 2003 SP3 broke my vba code "user-defined type not defined" | 26 Nov 2007 06:18 GMT | 3 |
After installing Office2003 SP3 I get the following error... [Microsoft Visual Basic] Compile error: User-defined type not defined
|
| Time not updating | 26 Nov 2007 00:53 GMT | 5 |
Hi I am using a query to update different types of data. for some reason I just can't get past this for the code below everything works except the ReportTime, ETD and ETA fields. It keeps coming up with error 13 type mismatch
|
| Lotus Notes Appointment | 25 Nov 2007 21:15 GMT | 1 |
I have built a CRM database and I would like to integrate Access with Lotus Notes 6.5 Appointments. I have Text boxes for Interview date, and start and end times. I would like to add the clients name, Interview date and start/stop times added to Notes appointment. I found this ...
|
| Finding the forms name in visual basic | 25 Nov 2007 19:56 GMT | 3 |
Is there anyway of finding the forms name that is currently being used by the user in visual basic on a real time basis. Maybe something like: if formname = "name" variable = name
|
| Problem with Combo box and Null | 25 Nov 2007 13:36 GMT | 3 |
I have a form with 3 combo box's that can select a part id that will appear in a locked text box. The combo box's use differnt variations of the same query(Part numbers that start with 4 the next for P/n that start with 5 and the last with 3. The problem of course is that after ...
|