Search results

I have a form which contains a sub form. I have set the tab order on both forms and set the Tab stop to those I don't want. when I open the Form the cursor flashes in the sub form and I cannot find where or how to have the cursor flashing on the main form. It needs to be there because I want to...

I understand that both the below examples do exact;ly the same thing. Is it always safe to do what is described first or should the second example be what is required? Made be there is an even better way. Thanks in advance. Private Sub Return_to_Exhibitor_Form_Btn_Click() DoCmd.Close...

I have inserted a jpeg image into a access report but when viewed in printed report it is blurred. The image is a logo and the size has to be approx 30 x 7mm. I know that is very small but it has to fit onto a stick on label approx 65 x 25mm. I then imported the original into CorelDraw where I...

I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes. Any suggestions...

Do you mean something like this. Private Sub Form_Open(Cancel As Integer) DoCmd.OpenForm "Main Menu" If (Timer - OpenTime) > 5 Then DoCmd.Close acForm, "Cover Page Form" End Sub Sorry

Do you mean something like this. Private Sub Form_Open(Cancel As Integer) DoCmd.OpenForm "Main Menu" If (Timer - OpenTime) > 5 Then DoCmd.Close acForm, "Cover Page Form" End Sub Sorry

I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working. Private Sub Cover_Page_Form_Load() OpenTimer = Timer End Sub Private Sub Cover_Page_Form_Timer() If (Timer - OpenTime) = 5 Then...

Using Access 2010. Have tried different Mouse no difference. Wondered if I may need to delete MS Office and reload file.

Have solved problem. When the file name is highlighted I have now pressed the delete button which removes the old name and leaves the cursor in place to retype new name. It is a little time since I have tried to do this and from memory I could put the cursor at the end of the word and use the...

Yes. Asked friend to email a copy of same file (different data) and same thing.

I am having a problem at present which I cannot solve. I understand the principle of renaming the above of using the navigation pane and selecting the object but what is happening in my case is that when I select the specific table/query I wish to rename, the text is highlighted as per normal...

Thank you very much.

Thanks for your reply. I have used a bound field because I wanted a printed report with a ticked check box to show the credit. I think I have followed your instructions correctly(without locking the control). When I enter an amount in the Advance field the Credit box shows no tick, and when...

I have two fields. Advances (Currency) and Credit (Yes/No) I would like have it that when an amount is entered into the Advances field it would tick the box in the Credit field. Similarily you cannot tick the Credit box when there is no amount in the Advances field I am not good at code but...

Have added file to maybe see better what I am trying to explain. I have a field Class. When I enter the Class number and press enter first entry in the next Field (CageNo) is recorded as 1. Enter the same Class press enter again and the next EntryNo is 2. The following is how I achieve this...

I have a field Class. When I enter the Class number and press enter first entry in the next Field (CageNo) is recorded as 1. Enter the same Class press enter again and the next EntryNo is 2. The following is how I achieve this at present using a query and an update query. ' Get ExhibitorID...

Thanks for suggestion re online query tutorials. You are not in line with my quetion. Basically when you have a Form or Report is it preferable to create a Query, or, is it preferable to use the Query Builder from within the Form or Report Design. It is over time I have built up so many queries...

Although I have been creating a file related to a Bird Show for several years I consider myself very much a novice when it comes to working with MS Access. The file I have built up has reached 7000kb and contains 128 queries. In some instances I need 6 queries to obtain the data I require for a...

From frmEditSpecials I am referring to the two right hand cloumns. Very occasionally these may need to change. e.g. a new group may need to be added at any position in the column.If this happens all numbers must be adjusted to end of list. In tblSpecialistBodyNotes column 1(SchedHeadingNbr)...

Thanks for the leading space help. Could you please explain more with respect ot the Foreign Key comment. I have added the JudgeID to the Sections Table but it seems to make no difference.