Search results

I tried: [ProductName] & Chr(13) & Chr(10) & [LatinName] but I just got the first string and one line. The second string may have been there but hidden because I couldn't see the second line.

I want to put 2 pieces of information in one text box on different lines e.g. the name of a plant and underneath it the latin name. I know how to concatenate them - [ProductName] & " " & [LatinName] - in the Field cell but how can I replace that space with a carriage return character (13)?

To be honest, even splitting it into front end and back end and have them stored in different places on the server is going to be a trial.... :banghead:

I think probably not.... partly because my knowledge doesn't extend to understanding a lot of the words you used and partly because I have no access or influence over the hospital's IT department. I've essentially got to give the senior therapist a file or files she can put on the server and/or...

Well, I wrote a scorching workbook that fulfilled all their requirements. Sadly I made a schoolboy error and didn't check how they would use it. It turned out they all wanted to keep it open most of the time and I was advised that this level of simultaneous use on a network would make it...

Now, I appreciate your offer but sadly I'm doing this for my local NHS rehab unit so there's no budget. To be honest, although I'm a whizz at excel (with help from the forums!) I'm an Access novice and I think this will be waaaay beyond me.... but I like to learn.

Well, that's the first hurdle overcome of many! My appointments lengths vary and they can start on a quarter hour. Somehow I have to translate a start time and duration into a size and position on the timetable. Still, one step at a time....

Thats pretty muc it. Thanks colin! Did you populate them manually as an example or do it through code?

Is there a way to draw a table with individual cells in like (like an excel spreadsheet)? I have to print a timetable with around 20 rows and 7 columns and if I have to draw 140 text boxes I'll go mad. In each box will be an event name (in text) happening in that days column at that row's...

Thanks, Colin. Do you know of a good tutorial on editing/saving your own themes?

OK, so I'm a newbie and note well the second commandment. Just out of curiosity, if lookup fields are so bad, why are they there and what are the alternatives?

I want to apply an autoformat in 2007 but I'm not keen on the built-in styles. Is it possible to find some free ones on line? (Green would be nice!) I did some googling but came up empty-handed. Thanks in advance.

I think I may have misunderstood something. When you create a combo box, there are 2 elements to it - what you display in the pull down list and what actually goes into the box when you make your selection. You have a lot of control over what is in the list as you can include any field if you...

Thanks for that. So what is it that dictates which field ends up in the combo box when you've selected a record with the pull down. Put another way, if I want the job title to go into the combo box, what do I set (and I think from what you say it's column 3?). Is it in properties somewhere...

I've had a play and I think I understand. I changed the therapist table to add a job title, added the job title to the query and added brackets around it and added an extra combo box to the form to pick the therapist's full name and their job title. It's given me a few more questions if you're...

forgive my ignorance but where does this code go?

That's all very useful - thanks. A couple of questions if I may? If I'm building a form with the wizard and I just want the name fields, why do I need to include the ID - especially if I'm then going to hide it? regarding relationships in general, I've been given a range of opinions that...

It does. You've been brilliant today, I really appreciate your time. I think I'm finally gripping the part that's been holding me back.

OK - that's a good article... I'm a convert. There must be a lot of alternative methods for putting the names into the name field (which I believe I should start thinking of as the id number for the record that contains the names) without using the lookup wizard. Do you know of any tutorials...

Is there a reason you've called the field in the appointments table 'therapistid' rather than 'fullname' or something like that? I'm thinking this might be the reason I've not understood relationships for so long. Am I right in thinking that wherever you use this field (appointments table...