Search results

My problem is not how to use the function but to get it recognised by my worksheet. Typing it in fails, I get #NAME? . By using copy and paste from a different spreadsheet where it works I get the results expected. I can then copy & paste on the new spreadsheet, edit the formula and all is well...

Hi. Using windows 7, 64 bit and Access 2013 I have a form which contains two sub forms which display related data. My main form has a large button which closes the form. My problem is when I enter data in one of the sub forms (just a date using date picker) I have to click the main form close...

Hi, I have a continuous form, fed by a query. In the form header is a textbox with the following code attached to the 'On Change' event. The variable searchtxt1 contains the value of the textbox. DoCmd.ApplyFilter , "[surname] like '" & searchtxt1 & "*'" This works well and filters the list as...

I am using a Count function 'Count(*)' in an unbound field in the form header of a continuous subform. All works well on my home PC but on transferring the database to the users PC, instead of showing the 'Count', the form sits there, blank field and showing 'Calculating... ' in the bottom left...

I have a form with a button on to open another form. Both these forms have DoCmd.Maximize in their On current (and On Load) events. The second form is a continuous form and each record has a button to load a further form. This further form has a subform which itself also has a subform. From...

Hi. I have a continuous form showing, amongst other things three check boxes. The form is fed by a query with criteria that requires that one of these check boxes is ticked. When an operator uses the form (adds or modifies data) they could leave the form without checking one of the boxes...

Hi. As an experienced, if very amateur database designer I have been asked to combine several databases that an organisation uses. All the databases are people based so a central file containing this 'person list' seems the way to go. Problem is each user has different needs in terms of what...

Having recently upgraded to Access 2013 I've noticed when designing forms or reports the Shape Effect button is greyed out. Also, when I click Conditional Formatting no dialogue box pops up. This is happening on all old Databases and new ones created with 2013. (Windows 7 64 bit) Hope I haven't...