Search results

(Access 2010) Hi, I have a table with 22 fields: - 1 ID (autonumber) - 1 Date (date/time) - 10 x reportnumber (text) - 10 x description (text) I also have a form to populate this table. I would like an unbound textbox on the form to tell me the number of reportnumbers I have entered on the...

How can I add an ID-number that always increases (by 1) each time I add a new record to a table (using a form)? I want to always use some info from the record that was added last to fill in a different form. The reason for my question is that I heard that the autonumber does not necessarily...

What I did was add an autonumber ID field to the table. Each time a new record is created it creates a number higher than the last one right? I have the table ordered on this number and then have it select the last one. Would this be good solution?

I do want it to go to the last record I have added, not specifically the last date or other value. I also found a workaround for the last problem. I added an unbound control that accepts the last date value and after update have this filled into the date field I wanted updated. Thanks for your...

I get no errors. In your DB the MaxDateField is an unbound textbox. In mine it has a control source (same table as where the rest of the data from the form go into). If I remove the control source it does fill in the correct value in the text box. But then it does not get filled into the table...

Now it says I can't assign a value to this object...

Hi JHB, Thanks for the response! The code does however give me a Compile error: Type mismatch, at "Set dbs"... Any thoughts?

Hi, I am trying to create a form with about 20 fields, with only 1 date field. Each time a user fills in the form, most values (but not all) are the same as the day before, so I have it duplicate on open. I would like the date value to be automatically adjusted, keeping all other fields...

How about this: I didn't have to go to work today because some snow fell earlier. It's result was the worst traffic in Holland ever!

Hi, My name is Mark and I am a new member from Amsterdam, Holland. I am relatively new to Access and am setting up a database for my friends company who makes reports on ships. This forum has been of great help to me already and I hope to keep learning from from al the smart people around here...