Recent content by HenryE

Thanks. (smacks own head). It works fine now. Henry

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, The reason I was using a table in the first place as the data source for the form was that it enabled me to use dropdowns in the form. Is there a way to allow dropdowns in Stored Procedures? It's easy to do with Views, but I don't know if it is possible with Stored Procedures. Thanks. Henry

jahooper, Thanks for the email. If I may ask: Why is using a table as the Record Source bad design (by the way, that is exactly the situation I have)? I'm much more familiar with Access than SQL Server, so I'm probably making many SQL Server mistakes. Thanks. Henry

Thank you very much! I think, hopefully, it's fixed. Have a star! Henry

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...

Ah, yes, I wish I could just buy a pc and pocket the change. Unfortunately... The key question I have is this: Is there any way to make things faster for the countries where the database is NOT hosted? For example, if the database is hosted in the US, what is the best way to make access...

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...

In the ADP. I know that making changes in the ADP, vs in Enterprise Manager or Query Analyser makes a difference, but does anyone know exactly what the differences are? Thanks. Henry

Thanks everyone for the ton of information. I think I might know what went wrong. I probably was a bit careless in changing the primary key name from FileNumber to DocketNumber, and, as this primary key was a foreign key in other tables, it didn't like that. I probably should have gone into...

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...

Thanks for the tip. The view works fine now. Henry

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...