Search results for query: *

I need to have access create a folder on the user's root directory and then copy some files to it. I tried ... Shell "md c:\test" I could not create the file. Could someone guide me on this?

http://www.tek-tips.com/threadminder.cfm?pid=183 This is a continuation of the above link. I have the below query inserting into table tM_FR_WIP_UnitID_FastStops and I would like to have the query JOIN on ENDGROUP and LINE to the table so it can determine whether or not the data is there and...

When I try to execute this Delete query, I get an error asking me to specify which table I want to Delete. I want to delete the data that match Query2 from tM_FR_WIP_UnitID_FastStops. DELETE tM_FR_WIP_UnitID_FastStops.nLine FROM Query2 INNER JOIN tM_FR_WIP_UnitID_FastStops ON Query2.EndGroup...

I have a unit that will start off with zero or close to zero lbs and when it completes there will be either 1500 lbs or 2000 lbs. During the time it's weight is growing there are things that could go wrong and make the unit stop growing. This is indicated by either a Slow Stop or a Fast Stop...

I have an external data source that is refreshed when the Word doc opens. The problem I am facing is that Word asks the user if it is OK to load the data and to press YES to continue. I would like this message to never appear. How can I do this?

I have a continuous form that when I open the form it goes to the last record. It does everything I want it to do except I would like for it to go to the last record without placing the last record at the top of the screen. I would to have it go to the last record and have the record displayed...

I have a bunch of computers that are networked bound, but are not bound to a domain. My problem is that every once in awhile, the time on the computers are off or they slowing change. I would like to do a simple net time /set /yes, but the "/set" does not understand where the time server is...

I use a static IP address for a computer I have on the shop floor. The IP Address for the network jack on the wall will never change. I have to manually type in the IP address for that computer. If that computer should happen to fail and I have to replace it, Is there a way to have the...

I have some data that some engineers would like to work with, but it is very time consuming to compile what they need. I have a machine that will stop because of a problem within that machine. Then the operator will fix the problem and then start the machine up again. I have numerous...

Is there a way to take this query and normalize it? I have approximately 15 elements that are tested and display a result along with 15 lower specs and 15 upper specs. I would like to take the results and pile them on top of each other therefore creating a Results, Lower Spec and Upper Spec...

I can not get this code to work. I am getting a syntax error, but I am not sure what I can do to fix this. Me.Filter = [Date] = "Between '&[forms].[fM_ScrapControl].[start]&' And '&[forms].[fM_ScrapControl].[end]&'" Me.FilterOn = True Thanks very much!!

I need to create a trigger when data is present in a particular table. There is only one record in this table. I know how to set up the trigger and have it run some code, but what I need is someone to tell me how I can make my stored procedure (code below) execute faster. For every elemnet...

In MS Access, I can create this command line. Right([Product name],InStr([Product name],',')+3) Is there a way to reproduce this in SQL?

In SQL, I would like to create a view that I have a simple IF or IIF command in the field name. I know how to create If statements in SQL and I know how to create IIF statements in MS ACCESS, but I need to have a field name test a criteria and then displaying the correct data when the view...

I have created a shortcut that allows me to view the files on a networked computer. How can I modify the shortcut so when I double click it, it will open in a new window? When I hold the shift button down and double click the shortcut, I get a new window. Any thoughts? Thanks!!

What is the command line to ensure the Access application maximizes on open? I am using the HAL.exe as a scheduling agent. When I have HAL.exe open an application from the autoexec, it keeps the application minimized on the windows task bar. I need this application to be maximized. Now I am...

When I plug my mp3 player or my memory stick into the usb port there is a specific drive letter assigned to the port. Is there a way for Access to understand which drive letter the external device has been plugged into. I do not want to limit the user to only plug the device into a certain...

Is it possible to have a query that would list all of the files in a folder location. I would like to build a hyperlink that looks up this list. Please just point me in the right direction.

Does anyone know if you can embed a media player into a form so when a user selects a media that it can be viewed from the form?

I would like to create kind of a setup program for my maintenance dept so that when a new computer is issued for a production line they can easily set up the computer without going to me or IT for help. What I would like to do is have maintenance pick up the computer that needs to be set up...