Search results

isetea, name the command button whatever makes sense to you. I call it PopUsers: Private Sub PopUsers_Click() ListUsers.RowSource = "" Call ShowUserRosterMultipleUsers("ThePathToMyDB") End Sub You can use your code, but what are you looking for? I started with the exact same code...

I think I saw something posted somewhere about a Transpose function. Do a search on this forum for Transpose.

Think about it for a second. You have $656.00 associated to Additional Living Room signed 06/20/2006 and $2,000.00 associated to Bathroom in the garden signed 06/22/2006 VO VO_Signed SumOfVO_Price Additional Living Room 06/20/2006 $656.00 Bathroom in the garden...

Do you have any VBA code anywhere? If so, do a search on this forum for References.

Then you have to get rid of the VO & VO_Signed fields in your query. They have unique values that is throwing off the Group By: SELECT tblPhase.Phase_No, tblPhase.Roads_Bond_Received, tblPhase.Roads_Bond_Ref_No, tblPhase.Roads_Adopted, tblSite.Site_No, tblSite.Department_Number, tblSite.Name...

You can also run this in any Enterprise Manager ... Table Design View ... SQL and paste and run the text. Be sure to re-register the server in EM, though.

I guess I am not understanding what the problem is. If you are able to read the first line, and the second line, why can't you read the third and subsequent lines? What do you get in the Immediate (Debug) window if you run this? Dim InputData Dim MyCounter AS Integer Open "MYFILE" For Input...

What is returned by: SELECT srvname FROM master.dbo.sysservers WHERE srvid = 0 is it the correct name of the instance? Was there ever a renaming of the server or of the SQL Server instance? ** Edit I wanted to add that you should always have the server registered with its name. Don't now if...

Gemma, the cn can be directed at any Access database. That is how I do it. I pass the location of the database that I want to know who the users are, whether it be FE or BE. I have a form with a listbox (ListUsers) that will then list out the users and a text box where I can put in the path...

Add: SET NOCOUNT ON After the AS statement. http://groups.google.com/group/microsoft.public.sqlserver.clients/browse_thread/thread/4afde934c9297196/6689144ed9a61c36%236689144ed9a61c36

It won't truncate from a call from a job to a SP. It is when you are looking at the results through QA. If you want to check it, do a LEN(FieldName). The data is there.

Create a listbox on your form (ListUsers). In your While loop add: ListUsers.AddItem Whateveryouwantdisplayed

Do a search for them, but the default is: C:\Program Files\Microsoft SQL Server\MSSQL\Data

In Query Analyzer.

Do some searches on Decompiling an Access Database. This may free up some of the issues that Colin was referring to.

Tools ... Options ... Results ... Maximum Characters per Column The default is set to 255. I changed mine to 8000 when I came across this issue. No problems since.

My guess is that you are not dropping the temporary table and it is having issues with it. Instead of using a temporary table, try using a table variable. It is stored in memory and is just right for your needs here. CREATE PROCEDURE dbo.Receivable_Aging_InDays_2 @CompanyNumber CHAR(2)...

Look up what Unicode is. A brief explanation is that it is an expanded character set able to store the additional characters used in all the character for the different languages. Char = 8 bit length NChar = 16 bit length

Check the References. Lots of posts here regarding this. Do a search on References

Not sure I understand ... perhaps you are looking for a counter? Dim InputData Dim MyCounter AS Integer MyCounter = 1 Open "MYFILE" For Input As #1 ' Open file for input. Do While Not EOF(1) ' Check for end of file. Line Input #1, InputData ' Read line of data. If Instr(InputData,"TOTAL") <> 0...