Search results for query: *

Thank you for your reply but I'm looking for a generic way to do this since I'm unable to hard code every single control...this is why I'm using .activecontrol

I am trying to create a number keypad on a form that the end user can use to enter data. The end user will be using a tablet while walking in a department and entering data. The below vb code works but does not work when the end user needs to enter data into a sub form on a tab control. A...

simian336 - Thank you for taking the time to reply. I've run your first suggestion and I get back 'The system cannot find the file specified.' Although I've copied and pasted the exact key and it is obviously there. EXECUTE master.dbo.xp_regread 'HKEY_LOCAL_MACHINE'...

I'd like to use SQL Server 2014 Management Studio and write a SQL statement that returns all the program files on my computer - or better yet another user's computer. But first things first....your help would be appreciated. First I'm trying to list just my machines programs that are installed...

Part of My Code in SQL Server Mgmt Studio as listed below. On the last line I want to get the modified date on the txt file that is used in the bulk insert and place into a column that I just created "UpdateFileDate". Any help on the code I would use? I have end users who creating a txt file...

Thanks to everyone who responded! I do work for 100+ farmers and found that the way I am doing it in Excel seems to be the best. I use a sumif for acre totals and then use nested if functions to return the fields name desired. I was simply trying to see if there is a forumula that I didn't...

I want to know if there is a formula that is similar to SUMIF but for text. I want to return text values.... If last year & this year crop is corn (C) then return the field name(s) example.... year year 2010 2011 field crop crop...

Thanks for your suggestion. I ran an SQL statement to append table and it works however I then need to refresh my dataentry form because the record doesn't show up.

I want to repeat this step (copying current record) as many times as the end user states in a text box on the current form. DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord...

AceMan1: Thanks so much for your reply. more info... Me.NextNum is actually a txtbox that is calculated =Max([ControlNUM])+1. I am having trouble with some end users clicking on the command button cmdAddNewEntry BEFORE the NextNum has calculated (some endusers click on cmdAddNewEntry right...

I wish to have a cmdbutton (cmdAddNewEntry) disabled when the NextNum = 1 (NextNum is a textbox on the current form) and enabled when NextNum <>1. Below is my code & I am not sure why it keeps locking up on me. Private Sub Form_Current() Do Do While Me.NextNum = 1 If Me.NextNum = 1 Then...

I know it doesn't make sense to me either. All I know is that the screen needs to repaint after I make the selection from the combo box using the down arrow button - not mouse. And it works with the echo code. I understand echo "hides" screen changes from the enduser until turned on again. It...

cool - okay I see what you mean - thanks. I still need the echo code in order for screen to "repaint

It shows approx. 5 lines of list. I got it to work finally by: (afterupdate) application.echo false application.echo true end sub I am sure there is another way :) OnFocus? I want the end user to be able to enter data fast. They like to use tab or enter to move to next field and then use...

I have a combox box which is bound to a field in a table and selects its list from a querry. After the end user chooses the field - everything works as it should - when using the mouse. If the end user chooses to use the down arrow to select it works - EXCEPT that the screen still shows part...

I don't want the end user to be able to have duplicate records for the same date and shift. (I have a control number as a primary key field due to the large amount of related data - backend in SQL, front in Access) example: date 10/1/10 shift 1 (good) date 10/1/10 shift 2 (good) date 10/1/10...

WOW - you lost me :) I am going to use: =IF(ISERROR(SEARCH(B6,A1)+SEARCH(C6,A1)+SEARCH(D6,A1)+SEARCH(E6, A1)),"ALERT","GOOD") a1 = sew I have a table with all my letter combinations: either s, e, w, or m in any order (stands for allergens: soy, egg, wheat, milk) example: b6 = s, c6 = e, d6 =...

Nevermind my indirect code .... (its getting late :)

P.S. I am experimenting with... if(iserror(search(indirect(a1),a2)),"good","alert") I just don't know where to place wildcard.

Thank you! Now can I take it a step further?... I actually want to search text in cell a1 and compare it to cell a2... example: a1: sw a2: sewm =if(iserror(search(a1,a2)),"good","alert" if any part, in any sequence is in a1 and in a2 I want a "good" return, if not alert.