Search results

Hello gemma-the-husky and thanks for the reply, This sounds intriguing. Can you perhaps describe what the table structure would look like? Thanks again.

Hello John, Thanks for the reply. I think this is pretty much what I described, unless I'm missing something?

Hello, Thanks for the reply. I'm not sure if I'm familiar with the solution you're describing. Can you elaborate please?

Hello All, Here is the situation: A parent can have many relations (maternal- and paternal grandparents, siblings, father and mother and children). Each of these relations can in turn have zero or more medical conditions. Any single medical condition can be assigned to zero or more relations...

I thought that two functions, one to return the start date and one the end date, might be the easiest way. Thanks for the suggestions.

Hello, I'm trying to write a function that will accept an input parameter - Q1, Q2, Q3 or Q4 - and return two dates, a start and end date based on the value of the input parameter. So if the input was Q1, the start date would be '01/01/2013' and the end date '31/03/2013'. I can return one date...

Some extra information. If I export the data to Excel manually, the text field is not truncated.

Thanks for the replay. No, nothing like that.

I use the code below to loop through a recordset and then export every record with a matching practice id to an Excel spreadsheet. The code works fine as it is, except for a minor problem with spreadsheet itself. I've noticed that one of the fields in the Excel file has been truncated to 30...

Hello, I'm trying to create a series of excel spreadsheets from a recordset object. The recordset contains three records (to test), so I'd like to create three excel spreadsheets. The name of the spreadsheet is comprised of the 'practice' and '.xls'. Effectively, i want to code to loop through...

I have a difficult problem with a database. We have patients from multiple GP Practices. We need to send these practices a report with the results for their patients, say on a monthly basis. There may be up to 80 practices. I think I understand how to, say, send one email containing one...

Hello, I've just noticed that the text-boxes in datasheets in Access 2010 have a down arrow for sorting. Is there a way to remove or disable this feature? TIA.

Resolved. FYI I checked two boxes in the 'Access Options' section; 'Allow Full Menus' and 'Allow Default Shortcut Menus'.

In an Access 2003 db, I'm able to right-click on a report. One of the options that appears is 'Export'. You can then select 'Rich Text Format (*.rtf) in the 'Save as Type' drop-down box of the window that appears. The database that users needed to do this with has now been updated to Office...

I wonder, is it also possible to have the properties pane so that it too is free-floating?

Thanks. Exactly what I wanted.

Hello All, Have a slight issue when I'm looking at forms (or other objects for that matter). They all appear as a 'tab' in a central pane, so that the navigation pane is on the left, the form/table/report etc in the middle, and the properties pane on the right. I'd like switch to a view where...

Thanks for response. I've tried the following with no success (happens before the user closes the parent form): Forms!mainform!subform.Form.Recalc

I have a form with a subform. The subform contains a combo box (bound), from which the user can select a parent. The subform also displays some other data relating to the parent in a number of unbound controls. These get updated when the user selects something from the combo box. If the parent...

That's brilliant DJKarl! Thanks.