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 Rhinorhino 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: kermit01de
  • Content: Threads
  • Order by date
  1. kermit01de

    gaps between item numbers

    Hi there, we have an SQLtable "item" that contains a full range of items. We usually assign 6-digit-numbers as [No_]. I already have a script, that finds free numbers: Select t.[No_]+1 as LueckeVon, (Select MIN(CAST([No_] as int))-1 From [BODAN600].[dbo].[BODAN Gh_ für Naturkost GmbH$Item]...
  2. kermit01de

    WHERE datefield > Yesterday() ???

    This is about SQL Anywhere 11 - with Visual Studio 2008 - via ODBC I try to create a query with filter to a datefield (LAST_CHANGED) > Yesterday. As from MSSQL I know "Today()-1" --- this does not work here. I also tried "> Dateadd (day, -1, Today())" - Invalid expression Does anybody have a...
  3. kermit01de

    Export > 400000 records ?

    Linked SQL-table qry: SELECT [dbo_GmbH$Sales Shipment Line].[Order Picker], [dbo_GmbH$Sales Shipment Line].Quantity, [dbo_GmbH$Sales Shipment Line].[Gross Weight], [dbo_GmbH$Sales Shipment Line].[Net Weight] INTO Kommi_1 FROM [dbo_GmbH$Sales Shipment Line] WHERE ((([dbo_GmbH$Sales Shipment...
  4. kermit01de

    assistance find dups - another issue

    For this example: Table SalesLine Field [orderno.] Field [Debitor] Field [item] orderno. - Debitor - item 10001 12345 1010101 10001 12345 1122334 10001 12345 1111111 10002 12222 1010101 10002 12222 1122222 10002 13344 1231231...
  5. kermit01de

    Error 812 when setting up integrity rule "Firewall active"

    Hi all, Szenario: SVR1 - W2K8R2, NPS, Routing&RAS --NPS Proxy redirecting to SVR2 SVR2 - W2K8R2, NPS CLI1 - Win7SP1, NAP Client enabled L2TP VPN works from client via SVR1 to SVR2 As soon as I implement a Windows Security rule ... integrityrule - networkrule on SVR2 saying "Client Firewall...
  6. kermit01de

    image as a secret to discover

    As I am not familiar with java at all, maybe someone has got a hint for me - this is, what I want to do: - Having an image (img01.jpg) on my webpage - on top of that another image (img02.jpg), so that img01 can not be seen - moving the mouse over the image area just shows a small circle of...
  7. kermit01de

    Access randomly in the background and/or foreground

    Hi, maybe anyhone has got a hint for me: Having Access2010 with a main form, from where I am able to call other forms. (Main Form -> New Record, Main Form -> Records marked as X etc.) So these buttons just open a new form with a filter. It happens from time to time, that I try to open another...
  8. kermit01de

    Test Emails every 10 minutes

    Just a quick question, having a domain hosting provider, I want to log the faulty mail system he provides to be able to quit before end of contract. Is there any simple tool or script for eg. Outlook that sends a Testmail eg. every 10 minutes through a configured smtp server? Send as...
  9. kermit01de

    word doc as body of mail

    Hi, Original issue: list of recipients should receive mail with pdf attached. I already found a solution for that in general, but as I do not have any clue about vba, maybe someone could help out at the missing point. I have an Excel table containing the recipients(A), Subject(B), Text(C) and...
  10. kermit01de

    ODBC.ini - driver path

    After upgrading the client to Win7 I have got the following issue with odbc: As long as I put into the ODBC.INI in the registry te full path to sqora32.dll and write protect the key C:\Oracle\product\11.2.0\client\BIN\SQORA32.DLL the application is able to connect. So far so good. "The...
  11. kermit01de

    weird - shell command executes but does not

    Access 2010 The following procedure is on the "after update" event on a checkbox Private Sub FertigX_AfterUpdate() CurrentDb.Execute "INSERT INTO LapLog ([LfdNr], Aktion, Zeit) VALUES (" & LfdNr & ", 'Fertig neu: " & FertigX & "', Now())" If FertigX = True Then If MsgBox("Wirklich...
  12. kermit01de

    New record on top

    Hi, What I have is a form, where I am able to select a person from a combo. Form then displays main data (PC-Name, Room, phone etc.) and a contiuous subform, displaying info about what was done with this user. - Let´s call it "ticket system" In the subform I sorted the last entry to the top -...
  13. kermit01de

    Cancel on open event without opening form

    The next one from me ... I have some code in the on open event on my switchboard, that opens another form. Both are PopUp = Yes, so that the switchboard comes in front. I tried to docmd.minimize before opening the other form - that works, but a) Howto automatically maximize switchboard after...
  14. kermit01de

    text truncated in text field

    A textfield in a continuous form is bound. The field contains "Hello Dolly how are you? I hope you are fine" As the width on the form is only 5 cm it displays "Hello Dolly ho". Having the focus I can go further to the right and scroll the whole text, so it is not truncated because of the...
  15. kermit01de

    Click & Message if fields match

    Unfortunately I do not find any hint for what I am trying to do: Having two tables FE_Version and Config. Both have field Version - if they match everything is fine. I would like to have a button "Check Version" that checks the fields and pops up a message saying "Please update your frontend"...
  16. kermit01de

    Send message(box) to user

    Hi all, is there any "built-in-solution" for the following scenario? - Form - field "Finished" is set to true - Messagebox is sent to accessuser "ITDS" I found an external solution, but am still wondering if there is any internal possibility. -------------------------------------- >>>>>>...
  17. kermit01de

    Search all fields

    Is there any possibility to have a search-field to enter something and to have a result list that diplays all records that match the entered text in ANY field? eg. name, surname, city -> entered "mil" -> result Miller Martin New York Rodemill Robert Washington Fine Fran Milchester Bond Emil...
  18. kermit01de

    Open new form and show record selected in "previous" subform

    After browsing around and testing several things, I am not really coming to the final ... Having a from containing a subform "frmSUB". What I would like to have: Click on the "Name" field in the subform should open a new Form "frm_DispDetail", displaying the details of the selected record...
  19. kermit01de

    subform only visible if it contains data

    Scenario: - Form with Combo-Box - selected "User" will display details in detail section - subform in detail section that displays the "user" if it is present in another table (SELECT [Fehlende].[User] FROM Fehlende; ) How to hide the subform if it does not contain records/data? Thank you...
  20. kermit01de

    BB Save/Restore Blackberry Layout only - possible?

    After I sorted, hid and moved my applicaton icons around I wondered, if it would be possible just to save the order and appearance off the icons to restore it eg. to another BB. It should not change any Theme, Skin, etc, just the order of the icons in the menu. Any hint for that? Or is it not...

Part and Inventory Search

Back
Top