Recent content by ddelk

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

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.

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?

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

Found it but I have to use the windows api

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

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

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

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

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]<= " &...

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

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

I do mean OLE automation.

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

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