Search results

Hello, I am trying to import hyperlinks. Apparently it is not possible to import hyperlinks from excel to access with just the normal wizard. I have tried different techniques such as saving the excel file as a tab delimited file or adding # signs to the fields prior to import to access...

hahahahahaha! as long as we figure it out i suppose.

Thanks for that suggestion, it helped me pinpoint the problem. But now I have another problem. I entered the sql statement into the "sql" tab of a blank query. When I ran the query, it was have trouble finding the fields: , [Cause], [System], [Component], [Reportable to EPIX], [Manufacturer]...

Ah ok, thanks for the clarification, I misread your earlier post. CurrentDb.Execute "INSERT INTO LER_Digital ([Originated by], [Date Entered], [Reviewed by], [Date Reviewed], [Title], [Event Date], [Report Date], [Report Link], [LER Number], [Facility], [General Plant System], [Plant System]...

Thanks for the response. I am trying to get rid of the space, but because the first line is so long, it is not letting me delete to make it all one line so I thought that syntax is what is used to connect the lines together in a string. If I just leave the "&" and delete the "_" I get a syntax...

Hi, I am trying to move some records from one table to another using sql. When using this code: CurrentDb.Execute "INSERT INTO LER_Digital ([Originated by], [Date Entered], [Reviewed by], [Date Reviewed], [Title], [Event Date], [Report Date], [Report Link], [LER Number], [Facility]...

Thanks!! :D That worked, I am going to try to figure out what you did. I'll be back with questions if I cant figure it out. Thanks again!

Hello, I want to open a form based on two conditions: a date and a facility name The problem is that the data I have is not consistent when it comes to the facility name part. For example, if I wanted to search "apple" the data might have "apple" written as "apple1" or "apple2". Therefore it...

You are right, in that code I only have one array. I make two arrays later on based on your post afterwards where you tell me to simplify my data, so that code is outdated. I had added it there originally to try to show you what I was doing at the time. Thanks so much for providing that...

Hi Chris, Thank you for your response. Sorry if I am being difficult, but: I am confused, I gave you an array of plot points. One for the x-axis, and the other for the y-axis. I am a little confused as to how much more simple I could be. I am also confused as to why you are worried...

Sorry for the delay, I have been caught up with other things at work. I am now able to have two arrays, one with year, and the other with the number of events per year. here is an example of what my arrays print out: Year: 2010, 2011 No. Events: 2, 7 Granted this is barely enough...

Hi Chris, Thanks for your clear response. Based on your post it looks like my data is not in as simple of a form as it should be. I'll get back to you when I figure out how to make it more simple. Here is my situation: This is what I want: X axis: Date range, in years (1980...

Hi Chris, Unfortunately, I can't really give out the data because the database has some sensitive information in it. But here are the fields I am working with: Facility - Text Event Date - Date/Time Plant System - Text Facility and Plant System are user inputs that I get with an Input Box...

Hello, Here is the background on my question: I am trying to make a chart report where I want to show the sum of total events (the user inputs the criteria for the event they want the sum of) that have occured over time in the form of a line graph. I want the x axis to be years and the y...

Wow, what a simple mistake. Thanks so much!

PeterF, thanks so much for the clear steps you provided! I tried that code and it worked (obviously as you wrote it :)) As I mentioned in my first post, I want to sort the array. I understand that vba for access does not have a Array.Sort function. I found this function on this site through...

Thanks for your response. I am using Access 07. I ended up having to import the database into a new database because there was a corrupt form and it was not letting me delete it. But now that I do not get a runtime error, when I go from design view into form view I only get a blank form...

Hello, I am a self learning access user and I have some very basic experience with vba with random tasks that have been assigned to me at work. This is the first time that I am trying to use arrays with Access and I am facing some challenges. I have a fundamental understanding of arrays from...

Ok, so I changed my code and instead of using the clickconditions I am going to write something different in each of the after update subfunctions. Private Sub chkLB_AfterUpdate() If chkLB Then If MsgBox("Are you sure you want to make this update?", vbOKCancel) = vbOK Then...

When the event looks like this: Private Sub chkCSDAB_AfterUpdate() If chkCSDAB Then csdabapprovedate = Date Else csdabapprovedate = Null End If 'clickconditions End Sub When I click on the CSDAB checkbox on the form, nothing happens.