Search results for query: *

I am trying to construct an analytical graph. Below is sample data Name Monday Tuesday Wednesday Total ------------------------------------------------- ABC 2 2 2 6 EFG 5 5 5 15 I am trying to make a Bar...

I am using Access vba. A text file is copied from the server to a network drive. What I am trying to do is copy this file form one folder to another. Except when the file is copied to the destination, I also want to include a date stamp in the file name. Following is what I am using and it...

Hello there, I have designed a database which opens in the compiled mode. Now when you press the shift key it will open in design mode. I want to open in design mode with a batch file. I have tried the following code. z: CD\MED_SERVICE\Manpower ManPower.mdb /x It still opens in the compile...

I have a crosstab query which is two joined tables giving a sum of hours worked. Now on my form I want to be able to select certain fields for a criteria. I want to search by * Sold to Customer Name * ContractStartDate (Greater than or equal to) * ContractEndDate (Less than or equal to) *...

Hello there. I have a field of Hours and Minutes. I need to add them to get the total number of hours consumed. The hours fields I can add without any problems. The minutes field I want to convert to hours. This is what I have Minutes ------- 60 65 Total of this is 125 which is 2 hours and 5...

I have imported a large data file in to Access. I have a whole bunch of values for time. They are in a text format and I need to convert them to time. Activity Start Time 083000 093200 090500 100500 092800 I need to get it into the following format. 8:30 9:32 9:05 and so forth Is there a...

Hello all. I have to do a bit of data cleaning. Below is sample data. CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V1.0.0.1 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V3.6.0.0 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V4.5.0.0 CANON INC.CANON DIGITAL CAMERA V1.0.0.19 CANON INC.CANON...

Hello all. I have to do a bit of data cleaning. Below is sample data. CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V1.0.0.1 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V3.6.0.0 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V4.5.0.0 CANON INC.CANON DIGITAL CAMERA V1.0.0.19 CANON INC.CANON...

I have a whole bunch of records I am developing for a water meter reading program. Basically I record the water meter reading for a particular house on a monthly basis. Also for that month the rate is different. To calculate the full rate I need to take the difference of the current meter...

Here is my problem which has me going in circles. I have a spread sheet with user data. This sheet is structured in a table format. There are 20,000 records. Basically it is a table of users and the money they have spent. There are fields which specify the place money spent the amount spent...

Here is my problem which has me going in circles. I have a spread sheet with user data. This sheet is structured in a table format. There are 20,000 records. Basically it is a table of users and the money they have spent. There are fields which specify the place money spent the amount spent...

I have developed a database application for my department. basically our employees have the option to take internal educational courses. They are awarded certificates once they complete a set number of courses. We have around 8 certificates to be awarded, and each ones course requirement varies...

Hello all, I have a hyperlink on my webpage which opens a .wmv file in media player. However I would like the video to be opened full screen so the user does not manually have to do it. Is there some sort of code which would help me do this? Below is my code <a href="AddingtheRole.wmv"...

I have an gif image that I want to convert to either .ai or .eps I have tried to search the net for software that would allow me to do that, but no luck. any help would be appreciated!!

I want one column on my spreadsheet to be 40 characters max. Can someone help me with how to achieve this. There is no built in functionality in Excel that would allow you to do this. What I want is that everytime a user enters a value in the cell, they should get a prompt saying that they have...

Hi there everybody, My problem deals with people who use my home computer extremely for chat programs. When I am at work, people tend to log onto various messengers and chat programs to chat all day. They have no knowledge on Information Security and are stupid enough to accept files from...

I am using Excel 2002. currently I have locked my cells so they may not be edited. If a user tries to edit a cell, Excel displays a custom error message stating that cells are locked and protected. Is there a way to replace this message with one of my own? I know you can do this is Access or...

I am trying to make one report from a collection of 4 reports. The selection criteria of this report comes from a drop down menu in the form. And all 4 reports can also be viewed from the drop down menu. Now the problem is when I want to combine all 4 reports into on. All 4 reports are from...

I have made a custom form in access. Basically the user enters data about various IT assets. However if there is a duplicate asset in there the program crashes. Somehow I want to trap that error or if that record already exists in there then I want it to be edited. Below is the code I have and...

I am trying to add values of fields in access. My problem is as follows; One field value contains a value greater than zero, and the other fields value comes to zero. When I add the two and multiply then by 6/12, the whole answer comes out to be a zero which is not correct. Below is what I...