Search results

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

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

This is from the Access Help file with the added line to check for TOTAL. Dim InputData 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 Then Exit Do...

1. Yes 2. No. You just have to understand the Excel Object Model. It is not very complicated. Rather intuitive, actually, if you have ever worked in Excel past the basics. Here is a snippet of code that I have used: 'Count the number of fields or column MyFieldCount = rs.Fields.Count...

Just put this in a new query. When you create a new query, don't add any tables (hit close on the table listing), then select View ... SQL View and paste this: SELECT * FROM dbo_Committment WHERE seq_no NOT IN (SELECT seq_no FROM dbo_Committment WHERE commitment_user_group_cd = "SRG")

Even better. Update the link to the location of the new file. That way, you can have a static name within your Access DB and have queries written to reference it. There are many posts on this forum to get a filename, so search for that function. Public Sub UpdateLinkLoc(FileLoc As String)...

Link the Excel workbook as a linked table and then create an Append Query where you get the unique values. File ... Get External Data ... Link Tables ... File type = Excel

Access is only going to import the data stored in cells in Excel. If you have check boxes, then you need to see if they are linked to a cell in your workbook. Check boxes are not data, just a way of displaying the data. You may have to move the source for the check boxes to an adjacent cell...

get rid of the parenthesis and add another 9 to the beginning.