Search results

Thank you. I just figured it out - it's in a split database - had to change the backend.

RESOLVED: Cannot add record with newly added value in lookup table I have a database that allows me to select a text option through a drop-down list on a form, where my form field is linked to a lookup table, and the value is then saved numerically in my data table. I just added a new...

Thank you. There was a weird remnant of a relationship I thought I had deleted, in the form properties. It was a data source issue. Resolved. Much appreciated.

I think I figured something out. My forms seems to be filtering out of view records that have a blank value in one field, within that sub-form. I didn't do this on purpose. Any idea how I can get the form to show all the records, even if one of the fields on the subform is blank? Thanks!

Thanks. I delete the records via the form. I shouldn't have to delete them through the tables, so I don't know why they are still there, in the tables. I didn't write any code for deleting. The form should really cover all that, right? I have never seen this happen.

RESOLVED: Deleted rows still showing up in background tables Hi. I have a database with a form, which has a continuous subform. I've deleted rows of data via the form, and I no longer see them on the form, and yet they still seem to be in the table when I export the data. Any idea what is...

RESOLVED: Not sure what I did, but it seems to work now. ------------- I split a database, and then afterwards changed the field names in my backend. The new field names are now reflected in the front end, but many of the fields on my forms no longer link properly. When I try to re-create...

Thanks everyone.

Thanks everyone. If I can explain to them remotely how to split it, and make multiple copies of the front end in one network folder with their names on them, would that work? Each person would be using their own copy, but they're all in the same folder. It's challenging to get a copy to their...

Thanks. Unfortunately, I'm off site today and cannot split it for them...

I have a database where 2-4 users will be entering data, via a form. They may be viewing the same records simultaneously, but won't be editing the same fields within those records at the same time. In the past, we've had multiple copies of the same form feeding data into a single table, and...

I have a query that pulls together data from several sub-queries. One of the sub-queries may occasionally result in multiple records for the same person. At this point, we are not changing the database to prevent this. We do not want to prevent duplicate records - we need to see the...

Thanks so much, Arnelgp!

I am creating a form based on a table which has meaningless field names (except for data analysts), but the field descriptions are detailed and would be very helpful to include on the form. For example, the field name might be "I_A", which means nothing to those who have to enter the data into...

I have a database with multiple users. They've requested a specific date format to ease data entry. There are many dates to enter, so I'd like to help them with this. In earlier development of the database, I found that regardless of how I set up the date input on the forms, the date...

I have a database which will have multiple users. They will enter and view data on a form, which also has a sub-form on it. The form header has a "Search" command button. I know it's possible to change MS Access options on each user's computer, to specify the search options. However, is...

Thanks. Well, I have to say it's helpful for me even if it's just for text and number fields. I have a query output I want the team to see, and there are so many columns, it's nice to just have some way to visually divide up the output. Very helpful tip. Thanks for posting it!

This works great for my queries! Did anybody find a way to change the font colour of date fields, without changing them to long integer format?

Thank you arnelgp, and everyone! The reason it didn't work was because I simplified when I described the numbering of the stati. Actually, the numbers in my database are not 1-6. They are 1, 3, 4, 6, 8, 9. It's a long story why they are not sequential, but I left it that way on purpose for...

Thank you. I think I need to wrap my mind around this a bit more. JHB - I've attached some sample data.