Complete novice with Access and got a few simple (hopefully) questions

[niall]

That looks like VB.net syntax. VBA would be:

Me.txtKickOffTime.SetFocus

Great. It worked. You lot are more of a help than my lazy teacher !

ONE more thing (probably not) - is there anyway of taking the day from a date-formatted text box and putting that value in another box? What I mean is, I've got a combo box with the days of the week to choose from, which I input myself (not taken from a table). Then, right next to it, I've got a DATE box that has a long date format, so it comes up with the calendar style thingy. However, if the user chooses Wednesday in the DAY box, they could easily pick a DATE on the calendar that's a Thursday or Monday etc. in the DATE box, because the DAY values have no meaning as I input them myself.

Is there any sort of validation I could do, or possibly - like I said - take the value of the DAY from the DATE box and put in into the DAY box?

Confusing, I know. Used caps to indicate the different boxes

This is hard! And I was thinking of doing software engineering at University

[June7]

Try expression in DAY box control source property:

= Format([Date Box Name],"dddd")

[niall]

Try expression in DAY box control source property:

= Format([Date Box Name],"dddd")

Genius. Thanks again.

[niall]

Anyway, about that append query. I've completely forgotten how to do them! I've got dozens of update and select queries but I can't remember the append querys. I thought it was as simple as:
- This is my attempt, but it doesn't seem to work.

- this is the form where the values come from. The value from 'txtNewPlayerName' needs to append to the new record in the 'PlayerName' primary key field (see above), the value from 'txtNewSquadNumber' needs to append to this new record in the 'SquadNumber' field and the value from 'cboNewTeamName' needs to go in the 'TeamID' primary key field to the new record. Bear in mind these 3 fields will just make up 1 new record, obviously. I've just forgotten 'em!

[June7]

Why are you using unbound forms?

The SQL for APPEND/INSERT in VBA behind the form would be like:

CurrentDb.Execute "INSERT INTO tablename(SquadNumber, PlayerName, TeamID) VALUES(" & Me.SquadNumber & ", '" & Me.PlayerName & "', " & Me.TeamID & ")"

Assumes SquadNumber and TeamID are number type and PlayerName is text.

[niall]

Why are you using unbound forms?

The SQL for APPEND/INSERT in VBA behind the form would be like:

CurrentDb.Execute "INSERT INTO tablename(SquadNumber, PlayerName, TeamID) VALUES(" & Me.SquadNumber & ", '" & Me.PlayerName & "', " & Me.TeamID & ")"

Assumes SquadNumber and TeamID are number type and PlayerName is text.

I just sort of made the forms. I didn't think the 'unbound' in the text boxes/combo boxes meant anything - just that it had no load value?

I'll try that SQL coding. SquadNumber is a number type and TeamID and PlayerName is text.

[June7]

If you bind the form and bind the controls then data entry/edit will pass directly to table. No coded SQL actions necessary.