| Thread | Last Post | Replies |
|
| Inputting case-based conditional statement with wildcard into SQL | 10 Jul 2007 03:34 GMT | 3 |
As a disclaimer, I'm not sure if what I'm specifically trying to do can in fact be done, but I figured that the program and users here are far smarter than me. I am trying to enter a new column in a query called "Zone" that will
|
| Remove subform filter does not show all records | 06 Jul 2007 21:01 GMT | 3 |
Hello... In Access 2003 Project... I have two subforms on a parent form. One of these has a combo box for selecting the filter value, and a button for clearing the filter.
|
| How to create date modified field that changes when form is modifi | 06 Jul 2007 15:17 GMT | 6 |
I am new to Access. In FileMaker it was very easy to include a field that recorded the date each record was modified. I cannot figure out how to do it with Access. I assume it has something to do with the "After Update" form property, using
|
| Performance for different users | 05 Jul 2007 20:55 GMT | 1 |
I have the problem, that the performance between a 'normal SQL user' (= verry slow) and 'sa' (normal performance) is verry different. I open a form in my ADE Project an all data in this form are transfered vom SQL Server to ADE. The data are produced by a stored procedure.
|
| Access 2000 & SQL Server 2005 | 05 Jul 2007 15:24 GMT | 3 |
I am trying to first use an access .adp project of acces 2000 with sql server 2005. I can create project, I can also connect it with existing database using "sa" login, but when I try to add table I get the folowing error:
|
| Problem with SQL query | 02 Jul 2007 19:21 GMT | 2 |
I'm an Access/SQL novice and I have an sql problem: I have the following table Price: FuelID PriceDate Price LPG 1/05/2007 0,2
|