| Thread | Last Post | Replies |
|
| Default Value | 21 Oct 2007 22:56 GMT | 2 |
I have the following two fields (among others) on my form: 1. Checkbox called "Script Required?" 2. Combo box with a choice of services. Some services require scripts and others do not. The default value for the
|
| Report form Parameters | 21 Oct 2007 16:55 GMT | 8 |
Ok, I am a newby here. I have a report called MDB Data that is ran from a query called MDB Data Query. What I want to happen is when the report is clicked, I want it to prompt for a status parameter that gives the option of Open or Closed. The field related to this is called ...
|
| requery issue when combo box values set by another combo box value | 21 Oct 2007 16:49 GMT | 3 |
I am experiencing a problem when assigning values from one combo box to another. When I want to clear the newly assigned values I simply requery the combo box (single form so no issues there) but it refuses to requery. The orginal values for the combo are set when the form opens. ...
|
| Querying from two tables | 20 Oct 2007 22:43 GMT | 1 |
Let me describe my hang-up. In the first table (table 1), I have a unique code (CONTROL #), each one (i.e. row) corresponding to a particular sampling event. In table 2, I have the same set of CONTROL #s, but they are not unique in this table since each row describes an ...
|
| A "seek" problem | 19 Oct 2007 21:49 GMT | 11 |
I'm trying, in database moved from Access 2000 to 2007, to populate a link table with pairs of random integers structured to be in the range of the number of records in the master and detail tables. The sub hangs, in compilation, on a seek. It says "Compile error: wrong
|
| Starting Access | 19 Oct 2007 20:41 GMT | 3 |
I recently reinstalled Office 2003 because I needed replication to be enabled for Access. When I try to start Access from a desktop short cut or the Office menu Windows Installer starts and opens and closes configuration windows before the Access start page eventually opens. ...
|
| Lookup Not Working | 19 Oct 2007 17:16 GMT | 4 |
Running Access 2003 SP2. Have several tables and forms that utilize combo boxes to "lookup" info from other tables (i.e., state abbreviations) and everything is working fine. I installed SP3 and now all the combo boxes are displaying blank entries. I copied the database to a ...
|
| "Subscript Out of Range" shows up when I tried to split my databas | 19 Oct 2007 06:10 GMT | 1 |
I did split my database, but none of the tables show links to the original database. ... I've seen "subscript out of range". The back end db is created but not front end. What causes this? Thanks for help.
|
| Need Help with formatting | 19 Oct 2007 05:26 GMT | 2 |
I need help formatting telephone numbers in a table
|
| windows mail | 19 Oct 2007 05:11 GMT | 1 |
I need help setting up my windows mail, don't know about pop3 or stmp whatever I need to set up.
|
| Access 2003 problem with wrong totals | 19 Oct 2007 02:01 GMT | 1 |
Please bear with me as I try my best to describe a problem we have with our Access 2003 program. I didn't create our system but I do use it daily. We're using Access 2003 (I don't know the version) for a simple inventory program. We have 12 fields that has 10 items (entries) each. ...
|
| IF STATEMENT | 18 Oct 2007 21:12 GMT | 6 |
I imported a txt file into access and one of the fields is a date field. My problem is that some of the data in the field show up as '000000' because there is no date and the rest is a date (010107). So, when I brought it into access the column shows up blank when I make it
|
| Macro | 18 Oct 2007 20:59 GMT | 3 |
I need some help with building a macro. On a form, how do you use the Set Value Macro to hide (visible=no) a control based on the value in another field? What would you use for the Item and Expression?
|
| DateAdd function | 18 Oct 2007 19:44 GMT | 2 |
I'm trying to use the DateAdd function in a text box to add a specified number of working days to a date stored in another text box. I have typed: =DateAdd("w",4,[Text24]) where Text24 contains the original date of
|
| Age of Patient | 18 Oct 2007 17:41 GMT | 1 |
I need help. I'm new at this and I'm trying to write a facesheet and armband that will calculate the age and also put it in Years, Months, and Days. Here is what I have so far but the problem is that it putting it in years. I at a loss on what to do to get the month and
|