Search results for query: *

can you make the field on the table a primary key field? that would make it a required unique value and your database would take care of the message. Otherwise the code would have to change as items were added. RBE Are you 100% sure of where you are going.

Thanks I figured it out xcopy does work you just need the deliminator of /e. Thanks for your help. RBE RBE Are you 100% sure of where you are going.

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

I was looking at the openargs function. I know how to open the form with the openargs command at the end, however I am not sure how to use that information to fill in the required field in the form being opened. Here is my situation: On the first form I have a value in a field called Transmix...

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.

Can I use the openargs property on the forms to transfer the ticket # between forms. If I can how do I get the queries to see the openargs when I call it? 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...

Thanks, Still trying to figure out this VB stuff. Thanks again. RBE RBE Are you 100% sure of where you are going.

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 just wanted to let you all know that I did find a way to sum a calculated control in the group footer of a report. This is how I did it. It may help others as well so I am posting it here. 1. create an unbound textbox in the detail section of the report. 2. Put this expression in the...

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

Thank you all for your suggestions. Is there any more. These have helped. Seems they are very similar. Thanks again. RBE RBE Are you 100% sure of where you are going.

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

Never mind I can't belive I didn't think of this before. Just for future reference "run an update query to true" duh!!! Sorry for bothering you all with something this stupid. You can always say tomarrow, but when you say yesterday, today is easier. RBE Our prayers go out to the...

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

ok I have it comming back with a result and it is giving me a running total but it is starting with some out ragiously high number. Could be the total for all the gallons in the database. how do I get it to start from 0? You can always say tomarrow, but when you say yesterday, today is...