| Thread | Last Post | Replies |
|
| Mircosoft Access 2007 training | 20 May 2008 19:55 GMT | 2 |
Hi, I just loaded this product and need training on how to use it for an upcoming project. I was hoping you could provided me with a list of training sites were I may get some detailed training on this product.
|
| Runtime Error 94 when entering a new record | 20 May 2008 19:47 GMT | 2 |
I have two text boxes in a form that are only visible if their respective check boxes are clicked. The coding on the After Update event of the check boxes is as follows: Check box one:
|
| Data from multiple database tables | 20 May 2008 19:40 GMT | 4 |
I keep construction bid results in seperate databases (they are different projects). I need a report showing the results for a single contractor from all the databases, but not sure how to do this. For instance, a plumber has bid on 5 different jobs, hence 5 different databases ...
|
| date difference excluding weekends | 20 May 2008 19:27 GMT | 4 |
I am trying to write a query that will count the number of days between two dates but exclude weekends from the count. Any help would be greatly appreciated
|
| retain entry from parameter query (2 entries) for report display | 20 May 2008 19:21 GMT | 3 |
Good morning I have a query which prompts for Beginning Date and Ending Date on an existing field. I would like to have the Beginning Date and Ending Date print on a Report. Can I retain the value entered for Beginning
|
| Long Date format without day of the week | 20 May 2008 19:09 GMT | 3 |
How can I format a date to appear 'Month Day, Year' (ie. May 20, 2008)? The closest I can find is the Long Date format (ie. Tuesday, May 20, 2008), which includes the day of the week. How can I exclude the day from the format? What input mask would reflect the same date format?
|
| lock records in subform - multi-user | 20 May 2008 19:01 GMT | 3 |
My DB is in a multi-user environment. I have a form with a subform. On the main form is an edit button. When a user clicks the edit button, I want to disable editing of the main form for other users (no problem with this), but also disable editing of the related records in the ...
|
| dbSeeChanges are already there | 20 May 2008 18:56 GMT | 6 |
I run the following code and I get this error: You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column. (Error 3622) I’m putting in the dbSeeChanges but I’m still getting the error. Please help
|
| Creating Reports | 20 May 2008 18:45 GMT | 3 |
It would be nice to be able to use a created form as a template for creating a report.
 Signature -Matt
|
| Where DateTime Field >= '2008-03-22' | 20 May 2008 17:39 GMT | 8 |
In Design View for ACCESS 2003, how do I select records where a DateTime formatted field is >= '2008-03-22'? The field name is INSRT_TS in table QDDWCHAR, database MEDIB. Any ideas?
|
| Add fielf to combobox from an inputbox | 20 May 2008 17:36 GMT | 3 |
Sorry to ask again but its really urgent.. I have some combobox with a few fields (The values listed are not from a table, i just wrote them) previously added and one of them is called "Add new park".. i'm trying to create a code that when this option is
|
| Address Labels | 20 May 2008 17:08 GMT | 3 |
I am trying to create address labels in Access 2007, but when I go into the label wizard the Address field is not in the list of available fields. State, ZIP, Country, etc are all there but not street address. How can I get this field to appear in the available field list?
|
| *** URGENT PROBLEM *** !!! HELP NEEDED !!! | 20 May 2008 15:16 GMT | 1 |
|
| Using a form to supply DCount Criteria | 20 May 2008 15:14 GMT | 21 |
I have a form (dialog box) where you can supply a range of dates and an expense category in order to customize a report. It's possible to not supply dates or an expense category in which case I want all expense records to be printed in the report. I want to use the DCount ...
|
| Finding Field Use | 20 May 2008 13:51 GMT | 2 |
Is there a way for me to easily locate every use of a field from a table that I have used in forms, queries or reports? For instance, if I have a table named tblTEST and it has a field named FIELD_A, I'd like to be able to find that field in every form, query or report that I've ...
|