Search results

Thanks Eugin - I should have thought of that! Doh! :o

Hi All I have a report, based on two tables which I have combined into a query. The first table is the invoice date & ref, and the second table is the invoice amounts & descriptions, which could be more than one. I have based the report on the underlying query, and I want all the many...

Hi I have developed a new database using Access 2003, which I need to roll out across various users. Some have XP, some Windows 7, and each of them has different size screens. I guess I will have to adjust the various forms to size to a particular users screen resolutions and sizes. Is...

Thank you both. Only being a UI user, not much VB or SQL, I think its option 1 that CJ listed. The control is an unbound combo drop down, and is blank when I first load the form. The subform has the linkchild and linkmaster info. When I open properties for the main form, and choose On...

Hi All I have a Form with an unbound combo box which, when selecting a date in the drop down, the underlying continuous subform populates with data. I have added a switchboard control which opens the form (in edit) and, even though I have managed to get the main control to be clear on entry...

I've cracked it! SELECT tblResWeekEnding.[Week Ending/Date] FROM tblResWeekEnding; simples - thanks Bill - Just you asking that question enabled me to write the code via a query! Cheers

Thanks Again Bill. I'm one of those self-trained types, who only use the UI to create databases, and maybe a little VB, but no SQL. I used the tool box to create the combo box, which is directly from the table where the dates are stored. Strangely enough, I can hit the page down key when...

Thanks Bill. Yes, I've set the control source to the table with the Week Ending dates, and the Row Source to the same table, yet I can only get a return of a list of the WeekEndingID, not the week ending itself. Should I delete the ID field and make the date field itself the key? Rgds Mark

Hi All I have created a simple database, with 2 x tables. The first is a 'Week Ending' table, with a dateid key and Week Ending field. I have created several week-ending dates in order for a user to input details of work done the previous week. The second table contains the details of the...

Hi All I Seem to be stuck on a small problem (aint it always the case). I have a report, based on a query, where the field name is "Date of Work". The criteria in this query field is >=[Start Date] And <=[End Date], which works fine. However I need to have the start and end dates to show in...