Search results for query: *

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

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.

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?

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

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.

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