| Thread | Last Post | Replies |
|
| Problem creating MDE after adding another Report | 13 Feb 2007 18:46 GMT | 6 |
I have an application that I have created an MDE many times in the past with no problems. I just added another report, and associated parameter query form and query and, for some reason, now cannot create an MDE. When I now use the menu option to create an MDE, after selecting ...
|
| Opening Access 2003 to view tables etc | 13 Feb 2007 18:41 GMT | 1 |
At Canada Post we were on Access 2000, in order to open to the tables rather than the application we had to hold down the Shift key when clicking on the file we were opening. This does not work now when I try it it launches the appication front end, how do I get to my tables???? ...
|
| Format question? | 13 Feb 2007 18:17 GMT | 3 |
I need some help with formatting a numeric field. I need it to be 3 characters long with one decimal place. Right now, when I enter 45 it shows 45.0 and when I enter 123 it shows 123.0. What I want is it to show 4.5 or 12.3.
|
| multiple answer quiz database | 13 Feb 2007 17:34 GMT | 2 |
I am planning to make an access database with multiple answer quiz for training purpose in my office. Before I even start this project, does anyone know of an access database example out there that does this? Thank you,
|
| Add new records for Combo Box | 13 Feb 2007 17:29 GMT | 2 |
I have a combo box with 3 columns that I want to allow the user to add entries to. I tried adding an OnNotInList procedure, but it seems that it processes my AfterUpdate procedure first. I couldn't see how to add 3 columns of data here, so instead I open a
|
| DoCmd.OpenReport and OrderBy | 13 Feb 2007 17:17 GMT | 2 |
1st: Where do i insert the order by criteria in a DoCmd.OpenReport? 2nd: What syntax do i use? 3rd: How do I get a string variable from a sub form to become the OrderBy string
|
| Query by most recent modified date | 13 Feb 2007 17:16 GMT | 2 |
A table like this: moddate ID 1/1/2007 001 1/2/2007 001
|
| nebie | 13 Feb 2007 16:58 GMT | 2 |
Is there any test group under msnews.microsoft.com.. ? I haven't got access to any other nntp server right now..
|
| Combo Validation | 13 Feb 2007 16:55 GMT | 2 |
How do I make a validation rule for a combo box that the value of the combo box equals a value in the drop down list? Thanks, Dave
|
| work out 30 days end of month | 13 Feb 2007 16:32 GMT | 2 |
Im trying to get a formula that will work out the the due date on an invoice based on 30 days, end of month. Im assuming it needs to be something along the lines of Invoice Date + 30 + difference between the last day of the month and invoice date. i would like
|
| ADO/ULS problem | 13 Feb 2007 16:24 GMT | 3 |
I created an ADO recordset from a table called Students, however the code will not work for people without permission to read the table. How do I create a RS from a Table when the USER does not have read permissions to the table? For example, is there a way to use a RWOP query to ...
|
| Save Record and Close Window | 13 Feb 2007 15:59 GMT | 3 |
I have a form that launches a subform upon clicking a button. On the subform, one value is entered and a button clicked to save and close the subform. For some reason it's not saving my data. Here's the code used. Private Sub Command124_Click()
|
| Form On Top | 13 Feb 2007 15:29 GMT | 1 |
Hello Experts, I've designed a Switchboard linked to a Form. When users click the Switchboard, however, the Form opens in the middle a not at the top.
|
| IMPORT ERRORS | 13 Feb 2007 14:27 GMT | 2 |
When I import an xlss, I get errors on some rows. I think this is because the data type is listed as "double" not "text" like the other fields. I can't figure out how to change "double" to "text". I've tried edit copy paste special formulas in the xlss field and then import but ...
|
| Conditional Formatting | 13 Feb 2007 13:58 GMT | 3 |
How do I format a field in a table to change colors when I enter "Yes" I want the field to turn Green and when I enter "No" I want the field to turn Red. When I apply conditional formatting through design view form and put text in the form text box nothing happens. Not sure how ...
|