Recent content by ianatkins

  1. I

    criteria

    cheers thats works.
  2. I

    criteria

    it throws an invalid syntax message without the quotes. By the way im using access 97. Is their any other way of selecting records by thier first letters?
  3. I

    criteria

    Ok ive got a criteria on a surname which is based on the value from an unbound text box. Currently in the query the criteria is: Like "[forms]![frmalpha]![letter].[text]*" Which would return all fields starting with the value of letter. This returns nothing. If I close the form the query...
  4. I

    email field validation

    Hi, Ive been trying to find out a method to validate an email field. I basically want something to check whether there is a . and an @ in the field. Can this be done at table level or shall I do it on the form , and how can I do it!! Thanks alot, ian.
  5. I

    combine two fields

    how can i change the "control source" on the click of a button?
  6. I

    combine two fields

    Hi, I Have two fields, title and surname, and would like to combine them to make a letter address field which takes the below format: Dear [title] [surname] This would be simple except some of my records already have this data entered in a letter address field. So I want this code to run on...
  7. I

    do command if criteria met

    Thanks Alot it worked!! Excellent, cheers guys!
  8. I

    do command if criteria met

    Thanks alot, The following line throws up a compile error (the line is highlighted red): MsgBox("This option cannot be run without data",vbCritical,"No Data") Im using access 97 if this makes a difference .. Thanks again Ian.
  9. I

    do command if criteria met

    Thanks for the speedy replies guys. Here is my existing on click code : Private Sub logcall_Click() On Error GoTo Err_logcall_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmcall" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm stDocName...
  10. I

    do command if criteria met

    Hi, Ive got a form with a few buttons on it, for example one runs a report based on the information in the form. I would like some code that when the key field of the form is null and trhe button is pressed then a message box is opened saying something like "This option cannot be run without...
  11. I

    calendar

    cracked it thanks for the help. Ive managed it :)
  12. I

    calendar

    Hello, Ive got a problem with an active x calendar. (running access 97) I want a query to run with the criteria of the value of the calendar, which is in a form. Ive tried the following criteria on the date field: [forms]![calender]![ActiveXCtl10.value] and [forms]![calender]![ActiveXCtl10]...
  13. I

    multiuser

    All 3 users are in different locations. The database is a contact management system. So all 3 users are going to be logging calls, and all 3 need to see what each other has called about. thanks ian.
  14. I

    multiuser

    i need to make my database available to 3 users, all of which have interent access. I dont't really want to deleve into asp, is there any there alternatives. Can I split the data out of the database, and make access connect to that? Or is there anyway that the users could upload the database...
  15. I

    one a form with on relevant record.

    ive tried that one but it didn't work. :confused: is ther any reason that springs to mind why that doesnt work. At the moment in the primary key (for the second form) is a lookup of the primary key fromthe first form's data (whether that makes a difference). thanks.
See more
Back
Top Bottom