Search results

Create a textbox and set the Control Source property to "=1" (without the quotes). In Running Sum property choose "Over Group." That should do it.

Use a query like this one: SELECT count(LicPlate) as CntLP, LicPlate FROM <your_table> GROUP BY LicPlate HAVING count(LicPlate)>6

I think you need to use IsNull instead of zero (Date()>=[duedate]) And isNull( [receivedate])

you could try something like right(yourfield,len(yourfield)-1)

This should work: y = 1 For x = 1 To Len(mystring) If Mid(mystring, x, 1) = "x" Then Debug.Print Mid(mystring, y, x - y) y = x + 1 End If Next Debug.Print Mid(mystring, y, x - y)

Since you are processing by students, you can include something like this on the Detail_format of the parent report: If Not [<subreport>].[Report].[HasData] Then <your code here> endif

I would keep the images outside the database (in a folder, as .BMP or .JPG). That would reduce the DB size, and would improve speed. If you use the product code as the image name, then you can easily include it in the report on Detail_Format, and you would not have problems when grouping.

I would design a report whose Recordsource is a query of tblCar. Then, I would add labels (instead of textboxes) in the detail section whose captions would be updated on Detail_Format by calling a function that performs a Do Until CarID = <current_carid>. In this way, you won't need a crosstab...

If you don't mind using a rectangle/square, you can change its back color on Detail_Format based on your codes.

Why don't you put the query in the Row Source property?

[Opportunity Description] = [Company] & " " & [Type] & " " & [Project ID].[Column](1) the index is zero based. If the description is in the second column then index is 1

probably a Me.<voltage_listbox_name>.requery is more appropriate

Do you get any error? The query goes in the Row Source. You will need to add a "Me.Requery" in the After_Update event for th textbox that has the product ID

The query for your listbox should be something like SELECT <voltage_field> FROM tblVoltage where tblVoltage.ID = [<textbox_id>] (the textbox that has the product ID)

The record source for the form should be based on tblProduct. Your combo box should get the voltages for the product currently dispayed on the form. Another approach would be the use of a subform displaying all voltages for that product. It will ultimately depend on what you want to do.

Try something like this on Detail_Format Add a textbox for the field that stores the format and set its visible property to 'No'. Suppose that the textbox name is 'fmt'... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.fmt = "A" Then...

the single quotes need to be inside the string.... ) = '" & Me.product_choice & "')) "

Perhaps something like this: Set DB = CurrentDb() Set RS = DB.OpenRecordset("select tblorder.*, tblorderdetails.* from tblorder inner join tblorderdetails on tblorder.<field1> = tblorderdetails.<field1> and ....", dbOpenDynaset) Do Until RS.EOF Set RS1 = DB.OpenRecordset("tblOrder"...

Use DateValue("12-Jun-2008). You will get 06-12-2008. Use the date formats included in Access

How do you legit a field? if you can determine is not legit, then insert a Me.Undo. This should work.