| Thread | Last Post | Replies |
|
| Access 2007 New attachment field | 11 Oct 2007 09:24 GMT | 6 |
I am thrilled with the new attachment field type in Access 2007. Not sure how musch space it takes. Is there any way of referencing an e-mail if one sends the e-mail from Access?
|
| Strange files/modules in VB window | 11 Oct 2007 05:37 GMT | 1 |
I am using Acc03 SP3 and have recently noticed some strange/new modules/projects will appear in the Project pane of the VB window. I did not create them and I can not delete them one is Utility and the others start with AZ***. I was able to find that at least one is a wizard. ...
|
| Requery to same record? | 11 Oct 2007 00:41 GMT | 5 |
I have a form with a drop down list with values for Salesman. Whenever I select a different Salesman from the drop down list, I retrieve the remaining fields from the corresponding record in a table for that particular salesman and populate the remainder of the form.
|
| Combo box Question | 10 Oct 2007 23:05 GMT | 4 |
hi- I have a form that has 2 Combo boxes. Drop1 and drop2 row source for Drop1 is a list of values in a table. row source for Drop2 is based on what users selects in drop1.
|
| "Dim qdftemp as QueryDef" gives me rrror Message... | 10 Oct 2007 22:28 GMT | 1 |
I wrote a function in and in it, the statement "Dim qdftemp as QueryDef" gives me a compiler error of "Compiler error: user-defined type not defined". What gives? I have used this statement before in other databases and it has worked.
|
| Is there a way to determine if a column exists in a table? | 10 Oct 2007 22:25 GMT | 4 |
My code is building SQL based on user input. Is there a way I can test to see if a specified column really exists in a table before executing SQL that references it? Thanks
|
| Selecting columns | 10 Oct 2007 20:59 GMT | 1 |
I need to unhide some columns. The number is variable but is a known factor. To select the columns Excel requires a letter designation, i.e., Columns ("A:D").Select. However, I want to use numbers instead since I know the number of columns. If this is not possible, is there a ...
|
| Cascade list/combo box | 10 Oct 2007 19:41 GMT | 2 |
I'm not sure how to phrase my question so I'll give you some of the detail. I have an Equipment Table and a Manufacturer Table with a many-to-many relationship. I want to design a form that will list all the Equipment Types. When a Equipment Type selection is made I want ...
|
| SQL for List Box Row Source | 10 Oct 2007 18:33 GMT | 7 |
I am creating SGL statements for a list box programmatically in VBA. Unfortuneately, they can get long, and sometimes exceed the length that the rowsource property can hold. Is there a way to get around that, such as saving the SQL as a query def, and simply calling the query?
|
| Follow Hyperlink | 10 Oct 2007 16:10 GMT | 3 |
Good day. I have a table called tblMain that has the following three fields. OrderNum "file Number Field FileLoc " file location Feild
|
| Type Mismatch Error | 10 Oct 2007 16:01 GMT | 3 |
While trying to open the database we are receiving the following error, "Type Mismatch". The person who created this database is no longer around and I have very little access programming knowledge. Any ideas on how to fix this?
|
| Calculate Percentile by grouping fields in Database | 10 Oct 2007 14:19 GMT | 4 |
Hi, i am having DATA like this in access table , i would like to calculate Percentile 50% of sales by grouping data at Month Level, that means for each month i ll get differnt percentile value , eg. 2007/01 - Percentile Value, 2007/02 another percentile value.... and so on, is ...
|
| refreshing linked tables | 10 Oct 2007 13:46 GMT | 4 |
I am building a dbase that has 5 linked tables from other Access dbases that we use in the department. I would like for the procedure I'm programmin to update the data in the linked tables every time the script runs.
|
| Help with code | 10 Oct 2007 09:26 GMT | 6 |
Apologies for the repost. I have a set of fields that require information before "Qry_status" can be changed from "outstanding" to "complete". The added complication is that if the query type is an "invoice" then I need an extra two fields.
|
| Object required error | 10 Oct 2007 09:21 GMT | 2 |
Hello i'm trying to create a WinHttp Request object but i get the error "Object required". What libraries must i use to do this? The code i'm using is the following: dim HttpReq
|