I have a question about how to write a formula to include specific info in a range of cells. I have a range of cells I want to include in a formula but I want...

I need to write MANY if...then events. I have my tables and need to write a query based on the YES/NO answer of a box I am going to put in my form. I want to...

How do I make a drop down list that is dependent on the previous field. Example: If ="Security" then = or If ="Treatment" then = field is a drop down list...

This is a simple expression, I just am having issues today. I am trying to write an expression that show the difference between 2 fields and if the second...

New at this. I am having trouble writing my formula (invalid syntex) to get sum of one field if another field is ="credit" =Sum()IIf(="Credit",0))) And then...

how do you number in fraction for office access 2003

I am creating a database that track employee paid benefits. I have two tables – Employee Table and a Tracking Table. The primary match is a single check...

Hi all I have just started using access and need your asistance. I generate a unique customer ID using a procedure I created. How do I insert this ID into the...

I have a time card form (it's continuous) that let's users assign their entry to a client. There is a drop down list of active clients to choose from. If the...

I am getting a datatype error on this taatement. I think that it has to do with the SSN. The SSN is suppose to be text do I have this right? DoCmd.OpenForm...

hello everyone, I will try to explain the best I can. Any help or suggestions are greatly appreciated. I have a main iventory table, a Purchase Table, and...

when i installed microsft off.pro edition 2003 the database files from the old microsft office works has a file extension of .wdb when i try to open the...

I have been trying to activate my trial version of microsoft office and when prompted for the product key I enter the only one I found and it tells me that...

what would cause wscript to stop working. the floowing code was working fine on my box and is still working on all other boxes: Dim key As String Dim sh As...

what reference do i need to check to make this work? Dim WSH As New WSHNetwork

I need help figuring out how to draw an x and y axis graph, on graph paper in Excell. Please.

How can I get a simple x-y plot? The wizard insists on grouping and summing the data, which is not what I need. A search of this forum didn't shed any light on...

my current office works with Excel (in more of a database fashion than a spreadsheet); and I have written a fair amount of code for our specific needs; I will...

I created an XML file, but it was created in utf-8 format, and I need to create it in ansi format. How can I create it in Ansi format? Thanks for your help

anyone have any good ideas about how to import XML files inot access tables using 2000 or 2002. it seems these versions ignore the DDT and make every column a...