Search results

In access 2007 I've added a description to a field in design view. I thought this was supposed to display in the status bar when that field was selected in datasheet view but it doesn't. Any idea what I'm doing wrong?

thanks for the link. thats set me in the right direction. this db will be for an NHS department so they'll be heavily oriented around week numbers and i can't really work around that. Ican't see this being used for more than a few years so, thinking about it, I might work them out by hand and...

nice one. my lap top screen should be able to do that res but it doesnt offer the option.

does the code tell access to adjust the size of forms and reports to fit the current screen res?

Thanks. I've done it in excel but there's a function for it. Even so it's tricky to use with regional variations involved.

please forgive my ignorance - what do i do with that code?

Can anyone suggest an approach to designing the layout of forms and reports so they fit neatly on a screen? I want my users to not need to scroll to get to everything. They'll be using 1366x768. The problem I have is not having something like a print preview to easily judge my layout. The...

http://www.access-programmers.co.uk/forums/showthread.php?p=1451729#post1451729 thanks

i'm designing an appointments database. Each appointment will have a time - year, date and time. I'll probably have at least one report that lists them by week number. So, here are my questions: should i break up the time into seperate fields i.e. year, date and time of day, or use just one...

Did you see my other post under 'tables' for advice on what fields to use for date and time etc?

thanks for this. Sorry for the delay - i've been ill. Now trying to pick up the threads of where i left off!

The action failed dialogue shows the arguments: Label1, 9, LUNA LUNA is the name of my main switchboard.

I use the switchboard wizard to set up a switchboard. At the moment my main switchboard has 3 items and they are all set to 'open form in add mode' and they all point to the same form at the moment (which does exist). When I try to go to form view of the switchboard I get the error 'The control...

I think I'll still pursue the non-VBA approach first. I've only been earning access a couple of weeks and I think I should learn to understand it a bit more first. I have just started into VBA in excel with very simple code and modifying macros. Am I right in thinking access doesn't have macros...

Thanks Mihail. I will need to select the date as one person may have many booked appointments and i'd prefer them not to need to scroll. I managed to get the subform to display properly by removing the parent child links. I'll work through your example a bit more today.

just out of curiosity, what's the advantage of putting the criteria in the header? Is that so they don't get lost if the form scrolls? I've been using a fixed subform so I assumed any scrolling would be within that box.

Thanks for that. It looks like a good article if you can manage VBA but unfortunately I'm not there yet!

I think, from all the advice i'm being given, that i'm trying to approach this the wrong way. Unfortunately i haven't been able to figure out the right way so i'm going to try to reframe my question... What would you say is the best way to approach the following? I want a form which allows...

Thanks, Mihail. It's given me loads of questions! I can't see where you select the name and date to filter to query in the subform. What was I doing wrong with the subform? That'll do for now!

I'm on 2007 too. the form tblappointment1 is a copy of the original form tblappointment that i made to experiment with after your post. the form tableappointment is intended to enter data into the table tblappointment whilst displaying tableappointment query3 in a subform. this query is a...