Recent content by MARKYB0Y

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