Some general information about forms in Access may be helpful as you continue your development. There are times where it is necessary or useful to use an unbound form...

If you are looking to export records or reports to Word, the simplest way is to use the Export function to RTF. There are several limitations in doing that...

bdog2607 (11/21/2012)

---

thank you . if you can direct me to an access forum that would be great. I do SQL developemnt as well and just got stuck with this one....

This forum may not be the best for pure Access applications. Most people who post here are working with SQL Server back-ends so they aren't that conversant with strictly...

Are you linking to a SQL Server backend, or are the tables stored in Access as well?

Also, what if anything, changed from September 1 to October 1, other than the...

In order to make suggestions as to what might be going on, it would be helpful to know what version of Access you are using, and what the format of...

It's not clear to me why sorting the data would prevent you from adding a new record, but I seldom work with .ADP Access applications. Perhaps one of the...

That helps consisderably. It appears that you really want to sort the display by the Description column then. (It also appears that either Access or SQL Server thinks...

That wasn't my question. What is the file extension of the Access database that contains your data entry form - .ADP...

We need some additional information if this query is being used as the data source for a data entry form. First of all, is your database a .adp file...

Adding an "ORDER BY HID" clause to your SQL statement should correct the sort order.

sdhanpaul (10/28/2012)

---

Okay,

after thinking long and hard as to how I will go about doing this, I decided that I will use ADP file to creat stuff, stored procedures especially ...

I'm in way over my head on this, as I've never done any .NET programming or worked extensively with xml, but in theory I don't see any reason why it...

I don't see why you couldn't use a pass-through query to invoke the SQL Server function - although there are several limitations with pass-through queries. But Access has had...

I should say! Extended condolences are definitely in order. :crying:

There's a common misperception that Access is an insecure system that is also unreliable. As long as you...