i have a table with two fields.
i want to draw a graph with one field values as x- axis and other
field as values
i.e

I have a created a form that will be used to update existing records as well
as create new records using all the fields from an existing record except for
one field. I created an 'Add' command button that opens another form that I
want to populate with most of the data from the ...

I am trying to find the maximum date using two criteria and I keep getting a
type mismatch. Here is the code...
x = DMax("DateChange", "tblState", "[State] = '" & strState & "'" And
"[DateChange] <= #" & Format(StartDate, "mm\/dd\/yyyy") & "#")

Good morning-
I am updating a small database that I wrote and before I change code I would
like to get the opinion of the experts.  
The database is being utilizied in a Front End and Back End and has an open

I have a table, tblMediaTypes, with three fields, strMediaType, curPrice, and
lngCount.  There are four records…CD, DVD, Hub Printable CD, and  Mini CD.  I
want to create a form where I can choose the record(s) I want and have a
blank field where I can enter a number that will ...

I have connected a Access database to a sql server database. Thus the tables
are linked and show as dbo_table1, dbo_table2 etc. I need to rename the
linked tables in Access so that the dbo_ part is deleted. Thus the lined
tables will be table1, table2 etc. This needs to be done ...

I have been using the "SendObject" command to email reports and it works
great as long as the user has MS Outlook as their mail program.  Users that
have AOL (and I can't convince them it adds no value) get errors.  
Can the SendObject be configured to other mail programs than MS ...

If anyone can help me out i would appreciate it. the program states to
declare a user-defined type call HomeData with elemements StreetAddress,
City, State, SquareFootage, LotSize, and SalesPrice in a standard module.I
don't know how to find the Add Procedure dialog box in the ...

Is there any way to determine if a file is still open that was open using the
Open XXX as #1  ?

I've got another project that I don't totally understand. The book I've
been using is pretty good (Access VBA for Absolute Beginners), but this
chapter is a little disjointed.
Here is the problem:

Is there a VBA command or commands that perform the same function as the
COBOL Inspect.  It would be usefull for separating first name from last name
when there is a space between them.  Thanks for your help!!

Ok, I have some code that is going off no matter what number is being
inputted and i have no idea why.
AU is a double defined earlier in the code.
The part that is going off every time is:

I have opened a Word doc, filled in the data from Access, and merged to new
document. I now want to close the original doc. I got the following from the
MSDN site:
  Documents("Document1").Close SaveChanges:=wdDoNotSaveChanges

Thanks in advance for your help.
I have an ACCESS application that sets on a WINDOWS NT SERVER.  Part of the
application will generate a report that will show user accounts that are set
to expire in the next 2 weeks.  Does anyone have VBA code that will read the

I've converted mdb from access 97 to access 2003.
There were an error in the docmd.TransfareText: two many parameters
When i check the amount of parameters i found out that there is one more
parameter that was in assess 97 and not exist on access 2003.