Search results

I have searched through most of the threads for an answer and couldn't find an exact answer for my problem. I have a combo box pulling three columns, Primary Key, Last Name and First Name. The properties box has a column count of 3 with column widths set to 0,1,1. My problem is the combo box...

Hi all, I'm asking for some help on this simple question. I have a form with a button that runs a query based on user's selection. Sometimes the query returns no records but leaves the query window up. The user has to manually close the window. I want to add the feature that if the query...

I am new to writing VBA and am stuggling to understand why my ElseIf statement is failing to complie. The combo box is unbound and pulls data from a lookup table. I put a "0. All" record in the table so the user could select it to retrieve all records after a filter. Right now, once the...

I'm stuck on a problem, not knowing the best way to handle it. I have a form which reads one table. The table has two fields that I'm working with. One is a location and the other is a sequential number. Currently, I have a combo box that contains the location from the table. I can step...

Hi all, There is hopefully a simple fix to my problem...it's baffling me :confused: I have a Command Button on my form which opens another form. Both forms use data from the same table. I don't want the user to be able to change two fields on the opened form. The third field on the opened...

Hi all, I've never written a lick of VBA, so this may be an easy problem to solve. I have a parent/child table construct. In the Parent (Action_Item_Main_Table) I have an element named Current_Status. In the child table (Action_Item_Status_Table) I have the element Status. I know this isn't...

Maybe someone can point me in the right direction. I have a one-to-many table construct. A problem (Main Table) goes through many states. It can be open, working, closed, etc. In the many table I have Status and Status Date. What I'm trying to get to show on my Main form is the most current...

I'm relatively new at trying any advanced stuff with MS Access, so I don't know if this can be done. I've seen it done many times in other applications. What I have is a form/subform combination that looks up people's names and if they've been invited to or attended different work functions...

I have what probably is a simple problem. I've been able to select and display in my form the two columns I want from a lookup table. One column holds the Product Code, the other has the Product Description. The problem I need solved is taking the two values and inserting them into their...