Search results

Hi, I've been given an Excel list with almost 700 rows and two columns. A: name of school B: number of pupils who met a certain criteria, could be anywhere from 1 to 100. I have imported that list to Access and I will need to add more information for individual pupils. So as a first step I...

Hi, I have a report with a control called "Highlight" (which will be hidden eventually). Depending on which value I have selected on a form, one of the lines on my report will have the Highlight value set to "H" and the others will all be Null. I have verified that this is working. The H does...

I have a pretty complex (for me!!) Access database, with lots of queries/forms/reports and links to tables both in a back-end and to Excel files. Because I hotdesk across three sites and also work from home sometimes, I have the front-end, back-end and linked files all in different folders on a...

If you have data in one Excel worksheet, can you output a subset of it to another sheet in the same workbook, based on criteria set on another sheet? For example: Criteria sheet: User selects various values Data sheet: All the raw data, refreshed periodically, could be up to 50,000 rows x...

Hi, I use the code below to loop through a table and export data to a named range in almost 100 different spreadsheets. These are identical in all but the filename, which changes by record. It works fine if I manually open all the sheets first and clear the ranges in all of them, but otherwise...

Hi, I have a button in my Access database that runs four queries and displays the results. The queries are designed in such a way that I know in advance how many rows and columns they will have and this won't change. The queries are named "qryExec01", "qryExec02" etc. I have an Excel...

Hi, I have data coming via Excel spreadsheet from an external source and it includes a column called PercentRecruitment. It looks like a percentage but actually it seems to be text. Some sample values are 10% 15.5% 0% 121.66666667% There's no consistency with the number of decimal places...

Hi, I receive data each week that comes in Excel, but apparently from another system called Qlikview before that (which I don't have access to). One of the columns is called %TE and can have values such as 0% 10% 66.6666667% or blank They are left justified, there is no set number of decimal...

Hi, I have attached a sample accdb which shows how far I've got with this. Background We have 30 hospitals in our region each designated by alpha codes. The hospitals can run various clinical studies, designated by numeric codes. Sometimes studies are specific to one hospital, but more often...

Hi, I have a process which runs lots of slow append queries, so I want to reassure the user of progress, by changing the font colour of labels to green when the relevant queries have finished. This is the code I'm using 'Update the older data if that option is selected If...

Hi, I use DoCmd.ShowToolbar "Ribbon" acToolbarNo (or acToolbarYes) depending on a value in a table which I have shown certain "trusted" users how to change. But is it possible to do something similar with the Navigation Pane? Thanks

Programming is not really my thing so I apologise for not really understanding some of the code I have pasted below. But I think I’m very close to getting this right and I just need some help to iron out a bug or two. The task is (1) output an Access query to Excel (2) overwrite that file if...

Hi, I'm a complete newbie at getting VBA to export from Access to Excel, but after looking at other threads here and elsewhere, I have cobbled together the following, which does most of what I need. The data is pasted in cell B1, but there are no column headings. Dim rs As dao.Recordset Dim...

Hi, The code below sets my printer to "Cute PDF writer" and then opens a report in print view, which creates a PDF version of my report. So far so good. But just before the last step, it brings up the Save As dialog box, asking for a filename and location. Three points are important: I...

I have a VBA routine that runs some queries and then creates a report as a PDF document using my virtual PDF printer. At this point it brings up the Save As dialog and I give the file a name and select a folder to store it in. But I run this report 30 times for 30 different parameters. The...

I have a listbox on my form with 30 options, referring to clinical specialties, cancer, diabetes etc. These options come from tblSpecialties. I have a command button which: Turns warnings off Runs various make-table queries, each of which refer to that listbox “Prints” a report to my PDF...

Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter...

Sorry if the following is a bit long-winded!! I have a database split FE/BE where the front-end sits on my laptop's desktop screen and connects to a back-end at my employer's head office, when I'm there 1-2 days a week (I don't need it at my usual office.) Several colleagues at other branches...

I have two browsers installed, IE8 and Chrome (Version 35.0.1916.153 m) I need IE8 because it links to clinical systems in the hospital where I work and those are apparently not compatible with newer versions. But I am also part of a research network which is using Google Apps, so I have...

Hi, I get two weekly files 'StudySummary' and 'Recruitment'. 'StudySummary' contains a list of clinical studies, 'Recruitment' contains the organisations in our area with the dates they have recruited patients to those studies. (It’s all anonymised and in the public domain) I’ve attached a...