Search results

I think I just remembered how to add in extra columns, add the field into QRY_SearchAll and then add the field into the row source of the list box but this only worked for the divisions field, it didn't work for the legatee field. Maybe as it is not directly linked to the widow table?

I have created a form that searches through a table, following the instructions of John Big Booty, as can be seen here: https://access-programmers.co.uk/forums/showthread.php?t=188663. The search form has a list box that has a query run whenever a text box is changed which allows me to search...

I have encountered another problem. I want the search box that allows you to search for info about the widows to be able to also allow you to type in the legatees name in the search box and to have the widows that are assigned to that legatee appear in the search results. I have the...

I got the date working by creating a new field with the time/date data type but now I have another display issue. The phone numbers are also displayed in search results but they appear as 0294036034 but I want them to appear as (02) 8604 8545. I have tried changing the input mask but that does...

I have decided to just make a new field and copy and paste the dates across.

What do I do with this code, how should I run it? Where do I write it?

Sorry if I sound a bit ignorant, but how do I put in a module?

I have made a table in which I had a field for a date of birth. When I created the table, I made the data type to be a number but used the input mask on the field as 99/99/9999. The reason for the option of the DOB is that we might not have the DOB on file for different people. I have a search...

I got some help from a friend who is a programmer to delete a record from the list box but I think I like that idea of archiving records so maybe I will try that. Here is the code he helped me with. Private Sub Cmddelete_Click() ' If there are no records selected, then skip this...

I also will be the only person using this database so it is just to help myself find the records to delete them.

I am just trying to make a way to delete records as when the widows die, I want to remove them. I just had the text box as a way of finding the records you want deleted.

I work for an organisation that looks after war widows and I am making a database to record all of the widow’s details. I have a search form that searches through all records in a database for a phrase that is typed into a text box. The results are displayed in a list box. Here is a link to a...

I couldn't look at the sample database as I tried to register but there was a security question of 'Who is the next vice president of US?' and I live in Australia, so I had no idea. I really liked the idea of trying to find something, but not remembering where it was. That was what I was...

Here is an explanation of what I am trying to do then. I work for the Orange branch of Legacy in NSW, Australia. The main goal of Legacy is supporting widows and dependents of deceased war veterans. I am just trying to make a database to store the information in regarding the widows. I have...

Hi, I have a relational database with information stored in multiple tables. I am trying to make a form that will allow you to enter data into a text box and for it to search through every field of every record in the entire database for the typed criteria. I want to have something like a...

Thanks for that Moke, it worked perfectly. Is there a way of doing this without the use of sql as I would really like to learn it, or will I need to learn sql if I really want to learn how this is done?

I put this code from Grumm into my query but it still gives me no results when I run it. No errors but no results. SELECT Widow.WidowName, Widow.WidowLegatee, Legatee.LegateeName FROM Widow left join Legatee On Widow.WidowLegatee = Legatee.LegateeID WHERE...

I forgot to tell you, a widow can be assigned to a different legatee over time. An example of this is a legatee might die or get very ill preventing him from performing his duties. There is also a section at the bottom of the widow form that allows for comments to be made by different...

I tried what you suggested, used a query with the criteria for LegateeID being [Forms]![Widow]![cmbWidowLegatee] and just included all the fields and that partly works. There is only two widows in the table at the moment and they are both joined to different Legatees, therefore, the query should...

Just had a thought, I will post my db up here so you can see what I am looking at. Also, I have a table that maps the joins between the widowID and LegateeID, but the table has nothing in it, even though there are several widows that have been joined to legatees. Should there be data in this...