Search results

Hi, I have very small sample TEST database to play around with and it's the combo box filter this time. I followed a tutorial on-line and got it almost working state, but need your expertise. as you can see from the attached file, every time you make a selection from the Category dropdown...

Hi, I have a filter by form set up. This has been working very well until last 10 minutes....I must have done something to it and it's now not showing all records based on the criteria. I checked the toggle filter as well and doesn't seem to be the source of the problem. Has anybody ran...

sorry I'm really stuck here. It seems that I'm griping with the concept of FK and lookup....... Could you be a little more specific? I should store city PK as foreign key in my table. Are you saying that I should store City as a foreign key in the lab table?

Thank D. I'm not sure how I should go about making the changes. Are you implying that the city fields would have to be real solid values instead of looking up from city table?

Hi, I have attached a test database that utilizes an UNION query to join two queries. The city look is not working properly as you can see in the UNION query as it's showing numbers, instead of the actual city names. Is there any way this can be fixed? I checked for the column bound, but...

I see. Yeah, it's problematic and I see it now. Maybe I will just get rid of feature. Thanks alot.

yes when you do queries in the front end, all relationships are shown properly as in the backend. It's just that when you click on relationship tab in the frontend, no links are shown. weird

Hello, This is really bugging me. Tables are in one to many relationship.(two tables). In query which pulls records from two tables, if I make changes to a field in query, it gives me a prompt saying there is write conflict. Database is already split into backend and frontend. I am not...

Hi, I have made an observation on my front end database. In the relationship window, all the tables are there, but not the relationship links. When I go back to the backend, all tables and relationship links are visible and properly connected. Is this because Access is preventing users...

Hi, My database has been split into front end and back-end. Perhaps this is a redundant security question, but is there any way for users to hit a single button to create a backup of the backend from time to time? You can do it from the Access Office Button, but if users think it's too much...

I see. It's okay if it is not updatable. I will just tell users to update them individually. I have just ran into a problem regarding the union join. The problem is that the City field is actually a look up field from another table. The reason I did not include it in the all these TEST...

Hi, Thanks for posting back. I have noticed that the report screen actually gets reshuffled everytime there is an update logged. (this is with the timer built in) Users would just like to view the report either on screen or have them printed out, but I guess I can increase the interval to...

Hi, Perhaps this is a dumb question but... The database is split into backend and frontend. When users make changes to data(changing values and updating numbers) through the front end in query, for example, will other users will able to see the changes immediately when the change happens...

Hi, I have an data entry form that users use to enter new record. Since data entry is the main thing with this database, I would like to include a field or perhaps just a caption on the form that simply reminds users of the last PK they put in as they go enter a new record. Users are...

Thanks for posting back. I've thought about it and maybe it's even easier to just put a lock on that particular textbox.(fee_num) I've also realized that you can simply change the control's locked property into "yes", but I'm just curious to see the code that actually does that. The...

Hi, I have a form on which there is a textbox control that I would like to add a bit more security. There is a search button on the form and when it is clicked, users will be able to search the record based on the textbox. When a user cancels out of the search box, the cursor focus is...

Oh I see.....a union query will do the trick. Plus it's not counting the chairs for the same facility multiple times. Thank you very much on this Brian. One question though.....why is it that I cannot update directly on the union query in datasheet view? It's saying that the recordset is not...

Hi Brian, You are right. I was wrong at the beginning and I see it now. If users want to do filter based on geography for both lab and storage facility, then they will miss out on records because not all storage facilities and labs are in the same city. What I mean is.... In the attached...

Hi, I appreciate your help. I'm not sure either if this can be done, but it sounds just like a query problem? Right now I can actually generate a report based on lab and on the report it counts all the labs once and I did a "sum" and "group by" for all the chairs in the corresponding...

Try the OLE object in database design and see what you find. It's in datatype dropdown