Search results

set the combo box' VALIDATION RULE property to <0. this will force users to enter only negative values.

Docmd.RunSQL "DELETE * FROM TableName;"

when referencing group fields of the "same name", i usually do this type of routine: strsource = 1/1/2001 for i = 1 TO 31 Forms!FormName("Text" & i).ControlSource = DateAdd("d",i - 1,strsource) Next [This message has been edited by joeyreyma (edited 07-19-2001).]

i thought IsEmpty is used to determine if a variant variable is initialized or not? i've never used it in a field or control.

i thought IsEmpty is used to determine if a variant variable is initialized or not? i've never used it in a field or control.

you can try this one: 1. put two textbox in the section where you want to print the sequence number. 2. on the first textbox, set the controlsource to =1, then set the running sum to OVER GROUP, then set the visible to FALSE 3. on the second textbox, set the controlsource to...

Mike nah! i frequently used it in my programs. i just tried it in the debug window but can't get it. can you pls. post your example. i'm very curious about it.

i think Carol is right about the built-in chart feature of Access. Try third-party add-ons or the Microsoft Chart Control.

i know two approaches to this problem. 1. In your table, you could set the REQUIRED property of all entry-required fields to YES. this would also affect if you use it as recordsource for bound forms. 2. Or, everytime you exit the form, you could loop through each controls and check the value...

you can also make more strict entry by applying a validation rule in your table. eg. >=DateAdd("ww",-2,Date()) And <=DateAdd("ww",2,Date()) but then again, you should be careful because you will have hard time changing old values since they will be limited to +/- 2 weeks of the current date...

try not enclosing 0 with parenthesis: =IIf(Nz([F1])="",0,Count([F1])) HTH

right, it's one-to-one relationship! but i'm more concern on the structure of the Attendance table because its not normalized for a relational database. i mean, if you continue using this structure and enter data, their will come a time in the near future that manipulating fields or...

Check the Help on Limit to List property and the On Not in List event of the combo box. It will explain more than me trying to do it here.

not tested but try this: Difference = DateDiff("d",Current_FieldDate, DMin("FieldDate","Table","FieldDate >#" & Current_FieldDate & "#")

if you are operating on a recordset, then use the AbsolutePosition property. however, counting starts from 0 up to 1 less the number of records (same as RecordCount - 1) in your recordset basing on the ordinal position of the record. thus, you can deduct the (absoluteposition + 1) from...

as i understand it, the string format you want is already done but only you get four copies of it or the same with the number of records. why don't you remove the recordsource of your report because in every record in the source will cycle you in the detail section of the report.

you can by drag and drop, when you are on your database, adjust the access window so that you can see a part of your desktop where you can drop the icon. click and hold the form's name from the database and drag it to the desktop. this will create a shortcut for the form. when you open using...

try to insert this code before rs.movefirst: str=vbNullString

try to remove the do...loop in your code because this cycles you to every record in your recordset. since you only want one record, it is safe to remove these lines. and by the way, try to put this code before rs.movefirst: if rs.recordcount <> 0 then rs.movefirst however, on your last...

bound forms has a value in the recordsource property. same with bound controls, in which controlsource property has value also. however, controlsource property is dependent on your recordsource property. if you do not specify a recordsource (table, query, sql) in your form, your control can't...