| Thread | Last Post | Replies |
|
| #Name? being returned for form field | 15 Nov 2006 19:00 GMT | 4 |
I have a form field which returns a value from a table. The reference is : =Training_Course!TuitionCost which is displayed as #Name?. What does this mean>
|
| Datasheet Form | 15 Nov 2006 18:31 GMT | 3 |
I have created a datasheet form. When I open the form from the Database Window the form opens in a datasheet view. I have a button that opens the same form but when clicked the form opens in a single form view.
|
| Duplicate Field | 15 Nov 2006 18:16 GMT | 5 |
Hi, hope someone can help me with the code for a duplicate field. I found the following code in this forum, Me.Date.DefaultValue = "#" & [Date] & "#", which works great for the date field that needs to be duplicated for the next record, but I am having trouble with code where
|
| GetDesignerAddress() works one way but not the other, please help! | 15 Nov 2006 17:14 GMT | 2 |
Little problem, if I type: WhichDesigner = DLookup("pWhichDivision", "tblProjects", "pID = ProjectID") doesn't work. But if I type:
|
| reporting | 15 Nov 2006 16:55 GMT | 18 |
I have a report that shows up any coolers that are due to be serviced on ie i can run the report/query for coolers due to be serviced in Nov and a list will come up. We have some companies that don't get their coolers serviced when they are supposed to. What i want to do is ...
|
| Form using queries not allowing new records | 15 Nov 2006 14:33 GMT | 2 |
Help! I broke my form again! I know what did it, but I don't know how to fix it. Basically, I needed to use queries to calculate a couple of the values
|
| Memo Underline | 15 Nov 2006 13:57 GMT | 3 |
Is it possible to underline one word in a memo field, instead of the whole field? If so How? Thanks, Salty
|
| Lookup combo box | 15 Nov 2006 13:50 GMT | 4 |
We have a form: Frmpallet and a combobox for the location. The Pallet can only have one location. After selecting a Location in the form and going to the next entry (pallet) the previous selected location must not be available
|
| Filtering a Combo Box based on a field on a form | 15 Nov 2006 13:30 GMT | 1 |
I have a form with a sub form on it. On the parent form I have a combo box (cboEmpName) which looks up an employee by name, and then returns the related training they've attended in the subform. What I want to do is have another combo box which will limit (i.e. filter) the ...
|
| How do I run an animation in Access? | 15 Nov 2006 13:24 GMT | 1 |
I am an A-Level ICT student and I am creating a Database for one of my projects. I have created a splashscreen but I would like to have a loading GIF on the page. I have copied it onto the page but there is no animation when the form is opened!?
|
| dlookup #error | 15 Nov 2006 13:03 GMT | 2 |
I have a text box where the control source is a dlookup function based on another text box on the form. When the text box is populated, the dlookupfunction works fine, but when it is empty, the function returns #error. I thought that error message meant that there eas something ...
|
| export text file in macro | 15 Nov 2006 12:11 GMT | 1 |
I am writing an export text file function in macro using Access 97. I use transfertext and export delimited. However when I run this macro, I got an error message "the file is already existed" and stop processing. How can I delete the file before I run this process in a macro? ...
|
| Form using multiple tables not allowing new records | 15 Nov 2006 11:48 GMT | 19 |
I've been teaching myself access on the job out of necessity, and I've come across a small stumbling block in the forms I need to create. Basically, if I only build a form using one table, I can
|
| Using check boxes to select items in a multi select list box | 15 Nov 2006 06:53 GMT | 5 |
I am trying to create a multi select list box consisting of keywords. However, I don't want the user to remember to hold the Ctrl key down, etc. I'd like to present them with a list box showing the keywords and a check box next to each to use instead. Eliminates them accidently ...
|
| SQL integration service | 15 Nov 2006 06:35 GMT | 1 |
What is the SQL integration service used for? Thanks.
|