Search results for query: *

I have this same problem, any ideas?

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

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

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

Thanks SOOO much this is perfect

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

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

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

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

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

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

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?

Beutiful. Thanks for all yout help.

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

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

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

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?

Im looking for pretty much the same thing!

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

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