Recent content by SR

My shiny new database is ready to go - now I have deleted all my trial data and want to re-set the autonumber primary key of my main table to start at "1" (I thought I could delete it and re-insert it but it won't let me). Suggestions?

Thank-you for your response (its taken me forever to get time to get back to this project...) - dumb question, because I am a "very limited" Access programmer... regarding the ABS function for changing my negative valued sums - where do I use this function? do I put it in the query somewhere? I...

I have a query calculating the sum of checked boxes of field 'A' ('letters sent') and the sum of checked boxes of field 'B' (letters received). My sum field is counting the boxes that are checked but showing the values with a negative sign in front?? How do I correct this? Also - could I...

I am working on a french version of Access but in my english forms, I need the current date field to be written in english - is there a way/expression to change the language of the date field on a form (from french to english)?

Missing subform data in datasheet view Thank-you AGAIN! Defining the relationships fixed my problem, but, another one has arisen: when I try to display my form in datasheet view, the "+" (which displays the subform fields) does not show the data entered (the fields are empty). The underlying...

(original thank-you below...) sorry, more stupid questions: I want the underlying table for the mainform to have the little column with the "+" you can press to see the related subform data. I created the two tables and then created a related form and subform, but the underlying table does not...

Form|Sub-form on same underlying table? (original thank-you below...sorry, more stupid questions...). I see in the example you sent me, that the underlying table for the mainform has the little column with the "+" you can press to see the related subform data. How do I create the table as...

Unsolved problem: I have created a data entry form using a subform to allow multiple entries under one person's name|coordinates (address etc - on main form). However, whenever I enter a record, the underlying table always shows one additional record with just the the main form info...

Easy question (I hope). I have created a data entry form using a subform to allow multiple entries under one person's name|coordinates (address etc - on main form). However, whenever I enter a record, the underlying table always shows one additional record with just the the main form info...

How big of a nightmare will it be to convert our 97 db to 2000? Tell me there's a very simple answer......

A question out of ignorance: We would like to post our database on the web for users to query and/or enter data (using a log-in process). Can it be linked to a back-end on our network server? Is it a difficult (complicated) process to set up (i.e. can a numbnut like me accomplish this?)? Are...

VERY EASY QUESTION I'm sure: I've added a table to the back-end and I don't know how to link it to front end. I've just copied it into front-end but would rather have it linked like the rest of the database and it does not show up on list of tables when I try to refresh links.....

Thank-you thank-you thank-you. That was exactly it. Now I can haul my computer away from the window ledge....

I want date to be displayed and stored as Medium Date. I am using the Medium Date input mask and I have set format to Medium date. Date types in correctly but then when I press enter to move to next field, it is displayed and stored backwards (so that 16-jun-01 shows "01-jun-16". The strange...