Recent content by sunshine076

How do I connect to an Access 2003 database in read only to a switchboard form? Con = New OleDbConnection Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBA & ";User ID=Admin;Password=suntime8,true" ' Dim Con As New...

I have been able to store a checkbox value into the database but when I want to retrieve this value have it read back into vb.net it doesn't want to read it Here is a copy of the field name and checkbox LeanFile_Closed.Checked = dr("FILE_CLOSED") that I am wanting to use.

I believe that I am on the right track with my thinking in regards to active cells in a range. what I am wanting to do is as an individual enters a value in a range of (F14:F1000) and is greater than .001 it will send an email to appropriate person. Sub Mylarchk() Dim val as Integer Dim rg as...

Ok thanks I will give it a try

try this select convert(varchar, getdate(), 108)

I have converted a macro that runs a chart with everything working properly. However, I have noticed that the range gives you a specific range and what I am looking is to be able to use the offset formula where if we lose or gain a row it will automatically update after the entry. How can I...

Is there a way to use a case select to hide images for different words such as apple, banana and pear. This would be in a list box and if one is selected it will show a picture of the item?

Since you are working with two separate functions make sure you use something similiar to this to separate the two. Function Area() End Function A source you can look at can be located at http://www.blueclaw-db.com/visual-basic-function/vba-function.htm

I will Thank you

Thanks VbaInet however, I have noticed that also it is allowing me to switch between names with the list it doesn't hide the pictures or show the correct one it stays on whatever one is on top of the pile. I have attached a copy of the file that I am presently working with. What it looks like...

Morning to everyone, I have a piece of code that I am modifying by adding a select case to it but it keeps giving me a compile error on .visible. What I am doing is trying to hide inactive pictures and only show the name of active person with their logo. Any suggestions would be greatly...

I pulled a piece of code from the internet and works well. however, I found out that when you import a picture that isn't linked to the specific cell it hides. Is there anyway to stop this action but keep the others hidden? Option Explicit Private Sub Worksheet_Calculate() Dim oPic As Picture...

I have found that the code that I have in my initial post does work however, it does not update access when a new line is entered into excel any suggestions?

sorry about this

I have written some code and found for the most part that it works up until the code updates an actual line of data form Excel. It will read it but it will not import the line into access. Option Explicit Dim intCOL As Integer Dim intROW As Integer Private Sub Worksheet_Change(ByVal Target...