Databases

Recent Answers

2009-11-21 Using MS Access - MS Access 2000-adding a new field to a form:

Tony, The recordsource of the form is probably a query that does not include these fields. Check out the form's record source property and see if it includes the two fields. Bob Heifler MyAccessProgram

2009-11-21 Using MS Access - MS Access If Function:

=Format(Date() + Choose(Weekday(Date(),vbMonday),1,1,1,1,3,2,1),"dddd") To test this Substiture a Date value for Date(). For example: Format(#11/20/09#+Choose(Weekday(#11/20/09#,vbMonday),1,1,1

2009-11-21 Using MS Access - Time Calculation Using Access Query:

First, you need to understand how Access stores DateTime values. Access stores date/time values as a double precision number where the integer portion is the number of days since 12/30/1899 and the decimal

2009-11-20 Using MS Access - MS Access AutoNumber feature:

If I follow you, you have two tables in one to many relationship. What's not clear is which is the one and which is the many. But these tables should NOT have the same primary key. They should both have

2009-11-20 Using MS Access - How to connect a text field to combo box:

I would not use a combo in this case. I would use either an Option Group or a Check box. But the process is the same no matter what control you use. In the After Uodate event of the Status control