Search results

I have attached an update to your dbase have a look at report aaaa Hope this is what you are after

after the save close the form and then open the form

I would suggest a report menu form with a startdate and end date fields then create a query to select the required data In the query's criteria section of your date field type between forms![yourdateform]![startdatefield] and forms![yourdateform]![enddatefield] create your report data source...

When you select the combo box arrow (and opend the combo box) you should be able to type a letyter on the keyboard and the combo box will start with a name with the letter typed

I want to open the main form when the database is opened, and then close the whole access application when the main form is closed. To open the main form when openibg the database Tools , startup select your form from the display form/page dropdown box deselect the display database check box...

In the on exit (or after update event) of yourfield If yourfield = "Yes" Then Yourdatefield = Date Else Yourdatefield = Null End If

Set the data control source of the check box on the column in the table same as above for the text string

I would remove the exit button from the form(top right) And have a button to save the record. In the buttons on click event prior to the save record command I would validate each field on the form (if it is null or the wrong format display a meaning full error message return focus to the field...

In the forms on open event yourpayrollnumberdataentrybox.setfocus

'tblSTSLimits.Max Short' Try tblSTSLimits.[Max Short] Sometimes doesn't like spaces in column names

In your code Yourfield.fontbold yourfield.fontunderline yourfield.fontitalic

It maybe that the other users are using a different version of Access and are missing some references. If you get into your vb code and then click on tools , references and compare the ticked items with your other users yo may find that they are eithrr missing some or are using a different version

I tok an access course at learn direct You can either go into their office to do the course or you can do it at home. If you are a novice the course wille be good for you

format(datefield,"dd/mm/yyyy")

Try this SELECT Yourtable.phoneno, Count(Yourtable.phoneno) AS CountOfphoneno FROM Yourtable GROUP BY Yourtable.phoneno HAVING (((Count(Yourtable.phoneno))>1));

make sure that your customer Id field in your table has a datatype of text

Design your table and in click on the required field name then on the general tab,format type the following character >

strSQL1 = SELECT FieldA FROM table WHERE FieldA = xxx strSQL2 = SELECT FieldB FROM table WHERE FieldB = xxx strSql3 = strSQL1 & strSQL2

Write a new query that joins tblShipping with tblContainer and select ShipID (PK) PCNo ContainerNo - (data to be displayed on form) where tblShipping.shipID = tblContainer.shipID in the criteria section of the PCNo type forms![yourform]![comboboxname] In the afterupdate event of the combo...

Is your header in the report header ? if it is it will only appear once at the beginning of the report. If you put your header detail in the page header section the details will appear on every page