Hello everyone,
I am having a weird problem that I can't seem to find an answer to anywhere online so I thought I'd finally post a question.
I am trying to connect to a remote SQL Server through an Access .adp file (Access 2007) through the Data Link Properties. It works just fine on my laptop, which is running Windows XP and has SQL Server Manager 2005 installed. However, I can't get it to connect on my PC, which...
zswanson
Last Activity: May 23 '09, 09:41 PM
Joined: Jul 25 '07
Location:
-
Hey Matt,
Try changing @SearchText to nvarchar(15) instead of nchar(15). Since it is char, it is padding the value with spaces so that it is 15 characters in total length. Therefore, when you are searching for 'at' you are really searching for '%at___________ __%' (where _ is a space).
Zach -
Try CAST instead of CONVERT
SELECT CAST(entrydate AS datetime) FROM timeentryLeave a comment:
-
BULK INSERT row terminator issue
Hi everyone,
I receive a variety of text based files that seperates each row by a single delimiter, usually '~'. I use BULK INSERT to transfer the file from a text file to a temporary table. It works fine for most of the files (which use '~' as the delimiter for the rows), but for some reason I can't get it to work for a particular file.
The file looks like it uses a new line character as the row delimiter, so I put... -
I'm using whatever version is with Access 2003. I wanted to be able to use the function from any form. I figured it out. I didn't use a control array, I can't say I know how. What I did is below if anyone cares. It's kind of messy but it does the job using what I know how to do:
...Code:Public Sub subFlashControls(strControlNames As String, intSwitch As Integer, _ strFormMainName As String, _Leave a comment:
-
I kind of sovled my own problem by doing it through a split array instead. But if anyone knows how to do it the collection way, that would be better.
...Code:Private Sub lblEditInfo_Click() Dim arrTextNames As Variant Dim counter As Integer arrTextNames = Split("txtName;txtNickname;txtExternalID", ";") For counter = 0 ToLeave a comment:
-
Adding controls to a collection
Hello all,
I'm trying to change the propeties of 4 controls all at once using a collections object. Is this correct? I have to add them to a custom collection first, because I don't want all the controls (text boxes) on the form to change, only certain ones.
How can I get it to work?
Here's my code:
...Code:Private Sub lblEditInfo_Click() Dim colTextBoxes As Collection -
Alright, i'll give that a try.
Thanks for your help
It worked! Thanks again
I will visit this forum more often now...Leave a comment:
-
Reference a control through a string?
Hi all,
I have a sub-form that has 196 controls on it. The name for each control is a nubmer from 1 to 196.
I'd like to generate a loop that assigns a value to each control.
Is there a way to reference a control through a variable?
This is what I have now, without trying to attempt to reference through string:
(arrLayoutArray is a 28 row by 7 columns array that was generated in a...
No activity results to display
Leave a comment: