Search results

Thanks but I found the answer, I just had to set data entry to no and allow edits to yes on the form.

In addition to the previous problem, when I open frmcarers, nothing is displayed, despite having data in the db. I have checked the allow edits property and it is set to yes.

I now have a problem that I am sure I have encountered before but I don't know how to solve it. I try and enter carer notes into frmcarers and I get the error message: you cannot add or change a record because a related record is required in table 'tblchild'. This doesn't make sense as you...

I must have zipped the wrong file but I have worked it out now. Thanks anyway

I open the db then try and open the form and it gives me an error and I don't know why. It displays a little window saying "enter parameter value" in the heading and says "ID" below.

My friend told me about an error log to help you track down the source of an error when one occurs but I can't remember where it was. Could someone help me please?

I have changed something and now my form (frmCarers) won't open. Could someone show me what is wrong with it please? It displays an error box that says ID. Thanks, Dave

Hi John, can you please comment on this post? https://www.access-programmers.co.uk/forums/showthread.php?p=1530458#post1530458 Thanks, Dave

Well I changed the data type to text using an update query and it is all good now, thanks everyone, but another problem has occurred. I decided I didn't need a field so I got rid of it but then I tried to run a form FRM_SearchLegatee but I just get the error message "Enter Parameter value...

I have a form that applies a query to data using a list box. How would I add a button that applies a different query to the list box when it is clicked?

But how do you do this, what do I have to do to make an update query so it will copy the column contents to the new column?

Thanks Bob :)

I have made a number field to record some numbers but it won't let me record zeros at the start of the number, such as 0457 945 673, as this is the format for mobile numbers in Australia. When I look at the number in a form they appear without the zero, so 457 945 673. I need to make the data...

I have a search function built into my database. Open the form “Start”, then select Search for Legatees. This opens a form where I can search for Legatees by the name. I want to be able to search for legatees by their division also. I tried updating the row source for the list box where the...

The more I read, the more it seems apparent that I can't have a leading zero in a number field. Is there a way to copy all the data from this number field to a new text field, if I was to create one?

Considering I already have entered about 550 records, I do not want to change it to text and enter them again so the option of making a leading zero sounds very appealing, how do I do this?

I have some phone number fields on my form and living in Australia, our phone numbers appear as 04xx xxx xxx or (0x) xxxx xxxx. Whenever I try and enter the zeros first, it just disappears. How do I get them to stay there?

Hi, Could someone please show me what the vba code is to suppress error messages for an event. I know you can turn it off but I want it to turn off automatically for an event then I could put turn it back on after the event. I looked online and I found this response but it didn't seem to...

Thanks for that Bob. To tell you the truth, I don't know why I used many of the things I did either. I guess I am still reasonably new to this and don't understand a great deal about access but I think I was just trying to get things working and if it didn't work, i would move onto the next idea...

I am trying to make a filter to go on a sub form. The form has a sub form that shows legatees and I have a combo box at the top of the screen that I want to be able to select a division from the box and have that division apply as a filter to the query in the sub form. Therefore, the sub form...