Search:
Type: Posts; User: sparbag
Search:
Search took 0.09 seconds.
-
Hello sapator,
declare @mydate varchar(10)
, @realdate datetime
, @strDate varchar(8)
, @wrongdate varchar
set @realdate = getdate()
-
Hello Luca,
You are going to have to create an index on the DATE1 field. As far as I can read, this can only be achieved using code rather than the utilities that Access provides.
From other...
-
Hello Chapran,
Please investigate CHARINDEX and PATINDEX as a possible solution to what appears to be an overly complex solution.
search for the value in the string and its starting location in...
-
Hello John,
From my perspective everything is good up to the point you are adding the parameters.
I mostly work wit SQL Server when using access but most of the code is identical.
The...
-
Hello,
Two things to note.
1. the screen updating and other criteria to speed up your code will not work. The reason for this code not working is due to the calling sub losing focus, resetting...
-
Hello Pratik
xlApp.Quit
The Excel application Quit command 'should' close the application running in the background. It is good practice to test whether there are Excel application...
-
Hello Richard,
Line 18 is the beginning of the membership section of your config file. I do have a config file that includes the same section but mine appears as below
<membership>
...
-
Hello Steve,
I get the impression that you are completely confused by the entire process.
Personally I haven't used OLEDB for asp.net since VS 2010 and that was in C#.
Secondly I tend to write...
-
Hello Cory,
Please post the offending code and if possible, highlight to us what aspect of the try catch is returning the warning.
Kind regards
Steve
-
Hello Steve,
Apologies for the delay.
Dim strEmailValue As String = strEmail.Text
Dim passwordValue As String = password.Text
Dim MSAccess As String =...
-
My mistake it was.
your code has overcome the issue by using the full hierarchy rather than the importing the hierarchy and shortening the directives in the using statement.
Using conn As...
-
Hello Xcaliber,
Looking at my VBA scripts from Excel I suspect that when you set colFiles it is only picking a single file. That is all it can do.
If you change your code to
For Each...
-
Hello Steve,
It is great to see you using the Configuration manager and the web.config file.
Unfortunately you are missing a directive to access the functionality.
Add
Imports...
-
As far as I am aware you would Build the web site {Shift + F6} then copy everything to the folder on the web server where the pages would be visible.
That is how we have our web sites available to...
-
Hello Steve,
I do not think the JavaScript is causing your issue.
As I walked through your code it became very apparent that the two variables being sent to the database, in your query, are...
-
Hello George,
I think a function such as below, with tweaking, may suit your needs.
written straight into the text box and not tested.
Function fnConvertIntoNewString(ByVal variableOne As...
-
Hello Frangine,
a global variable as a filter for the file dialog
Public Const FILTER_MDB As String = "Microsoft Access Databases|*.mdb"
-
Hello,
Below should do most of what you require. You may need a small amount of amendments as this was written in notepad. Did not compile well in Notepad so couldn't test.
cmd.Connection =...
-
Hello Tammy,
From a logic perspective I would create four separate Boolean variables to hold the state of each checkbox. As the user selects a row the Booleans will have to be set to mimic the...
-
Hello Tammy,
I noticed that you had received no responses so decided to read why.
Whenever I read the 'mutually exclusive' in the fields of a database I tend to focus on the database design.
...
-
Hello,
From an SQL perspective I would believe that your error is being caused by the fact that all customer records are being identified with each of their child records in the [SpecInfo] table....
-
Hello DurrantBun,
Please bear with my answer as I have had to read what you are trying to achieve several times but I am still assessing the terminology in regards to filters and row labels.
...
-
Hello ,
From what I can gather, and this is an assumption based on the code, the type has never been initialised into any array. There has never been an index offered to hold a single record of...
-
I have written .NET to transfer data from a list into Excel by way of holding the list as a list of(list of aclass). This was by far the most efficient method that I believed would complete the task....
-
Hello,
I was in a similar situation some months ago whilst attempting to get an application, built by an absent other, to work within similar parameters
Private Sub arrDeleteElement(Of...
-
Hello,
I can see that you have misinterpreted or misunderstood the object model of Excel. In your code you are referencing a non existent worksheet object 'ws'.
private void...
-
Hello Cachado,
If you are going to use multiple connections I would also make use of the app.config file and add all of the connections into this file. This will centralise the connections and...
-
Hello Chachado,
It is quite simple. Firstly I would advise that you use well distinguishing variable names to uniquely identify your separate connections
Dim cnSQL As New SQLConnection
Dim...
-
SELECT * FROM Login WHERE Username='" & UsernameTextBox.Text & "' & AND Password='" & PasswordTextBox.Text & "'
if the table where the username and password are stored.
Even for a school project...
-
If the values down column B are all unique then the formula method will work. If the values down column B are not unique then the formula method will not work.
The contents of C5 and C8 will be...
-
Hello,
I am not certain that you would need VBa to get the solution, unless I have misunderstood the requirements
in column D starting at row2 place the formula
=IFERROR(VLOOKUP($A2, $B:$C,...
-
Hello,
The COM exception is due to an unrecognised object ("Excel.Sheet")
Please try
objExcel = CreateObject("Excel.Application")
This will give you access to the Excel Application...
-
Hello all,
I have resolved the issue. I could not change the server\machine name setup in SQL Server 2014 and began looking laterally at the issue.
It is not an unusual occurrence for the SQL...
-
Hello all,
I believe I am responsible for this error as my other developer machine is OK.
The install of 2014 sql server appears as :
SQLSERVER\DEVELOPER
I am using c# to connect to the...
-
Below is code that I have used succesfully in both Word and Excel VBA. This code has been available on the Internet for so long I forget.
Sub ListFilesInFolder(SourceFolderName As String,...
-
Hello,
Very little to change from my perspective.
If statements are logic gates: if (condition) the use my goto
Change the condition so that it meets required criteria and continues the code....
-
Hello Kris,
I sincereley hope the solution is not as simple as the solution I would use if I was facing the same issue.
=Countif(E5:AH5, "S")+Countif(E5:AH5, "A")
Kind regards
-
Hello very strange usernamed individual,
There will be a time when you will have to start looking at the tools that arrive with Excel can be very useful to you. One such tool is being able to set...
-
& " WHERE instead of & "WHERE"
Give that a go and post back if there are any other issues.
Kind regards
Steve
-
Hello Vargs,
For point 1. I have been in this situation. I overcame this by creating the first sheet as a set of instructions in how the user could set macro's. Also supply a user guide explaining...
|
Click Here to Expand Forum to Full Width
|