Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HenryE
  • Order by date
  1. HenryE

    HELP - strWhere problems in DoCmd.OpenReport

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

    HELP - strWhere problems in DoCmd.OpenReport

    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 =...
  3. HenryE

    Why Does "Server Filter" Get Stuck?

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

    Why Does "Server Filter" Get Stuck?

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

    Why Does "Server Filter" Get Stuck?

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

    Why Does "Server Filter" Get Stuck?

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

    Accessing database from around the world over Web

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

    Accessing database from around the world over Web

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

    Find Record Combo Box Wizard Won't Show 3rd Choice

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

    Broken Link Between ADP and SQL2000? "Can't find column..." Error

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

    Broken Link Between ADP and SQL2000? "Can't find column..." Error

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

    Broken Link Between ADP and SQL2000? "Can't find column..." Error

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

    Updatable Multitable Views?

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

    Updatable Multitable Views?

    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)...
  15. HenryE

    Help With Update + Insert Trigger

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

    Append Between Two SQL Server DB's

    nigelrivett, Thanks for the info. Triggers it is. I actually have to link several different databases, so the real-time linkages will be with triggers and the others with DTS. Henry
  17. HenryE

    Append Between Two SQL Server DB's

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

    Why # of Rows Not = # of Records???

    Thanks Everyone. The problem has gone away by itself, but I learned a lot from everyone's suggestions. Thanks. Henry
  19. HenryE

    Why # of Rows Not = # of Records???

    Thanks for the suggestion. I checked, but there are no duplicates. Henry
  20. HenryE

    Why # of Rows Not = # of Records???

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

Part and Inventory Search

Back
Top