| Thread | Last Post | Replies |
|
| Update query underlying a combobox | 12 Jun 2006 01:24 GMT | 1 |
On a form, I have a frame that is used to identify a building number (1,2,3) the value of which is used as the select variable of a query underlying a combox, the value of which is stored as part of the record completed by my form.
|
| Need a loop! | 12 Jun 2006 00:36 GMT | 15 |
Is there a way to change the text code below into a loop? I tried the following, but it did not work dim vso for vso = 2001 to 2028
|
| How to populate a control from one of a number of forms that might be open | 11 Jun 2006 19:15 GMT | 2 |
I would like to populate a control in form B with a value from a control with a common name in say 5 different forms (A1-A5), the one form I am using (A1-A5), should determine what to populate the new one (form B) with when I open form (command button). How do I refer to the ...
|
| VBA loop variable reference in dlookup criteria | 11 Jun 2006 17:32 GMT | 2 |
Is it possible to refer to VBA loop variables from dlookup expression criteria?
|
| Access 2000 wizard can't add fields to form or report from tbl or | 11 Jun 2006 05:45 GMT | 1 |
This is very similar to Knowledge Base */kb/209024/en-us EXCEPT that is does not apply to Cross-Tab query but to a simple table and query. For a brand new table as well as a query (based on the table), the field list is blank and the field add buttons (>, >>, etc) are greyed out. ...
|
| help with switchboard error pleeeeeease!!! | 11 Jun 2006 05:39 GMT | 1 |
I'm sure some of you out there have experienced a switchboard error. Well I've done a lot of reading and still can't get it fixed. I have a database that I created in Access 2003, but in Access 200 format. I created all the tables, queries and reports to my liking.
|
| comparing value combobox | 11 Jun 2006 03:00 GMT | 1 |
Hello I'm stuck This is what I'm trying to acchieve I want to find out if the selected value of a combobox is already part of a table.
|
| Datasheet View - Zooming | 11 Jun 2006 02:44 GMT | 2 |
I would like to be able to zoom a datasheet view as if it were a spreadsheet. I can place a zoom icon on the toolbar but it remains greyed out and inactive. Is there a way to get this to work? Leonard Priestley
|
| Total of a subset of records reported to a box on a form | 10 Jun 2006 22:42 GMT | 1 |
I want a box that will look at another box on that form then find all the instances of that entry in a table then total all the entries in another field on that table and report it to the box. Ex. If box1 = X and reports its entry to field y in table1 then find all
|
| Populating new record by copying last record | 10 Jun 2006 21:28 GMT | 1 |
I have a table tha contains many memo fields. When I create a new record most times I have to change minor data in each field. Thus I don't have to retype or paste all of the information over. How can I create a command button that will pull the info from the last
|
| How "Enter" without deleting data in Access | 10 Jun 2006 19:10 GMT | 1 |
How do I move between fields by using the "Enter" key and not delete the present data. In imputting data, it is not recognised in the query. I have to use tab to move. There must be somewhere to control this function.
|
| Frame Text display problem | 10 Jun 2006 14:07 GMT | 3 |
I have the following problem, In the secondary form I have a frame text which contain a number. When the subform has no records (the allowadditoions = false) it must display the value 0.00 €.
|
| Warming Message for incorrect number format | 10 Jun 2006 13:42 GMT | 6 |
I asked this before and I am still having trouble with it. I just need, each value seperatly, a custom number format of x.xx, Anything other than this format will produce a warning message box alerting the user of the incorrect format. EX. xx.x or xxx. Can anyone help me?
|
| automatically calculate DOB or age fields if not entered | 10 Jun 2006 11:46 GMT | 3 |
I have a form where I ask for either Date of Birth, or age. I want to automatically calculate and store the age field if the user enters a date of birth, otherwise, I'll store the user-entered age value. I can successfully use an expression to calculate the age value, my query is ...
|
| y won't access2004 show datasheet view even tho set in properties | 10 Jun 2006 02:12 GMT | 8 |
i have repeatedly tried 2 get a particular form 2 show up as a datasheet both manually and using a wizard. it consistently shows up as a regular form. i have set the properties 2 datasheet view, etc. is this a bug in this version of access 2003? or will it only do datasheet ...
|