Search results

Hi All I have a master dataset which has approx 8500 patient records and have just inheritted another, similar dataset with approx 2500 patient records, many of which are duplicated. As part of this inherited dataset I have a table of test results some of which exist in the master dataset...

Hi All I am having an issue with the sort order on a subform. Basically I have a main form with Client Details and a subform hich displays the associated test results for this client. Each client can have multiple test results which should be displayed in date order. Initially the form...

Hi All I am having an issue with DLookup, which, for some reason which I do not understand appears to missing the first record in the table. What I am trying to do is to extract the e-mail address of all users who have 'Admin' status to the database. In the table ('LogIn') there are 3 users...

Am I missing something here? I have a split form wich shows individual record details in the top half and datasheet vie in the bottom half. The form settings are as follows:- Default View - Split Form Allow Form View - Yes Allow Datasheet View - No Allow Pivot Table View - No Allow Pivot...

Hi All Not sure if this is possible but I am trying to extract data from a word document to set up a database. Basically I am trying to capture data from completed forms, similar to the sample attached, the actual blank form is 20 pages long and once completed can be as many as 30 pages, or...

Hi All Not sure if this is possible but I am trying to extract data from a word document to set up a database. Basically I am trying to capture data from completed forms, similar to the sample attached, the actual blank form is 20 pages long and once completed can be as many as 30 pages, or...

Hi all I am trying to import data from Excel into Access to create new tables. However in some of the excel spreadsheets I am importing there are dates which precede 1900 and, although the data type is set to short date, for some reason excel decides to store these as text, so when I import...

I found this code really useful when setting up BE/FE Database and copying FE to users personal drive. The function will create a shortcut to the FE software on the users desktop so the user doesn't have to search for it. The function takes 2 paramaters, strFileName = The name of the link...

Hi All I have a form which uses a list box to select which record to display. The code is all generated by Access during form design. It is a method I have used numerous times inthe past in various database without problem (even in the current database I am developing). But for some reason...

Hi I have a form which uses a listbox to display a given record but when a user without edit rights opens the form in read only mode DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormreadOnly The user is unable to use the listbox to select a record to view. I have also tried opening the...

Hi All I have an unbound listbox on a form which displays a list of staff, both past and present, based on an SQL query. I want to be able to differentiate between current and past staff using different colors, i.e. Black text for current employees and red for employees who have left, based...

Hi All I have a form which displays records based on a selection from a list box on the form. The default record displayed when I load the form is record 1 from the table, this is not an issue when I initially load the form but I also have options to filter the records displayed in the list...

Hi All I am trying to apply a filter to a subform using the text filter Like "*text*" by setting up a dynamic SQL query for the subform, see code. The issue I have is that the SQL doesn't seem to apply to the form because it isn't filtering the form. If Not IsNull(Me.ID) Then...

I have a database which I have set up to manage users and permissions using the user level security wizard to set up users for a specific database. The issue I have is that it has now set user level restrictions on all of my databases, not just the one I wanted it on. Have I done something...

Hi All - hope you can help. I am trying to get a year value from the current date, the code is:- Dim CurrentYear as Long CurrentYear = Year(Date) However every time I try to run the code I get a Type mismatch error(error code 13). The really frustating part is that I have two similar...

Hi I am trying to use a combo box to enter a year value into a query. I want the values to list each year from, say 2000 to the current year, with a default value of "Current". Does anyone know a quick way of achieving this or will I have to code each year individually either into a value...