Search results

Hi folks, I am using the following code in one of my databases, and it is working as it should but not as I would like it to. Dim strPathFile As String Dim strTable As String, strBrowseMsg As String Dim strFilter As String, strInitialDirectory As String Dim blnHasFieldNames As Boolean...

When I try to create a command button in any Access database, including new blank ones, I get the following messages. I have reinstalled Access over and over. I don't know what registry keys to delete and the problem still remains. Any ides would be helpful! "The database cannot be opened...

Hi all, I have got a database solution that I need some help with. The main problem is that it was designed in Access 2007 and I need it to run in Access 2003. When I try to convert the database, it tells me there are some features present which prevent it from being converted. I know...

Hi, I am trying to append the data I have stored in Excel format into an Access table using the following code: Private Sub Command0_Click() If MsgBox("This will open the Excel folder for spreadsheet imports. Continue?", vbYesNoCancel) = vbYes Then Dim i As Integer Dim tblStr As String...

Hi, Hope someone can help here. I have a field on a form, 'Date of Last Review'. This form is based on a query storing the details of all the patient reviews. The two important columns in this query relating to this query are 'Client Code' and 'Review Date'. Basically, there will be more...

Hi, I have a patient database with data stored in two tables. One form is used for entering personal details (First Name, Last Name, DOB, Patient Code, Sex, Address, Phone Number ect) for a patient. This is stored in the table called 'Patients'. Another form used for entering treatment data...

Hi, I have a table with 4 different columns. Each column has a measurable indicator where the value can range from 1 to 10. In the last column, I would like the field to calculate the average score for the previous 3 columns in that row. Is there a way to do this? Thanks, David...

Hi, I have a table containing patient data, including a column which has dates of birth for all patients, and another column containing the ages of all patients. I would like to produce a report containing a chart of all patients split into ages ranges as follows: <15, 15-19, 20-24, 25-29...

Hi, I am attempting to create a database that can score patients based on symptoms. Each assessment criteria is scaled from 1 to 10 (10 being most severe). There are 25 different assessment criteria that each have this scale. I would like to create a form whereby it is possible to enter a...

Hi, I have the a command button on a form which has the following code on click: DoCmd.TransferText acImportDelim, , "Patients", _ "T:\Practice Recovery Plans\data\import.csv", -1 However, what I would like to have is to be presented with a dialog box asking me to choose a csv file to...

Hi guys, I'm new to this forum and apologise for making my first post one that requests help. I came across this site by searching my problem in Google. However, that thread ended up not being what I was looking for, or at least, I didn't understand it. What I am trying to do (as per the...