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

Well there wasnt exactly a ban on it. What happend is we have to design a database system using MS Access. I basically designed the forms, but done all queries in the vba code, instead of using access's query module thingies. So thats why i was told off. From your reactions, i'm sure that...

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

I tried the one that was made for fields that arnt of type text and that worked, ty. Hopefully i shouldnt have too many more problems. Thanks !

I get an error when doing this : =DLookUp("[Match_ID]","[tblMatch]","Home_Club_ID ='" & Forms!frmAdd_Result!cboHomeTeams & "' AND Away_Club_ID = '" & Forms!frmAdd_Result!cboAwayTeams & "'") The text box just shows up "#error". When i try to start form 2 manually instead of having it opened...

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

Well, i dont want to use vba because its for a uni assignment and were supposed to be doing an ms access database - not a vb assignment.

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 ?

Doesnt matter, got it working :D

I did try but i got an error whdn doing this : Docmd.OpenQuery "qryAddMatch" Error: This action/method requires a query name argument. Im not sure what this means though.

lol :D How do i run queries and/or macros from vba ?

*Bobby whips bradcccs with a metal chain * :D Thats ok, thanks for ya help :D

Well,that didnt completely answer my question but thanks to your reply i have thought of a better solution. If i split the form up. Originally the form comprised of this : User specifies home team and away team user specifies total goals scored by home and away team user specifies who...