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

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

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

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?

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

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?

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

I am using Access to link to DBIV tables. I have a module that, when given a folder path, will link all the .dbf files found in the folder into Access. If a user opens the Access front end, I want to display a link to a table so the user can determine if the folder is the correct one or if...

I need to get the value of a field and store it to a variable. Is there a way to reference the table directly rather than go through the process of creating a recordset or writing a query? Something like intValue = tablename.fieldname.value

I want to execute a third party application using VB but without using Shell. Is this possible?

I am forced to use DOS to run dbase IV programs. ( It's a legacy thing). I am using the Shell function to open a DOS command window, and then executing the dbase program. I then want to wait for the DOS window to close before executing more VB code. I cannot seem to find a way to make VB wait...

When I export an Access table to dbase IV, all my integer (long integer too) values come out with 5 decimal places. I need to ensure that the structure does not change as my program requires integers not floats. Any suggestions?

I do not want to make a structure file then use CREATE <FILE> FROM <STRUCTURE FILE>. I want to create a dbase file out of thin air using a dbase program. Is this possible?

I am trying to determine the best way to record multiple facts about a coal plant over a span of 30 years. The plants are designated by Primary Key and each year is a field heading. Is it better to have one table for each characteristic with each table having 30 &quot;year&quot...

I have data in an Excel spreadsheet. I want to use VB 6.0 to connect to it, then pull data into text boxes or list boxes or whatever. I have created a 'front end' by using VBA in another Sheet in the Workbook, but it is too limiting. Additionally, I need to package it all together so that I...