Search results

Hello, My database system tracks football scores such as : 7/6/2004 Arsenal 1 - 3 Liverpool I have a tblMatch, which tracks the home team ID and the away team ID as well as the date of the match. Tbl clubs contains the id of the club and its name. So: tblMatch ```````` Home_Club_ID...

Hello, I have a form with a combo box on it. In my report i want a text box to display: "Showing results for " & value_from_form The value from the form is retrieved from a combo box. Im having trouble doing this though and have tried setting the control source to...

Guys, im not trying to print my report, just merely showing it on screen, however, it is always in portrait mode, even when i specify landscape in the wizard. Im using the desing view, and cant find how to change it to landscape, any ideas ?

Guys, i have a form where the user selects a football club, for example : Liverpool. When they click the View button or whatever, i want a report to show up showing all the teams that Liverpool have played. In the report i can get it working when there is just one source, e.g. just one...

Hello, im doing a university assignment and i was told off for using vba code, this was preety fair thoguh because i coded my whole access database in vba, so that was ok. But im wondering how to do this. I have a main menu, with three buttons on it, when there clicked they open up the...

Guys, i have a form and it loads existing results into a database using an sql query. THe user selects one of the records that they want to delete. When they click the delete button this code is run: DELETE * FROM tblGoals WHERE...

Guys, im trying to use a Dlookup to get the unique id (integer) from a table. Im doing a query, to put the result into a textbox. Dlookup("[Match_ID]", "[tblMatch]", "Home_Club_ID = [Forms]![frmAdd_Result].[cboHomeTeams] AND Away_Club_ID = [Forms]![frmAdd_Result].[cboAwayTeams]"); So...

I have a value of say 30 in a table - stored as integer. I have a text box on my form that finds this does a query to find this number, but of course when its stored in the text box its stored as "30". I need to run a query saying ... Where number_in_table = number_in_form but number_in_form...

Guys, i have a form and when the user clicks a particular button, some data (that they entered) is entered into a table. The listbox shows data from this table, but is empty until the user adds something. I want the listbox to requery when data has been added to the table. How can i do this ?

Guys i have a form and i need to set the value within a textbox or label to the value from a table using an sql select statement. I can get the value into a combo box using rowsource, but i need it either in a Textbox or Label. I dont want to use vba, because its for uni assignment. The...

Form 1 submits information to a database. When the button on form 1 is clicked Form2 loads. I want a textbox in form2, to = SELECT ....... but i dont want to use vba, and cant seem to make that textbox equal a certain value by default. Any ideas ?

Guys, im doing a university assignment. The user selects an item from a combo box. I want this item to be added to a listbox - is there a way to do this without using vba code and only using queries and stuff like that ? The item should also be removeable from the listbox if needed. Any ideas ?

I am designing a form that is interacting with some data in some tables. I have a combo box, where a user selects what they want. Then the select another value from a combo box next to it. I want to add these two values to a listbox, one value in one column, and one value in another. I have...

AHH.. PLEASE help me .... I really need some help. I am designing a form that is interacting with some data in some tables. I have a combo box, where a user selects what they want. Then the select another value from a combo box next to it. I want to add these two values to a listbox...