Search results

  1. I

    format this in a query

    hi. i have asked and people have the same question as this but i still have not found a good answer for this one. here's my situation. i need to format a set of characters, whether it is 123456789AB or just 123456789A or AB123456789, how would i format it in a query so that it would be like...
  2. I

    opening a form using a listbox with different criteria

    ah. but am using a query for that listbox so that it even without records, the employee's are listed hence if they don't have a record, they still have a next review date cause the next review date is calculated based on their hire date. yeah, am getting a mismatch and now, nothing happens...
  3. I

    opening a form using a listbox with different criteria

    oh, i thought i had it so that if the column 0 for that listbox is null, it would open something else. basically, the two columns would be reviewid and employeeid, if the reviewid is null it would look at the employeeid (used for new employee's without reviews). so what i really would like to...
  4. I

    opening a form using a listbox with different criteria

    hi. what's the best way to open a form using a listbox? but thing is, i need it to open when the column 0 is null, it will open or filter the record using column 1? i tried this but is not working. Private Sub lst3month_DblClick(Cancel As Integer) If IsNull(Me.lst3month.Column(0)) Then...
  5. I

    SOS with this VBA

    it's a integer. :(
  6. I

    SOS with this VBA

    me.lst3month is a listbox, basically, what is the best way to open a form using two different criteria with a listbox?
  7. I

    SOS with this VBA

    If Not IsNull(Me.lst3month.Column(0)) Then DoCmd.OpenForm "frmReviewDetails3MONTHS", , , "EMPLOYEEREVIEWID = " & Me.lst3month Else DoCmd.OpenForm "frmReviewDetails3MONTHS", , , "EMPLOYEEID = " & Me.lst3month End If End Sub keeps giving me a missing operator on the "DoCmd.OpenForm...
  8. I

    deployment

    what;s the best way to deploy a database? like, when they install the database, it is automatically split and other workstations can automatically link to the back end of the db when they have the front end in their desktops?
  9. I

    format alphanumeric

    how or what is the best way to format in a query alphanumeric number and text?
  10. I

    listbox and selection

    how but using select case?
  11. I

    listbox and selection

    hi, what is the best way to filter a form being opened from a listbox? e.g i have a listbox that has a column that can either be 1 or 2, what i want is, if it is 1, the listbox will open formA, but if it's 2. it will open formB, any suggestions?
  12. I

    highlist listbox row on current record

    hi, what's the best way to highlight the listbox if your form is on that record? much appreciated!
  13. I

    encrypt a field

    hi, i have a form that has a field that requires encrypting? how do i set it that everything (Me.NewRecord), when i hit save, it decrypts the field? or whatever more appropriate ways there are. thanks!
  14. I

    allen browne's code

    well, i figured it out :P hehehe. to all those that read this, thanks :)
  15. I

    allen browne's code

    err. how would i say it, that it would allow new records even if it's blocked? i tried, if not, is not, won't work :(
  16. I

    allen browne's code

    i fixed the new records, i hope someone can guide me how to add a code in this module to allow the form to be seen even if it is null or has no record to it. thanks!!!!
  17. I

    allen browne's code

    hi, i used this code from allen browne, it works great but now, i cant use the new record command and when the record is blank, it won't show up in my main form as a subform. any idea why? Public Function LockBoundControls(frm As Form, bLock As Boolean, ParamArray avarExceptionList()) On Error...
  18. I

    mass enable and locked controls

    what's the best way to mass enabled and lock controls? e.g i have 20 fields that i want to enabled altogether in 1 command and lock it altogether? any thoughts?
  19. I

    combo boxes with null

    my row source has a null value because of joining queries, but my combo box has none, how do i add the null value to it?
  20. I

    combo boxes with null

    how do i add null to a combo box so it can search a listbox?
Back
Top Bottom