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

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

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

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

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

Hi everyone, I am having trouble getting my code to work. I have a form that has 5 checkboxes and under each of these 5 checkboxes there is a field where I want today's date to be placed when the checkbox is clicked and nulled when the checkbox is unclicked, but for some reason nothing...

Hello, I have a main form that can be updated using a subform. The subform has check boxes and when they are checked/unchecked the main form will change its status. My subform is called frmStatusDetails and the main form is called SchedView. In SchedView, SchedStatus is a box on the form...

Hi everyone, I am working on a database as a student intern and I am gradually learning access and VBA as I go along, so put simply, I am no expert. Currently, I have a form which displays 5 check boxes. Depending on information from a previous form, some of these check boxes may dissapear...

Hello everyone, I am a student intern and a bit of a novice to Microsoft Access. I have been asked to fix a database that originally had worked fine, however after my workplace switched to Microsoft XP, they changed the security settings so that certain Macro's in that database do not work...