Search results for query: *

Hi, This should be very simple, but I can't make it work. I'm trying to open a report from a form using DoCmd.OpenReport and two criteria (choosing records that have student names that match two possibilities). It works with one criteria, as follows: Dim strWhere as String strWhere =...

Hi All, I have an ADP 2002 as the front end for a SQL Server 2000 database. Occasionally, a form will get stuck on a particular record and refuse to go to another record. I've found that when this happens, it is because the Server Filter has been set to the record the form is stuck on...

Here's a nice little scenario: Say you have users who would be accessing a SQL Server database over the web from around the world (mainly the US, Japan, and UK), and you wanted to make the access as fast as possible. Say also you have a couple of million dollars for hardware and software...

Hi All, Pretty much everyone knows that a very good way to find a record in a form is to use the combo box wizard and use the third choice - "Find a record on my form based on the value I selected in my combo box" on an unbound control. Anyone know why that 3rd choice sometimes...

Hi All, Has anyone gotten the "Cannot find column ..." and "Can't open the table in datasheet view" errors? I have an Access2002 ADP linked to SQL2000. My main table, TblCases, used to have FileNumber (varchar) as its primary key. I changed that field to DocketNumber...

Anyone know how to create updatable multitable views in SQL Server 2000? Actually, I was able to do just that for a view with two tables. However, I have been unable to do it for a view with more tables, or for a view that combines a table and another view (the one based on the two tables)...

Hello Everyone, I am trying to create a trigger that will add or modify data in a table, every time a user adds or modifies data in another table. Any ideas would be greatly appreciate. Here is what I currently have: -Two databses, call them DB1 and DB2. -Two tables, each in one of the...

I have two SQL Server 2000 databases on one server, call them DB1 and DB2. I would like DB1 to send data to DB2 from particular fields, whenever new information is added to those fields. So if a user adds a new person in DB1, therefore adding new data in the Names and EmployeeNumber fields in...

Help!!! I have a table in a SQL Server 2000 database where the number of rows (from Table Properties) is different from the number of records in the table. The difference is small, 12,748 rows, versus 12,750 records, but why is it happening? Especially since just a few hours ago, table...

Hi All, I have what may be a very simple problem: I have a database in Access, where in one of the forms I can perform searches using an unbound control. Works fine. Basically, the unbound control is a combo box that enables the user to choose from among a list, and based on that choice the...

Hey All, Is it possible to sort on a non-key field in a table? For example, say table Employees has primary field EmployeeNumber, and another field called Name. Is it possible to make the table be always sorted by Name, instead of by Employee Number? Thanks. Henry

Hi All, Is it possible to use a computed field as the primary key for a table in an ADP or in pure SQL Server? For example, say I have two fields in table Names: FirstName and LastName, and I create a field TotalName, which is FirstName+LastName. Is it at all possible to use TotalName as the...

Hey All, Anybody know how to use the Formula property for fields in the design view of a table in Access Data Projects? I've tried but I must be missing something, and I haven't found any references in my Access books. Thanks. Henry

Hi All, I just created a table where one field uses another field in the same table as a combo box. Namely, I have a table called Clients, with two fields: ClientName and CurrentClientName. ClientName has all possible names, recent, old, you name it, for clients. CurrentClientName calls...

Hello, I love the Access and ADP ability to use lookup tables as combo boxes. I'm now trying to build a pure SQL Server database, but with ADP-type abilities, and I have no idea how to create combo box lookup tables. You know how, in ADP's, in the table Design view, there are two tabs...

Hi All, I use combo boxes a lot in MS Access and ADP's. I'm trying to do use lookup tables as combo boxes in SQL Server, but I'm not getting anywhere. Any ideas? Thanks. Henry

Hey Everyone, I have an ADP linked to a SQL Server 2000 database. The odd thing is that in the main table, I can't make the Primary Key column the first column in the table's datasheet view. There used to be another primary key field and then I created this new primary key field, so maybe...

Hi All, We just upgraded from Access to SQL Server 2000. I'm trying to use ADP's to do in SQL Server what I used to be able to do in Access, namely create queries that would be used as the Record Source in forms to update several linked tables. I've tried to do this with views, stored...

Anyone know if Access 2000 has stacked bar charting capability. Excel does it easily, but as far as I can tell, Access 2000 only has normal bar charts. Has anyone managed to create a stacked bar chart in Access? Thanks. Henry

Hi All, Anyone know if it is possible to format text boxes and labels in Access forms so that, for example, the text is pushed in one space? Basically, I'm trying to have it not pressed right up against the side of the text box or label, and was wondering if this can be done automatically...