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

    Cant split tasks

    I have a 5 day task. I right click the bar and get the split task cursor. I put the cursor at the halfway point in the bar, and drag to the right. This is what the help file says I should do. When I drag/drop, the task does not split it extends the bar to the right by the amount of time I...
  2. ddelk

    String Criteria in query not returning existing string

    Found it. I simply have to surround the conversion with the Trim function. So Trim(Str(<number>)) This does both leading and trailing spaces. LTrim does leading only and RTrim does trailing only.
  3. ddelk

    String Criteria in query not returning existing string

    Upon further review, when I export the data to txt files, I get a leading space. So I get " 12345" instead of "12345". Any idea why this happens or how to remove it?
  4. ddelk

    String Criteria in query not returning existing string

    I have a string field that is 50 char in length. My data is about 10 char but it can vary so I left the default as 50. When I do a query and search for a specific string, the query does not return a string I know exists in the table. When I do (Like "*<string>") it finds the string. Is Access...
  5. ddelk

    Set size of application window?

    Found it but I have to use the windows api
  6. ddelk

    Set size of application window?

    I am using Access as my front end. I have a form that I want to maximize to fill the application window but the form doesnt have much on it. So I want to set the application window to the same size as the form and then, ultimately, just allow the user to minimize or close the application via...
  7. ddelk

    VB Script not so easy to figure out

    Im afraid my brain dumped on the msgbox thing. Thanks for reminding me of the definition for 'object'. I also appreciate the additional details on scripting. I suppose what I'm seeing is that scripting allows me to feed in code at run-time rather than have it pre-compiled in the executable. If...
  8. ddelk

    VB Script not so easy to figure out

    I guess Im just missing something. 1. I can use a text stream to pull in code from a text file that contains a procedure. 2. I can then use the script control .addcode and .run to run the code. 3. Is this all there is to it? I keep reading about adding objects but when I do...
  9. ddelk

    Scripting as a way to expose code to users?

    I have code that updates an Access database, exports the modified tables to text and then runs a linear programming model using the text files. I currently have the code in a front end Access database, attaching to a backend Access database where the data resides. I want to move the code in...
  10. ddelk

    DSUM Syntax conundrum

    I want to put this sql update statement into code but keep getting syntax errros. It works in a query but in sql I have to change all the double quotes to singles and I'm missing something somewhere. strSql = "UPDATE TEMP SET TEMP.CUMMW = DSum('mw','dispatch_all','[totdispatch]<= " &...
  11. ddelk

    Delete Table Relationships via Code

    I need to delete related tables via code but cannot figure out how to first break the relationship link via code. Any ideas?
  12. ddelk

    Refreshing CurrentDb.Properties in current session

    You need to do application.refresh<something> (cant remember the exact method) after each change of "AppTitle
  13. ddelk

    ADO vs COM?

    I do mean OLE automation.
  14. ddelk

    ADO vs COM?

    Is there a comparison or am I talking apples and oranges? Here's where I sit. I have a VB6 front end that uses ADO to retrieve a recordset from an Access 2000 database. I modify that recordset, the do recordset.update to put it back to the Access table. So far, so good. Within this Access...
  15. ddelk

    Can't export to .tmp file?

    Weird situation. On my PC at work I can use VBA and transfertext to export Access table to .tmp files. When I get home, my home PC won't do .tmp exports. At work I have Access 2003 and at home I have Access 2000. Is there a registry setting I can change or some such? Before you ask, yes I...
  16. ddelk

    Is it possible to append to a file that is open and see the update?

    Thanks tsuji. I came across a comment you made to someone regarding rtfbox control. I experimented with that and it seems to work fine. I still need to put the comments out to a text file for permanent record keeping but the rtfbox allows me to view the information as it happens.
  17. ddelk

    Is it possible to append to a file that is open and see the update?

    I have a log file I am writing to that shows the status of my code at various stages. I would like to open this file once and watch the output as it is written. At the moment, I have to close the file and reopen it to see what has happened since I last opened it. Is this possible?
  18. ddelk

    copying backend tables to the backend but using the front end

    When I do that, I get a linked table in the backend that is recursive, i.e. it shows it in the backend and its linked to the backend. Because of this, I cannot link the frontend to the backend since Access does not allow for multiple layers of links. For instance, when I try to manually link...
  19. ddelk

    Importing text files into a Backend database using the Frontend

    I am getting text files dumped to a folder and I need to bring those into a backend database. I am trying to figure out how to do a call to docmd.transfertext from the frontend that brings the files into the backend.
  20. ddelk

    copying backend tables to the backend but using the front end

    I have a backend database and an interface that links to the tables in it. I need to take a table in the backend, copy it to a new name (still in the backend), then link the front end to it. I think I should use docmd.copyobject, but each time I do it seems to copy the link in the frontend to...

Part and Inventory Search

Back
Top