| Thread | Last Post | Replies |
|
| mde | 21 Nov 2006 16:42 GMT | 2 |
Is there any way to view the code behind a Form and Report on an mde file.. I did the stupid thing - all my people are using my mde then I worked on the mdb thinking I had a back up.... Guess what....
|
| Converting fields in VBA | 21 Nov 2006 16:22 GMT | 6 |
I have a few fields that are imported from aonther program. They are "time" fields, although in the Dabase they are txt fields. (due to the way the other program exports the data) is there a way to convert those fields to actual time values to do time
|
| text field being padded with blank... | 21 Nov 2006 16:19 GMT | 2 |
I have two fields defined in a table, each as a text field with a length of 5. They are defined identically. I create a new record in a recordset using .AddNew and assign values to these fields., then use .Update to write the new record. I assign values to each field using a ...
|
| Apply formatting to selected text in text box | 21 Nov 2006 15:08 GMT | 1 |
Is it possible to apply bold formatting to selected words in a text box i.e. not all of the text? Thanks
|
| Can I change the "Enter Parameter Value" text? | 21 Nov 2006 14:42 GMT | 2 |
Since I will not be the only one using the database, I would like to make the popup box read "Enter the Contact ID" or something other than "Table!Contacts!ContactID" so that people using the database will know what the popup is asking for. Is this possible to do? Thanks!
|
| VB programming guides or books | 21 Nov 2006 12:48 GMT | 5 |
I am trying to find a good book/manual on VB programming. I have the Access Bible but the section on VB does not go into a lot of detail. I would like to learn more about writing code. For example I was working on a data base and wanted to update one subform
|
| select Query for report with two option groups | 21 Nov 2006 10:55 GMT | 1 |
Hi Is it possible to select the query for a report based on the results of two option groups on a form? eg the report requires the same set of information, but the query it uses
|
| Reference request | 21 Nov 2006 06:26 GMT | 1 |
I would like some help writing a procedure that would identify what references are missing in the active database. Sometimes when I get help from all of you, I get the dreaded invalid....msg. I use Office 2003, XP and 2000 depending on what class I am teaching. Thank you.
|
| Recordset or Query object? | 21 Nov 2006 01:02 GMT | 3 |
I have a form in which the user selects search criteria and enters values for that criteria. I can use that to build a select sql string easily enough but after this I seem to be having a mental blank. Should I use the sql string to generate a recordset, or should I store it as a ...
|
| Is there a way to run link tables thru code? | 20 Nov 2006 22:55 GMT | 1 |
Is it possible to link tables at startup in code and test for links in the same code? I have the menu item "Link Tables" on the menu right now, but the user may link the tables over and over again. I would like to be able to automatically test for a link at startup and if it ...
|
| dlookup vs. elookup | 20 Nov 2006 22:53 GMT | 4 |
we use reports in Access 2003 that use DLOOKUP in text box/control source. ELOOKUP does not appear to work in this situation, is that correct??? thanks in advance!
|
| CreateControl | 20 Nov 2006 21:22 GMT | 5 |
I use the CreateControl to create a new control within a form. However, later I need to reference the newly created control. How can I name the control after creating it or is there an input for this that I missed for this exact purpose?
|
| find X sequential values in a table | 20 Nov 2006 18:51 GMT | 2 |
I have very minimal VBA skills... Given a table of about 50,00 records, I am trying to identify whenever at least x (in this case, at least 5) sequential values in the field (check_number) occur in the existing table and whenever these values are identified, write these values ...
|
| On close or auto close in Access DB | 20 Nov 2006 18:20 GMT | 1 |
In MS-Excel you can create a function called Auto_Close that will fire when the file is closing. Is there an equivalent function in MS-Access? If not, is there a work-around? Could an example please be posted?
|
| FindFirst Method syntax | 20 Nov 2006 18:07 GMT | 3 |
Please help me to understand the syntax for the Recordset.Findfirst when searching for a CustomerID field using a combo box. First I declare an Object variable with Dim, then assign a recordsetclone to the variable. Then I use the FindFirst method to synchronize the combo box ...
|