Search results

I have a database in which widows are looked after by legatees. There can be multiple widows assigned to a legatee but one widow may only have one legatee. There is a widow table and a legatee table. It then has a table joining the two, that has the legatee ID, widow ID and a seperate ID field...

It says there is no related record in the table town. I have the widow table being linked to the primary key in the town table using a field in the widow table called WidowTown, which is a number field and has no indexing. It is a one to many relationship with the one on the town ID side. I...

I am not quite sure I completely follow you. There are 2 foreign keys in the table I am entering data, CommentsWidowID and CommentsLegateeID and both of those tables already have data in the table that is linked through the IDs. By saying it 'must' have a record, do you mean it needs to have a...

I have a problem and I can’t seem to work out what is wrong. I am getting the error message You cannot add or change a record because a related record is required in the table ‘Town’. I am trying to enter new comments on the comments form but whenever I enter all the information and press...

I just found the answer to the first question, I had '0' as the default value in the number fields in the comments table but I still am not sure about how to record the legatee name.

I am designing a database for the local branch of Legacy. In this DB, Widows are looked after by Legatees. At any one point, one widow may only be assigned to one legatee but every legatee can look after multiple widows. Over time Legatees can be assigned different widows so I want the legatee...

I thought it would be a database but how could I make a database for the ipad, as Access won't run on the ipad?

Hi, I need to make a spreadsheet for a business that sells coffees. The owner wants to be able to enter the information into an ipad on the fly so that he does not have to enter all the information at the end of the day. I have a spreadsheet with the options for the coffees in a drop...

Here is a copy of the database I am using. Sorry, can't explain much about it now as I am in a hurry but you can see what I am trying to do. Thanks, Dave

I have another idea, what about if I added some code into the got focus event on each check box, where when selected, would write the corresponding value to the Business_Description field? How would I do this?

I have a form with the check boxes on it but those categories are recorded in a field called Business_Description but are you saying I need to have separate yes/no fields for each business description? I wanted to have the form with the check boxes just look at the Business_Description field...

I have a contact details database and my manager wants to be able to send out letters to all the radio stations, for instance. I have a form that I have check boxes on that relate to each category of the entries in the database. I wanted to be able to select what check boxes, or business types...

Another issue, if I leave the Start date and Finish date fields blank on frmSearch, it won't show anything. I want it to not apply a date filter if I leave the fields blank. How do I get it to not filter the dates and display unfiltered records when I leave the date fields blank? See the above...

I found the problem. I had the query to group results by the crisis support worker ID, so that is why it was returning the two separate figures, all I did was remove that column from the query and now it works.

Just got back from several weeks holidays and I am trying to work out where I left off. I made a few minor changes but then came to the search form (frmSearch). In the start date I put 1/05/2011 and in the finish date I put 5/05/2011. The total hours by worker (on the left side) appears to...

I have been fiddling around with it and now can get that part to work, but I have found different problems. On the right hand side where it says "Total hours by TC location", dlookup doesn't appear to place the summed figured in the text boxes. The queries behind them do not appear to be...

Hi, I have a problem with a form I am making called frmSearch. Whenever I try and run it, I get an error message "#Error" that keeps flashing in the text field next to Supervision hours and I have looked and looked but I can't find where it is coming from. The field has dlookup in the control...

Thanks for that. Total deep search showed me where to find the error.

Not sure what happened but the orderby property appeared. It is: [tblCrisisSupportWorkers].[cCSWID], [tblCrisisSupportWorkers].[cLastName] The record source is: tblCrisisSupportWorkers

I have a text box where you type criteria in and it searches through the records looking for that criteria. If I type in something and click the button when the form is open, it opens the query with the results that match the criteria.