And I understand I could accomplish this the same way using naming conventions and add numbers to the end, but I only want to do this once for each field after I leave the field, not every time I leave every field for every single field in the form. I hope that sentence makes sense...
Sorry...
Thank you BigRed1212. I used your idea to help me design my show/hide fields much better. Now I show and hide by <div> tags.
But I am stuck here again at validating. Because I show/hid by <div> tags using an integer and a loop, I am having trouble validating fields within the <div> tags...
I have been searching the web about this. It seems most people want to validate hidden fields instead of not validating the hidden fields.
I am thinking I might just create separate forms for each branch in the form. That way I can have separate submit buttons, and then use the different...
I am building a form for my business that has a lot of hidden fields.
Since I am hiding and showing fields due to different selections the users make, I want to validate only visible forms fields.
Here is my small form on a website. http://gaduu.com/RMA/
I don't have the validation script...
actually, I would like to not log into a physical computer there because all of the computers will be in use for some other task when I use my laptop. really what i want is to have that virtual network without having to log into a physical computer at work. is that possible?
Hi All,
Sorry for the newbie question but I don't know if what I want can be done. I have a windows XP set up with shared hard drives that all of the users on the network can see and use. When I travel out of town with my laptop, I want to be able to connect to the network and be able to see...
Hi All,
I want to have a clickable image that runs a script that will parse the webpage the image is on for a specific word. Once I find the word I am going to use it to search in a mysql 5.0 database. I want to do this the most efficient way. My only constraints are that the image click...
Hi All,
I have a very general question before I start a project. The answer will help me decide how to move forward with the project. Any help is appreciated.
I will be placing an image on some of my friend's websites. This image will be clickable and when the user does click on it, I want...
Thank you bborissov. Unfortunately your idea gave the same error. I figured out what does work by checking another application that connects to my database remotely and was already working. I check its connection string through some options screens and found that it was using {SQL SERVER} as...
I am trying to make a simple form with a close button separate from the x in the top right corner.
I have made the button in the middle of the form. The button is called Command1. In the code section of the button I have:
Private Sub Command1_Click()
Me.Close()
End Sub
When the form...
Hello All,
I have successfully connected to my SQLExpress server with a connection string locally on my machine. However, now I am trying to connect remotely to the server from withing my network and I am having some issues.
My connection string locally that works looks like so...
For all of those who are wondering the solution is below:
[code]COALESCE(a.Company, RTRIM(LTRIM(a.FirstName)) + ' ' + RTRIM(LTRIM(a.LastName)), RTRIM(LTRIM(a.LastName))) AS CompanyOrName,
[code]
The COALESCE function returns the first non-null arguement given. So it worked perfectly in this...
Unbelievable...
As soon as I stepped away to take a break for a moment I figured it out. It seems that I will wait till I take a break next time to post a question.
I am having a problem doing nested case statements within a select statement. The error I get is "Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'WHEN'.
SELECT
Sales.OrderID,
Buyers.eUserid,
Buyers.Email,
CASE
WHEN Addresses.Company IS NULL OR Addresses.Company = ''...
...= adUseClient
conSQL.Open
...
With cmdNewOrders
.ActiveConnection = conSQL
.CommandText = "SELECT All.* FROM All, New WHERE New.[order-id] = All.[order-id];"
.CommandType = adCmdText
End With
With rsNewOrders
.CursorType = adOpenStatic...
Thank you Golom,
One question. I have my server in a LAN in my office. The three other computers will eventually be using this Dataproject and Module on their computers, and the connection string will obviously need to change a bit. The question is, can I still use the AttachDBFileName = ...
...Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf;Data Source=.\sqlexpress"
conSQL.Open
conSQL.Execute "SELECT * FROM Sales;"
Set rstSQL = Nothing
conSQL.Close
Set conSQL = Nothing
End Sub
The reason I ask, is when I run the module with this code included nothing happens...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.