Search results

  1. G

    Macro to open form in Datasheet view

    Thanks All. I found the problem: In the Macro in the design view this statement is on the second line : GoToRecord I deleted if and everything is fine
  2. G

    Macro to open form in Datasheet view

    Good Day All, I have a form with default open view as Datasheet. However when this form is opened via a button on another form it opens in form view only. Can anyone explain how to get it to open in datasheet view in the second case?
  3. G

    posting question on the northwind datbase

    Good Day All, Where in this forum are question of the sample Northwind datbase to be posted?
  4. G

    Identifying a term in VBA Code

    Thanks. That was very useful
  5. G

    Identifying a term in VBA Code

    Good Day All, I am referencing the popular Sample Database NorthwindDatabase2007. I am seeing the term " TempVars![Display]" throughout the code. I am interpreting to mean that there is a form "TempVars" or a variable. Hover I can find no evidence of either. Using the search tool there is no...
  6. G

    Deleting values in date/time datatype fields

    Good Day all. I wish to beg ever one who offered me assistance over the last 2 days and who I agonize relentlessly with my problem. Please note that your solutions were correct form the start; however I had a programing oversight, which is worth explaining: I discovered that my code...
  7. G

    Deleting values in date/time datatype fields

    Thanks for your response. Actually I used to temporally change the datatype to Text, then set the field to "", then change back to date/time datatype. This is reflected in my code. ' This procedure will clear all the cells in the InstructorAllocations table Private Sub Command0_Click()...
  8. G

    Deleting values in date/time datatype fields

    Good Day All. Can anyone guide me how to make a date/time data field empty. I have tried databaseNumber(p) = "" also isnull, Null, Vbnull and empty. None of these values work.
  9. G

    Sorting on a Dayname string

    I tried the week day function and it worked.
  10. G

    Sorting on a Dayname string

    Well I am interested in learning about this function. It's the first time I am hearing about it and it looks like I would have uses for it along the way. So can you guide me where to place it.
  11. G

    Sorting on a Dayname string

    Good day all. I have a field of string Data type but it contains the day names of days of the week( Monday, Tuesday, ........). When I sort this field the values are not sorted Monday, Tuesday etc. What I get is Monday, Thursday, Tuesday, Wednesday. I know why. Its because it does not...
  12. G

    DateTime Anomolies

    Thanks Minty for your kind detail explanation. I has led to an awareness of time date system. Consequently I have solve my problem and sure would be able to solve many more on my own.
  13. G

    DateTime Anomolies

    Good Day All. I am applying DateTime function to 2 different fields, both with Date/time data types. However when datetime wraps the values in field 1 every thing works sort of fine, but as soon as values in field 2 is wrapped with the datetime function there is an error message. Below is my...
  14. G

    comparing dates

    Thank you all. Its working both ways
  15. G

    comparing dates

    Thanks Arnelgp; however I am still not getting the expected results. I have todays dates in the table but the expected records are still not returning. I gone on to do a little test to show me what is actually in the "DateCreated" field and to my supprise all the values in the field are...
  16. G

    comparing dates

    Good day all, My code is intended to compare dates in my table with todays date. However I am not getting the desire results from this code, because the table contains todays date and yet no results are returned: DoCmd.OpenForm "Edit Signin", acNormal, , "OfficerName = '" & WorkersName...
  17. G

    combo box value do not save expected values

    Good Day all, I have a combo box which is populated by a control wizard and gets its values from a field "CourseName" in a table "Course". "CourseName" is of data type string value. The control source of the Combo Box is a field "Course" in another table "timeTable" The dropdown...
  18. G

    Aligning the tick boxes in a report

    this is the attachment
  19. G

    Aligning the tick boxes in a report

    thanks CJ_London. However my situation involves 3 adjacent controls in a necessary tabular layout which I can't really control too much; and additionally the width of the label section of the control is at their maximum Minimum.
  20. G

    Aligning the tick boxes in a report

    Good Day All. Ticked control boxes which has a data source of Yes/No type on a report canvas is always located to the left side of the rectangle box it is in. Can it be placed in the center?
Back
Top Bottom