Search results for query: *

I am trying to create a duplicate HD. I can do this in win 98 using the dos command for a fat32 system. However this command does not work in NTSF format. What is the dos command to copy a fixed disk? Thanks RBE RBE Are you 100% sure of where you are going.

Can Access 2000 do this? 1. in intervals open and check for email sent by a specified person 2. Take information off of said email and save it to a database table (needed information is in same place every time) 3. send an email to another person listed in another table I am using this to...

How do I pass a value from one form to another without leaving the frist form open? RBE Are you 100% sure of where you are going.

Can I use the openargs value in a query, and how do I do that? RBE Are you 100% sure of where you are going.

Is there a way to carry a value from one form to another to still another without leaving the original form open and referenceing it. I am using MS access 2000 and I have created a series of forms to post and print payable information. The first form has the ticket #(primary key in table) the...

I am getting a write conflict and I need some trouble shooting help. There are a series of forms that are used to enter payables and print a backup sheet for the invoice. Here is the process form1 1.enter in price per unit 2.enter in ticket # (primary key) 3.click button(runs update query to...

How do I use the inputbox value entered in a form? I am trying to automatically fill in a field on a form becaues, the users seem to forget the product when they don't have to enter a batch. The product usually defaults to a value when a batch is entered but if they don't have a batch # then...

I have a slight problem. I am trying to create a total field in the grouping footer of a report. Here is the problem. I am trying to total a calculated field (the control source is an expression not a field name). I have tryed the =Sum([fieldname]) but that does not work,(it will not...

Ok, Need some ideas. How do YOU create a running total in a query? RBE Are you 100% sure of where you are going.

I am using this code to create a running total in MS Access 2000. It works great. However it only works once. After the query has been opened once It will keep adding the intcost to the gtotal starting from where it left off when the query was closed. Can you tell me how to make this a...

On my tables I have a checkbox control called [closed]. I need a way to automaticly check all the boxes pulled in a query. What this does is lock the record so that it cannot be changed. I am not very good a looping through sets of records and changing the value. In fact I am not sure how to...

I am trying to create a running total in a query. Here is what I have done. The results I am comming back with is two little "boxes" at least that is what they look like. I am using ms access 2000 In a modual I have Option Compare Database Option Explicit Global gTotal As Long...

This is a query expression that is supposed to return a running sum over a group (destination terminal)of numbers (gallons received). Gallons received is a number and destination terminal is a text field. All of these are on the same table. It is comming back with a null value(blank), and I am...

I have a report, that in the group footer, the wizard totaled two fields. I added two more fields that are calculating off of other fields in the report(same group) and I want those to total too (same group but in footer), but when I try doing the =sum([fieldname]) in the footer it will not...

I have one more question. How can I get a running sum into a query. I thought about creating a function to do the calculation but I can't think of a way to get it to work in a query. or even how to get it to work at all. any suggestions. Thanks RBE

This is really strange and I am going to try to explain it the best I can. If you need more information let me know. I have a field on a report that has this if statement in it The name of this field is [rec gal] =IIf([GALLONS]>=[sum gallons received],[Gallons Received],0) Here is the...

I need a macro that will be placed in a personal.xls macro file and will check the name of the workbooks opened and if it matches dgltest.xls it will run a macro (dgltest) on it. This is a file that will open in excell from access. Access replaces this file every time it opens so I cannot put...

Below is a formula that is in an unbound textbox on a form. The form has all the fields listed here,on it. The fileds are bound to tables as follows purchase price = tenders table gallons received= "" "" inventory unit cost = "" "" pipeline...

There is a typo in this formula somewhere. I am comming back with a #error. This is the control source of a text box on a form. I got this off of the board so the syntax may be wrong. As far as I can see there is nothing wrong with it. Helllppp. Thanks RBE =DLookUp("[Terminal...

This code seems to be comming back with a null value. What I am trying to do is look up a code (primary key)on a table using values on a form and comparing them to the table. The table name is "Tariff" and the form name is "Tenders Form". The code is in the control source...