Recent content by Roli001

Put the following code in the VBA SHEET (not the module!) that you are changing the data for cell A1. Private Sub Worksheet_Change(ByVal Target As Range) '******If a change happens to cell A1 then run sub Validation_Example****** If Target.Address = "$A$1" Then Validation_Example End sub...

Try this: Sub Validation_Example() Dim Choices As String ' ******************This code tests the value of cell A1****************** Select Case Cells(1, 1) Case 1: Choices = "a,b,c" Case 2: Choices = "c,d,e" Case "yourText": Choices = "a,c,e" Case Else: Choices =...

I downloaded the files and put them in C:\Temp however when I try to open the mdb file, I get an error report:

So I figured out how to overcome the issue. Some solutions are so simple that it is impossible to see them until they hit you in the face.:o I used the import wizard and simply changed column 1 heading name to "Item Number". Because this is a "," delimited file the leading text and the words...

This is the first 2 rows + the leading information. I need to delete everything up to "Item Number" or have access import from the words "Item Number" with the first row as the column descriptions.

It takes me 15 - 20 seconds to open in Notepad, delete the leading text and save the file.

Hi, I have a large text file (80 MB) that is downloaded daily. The file has leading text with the source code of the file (about 60 characters). I have the text file linked to Access, however before I run my queries, I have to open the text file in Notepad and delete the leading text from the...