Search results

Ask the clip on how to create and sort a query.

if your table looks like this: name---- start---------------------- end john----- 2/2/2005 12:00:00 PM------ 2/2/2005 6:00:00 PM john------1/2/2005 1:00:00 PM-------1/2/2005 10:00:00 PM and you want this: name---- start-------------------end-------------------hrs-----week john----- 1/2/2005...

Where are you using DLookup? Can't you use a query instead?

Change the recordset of your report on open

Something like this, the table is pre-made, with two fields. Sub ReadText() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Dim fs, f, ts, s Dim ctrLine As Integer, CtrDiv As Integer...

I tried that. My mistake, that was supposed to be the syntax in my original post. I took that after SQL syntax with a variable. Tried this too. Rst("'" & Fieldname & "'") Still Error. What I am trying to do is reuse a procedure with different tables with different field names. I am...

IF CX is a checkbox, it can have two values, true or false. If you have two check boxes, why are they named the same way?

I am trying to reuse a procedure for different tablenames my procedure is like this. _______________ dim rst as dao.recordset set rst = db.openrecordset("table1") rst ("AFieldnameinTable1") = 1 _______________ IF: rst ("AFieldnameinTable1") = 1 I want to replace...

go to the report properties, click on record source, it will ask you if you want to invoke query builder drag all your fields, then create another field that calculates total. sort it desc or asc by the additional calculated field.

Create an odbc connection, then link the dbase table.

after update, me.form.refresh

Create a query, criteria is = date today minus one day.

Thats it. .

Create a table of holidays because some holidays change date. Then create a query if those dates are in between your dates, count them. so say if the count is 3 ( 3 dates are holidays) then 17 + 3

make the second for a subform and link them. or check the command button wizard open form, it will ask you what criteria you want.

Private Sub Command0_Click() 'MsgBox Me!Subform1.Form!ControlName MsgBox Me!Table1subform.Form!ID Dim myID As Integer, SQL1 As String, Sql2 As String myID = Me!Table1subform.Form!ID SQL1 = " INSERT INTO Table2 ( Table2Field1, Table2Field2 ) SELECT Table1.Table1Field1, Table1.Table1Field2...

If your button is on the mainform Subform1 the name of your subform: Me!Subform1.Form.RecordSource

Make sure you include the second line here. It doesnt see all the records until it moves itself to the last. Set rst = db.OpenRecordset("Name of your table goes here") rst.movelast If rst.RecordCount > 0 Then

Header and Detail

On Format?