Search results

Hi I've done searches on this and am guessing I probably need Index and Match but have gotten completely confused with the answers that are there and can't see if any of them apply to my query. I have a sheet with Primary Diagnosis, First Secondary Diagnosis, Second Secondary Diagnosis, up...

Hi Does anyone know anything about Report Builder please - I'm using version 2.0. I did a search but couldn't find anything, so before I go writing my problem, thought I'd better check to see if anyone might be able to help!!? My problem is related to forcing page breaks when there is no data...

Hi I’m trying to do a convoluted IF AND OR statement and am getting in a bit of a mess. I’m trying to say: IF A cell = “Achieved” AND B cell = “Y” OR B cell = “N” OR B cell = “Not indicated” Then value = “Achieved” IF A cell = “Achieved” AND B cell = “Indicated?” OR B cell = “Invalid...

Hi I am using MS Query to return data into Excel. I know Access but am quite new to MS Query and keep finding vast differences between the two!! I've looked on the help but it doesn't seem to be of any! I have two date fields which are formatted as dd/mm/yyyy hh:mm - and I need to take one...

Hi I have a column in Excel where I would like to sum up those with the values of "No Scan Date" and "No Arrival Date". The column would look like this (but a lot longer)!: Time from Arrival to Scan (minutes) 170 266 No Scan Date 15 1213 No Scan Date 945 1135 32 55 No Arrival Date 731 No...

Hi All Not been around for a while but I'm back!! I'm using MS Query as an external data source for an Excel spreadsheet. On inputting <> 'Inter Hospital Transfer' as criteria under a certain field in MS Query, I thought I would be asking it to exclude Inter Hospital Transfer from the...

Hi Not been around for a while but good to be back!! I find myself using Access again which is great, but what appalling coding skills I did have, have kind of disappeared more or less completely apart from the dead simple stuff. I have a query, where there are a few fields which are looking...

Hi Not been using Access for a while and back using it again. I've got a table that I'm importing from Excel which is originally a download from another system. The date fields are mostly set as Date & Time so are displaying like: 09/04/2009 11:30:00 When I import these into Access they're...

Hi Been doing a form for the first time properly and am trying to get the default date be today. Have tried a couple of ways: 1) with using Ctrl + F9, Insert Field, Mail Merge and Fill-in. Then I try entering =Today, =Date, {date} and anything else that I know might possibly work! 2) The...

Hi - am doing a mail merge in word, (data source is Excel). My merge word document is just an invitation insert which will be chopped in two, therefore I have exactly the same text at the top as the bottom. I have "would like to invite ...«Name»..." then I have exactly the same at the bottom...

Hi all Just to say hi - I'm back again. Got a new job, (finished my life sentence with the NHS). After the most appalling treatment, I decided to leave. Have landed a fab job with a commercial mortgage company in Brentwood so am getting used to commuting for the first time ever! Am working...

Hi - I agreed to try and help someone who was having a problem in word and ended up completely stumped! When you insert a text box an anchor appears. When you preview, there's nothing there at all and when you come out of preview again there's nothing there. If you then put on another text...

Hi - it's been a while since I did much access and am trying to help someone out and have got into a pickle! A quick job has turned out to be a lot more complicated! Plus I'm having to use *spit* Acc 2k. When I go into frmHighCostDrug (from the "add new drug episode" button on the frmPatient) I...

This was something originally posted by Stewart that got lost in the hijacking. Was hunting high and low for it and eventually found a hard copy. Retyped it out - hope there's no typos!

Hi All I'm back with Access again for a short time (hurray) where I'm picking up a problem for one of Col's dbs. And I'm really stuck! :( It's a car parking db and you go into the record from a form with a list box on. There is a delete button, which has the usual wizard code behind it: On...

I've got some code on a form, that posts fields to a subform, (therefore a table). There is code (in a module) to trap whether any fields have been left null, but if there are, I'm getting a data conversion error for some of the numeric / currency fields. So rather than declaring them as...

I've just been asked by a user if there's any way of incorporating the autocorrect option within Access from a file from Word, ie, they've downloaded the Word doc with all the autocorrect features into a document, including all the ones they've added specifically for the medical secretaries...

I've got the following error message, but cannot for the life of me work out why I'm getting it. I've tried attaching the db, but can only get it to 130kb, which is still too big. Does anyone know why I'm getting it please? "The changes you requested were not successful because they would...

I've used the function as discussed in this post but am not getting quite what I need. It's disabling the use of the x in the database window, but not in the forms I need it. The database window is not visible to the users, and I would generally need to use this x button. I am wanting to...

Aarrrggh! I have a form where I keep getting this error message. First of all it was another message, which was "You can't add or change a record because a related record is required in table 'Episode'" Managed to sort that sticking a couple of DoCmd.RunCommand acCmdSaveRecord in. The 438...