Recent content by mlswyo

Joe, I doubt that I can help you any but maybe you or someone that reads about your problem can help me. I've worked on an Access application now over nearly nine months and just get to the point of implementing it and boom something I did has screwed up every one of my forms. I go to my...

I've developed an access database which has been working, except for a bug here and there. Early this morning I removed some old programs from my computer and must of taken something I shouldn't have. Now none of the command buttons will display their caption. When I click on them they still...

Yes, at lease it seems to me there are features on one laptop that are not on the other. I'm not the sole author of this database so I guess I'm not all that positive. I'll take time today to investigate a bit farther, perhaps it really does not matter or maybe easier to change than to find a...

I've recently tried to move an Access 2010 database from one laptop to a newer one(both running Windows 7). On the new labtop I get the message to the effect that there are some missing reference libraries. One is MS Web Components 11.0 and the other isVSFLEX3.OCX. I thought I understood how...

I have a form based on a single table that opens blank. If I set the data entry property to no, it opens showing all 100 records but I can not make changes. If I set this property to yes then the screen is blank. I think it has to do with filters but I think I've cleared them all. I've search...

I'm new at this but have managed to get a recordset using the following: Private Sub cmdRunM1_Click() On Error GoTo Err_cmdRunM1_Click Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdf As DAO.QueryDef Set db = CurrentDb() Set qdf = db.QueryDefs("Query1") qdf(0) =...

Is it possible to have a field in a table that when selected opens a different table? Might I be able to hyperlink to a table from within an existing table? I'm want a table to list the names of all the lookup tables in my database then by simply clicking on the designated field the named...

On a form I have a multi-select list box for the list of employees which comes from employees table. Then I have a combo box from which to select a single training topic. This data cones from a table of training topics. Since the two tables are not related or do I say they have a many to many...

I select a number of employees from a list box and a training topic from a text box and put these into an append query that data is then appended to a table. since the data is still in the query, I assume that next time I do this all the data will be append, not just the new. I use this...

I have populated an append query and now need to run it without opening it. Then I want the data deleted so it can be run again with a different set of numbers. How to do this with vba code? thanks

I have two access 2010 tables; one with a list of employees, the other a list of training topics. I've related the two through a junction table whose primary key is a composite key from each of the two tables. My goal is to quickly assign individual employees to training topics. Not all...

Hello to all. I'm new to this forum but not all that new to databases. But it has been some time since I did much programming so am very rusty. It has been frustrating trying to discover how to do something I know can be done, just don't know the correct way to say things. Hopefully someone...