Search results

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

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?

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

Is there a way to have the date show up in a different cell when an entry has been made on the sheet. For example: Cell C3 has N then in cell F will show the date of entry

Been working on a new program that is working however when it reaches the case select it skips case 1 moves to case 2 checks it and skips the rest of the cases and exits the cycle. Variable myID will only stay on the first row of data and will not check the rest of the excel spreadsheet. What...

I have created a database and would like to link the data from excel into the database but I have found that one of the columns will only accept numbers and will not allow changes to the datatype to allow this otherwise I have #!NUM and you cannot read it. I have imported the data from excel...

Is there a way to add a comment to a specific cell while unprotecting and protect the sheet?

Is there a way to modify the if statements to help reduce the cluttered mess for the if statements. I am going to be adding more if statements to compensate for more data. Below is the program that I currently have: Private Sub process(ByVal myRow As Integer, myCol As Integer) Dim ce As String...

So far this code is running fine however I have noticed that everytime I rerun the update for data it keeps showing the form while updating is there a way to hide it and have it show only once for each page that requires it. Option Explicit Private Sub process() Dim ce As String Dim AA As...

I am somewhat new to using VBA and I have used the basic countif function but would like to use VBA and have it store the answer in a different cell without the msgbox. I plan to use this information later. Any suggestions would be helpful. Here is what I am presently trying to use. Option...

I have a db that is not resetting once a selection is selected. It will reset after the db has been shutdown and restarted. What the form is suppose to do is pull from two tables and when selected only give the customer's part information for that particular one. Any suggestions would be...

I am working on a vb project that involves MS Access. My question is: Is there a way to divide the values of two textboxes and have it placed into a different column? Or is it wiser to be doing some of this in Excel?

I have done this once before but apparently I have forgotten how to do this but I do have a db with a form and I want to have it filter the none active records by having it look at the archive check button. I have attached a copy of it for your viewing

Below is a copy of my code so far, I would like to make sure that I am on the right track. What I am doing is checking in one directory for any .txt file that has been last modified by about a few days and move those files to a different direcotry using vbs 2008. My other thought is use a...

I have created a vb form to access the server but when I click submit nothing happens to verify the user and then once the login has been verified I want it to go to another vb form. Any suggestions? Imports System Imports System.Text Imports System.Collections Imports System.DirectoryServices...