Search results for query: *

I have a Query that has a field for a file location that I use in an asp application. What I want to do is make another field in the same query that takes the last 4 digits from the file location field. Example:( File Location Field: /home/file/test.doc ) What I want to bring over to the other...

I would have 3 tables one for your sales information, one for the sales rep, and one for the sales company information. Let access assign an ID to each record in each table. Then in the queries you can bring that information together and do all of your financial calculations. Christopher...

I have been able to create a new MS Word document with the recordset but does anyone know how to mail merge that recordset to an existing MS Word template? I have a set of forms that has to be set up with the type of paper and margins.. I can do this in word but I have a multi user web app and...

If you want a really good *AND FREE* Remote program download the VNC program. This allows you to remote into anyones machine and lets you password protect every machine. http://www.vnc.com/ Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

Thats funny because this DB does that , you set the timer and it gets displayed to that user on a form that cycles down and then runs the script. Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

I have to do some searching, I did this about 4 years ago, to help you out now I can tell you there is a way to call their windows login information and kick them out of the DB by that, you can even reboot, shutdown, even log them off the computers. I will try to find my old db with the code set...

I would try to open Access Exclusively and then Compact your DB. Let me know if you need help on how to open a db exclusively. Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

DoCmd.close Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

I would put the login page as the index and set your update page to only show when a user auth. has been verified. Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

Does anyone know of any software or code that will let me generate my recordset from an ASP page and mail merge it with a MS Word document. The problem I am having is that yes I can generate the letters in an HTML format but some of them have to be exact due to perferated pages I use for...

You can get the above code to work if you save each one "Enable,Disable" As a seperate module. Then on your buttons ONCLICK code place Call DisableByPassKeyProperty or Call EnableByPassKeyProperty depending on which one you want. Always make a backup and try it on there first! Christopher Abney...

When I put that in my redirect field it gives me an error saying no table found. This is what I placed in the after update go to translis.asp?transid=<%=(rsval.Fields.Item("transactionid").Value)%> here is my page code if that helps.. transid is the key i want to pass. <%@LANGUAGE="VBSCRIPT"...

I am using asp and an access db. Can someone tell me how to pass a key value to my redirection page after an update form. I have tried to insert a hidden field and bring it over with Request.QueryString("transid") but I think I am missing something. Thanks Christopher Abney There is no limit...

Actually I do not store that value in a tabe, I get it from a caculation in the query. when I get the result if it is below $5 I want the value to be set to $5 in the query. Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

How do I change the value in a query if lets say I wanted at least a min of a $5.00 value and I have a value of $2.50. How can I change the $2.50 value to $5.00? Thanks Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

OMG, Thanks you guys! It has been a long time since I have worked with access. Trying to reeducate myself. Christopher Abney There is no limit to the good you can do if you dont care who gets the credit

I am trying to add a specific date to a query i have built. All I want it to do is propigate to all of the records. I have tried =9/20/2005 in build function but i get a wrong return, i have even set my format to date. Any answers out there? Thanks Christopher Abney There is no limit to the...

I got it, I had to build 2 queries per date, one to get all who have paid and then one unmatched query.This gave me a list who has not paid for that date. I know I could put the date in the criteria but I am using .asp web page to communicate with the data base. Thanks everyone Christopher...

I have racked my brain on this and hopefully one of you can help me. First of all let me explain what I am trying to do. I have a list of approx. 450 resturants that we need to collect taxes on every month. I have a table where all of the resturant information is stored. I have a table of...

Here is the code: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../../Connections/FIT.asp" --> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim...