Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wz
  • Order by date
  1. wz

    keypad on form for entering data - not working with subform

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

    keypad on form for entering data - not working with subform

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

    SQL to list all programs installed on local machine?

    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'...
  4. wz

    SQL to list all programs installed on 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...
  5. wz

    How to get last written date on txt file to SQL table after a BULK INSERT

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

    I'm looking for a formula to return text value if..... Similar to sumif formula but for text

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

    I'm looking for a formula to return text value if..... Similar to sumif formula but for text

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

    How do I Repeating Code as many times as end user states in txt box

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

    How do I Repeating Code as many times as end user states in txt box

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

    Do While and Loop - cmdbutton disabled or enabled depending on txtbox

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

    Do While and Loop - cmdbutton disabled or enabled depending on txtbox

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

    bound Combo Box needs to refresh after end user uses downarrow

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

    bound Combo Box needs to refresh after end user uses downarrow

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

    bound Combo Box needs to refresh after end user uses downarrow

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

    bound Combo Box needs to refresh after end user uses downarrow

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

    Duplicate Record - Alert End User

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

    Excel: IsNumber(search) - want to use wildcard to match any text

    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 =...
  18. wz

    Excel: IsNumber(search) - want to use wildcard to match any text

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

    Excel: IsNumber(search) - want to use wildcard to match any text

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

    Excel: IsNumber(search) - want to use wildcard to match any text

    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.

Part and Inventory Search

Back
Top