Recent content by Toby1kenobe

Hi All I've built up a form containing a textbox areas. On each of the 12 pages(all almost the same) is a "Student Name". Instead of updating this on each page i want this to be automated. In the properties of the first textbox (bookmark "Name1") i put a macro into the on Exit event. However...

Hi all I need to use data reports in landscape. I've set up the page as landscape in the printer dialog but i still get an error if i try to make my page wider than 15 in design view. I have a feeling that i'm missing something obvious and maybe i'm working too late? Thanks in advance Toby

Hi all I'm using Data environment to bind my front end to .mdb. I'm concerned that if i use the DE that i wont be able to add a routine that lets the user select a new (or find) data file. Can the Data Environment connection be changed in code? If so i don't need to worry Thanks in advance...

Dear Bob I was interested to read you're post, especially about not binding controls. Could you give me a quick rundown on how this can be done. I think it's the answer to my problem. thanks in advance Toby

Thanks for everyones help Replacing the singles with double quotes has done the trick Thanks Again Toby

Thanks for the speedy response I am using the jet engine v4 with an Access back_end. The code you suggested generates a syntax error, but not a type mismatch. Thanks again Toby 'trying to think of something amusing to type here!'

Hi All I'm trying to get results between two dates. The dates are prompted from the user in two text boxes. I then make two variables 'Sdate' and 'Edate' equal to the textboxes. Both these variables are set as Date sql2 = "SELECT * FROM daily_points WHERE date BETWEEN ' & #sdate# & '...

Dear Johnwm You are very true. In future i will endeavor to mark posts as useful. The tips i have been given have helped me enormously over the last year, and have always been prompt. Thanks for pointing this out to me Toby

Hi all I've set up a form as a 'Report Menu' from here i want to launch my reports. I can do this but i cant get the reports/query to look at items selected on this menu. For example, User selects a name from a combo, and this student's results are displayed. Do i just reference the controls...

Thanks again Jonathon I might be mising something really obvious because the Datareport object is not recognised. Is there a reference i need to install? Thanks Toby

thanks Jonathon Could i swap ......caption = "Filled in" for .................caption = forms!frm_Report_menu.combo1 ?? Thanks again toby

Hi all In access i've made reports that have an unbound text box at the top, set to a value from a combo box on the form that triggered the report. The user selected a name from the combo then previewd the report.The report has that name at the top. eg txtName = forms!frmReport_Menu.combo1...

HI In Access VBA it's possible to call data from columns in the combo ie; text1 = combo1.column(1) this is really usefull. Can combos in VB6 be made to do this. Is there a reference I'm missing? Column is not a property tht pops up Any help is always greatly appreciated Toby

Happy New Year to all I'm really struggling finding out how to make apps for my PPC (dell axim). I downloaded vis basic embedded tools, but when i tried to run the app i made on the PPC it told me that it didnt have the runtime files. Also the pocket access route seams to be a dead end. Has...

Hi All I want to set an Application Name for my DB. When set, such as "Heather Highschool", this gets used on any reports, forms etc. Is this possible? can labels have a variable name instead of the actual text? Can i set an label on a report that also looks at the Application name...