Search results

Hi Mert, Maybe I didn't explain a few things that I should have. Try the following. The ListBox 'Row Soure Type' needs to be set to 'Value List'. In the line below where frm!Text is replace it with frm! and the name of the control that is on the form named 2, I don't remember the name of...

Hi Mert, You must be missing a referance for the 'Me' not to work. Replace 'Me' with Forms!FormName, where FormName is the actual name of your form that this code is in. I believe the propblem with Forms!2 is that it see the 2 as a number and not text. You could change the name of the form...

You could resize the button to what ever you would like and this would save a lot of time. Hope this helps. Art

I couldn't open this file. However what you want is very simple to do, try this. Open the form in design view. In the View menu click the ToolBox. Select the command button. Point over the detail section of the form and click. If the Control Wizard is on click the Cancel button. In the View...

If you post the database I will help you more but this should get you started. Enter something like this into the OnClick event of the button. DoCmd.OpenForm "FormB", , , "[Customer Name Field]='" & Forms!FormA![Customer Name Field] & "'" Hope this helps. Art

Hi Mert, You can try this to get what you orginally asked for. Remove your subform named 2 from your main form, do not delete it. Replace it with a ListBox with the columns set to 3. Size it to what you need. Create a code like this in a module. I can't remember if the field named Number was...

If you set the visible property to no you could then use the AfterUpdate property to make it visible again. Does the subform show no records all of the time? Art

This should be easy to do if you base the report on a query. If you need help with it post your database and I will look at it for you. Art

I agree with Gizmo. It is a bad idea to add fields. One way you could get the work done is to have a date field and then you can group by the month, quarter or anything else that you need without having an endless amount of new fields. Hope this helps. Art

Sorry it took so long to get back to you. The reason you can not make changes to the second form is that it is based on a query that is not updatable. The form is based on the table Checks and the subform is based on a query tha is based off of tables Checks and Generatori. Maybe another...

If the column width is set to a blank it should display the column the same width as the combo box. I am not sure what happened there. Glad it worked out for you. Art :)

You could go to the Format menu and select Conditional formatting from the disgn view of the report. Art

Hello, I would do this: Set a variable to the Forms!frmCompanyList!txtContactIDPOPUP Close the Forms!frmCompanyList GotoControl txtContactID And then use the FindRecord command to goto the record of choice. Hope this helps. Art

You know sometimes the little things are what trip us up. What I would suggest is to have 2 or 3 list boxes side by side where you now have the sub form. Have the Row Source set to queries that are the same but have them filtered down by the Competecy Type. I believe that this is a number. You...

You must save it after you move it to where you want it and then close it. When you reopen it should be where you saved it last if the auto center is set to no. Hope this helps. Art

Hi Mert, I am working on this. Did you realize that you only have 6 competencies types and they are listed more than once on some of the licences? If you where to only list them once what you have would work. Do you really want to list them more than once? Art

Hello, You could try this. On Form1 set Combo18 row source to 'SELECT sales.CustName FROM sales GROUP BY sales.CustName;' column count to 1, column width to nothing, after update to Me.Requery Me!CmbPurchDate = "" Me!CmbPurchDate.Requery Set CmbPurchDate row source to 'SELECT...

Hello, You can locate the fom where you would like to be open at and then save the form. It will open in this position as long as the 'Auto Center' property is set to no. Hope this helps. Art

Hello, Use the 'Criteria:' row of the update query to filter only the records you would like to update. One possiblity would be to add '>Date()' fo the date field. Hope this helps Art ;)

From what I understand you would like to view all of the 'Competencies' on the 'Licence' form without using the scroll bar. Is this correct? Would like to help. Art