| Thread | Last Post | Replies |
|
| Now function on change | 09 Jul 2009 04:45 GMT | 1 |
I am trying to create a field in which the date time will change when I edit any field in the form. I can't figure out how to do it even though it is probably quite easy. Can anyone help me? Thanks in advance for any help.
|
| Access 2003 to 2007 | 08 Jul 2009 22:54 GMT | 1 |
I have recently installed office 2007 and now access is saying that I don't have permission to open the 2003 db. I don't have problems with any other program. I only need access to names, adds, tel no's etc nothing else.
|
| Remove Spaces | 08 Jul 2009 18:00 GMT | 4 |
I have inherited a Data Base where most fields have several spaces after the data. Can I use an Update query to clear the spaces, and if so, how would I write the Update query?
|
| Linking to selected fields in an external table | 08 Jul 2009 13:34 GMT | 4 |
I want to make an external link to a table on an Oracle database using an ODBC connection. Unfortunately the table in the Oracle database has approximately 300 fields and only the first 255 appear in Access, which I believe is the limit. However, I don't need all of the fields to ...
|
| Tab Control | 08 Jul 2009 12:11 GMT | 4 |
I have a single form with many fields in the Form. I have added a Tab control to the form with 2 pages, to split the fields onto two pages The problem is that when I click on either page the fields are repeated. If I try to cut and paste from 1 page to the other, I lose the ...
|
| Sorting based on selected value...Please help! | 08 Jul 2009 12:05 GMT | 4 |
I am trying to create a simple form where the users would enter (or select) the VIN number and all of the repairs that match that VIN number (and ONLY that VIN number) will be displayed. I cannot save a filter for this because users will obviously want to search for many ...
|
| Access 2007 - viewing Access objects | 07 Jul 2009 22:57 GMT | 3 |
Hi, I have been using Access 2003 and find Access 2007 VERY different! When I select the option of a new blank database, I can only see the tables. I would like to see the list, like with 2003, of Tables, Queries, Forms, Reports, Macros etc. I did find an option to show all ...
|
| Time Conversion | 07 Jul 2009 20:52 GMT | 4 |
If you have work 1 hour 30 Minutes How do you convert it to 1.50 And viceversa 1.50 to 1h 30m Thank you all,
|
| only calculate business days exclude weekends | 07 Jul 2009 18:47 GMT | 13 |
I have a a function below in my query, where it either add 1 or two day/s to the LLOOReqDate depending on when I receieve the request. The problem is if I receive the requeston a Friday, then it will need to show that the expected completion date should either be the next ...
|
| Oracle to Access | 07 Jul 2009 18:35 GMT | 1 |
I have Oracle database about 50 GB can I Import into access database. Is it possible. It will work good. This access database can support 50 GB data smoothly. Anyone can help me in this?
|
| Office 2007 ultimate long "configuration" process every time | 07 Jul 2009 17:38 GMT | 1 |
My computer crashed a little while ago. I used the restore discs and reinstalled Office 2007 ultimate on the computer. Now, every time I want to use one of the programs, it goes through a lengthy "configuration" process before the program will start up (it's like 7-10 minutes) ...
|
| Conditional formatting based on the Row Source in another control. | 07 Jul 2009 17:36 GMT | 6 |
How do you conditionally format a text box that is based on an IIF statement in another control? This is a sub form (sfrmKeys) with the following SQL: Row Source: SELECT [tblLocks].[LockID], [tblLocks].[Location],
|
| Unwanted Parameter! HELP! | 07 Jul 2009 15:56 GMT | 2 |
There is a parameter (Phone Number) that pops up every time I try to open a related Form or Report. I changed this field at one point so that instead of just Phone Number, there are now ¨Home Phone¨ and ¨Cell Phone¨ and am pretty sure that is how things got messed up, but all I ...
|
| Divide One Field into 3 parts | 06 Jul 2009 19:45 GMT | 9 |
I have a Name field that I would like to divide into 3 seperate parts? example: John W Smith Lisa Marie Jones
|
| ms access as a backend | 06 Jul 2009 19:11 GMT | 1 |
If you create an appliction that uses ms access as a backend do you need to install ms access? Thank you all, Bre-x
|