Recent content by dbprogman

Thanks that worked , however would it be possible to have the record selected without shifting focus to data2? May have been a little premature it kind of works, generates error about moving focus if you choose end then it works.

Situation: I have form with two (2) datasheet subforms data1, data2 both subforms are based on the same table but different fields. The reason for this is that the company commissioning this database dont want to have to scroll across to view fields. Problem: The problem I am having is that...

ok thanks for the reply...

I am using Access 2007 and simply just want to change the highlight color when a record is selected. I am sorry about the double post was a little unsure as to which category... Wont happen again.

Hi all I have a datasheet and when a user selects a record that record is highlighted by a dull colour (default) I wish to change this colour to a more prominent one, the simple question is how? Access 2007 Thanks for your assistance.

Please find attached a sample of what I am attempting...

If I change the control source of Time to Complete to the unbound field then Time to Complete would become an unbound field and the information no longer stored in the table, this is needed for reporting.

No the calculative field doesnt repeat its self it works as I would expect being different for each record the problem is that as 24hrs pass the calculative field is advanced by 1 great, however now the Time to Complete field is 1 day behind. How can I get all records to refresh on open or after...

Try using the actual form name instead of me. e.g. Form_frmYourForm.Requery

Yes, Sorry was a bit to brief. Ok, I have a form that has a tab control on it with two pages, on each page there is a subform that is displayed in datasheet format. When a user opens this form (Mainform) They choose a property from a combobox and then the datasheet shows those records...

Form1 TabCntrl1 Subform1 - Datasheet FieldA = FieldB (FieldB unbound calculated changes daily) Problem: When subform is opened and records dispalyed (filtered by combobox Form1) only the currently selected record is updated. How can I get all records to update (= FieldB) when opened. I...

Ok tried your suggestion, got a little lost in the requirements so if you could expand a little on your suggestion this would be most helpful. Table One tblProject ProjectID - PK WorksID Table Two tblWorks WorksID - PK ProjectID Description Table Three tblTasks TaskID - PK WorksID Task -...

Thanks for your reply, yes, the items are a simple list. I will give your suggestion a run and will let you know how I got on. Stay tuned for the next exciting episode, when you will hear the words.... Cheers And many thanks....

Hi All I am currently constructing a DB for a client and their request has left me scratching my head a little so any help is gratefully appreciated... We have a form that is connected to a projects table and a user would choose a project from a combobox and then a subform would display...

You %&^%* Beauty!!! It maybe a long winded way but I solved the problem, the code is below and thanks to lagbolt for your assistance. Private Sub cmdLogin_Click() If IsNull(txtPass) Then MsgBox "You MUST enter a Password" Me.txtPass.SetFocus Else If IsNull(cboDept) Then MsgBox "you MUST choose...