Search results

I have viewed other threads but these do not help. I click on a control to open a Form and receive the message Runtime error 2448 "You cannot assign a value to this object" When I click on Debug in the MS VB screen it shows the following Private Sub Form_Current() Dim IngTemp As Long...

I have just transferred all data to a new computer and have found a problem. I created a file which several people use so there is a file in different folders for each person. The same error is occuring on each file. A combo box shows the dropbox list of the numbers in a field from a table...

I created a DB, size approx. 7.5MB. It is used for an annual event and each year data must be deleted from the previous year. Sometimes all fields in a table, others just certain fields in a table. All deleted with their respective Update Query At present I have set in Options to have the...

I have a Table with 6 fields, 2 are named Initial and Surname. Is it at all possible to have a combo box on a form with these to fields "joined" with the alphabetical order on the Surname. I understand that using a query will not work as the result is based on an expression. Thanks for any advise.

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...

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...

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...

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...

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)...

If you open the query in the file it shows all the records I want. When you switch to the design view and join the JudgeName fields between the tblJudge and tblSections two records drop off. Could any one tell me why this is happening and what to do to show the addresses for the 21 records...

I want to create an Access runtime file but would like to be able to view the Tables. The attachment has a form set to view the Tables. First can I use this method to view the Tables in Runtime and secondly when I try to close this Form using the control Return to Main Menu I get a message...

I am working from a table which contains amongst other data, a number field (usually numbers are 1 or 2 but could occasionally be more). I have created a label but I would like to print labels to match the number in the Number field. E.G. 1 in the number field 1 label or 2 in the number field 2...

The attached file shows reports displayed by ExhibitorID. I have tried unsuccessfully to rearrange these so they will appear in alphabetical order. No matter what grouping I use where there are Exhibitors with the same Surname the awards are being merged into one report. E.g. B Hollyman page 25...

Can someone please help? The attachment shows the format I would like except that when you look at page 4 you will notice Class 183 and the headings Cage and Place are on this page but the actual boxes for these titles are on the next page. I would like to force that class to the next page (or...