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

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# & '...

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

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'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'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 I want to count how many times each student name appears in a table. Those that appear >= 3 will show on a report. Sounds easy but it's giving me a headache (I'm slogging through SQL, and getting their slowly!!) Any help is as always greatly appreciated Toby

HI In order to produce a graph with two traces i need to use a query to combine two tables. The tables are called "Daily Points" and "Daily Points S and L". Both tables have a 'date' field and 'daily points' field. For my graph i need 'Daily Points' from both tables where...

I need to search records by specific dates, i can't get this to work because the dates include hours and minutes. I want to put in 14/7/03 and get results. How can i simplify the dates stored, or how do i search less specifically? Thanks Toby

Hi all Each day of the week Mon - Fri i collect a daily score for a particular student. I need to plot these scores on a line graph. I can produce the graph but not without the graph plotting every day (ie sat and sun too, and also holidays. I need the graph to just display dates that have a...

Dear All I'm new to arrays and am having reasonable success. The problem i'm having is trying to write zero to an array variable, like: sanctionarray(0) = Forms![points input].Check1 where check1 is a check box (and therefore i need to use zero) by the way sanctionarray is set as byte, could...

Hi I've been using VBA with access for a while so fust presumed that it would be easy to build some code for WORD, oh no. I want a form to popup containing a picture and some information with a button to close it. I've created the form 'Userform1' and tried to atatch it to the on open event of...

Hi I need to split a table which holds 40 records into 4 smaller tables. This will allow me to make 4 charts instead of 1. I've thought of using queries but i'm not sure of how to set the criteria Any help as always is greatly appreciated Toby

Can i increase the capacity that a textbox can hold? I am right saying that they can only hold 255 characters? Thanks for any help Toby

Hi I need my reports to open maximised. How can i achieve this? All help as always greatly appreciated Toby