Search results

  1. Gigitty

    Return First Record of Each day based on [Date/Time] field

    Hi guys. Have had a look around on this one and surprisingly can't find any answers. I'm simply trying to return the first record for each day based on a [Date/Time] field (see screen shot example below). Any help would be greatly appreciated.
  2. Gigitty

    Making Label on Form Visible or Not Visible based on Date Field Value

    Hi gang. Trying to make the label 'Device Available' not visible if the 'Date In' field is not blank using code. Can anyone help out? Thanking you in advance. (screen shot attached)
  3. Gigitty

    Unable to Compact and Repair - Password

    Hi again guys. Trying to Compact and Repair my database however it keeps asking me for the password. After having to re-enter the password 3 times I get the 'Not a valid password' message. Ordinarily when performing and Compact and Repair you're prompted for the password once, you enter it...
  4. Gigitty

    Allow Edits Not Working

    Hi guys. Not sure why but one of my Forms is allowing Edits after I have set the 'Allow Edits' property to 'No' both in the Form design and in the 'On Load' event. Anyone have any ideas why this might be occurring? I'm not having this issue with any of my other databases. Thankyou in advance.
  5. Gigitty

    Set Multiple Label Background Colours from Yes/No fields

    Hi all. I have a bunch of yes/no fields on a form and I would like to set the background colour of the associated label when the field value is true. The code i've tried on the first label isn't working properly in that it is setting the background colour for every record not just the record...
  6. Gigitty

    Set Value in Continuous Form

    Hi guys. I have a yes/no (checkbox) I want to set to 'No' each time the form loads. I've tried {me.fieldname = No} in the OnLoad event. This only works for the first record on teh form. Anyone know how I can apply this to every record on the form? VBA beginner here.. thankyou in advance...
  7. Gigitty

    Combo Box displaying wrong stored value

    Hi guys. Had a look but can't find anything in the forums on this issue. I have a combo box referencing a table via the query builder. There are 7 columns in the lookup table and I want to store the value from column 3. I have set the 'Bound Column' to column 3. When viewing the data in the...
Top Bottom