| Thread | Last Post | Replies |
|
| locked record | 23 Feb 2007 22:30 GMT | 5 |
I have an line that appeared in the table that seems to be Greek characters. I can't delete it. Help. I can't sort or do anything because this entry is interferring. Suggestions, please for karen@wssra.org or debbie @wssra.org
|
| Unmatched Query always returning 1 blank result? | 23 Feb 2007 22:10 GMT | 2 |
[MS Access 2000] I have two tables with a linked primary key. I am using an Unmatched Query to find all the results in one table that do not appear in the other table based on the primary key. So when the two tables are
|
| SQL and VPN | 23 Feb 2007 21:51 GMT | 1 |
I’m new to Access (2007) and have developed a database that my co. wants to put on a VPN and give other offices access to the backend on are server. My question is this, can it easily be split to SQL (since we already have it) and what is the best way to have remote offices using ...
|
| Open a child form button | 23 Feb 2007 21:50 GMT | 2 |
I was wondering if its possible to creat a button into a form that leads to another form and close the mother form the same time. thanks
|
| Multiple forms in datasheet view Access 2007 | 23 Feb 2007 21:16 GMT | 1 |
We are creating several linked forms in datasheet wiew. Wen we select an element in a different form the cursor on the previous form desapear (missing left little triangle on former Acces Versions for selected fields) We know the focus can only be pressent at one form at time, but ...
|
| How to replace empty cells by NaN or -99 | 23 Feb 2007 21:08 GMT | 2 |
I am currently working on huge files imported into Access (1.5 Go in total splitted in 12 files). It is climatic datasets, and there is emply cells. i would like to find a easy way to replace all theses empty cells by a value (NaN or -99) in order to export theses files in
|
| Formatting the Date differently in mail merge | 23 Feb 2007 20:52 GMT | 3 |
I have a feild in a mail merge that is in the date format "##/##/####", but I want to change it to a longer format like, Month, Day, Year. I don't want to change the actual format of the original feild so that it is easier to input data, but wanted printed out differently in the ...
|
| Link 2 tables in the same database | 23 Feb 2007 20:12 GMT | 2 |
I have a database for tracking employee records with only 2 tables (Employees and Accounts). What I want to do is to be able to pull the employeeID from the employee table and place it in the employeeid in the acconts table. For example, in the employee table, I have the name, ...
|
| 'Undefined function in expression' error | 23 Feb 2007 19:35 GMT | 4 |
I'm a VB beginner using MS Access 2002 I'm trying to use the Haversine formula to calculate distances between geographic locations (lat longs) contained in a database. I have written a module to do this - the module contains trig and compiles OK. When I try to
|
| Access - Calculate diff between two dates - do not count weekends | 23 Feb 2007 19:27 GMT | 2 |
How do I calculate the number of days that have passed between two dates, without counting weekends?
|
| datediff | 23 Feb 2007 19:22 GMT | 2 |
i almost have a expression to calculate the length of employment for our employees, however, it is currently oly displaying the amount of days, how do i display the days and months of employment???? Can anyone suggest anything to help me??
|
| Developer Tools Backwards Compatibility | 23 Feb 2007 19:20 GMT | 19 |
I have developed an Access application with Access 2003. I have successfully converted the mdb to Access 2000 format and it will run (as an mdb or mde) under Office 2000 Access 2000. My question is: If I use the packaging tool from Visual Studio Tools For
|
| how do I print labels from table in access | 23 Feb 2007 18:59 GMT | 3 |
I created a table in Access. The table consist of names, address and phone numbers of businesses. I would like to print this information in a mailing label format. Can you assist??
|
| how do i put an expression in a table | 23 Feb 2007 18:22 GMT | 2 |
i need to subtract column b from column a in a table. column c is where i need the answer. i have read the "help" but did not see anything that shows how to add an expression to find the difference. i know it must be simple, but how do i do this?
|
| "like" search function | 23 Feb 2007 18:11 GMT | 2 |
I have a contract database. One table includes a field for contract provisions. I have created a query that allows you to search by different contract criteria. However, I would like to be able to seach by keyword found in the contract provision field. For example, the user ...
|