Recent content by ShovelinFishHeads

For reference purposes, this is how the functioning code looks: Private Sub MakeStatusBillable_Click() Dim UpdateSQL As String UpdateSQL = "UPDATE WatchListQuery SET WatchListQuery.LoadStatusID = 6 WHERE WatchListQuery.LoadStatusID<6 AND WatchListQuery.BookingID=" &...

Took out all of the () and it now works just like I wanted it to. Thanks guys!

I was all ready to get this problem solved with all of your help and move on to other programming, but something cropped up. This is the SQL that the query builder shows me: UPDATE WatchListQuery SET WatchListQuery.LoadStatusID = 6 WHERE (((WatchListQuery.LoadStatusID)<6) AND...

I am working on some code that is designed to allow a user to switch the value of an ID number associated with a "Status" to the number 6 by simply clicking a cmd button. Button is named 'MakeStatusBillable'. This button is on a form named "MenuItemsLoads" that has a series of ID numbers...

I got this to work with the following: Private Sub Add_Comments_Click() Dim EmployeeIDFilter As Integer EmployeeIDFilter = Me.txtEmployeeIDFilter.Value DoCmd.OpenForm "Client Main Form", acViewForm, , "ClientID = " & Me.txtClientIDFilter Forms![Client Main...

Ok I put a textbox on the "Client Employees" form and formatted it, and named it "txtEmployeeIDValue" Then edited the code to read this way: Private Sub Add_Comments_Click() Dim EmployeeIDFilter As Long Me.txtEmployeeIDFilter.Value = EmployeeIDFilter DoCmd.OpenForm "Client...

I put some time into making this work today. Here is what I have so far: Private Sub Add_Comments_Click() Dim EmployeeIDFilter As Integer Me.txtEmployeeIDFilter.Value = EmployeeIDFilter DoCmd.OpenForm "Client Main Form", acViewForm, , "ClientID = " & Me.txtClientIDFilter...

I would really like to put more time into working on this but the reality is that the CRM work I am doing in Access is just about the only thing that is holding up the launching of my new business. Which means that time I spend on this is costing me money (unfortunately). So, maybe I will come...

I am looking for ways to open a form and filter for a specific PK number where the form to be opened is a subform of a main form with the subform "under" a tab strip control. I want to Open the main and subform by clicking a textbox on a third form. The third form functions like a "Navigation"...

Thanks everyone for contributing to this thread. For some reason I thought this would be a lot simpler. Now I see that it's not simple at all. missinglinq: You're referring to the mousemove event for the detail section? I could not get that to work.

I have a bound form that I am working to make function like a menu (you know the old style where the items "highlight" as you move a mouse over them?) So I am using this to make a textbox "change" while the mouse is over it: Private Sub View_Activity_MouseMove(Button As Integer, Shift As...

Using Locked vs. Enabled will work for my purposes although it's not ideal. Thanks, Galaxiom for the tip.

I'm trying to do something just like this except that I am using disabled text boxes. How can I implement this but keep the controls disabled after applying conditional formatting? Or, can this be accomplished using code?

I figured out that when making the form for some reason Access was putting an extra company name into the control source like this: Client.[CompanyName].[CompanyName] When I took out the second instance of this in the textbox while in design view, the error was corrected. Wish I knew why it...

Why would I get a #Name? error produced by a bound textbox control on a form? I am using the result set of a query to drive a form set to be viewed as a datasheet. The query results have no errors of any kind. When I put a certain textbox on the form, whether I use the form wizard, or by...