Search results for query: *

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...

Hi I was only joking about the spelling. I've sorted the problem now. I said in my posting that the bound col was 3, it wasn't but when i set it to 3- problem solved Toby

HI I'm pretty new to SQL. I want my combo to list names from a table. However the records in the table have the same names many times, so my combo results are a mile long. How can i make my combo just display one instance of each name featured? Thanks Toby

Hi I dont quite understand what you need to do but maybe you need some unbound text boxes, ie not linked to a table. so you could set up two unbound text boxes, txtPART1 and txtPART2 in the 'afterupdate' property of txtPART2 you could enter the code field36 = txtPART1 * txtPART2 assuming...

HI i'm pretty sure thats spelt wrong! I'm doing a DB which is school based working with form groups. I've kept the year and regestration part seperate, ie form names go 7A 7B 7O 8T 9U etc. so the table holds the number (ie 7) and letter (ie C) seperate. I'm recording daily incidents and am...

Hi Thanks Rick, this is helping me also. I'm just earwigging! If i install my DB on the target Network and Secure it, will it make all other DB's they might have use my passwords? What i want to do is set up security on this machine, create a new WIF, put this file and my DB on the target...