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: nkamp
  • Order by date
  1. nkamp

    Delete child records before I can delete the parent

    Hello, I'm a newbie to SQL and if it is not to difficult I can succeed to write querie's. I don't much know about PL/SQL. We are working with Oracle. The parent ERD is this. Table 1 --> linking Table --> Table 2 --> Table 3(detail) 1 | 1 1 1 1 1 n |--> Table 1...
  2. nkamp

    Export with VBA from Excel to MSProject

    Hello, You can look at http://www.vbaexpress.com/forum/showthread.php?t=16843. Here I have the code which I'm using and is working. My solution beneath is straight forward and simple. [code] Sub openMSProjectFromExcel() Dim pjapp As Object Dim strValue, strStartDate, strEndDate As String Dim...
  3. nkamp

    Export with VBA from Excel to MSProject

    Allright, I have already solved by my self. So If anybody need support about this subject I can help him or her Nico
  4. nkamp

    Export with VBA from Excel to MSProject

    Hello, I have to export data (date's, description) from a excel file to a MSProject file. Oke, I can understand that I can open a MSproject file. But then: how do you paste certain cell data from excel into the MSProject cells? Does somebody have a example Thanks in advance, Nico
  5. nkamp

    Memo field length

    Hello dhookom, Till now I see the truncation directly in the datasheet view of the linked table. How can I see that this is happening in the query? It seems to me normal SQL query. Nico
  6. nkamp

    Memo field length

    Hello, If I read the documentation then memo field in a Access table can be 65.000 chars long. I have three memo fields in a linked ODBC table which is filled by a append query. The text in these field is cut off by 255 chars. Does somebody know what the cause of this can be? 1. Is there a...
  7. nkamp

    Time calculation

    Hello, I want at some stage everytime look back for half an hour like: Datediff("s", Timvalue(Time)-Timevalue("00:30:00"), rec("par1").value) Is there in VBA a simple function for? thanks in advance! Nico
  8. nkamp

    Why don't the Like work in the query?

    O sorry, I see now that Crowly also has mentioned this. Nico
  9. nkamp

    Why don't the Like work in the query?

    I have found the problem. It must the "%" sign instead of "*" because the application which I have to maintain uses the DAO microsoft rubish specific wildcards. Thanks anyway. Nico
  10. nkamp

    Why don't the Like work in the query?

    ...= adCmdText cmd.CommandText = "SELECT par1 FROM tblparameters Where tblparameters.gcnf = 'XMLexp' AND ((tblparameters.ccnf) Like 'ExpTijd*')" Set rec = cmd.Execute() Do While rec.EOF = False MsgBox rec("par1").Value rec.MoveNext Loop I don't get any result back. If I...
  11. nkamp

    Calling from VBA access a webservice over the network

    Hello, Is it possible to call from Access over a network a webservice? How? Thanks in advance. Nico
  12. nkamp

    run a proces or kind of deamon in Access

    Hello, I'm new to access. I have in Access at certain times to execute a query which is exporting an XML file. Is it possible to write some code in VBA access which is running in the background or sleep for a certain time. Wake up, checks if a certain time is passed and if so the query is...
  13. nkamp

    Shortcut key

    Hello Paul and Missingling, Missingling you're right. That's what they did. On every form they put a button. Thank you all for helping me. Nico
  14. nkamp

    Shortcut key

    Hello Paul, The hidden objects and system objects checkbox where not checked. But when I made thes boxes checked, I see now some system query. I don't if it made a slight different if I say I'm looking for a key combination ALT+p. I read something that in my autokeys you can only define for...
  15. nkamp

    Shortcut key

    But thats strange. The Access application which I'm working on, has at least two shortcuts ALT+U en ALT+D. Both are opening a form and are working correct. No problem at all. But under the object macro there is not a Autokeys macro!!! Or where must I look for the autokey macro???? Or must I...
  16. nkamp

    Shortcut key

    Hello Paul, Where can I find this? In the database objects macro I have found only two macro's: - mcrCleanupTempTables action setwarnings and RunSQL tblTempApplicants - mcrDelivery with action SetWarnings and RunSQL as wel statements. But I can't find any Autokeys macro like here while...
  17. nkamp

    Shortcut key

    Hello, I'm new to MSAccess. I have to maintain an access application. Can somebody explain to me how to define a shortcut key like ALT+P. When I press these key combination I want to open a form (popup), without closing the "parent" form. In the existing application they define already the...
  18. nkamp

    Testing if a file exist

    Hello, I'm maintaining a application. In this application there a files (like .doc, .txt, .jpg) opened with: setFrame('frm_file', '/ALGEBESTANDEN/' + file_link); Where file_link is a variable wich is comming from sql-server database. But now somebody has deleted the file, while the name is...
  19. nkamp

    Session variable - timeout

    Hello, First of all thanks a lot to help me with solving my problem. Really thank you. I hope not that you or somebody else is gonna shoot me because afterwards it's very easy. I believe that somebody has already mentioned or pointed in the direction of the problem. Thirst of all on advise...
  20. nkamp

    Session variable - timeout

    Hello, First thank you all for helping me. I have tried a lot of different things post, get, request.form, request querystring even with a variable (see my piece of code). If I try to fill a session variable with a request then I get a timeout error. 'hulpvariabele = Request("strURLvar")...

Part and Inventory Search

Back
Top