Recent content by wallacealeco

Isaac, On the positive side, I can ‘fill’ the formula down the column, change values in the referenced cells and all is well but, as you suspected, any attempt to change the formula , ie “y” to “m” results in it failing. Thanks for your comments.

Thank you Isaac. On my laptop, Windows 10, Office 365 it works. I should of a said the problem is on my iPad. on the iPad I copied and pasted the formula from a PC originated workbook to a new one and it works but typing the formula in doesn’t.

Thanks for your reply.

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

Thank you for your replies and apologies for my delay getting back. Ruralguy, the code on the Close button is a pretty standard DoCmd. Close. This works as expected. Jdraw, the database is home use home use only and is basically a list of numbers our band play. Other related tables/forms are a...

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

thanks Ken. That works just fine.

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

Update: I have tried the database on other PCs on the network and the Count function works as expected! Going back the the original PC it now works on that as well! :confused: I have done nothing to this DB to cure it. I had found, elsewhere on the net, someone mentioned Conditional formatting...

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 seem to have cured the problem by putting DoCmd.maximize in the On Activate event of the form with the subforms. Doesn't explain why I had the problem in the first place though. Thanks to all who may have pondered this.

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

Thanks Paul. Using 'Cancel = True' was the answer to my problem. Bill

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

If the only reason you have a blank first record is to allow users to navigate to the correct record you,could create a new form ( perhaps called controlFRM) and put your drop down on it. When clicked this could open your original form at the correct record. No need for a blank record. Put a...