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: *

  1. lamago

    Slow Startup of ADP

    I have this same problem, any ideas?
  2. lamago

    Filter report from subform , code error

    Check out thread958-1260216 I think this might answer your question.
  3. lamago

    Slow Startup of ADP

    Hi everyone, I finished converting form MdB to ADP frontend with a SQL Server backend. I put the FE on a WAN that users access through a shortcut on their desktop. The problem is that the ADP takes a long time to open for others, on my computer it is relatively fast. Is this normal? How...
  4. lamago

    Reference SQL Tables with VB in .adp

    Hi everyone, I finished putting all of my access tables into SQL Server 2000, i have all my procedures set, now I want to make an .adp front end, because im told this will allow multiple users into one database without corrupting the file, which has happened several times already. users will...
  5. lamago

    Best Update

    Thanks SOOO much this is perfect
  6. lamago

    Best Update

    This is my Data StudentID ELAPassed ELATestDate 1997000153.0 N 2001-03-13 00:00:00 1997000153.0 N 2002-03-05 00:00:00 1997000153.0 P 2003-05-13 00:00:00 1997000153.0 N 2002-07-23 00:00:00 1997000153.0 N 2002-11-05 00:00:00 1997000162.0 N 2005-09-13 00:00:00 1997000162.0 N 2005-05-10...
  7. lamago

    Best Update

    Hi, I have a table with duplicate records of each time a student took a test. I want to group each student into a single record table, but I need it in a specific sequence. If they ever have a Pass then use that, else if they did not pass use the last not pass, else if they never took it...
  8. lamago

    Creating a "Macro" in SQL

    Thanks! That exactly it! Actually cahseeadmin is the schema and cahsee is the database. Ill add that too. Thanks!
  9. lamago

    Creating a "Macro" in SQL

    Thanks, this is what im missing. What is a QA window? Query Analyser? How do I get to this using Enterprise Manager?
  10. lamago

    Creating a "Macro" in SQL

    Except when I dont put the go statement it doesnt create the table. Here is my code. How do I run a stored procedure? UPDATE [cahsee].[cahseeadmin].[Class Schedule] SET [School Number] = 32, [School] = 'PHS West' WHERE ( [School Number] = 30 AND [grade] = 9) UPDATE...
  11. lamago

    Creating a "Macro" in SQL

    Hi everyone, Im trying to go from Access to SQL. I want to set up a "macro" type procedure that does several operation. Update a table, drop a table, and create several other tables. When I use the stored procedure in SQLServer I can only use 1 Go. Does this mean I have to do one for each...
  12. lamago

    Use findfirst to get a value

    As a followup stix4t2 Why is it that you have an on error on top and on the bottom of that code, what does that do? And does anyone know what on error goto 0 does?
  13. lamago

    Use findfirst to get a value

    Beutiful. Thanks for all yout help.
  14. lamago

    Use findfirst to get a value

    Thanks! I used the debug.prints and what is happening is that some fields dont correspond so I have to put some kind of code so that it skips fields that .findfirst doest find, but how can I get it to go to the next fld? stix42 Im not sure I understand the error handler, I understand how it...
  15. lamago

    Use findfirst to get a value

    I am trying to copy data from one table to another, but the tables have different variable names. So I have a table named LayoutMatrix that has the names from one table that correspond to the names of the other table. Ie. ID, OldName, GlobalFieldName. I cant append it using SQL, but sometimes...
  16. lamago

    Mimick Paste Errors Table

    Hi everyone, Im am making a table programatically and appending to it from several tables in the database. The problem I have is that some fields are set to null due to Type Conversion, how can I find what these fields were, ie.e create a Paste Errors Table similar to the one Access creates...
  17. lamago

    FILE DSN Using UNC Path

    Thanks! I these worked for most of the computers. I had to change the server name to the IP name. But some users computers have the error "MIssing file ComTL32.ocx Version 1.3" What does this mean? Any ideas?
  18. lamago

    Datasources, how to define a global DSN

    Im looking for pretty much the same thing!
  19. lamago

    FILE DSN Using UNC Path

    I have a file dsn that I use to link SQL tables to access, the problem is that I Saved it on say L:\Data which is how it looks on my computer but others have different paths on their computers. I know the UNC path, but when I use this to create a file dsn it says fiel error #566. Is there a...
  20. lamago

    Create a TableDef with a type

    : ) Sorry, yes that is what I meant. The Type of a field

Part and Inventory Search

Back
Top