Search results

Hello, I have a subform with 8 buttons that users can pick shortcut paths to. in that subform (subform 2) there is another subform (subform 3) that becomes visible to edit the button names and forms the user wants to open, it is just an edit query from the tblButtons table. when i close that...

I found my error, i opened in acViewNormal rather than acViewReport, switching did the trick

Hello, I am somewhat new to VBA, but i have a form that pulls in a subform specific to the CurrentUser(). It is meant to be a shortcut or favorites form that holds 8 command buttons. I have Dlookups on the form to pull the correct fields from a table for OpenForm or OpenReport and then the...

Thanks everyone for the tips. I am not super experienced so in case someone else is looking, building off the premise from Gemma, I just set my on load command for the form to: Dim ButtonColor as String ButtonColor = RGB( 125,159,159) ' Manual Change cmdButton.backcolor = ButtonColor I did...

Thanks for the reply, i can get the RGB number or the code for the color i need just fine. I want to store that in a master form or table so that when i want to change 100 control colors all at once from black to white, i can just change the color value in the one form and since hopefully i can...

I am trying to see if it is possible to store colors in a form or table and then reference them while in VBA. What I am hoping to do is when I write all my code for command buttons to change On Got Focus, instead of writing xxx.backcolor = RGB (255,255,255) i could do something like...

Perfect!! thanks so much Paul

Thanks Paul for the reply, i am firing the after update on the calculated total like you mentioned above. However if i hit refresh the image appears as it should but i have to keep hitting refresh in the ribbon to prompt the changes. I am not super experienced in code so is there a way to do...

Hi all, I have a text box [txtTrafficValue] that is a calculated field of two short times. I want an image to be visible if the value is >= 0.0104 (15 minutes). I have in the after update of the field: if me.txtTrafficValue >= 0.0104 Then Me.imgWarning.visible = true Else...

I actually have 5 optional criteria on that form, but the checkbox is the only one that is not working when true. I have never had to enter anything into a parameter box in the past, so when i add it now, it is giving me an error if i try and add a Or Is Null statement.

SELECT DISTINCT dbo_Drivers.Name, dbo_Drivers.isActive, dbo_Drivers.DriverID AS Pin, pvqryZoneAssignments.Division, pvqryZoneAssignments.[Transporation Coordinator], pvqryZoneAssignments.[Transporation Supervisor], dbo_Zones.Note AS [Zone] FROM (dbo_Drivers INNER JOIN pvqryZoneAssignments ON...

Hello, I have a query that uses a checkbox from a form as a criteria. in the table the values are stored as 0,-1. if i run the query with the checkbox false, the query works and filters correctly, same if the box is null. But when I check the box true, no records load. It worked in an older...

Thanks so much, the restructure helped tremendously!

Thanks plog, i do have a separate service type table set up, for instance oil change is entered as 20 on the invoice form, same with my vendors. Are you suggesting then i hold all of my repairs in one repair table? then how do i query just oil change or "20" and still pull in all the other...

Hello, i am still somewhat new to Access but i am having a hard time with a query. I have an invoice form that is from tblInvoice, and on that form i have 5 subforms all tied to 5 tables, tblRepair1, tblRepairs2, etc. When we get service done at a shop the user can enter up to 5 repair types...

Thanks Goh, i entered the [forms]![MXTRepairLog]![cbxRepair] in each repair column of the query design view so it looks like the text is diagonally stepping down, but the vaules are only returning the records where the cbx from the form is in Repair1 and not pulling if they are in repairs 2-5...

Hello, i have a form with a control for "repair type" and a subform that has a query that searches a table holding vehicle repair records. on the form the user can enter up to 5 repair types, [repair1], [repair2], etc.. Then the control on the form holds each type of repair to search by. Since...

Ok, that gets the wheels turning a little, i will give it a go.

Ok but then how do i update the 'local rides' table when i change a checkbox to true?

hello, i am not sure i am on the right path. I have a table [rides] that is a read only link to a third party so the simply option of adding a field in that table will not work here. i have a query that runs from the [rides] table to show me all the cancelled rides for today. What i want is an...