Search results

@Pat Hartman sorry for the late reply I been out of work due to an injury. I jumped the gun but I do believe your solution will work but I'm not completely understand it. Can you explain this further please? Also below is a better explanation of what I'm trying to do... I have a form...

I only need to check the 3 text boxes and I need to spell check one after another with a press of the button. I got the below code working correctly with @Minty suggestion for the 3 text boxes and I added true to warnings.... Private Sub cmdSpellCheckIssues_Click()...

Hello, I have 3 text boxes that are memo fields and I added a button on my form to spell check all 3. For some reason it spell checks the first 2 and skips the 3rd (txtQualityIssues) one and wont check it. The spelling is correct so that's not it, what could it be? Thanks! Private Sub...

Is it possible in my print codes [Where Condition] to change the date of a textbox on my report? What I mean is I have a textbox (txtSpotcheckDate) that's control source is a particular date. Now when I print the report can I or am I able to change that date using the [Where Condition] to a...

@arnelgp could I just use Open arguments like? DoCmd.OpenReport "rpt_SpotCheck", acViewPreview, , "WeekEnding = " & Me.txtSpotcheckDate - 4 DoCmd.OpenReport "rpt_SpotCheck", acViewPreview, , "WeekEnding = " & Me.txtSpotcheckDate - 3 The txtSpotcheckDate is the date field and...

Hello I have a report that needs to print twice but on the report I have a text box that needs to change its date +1 on each print. The starting date is on a form and I need to start on a Monday from that date which is -4 and Tuesday is -3 Forms!frm_WeeklySafetyHuddle.txtWeekEnding - 4 and the...

Thank you @Eugene-LS and @June7

@June7 I followed your instructions and attached a DB. I have a initials query that this is what I'm trying to do this with. I needed to display the first and last letters of the name and not show data that is null. As for the employees I'm not sure what to do to normalize it.

Ok lets do it over.... I created a query and a table to make this right... In the query I have each employee field from my table. I need to only show the fields that show a name or data AND I need to only show the initials of the employee and not their name. To get their initials I would use...

So what woud the query look like it pull namex

No they are not saved but they are pulled from a table. This database is just to print papers I have to do every week and this is to make it easier for me. Acually I take that back I have a table that does save the selections on the main open form so I dont have to keep entering/selecting names...

Hello, on my open form I have a max list of 10 employees BUT there is usually 8 employees and the last few are usually blank. I need to just pull the list of the employees from that open form to a single text box in my report that gets printed from that form. How can I just print the names from...

Thank you!

Hello, I have a table (tbl_Inches) with a field (inValue) and I want to create a query that will check a table (tbl_MachineOutput) field (SLegCS) for data that is not in the (inValue) field. How is that done?

Your post #12 resolved my issue. There is a On_Click event in each of the 4 text boxes. I attached an example of the code

David, I used your example BUT I'm able to tab to the first control from a control that has no restrictions if I were to go this route of restricting the 4 text boxes that are in a row. Lets say I have a text box txt1 and then next text box is txtSLegCS, Im able to tab from txt1 to txtSLegCS...

I hate to block all the controls because there is only 4 controls that need need this (txtSLegCS, txtSLegNCS, txtPLegCS, txtPLegNCS). Is there a way I can just block tabbing and arrow keys to these controls and within these controls because they are one after another.

Thanks all that did it..... Below is code if someone needed it.... Private Sub Form_Load() Me.KeyPreview = True End Sub Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyTab KeyCode = 0 MsgBox "Sorry the Tab feature has...

That did it thanks.... Oh I just found out enter moves it also, how do I disable that key as well

Hello, I have a database that has on click events in some textboxes and they have to be used. The problem I have is I have an employee that uses the Keyboard TAB and the keyboards arrow keys to get around this and even being told not to they continue to do so. So I needed to disable these on my...