Search results

Come to find out the Office installation was changed on my VM on the 28th of November. I have the standard version of Office 16 and access runtime. Would it revert to Standard if a license expires?

I do not have an options in my DB. All I see is "File". I click it and it only displays Print, Privacy Options, and Exit.

The thing is I have tried old backups and everything. My PC is a VM which references a .accdb that opens without a copy of access installed locally (weird I know). Is the only way to open it now through Access then File > open?

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 apologize. I forgot I had the Row source set in the form load event and I was changing the query in the properties which in turn was being overridden by the Form Load event. This I was I shouldn't be coding tired at 4 am. Thank you for your interest in helping though

It just simply isn't doing it with the query code I provided.

i need ALL 4 digit numbers together ascending and then all 5 digit numbers together ascending, etc. I should have put it like this. 1113 1114 2224 2225 11112 11113 22223 22224 111112 111113 This is how I need it done

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...

SearchStr = FilterSearch & "(tblCalls.CustFirstName LIKE " & "'" & txtSearchBox.Value & "*' OR tblCalls.CustLastName LIKE '" & txtSearchBox.Value & "*' OR tblCalls.CustFirstName + "" + tblCalls.CustLastName LIKE " & "'" & txtSearchBox.Value & "*')" Like this?

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...

Thank you! That worked perfectly.

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.