Search results

My File is too big to upload (5.5mb)

Hi Pbaldy, I have not been able to find anything based on bookmark code, so anythin gyou could provide would be greatfully received thanks

I have been trying using the query in the OnOpen and OnClick events but to no avail. So I want all 30 rows of the table to be available but when the form opens I need it to open to the record with the most recent date. thanks for all your help

Hi Pbaldy, apologies fro not making myself clearer, but yes I want all records available, I simply want the first records visible to be the most recent record. I am not familiar with a bookmark code, can you elaborate please? thanks

Bracketing the Date has made the query run, but it isnt going to the correct row, it is only listing the one row, from there I am unable to select previous records.

Hi PBaldy, I have tried that but it does not seem to work the table is called Scores and the date field is called date I tried this SELECT * FROM Scores WHERE Date = (SELECT MAX(Date) FROM Scores WHERE Date <= Date()); and the query ran correctly but when I change the record source of...

Hi All, I have a form that lists scoresheets, dates are predefined on these scoresheets, what I would like is for when this form is called the row displayed is not row 1 but whatever date is nearest to todays date but not in the future how can I do this?

I am guessing not then :(

Hi Stockwell, that's done it many thanks!!

Hi All, is it possible to embed a font within Access as it is in Word or Powerpoint? I would like all my form's to show the custom font even if the user does not have the font installed

I already did that, when you enter the SUM Access removes it to just leave =[S1]+ etc so still the problem that it will add the 6 filds but only if they all have a laue in. I still need it to add the 6 fields even if some are blank thanks

Hi DJkarl, thanks for the response. as I do not really know VB that well I think Access and Excel are my best route. However what I would like is from Access to have a button on a form that would open my excel document and run a macro if that is possible? I do nto really want to create a new...

Hi All, I am in the process of creating a scoring and averages application. I have created a Access 2007 database to handle all the input of information, I also have an Excel 2007 workbook that I can import the table from access and then do tha calculations. What I would like to know is if...

Didnt see BOB's response, using the VAL infront of the textbox names does the addition as required so just the totalling as values are entered if possible !

Hi Guys, correct the columns of the table were text instead of number (weird that it can still divide, multiply and minus text values though?) anyway it is now adding all 6 values just great, however is it possible for it to add the values as it goes along? so if S1 and S2 are filled in it will...

Hi All, I have several text boxes on a form which are editable in my database, I would like to have a running total of these values on the form, the total is not needed in the database as the individual values are fine, how do I do this? I assume it is based on the control source of the...

Hi, I am trying to run a query to update all the teamnames in the scores table to be the same as whatever teamname is in ID1 slot the select statement runs fine on its own so it must be something in the syntax also, UPDATE [Scores] SET [Scores].[Teamname] = "anything" works just fine UPDATE...

Hi, I have a continuous form with 30 records that is too long really so I would like to split it into 2 lots of 15. I have created 2 query's that select the 2 sets of 15 records. how can I create a button to change the rowsource to the other query so the other set of info gets loaded into the...