Opening form on startup

[paulsimo]

Hi there

I hope somebody can help answer this seemingly easy question, although only easy if you know the answer.
I wish to open a form on start up of the PC. This part is simple enough, however I need it to place the cursor in the next available row in the first column. When I open the form it always places the cursor in the first row of the first column.
The application I am using it for is connected to an external rfid sensor taking regular readings automatically, in the event of power being cut to the PC, I need the form to re-open where it left off rather than overwrite the information it has already collected when power is resumed.

Hope somebody can help.

 

[RuralGuy]

Are you using a form? Is it in Continuous Form mode? Does each entry go on a new record?

 

[irish634]

Hi there

I hope somebody can help answer this seemingly easy question, although only easy if you know the answer.
I wish to open a form on start up of the PC. This part is simple enough, however I need it to place the cursor in the next available row in the first column. When I open the form it always places the cursor in the first row of the first column.
The application I am using it for is connected to an external rfid sensor taking regular readings automatically, in the event of power being cut to the PC, I need the form to re-open where it left off rather than overwrite the information it has already collected when power is resumed.

Hope somebody can help.

I use subforms a lot in datasheet view. It sounds like this is what you are doing too.

Perhaps one of these statements will help:
DoCmd.GoToRecord acForm, "YourFormNameHere", acLast
DoCmd.GoToRecord acForm, "YourFormNameHere", acNewRec

Or maybe the "setfocus" command will better suit your needs.

 

[paulsimo]

Yes, it is a form I wish to open, not sure what you mean by continous form mode, but each entry does go onto a new record.
I collect the information from the reader via a piece of software called BC Wedge. This places the rfid identity number into the next available record in the first field, named "ChipID" and then moves the cursor down to the next record.

Many thanks.

 

[paulsimo]

The form is in datasheet view, as the rifd is detected and recorded in the 1st field, named "ChipID" the 2nd field, named "Time" automatically records the time and date, keeping a record of which rfid was recorded and when.

Many thanks.

 

[RuralGuy]

If you set DataEntry to YES then you are always on a NEW record.

 

[RuralGuy]

Here's a list of words that should be avoided as names for anything in Access because they conflict with existing Access stuff (technical reference).

 

[paulsimo]

Thanks for your answers to my question. I tried the data entry option and it works as I wanted it to, although I was alarmed when all the previous records seemed to disappear. As I had it bound to a table I realised the records were still there and showed in the table, but now hidden in the form when it opens.
I also took note of words to be avoided, I shall rename the 2nd field to something different.
Once again the forum has provided me with the answers, very quickly and efficiently.

Thanks guys.

 

[RuralGuy]

Glad we were able to help. FYI, it is always a good practice to bind your forms to a query of a table rather than directly to the table.

 

[Niroth]

If you want to see all the previous record as well as go to a new record, you should try irish634's suggestion:

DoCmd.GoToRecord acForm, "YourFormNameHere", acNewRec

in the form's onOpen event.