Search results

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

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?

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

Thanks. That was very useful

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...

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...

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()...

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.

I tried the week day function and it worked.

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.

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...

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.

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...

Thank you all. Its working both ways

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...

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...

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...

this is the attachment

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.

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?