Search results

I was contacted to work in a DB that I have worked on a lot recently. Most recent was November 2nd. For some reason now when I open the database all I can see is the main form that is set to be opened when it first loads. I have no object explorer on the left and no menu bars at the top. All I...

I don't know where to put this so I figured general is the best place. VBA Access form has a subform. I was wondering if there was a way to make one grid on the subform like a textbox(editable)? Basically make a grid on subform able to Update

I have a query that organizes a drop down A-Z. I am looking for a way to organize it A-Z AND Smallest to Largest. SELECT tblPartNum.PartNumberID, PartNum & ' - ' & PartDesc AS Expr, tblPartNum.Deleted FROM tblPartNum WHERE (((tblPartNum.Deleted)=False)) ORDER BY PartNum & ' - ' & PartDesc; I...

I have a form with a Lookup method. I have it set as this: SearchStr = FilterSearch & "(tblCalls.CustFirstName LIKE " & "'" & txtSearchBox.Value & "*' OR tblCalls.CustLastName LIKE '" & txtSearchBox.Value & "*')" This will allow the user to search for a record by first or last...

I am working on a database and on one of the forms they have these three fields. Company, First Name, and Last Name. These three fields have cont.tag called Required. The "Required" tag makes all fields with it required before saving through a method I created. I want to make it so that if the...

My name is Matt. I work with vba access and excel. Here to give to the community as well as to soak up some knowledge.