I am starting a data base from scratch for a library of thousands of video tapes. The company I work for is broken up into many different departments and...

I have created a customer toolbar in Access. I have a number of other people who use the same database model. When I teach them how to use it, the...

I've have the following clause to apply as a form Filter in VBA: strFilter = " IN (SELECT From qryCompaniesCategories WHERE IN ( " & strCategories &...

Firstly, please excuse the multipost. I have been unable to get solutions in comp.databases.ms-access. Can anyone help me get this update query right? The...

good day all, I have been developing my db for a while now and have misc tbls, qry's etc and was wondering if there was a way to find out what is being used /...

Hi all, quick question. I have an access chart, derived from a query. My X axis is grouped by this field in my query: format(,"Mmm") The axis is grouped by...

I maintain an Access database which includes e-mail addresses. I also maintain a Web page where I create various e-mail distribution lists using the HTML...

the computer shut down wednessday 8th 2005 when i turn on the computer and i left it on the computer shut down it self when i whant to turn it on there is no...

I have a SQL Server database with images (binary). The images were imported using .Net (Image saved to a MemoryStream and read into a byte-array that was then...

Example: "abcd,e" needs to be "abcd, e"

I have a database that many people will be using, I don't need to protect the database as a whole with a password. But I want to prevent users from editing...

Hi: I have an access database, when selecting Filter by Selection on a field in a table, the DB shuts down and closes. Is this a bug? Anyway to fix this?

I found this article: http://www.aspfaq.com/show.asp?id=2509. It has been a while since I have used SQL, and it was Oracle at the time - many years ago. How...

and just for the record; Aaron If you could respond in a decent fashion without flipping your lid you'd get better responses. Tony -- Tony Toews, Microsoft...

Hi all - I have an Access (2002) database that has aroud 1800 duplicates, found by a query. Many are triplcates and were created on a certain date...

Please help me with the syntax for this stLinkCriteria. I have a main form with two subforms. Subform1 is in datasheet view and shows a few columns from the...

Hi All, Thanks in advance! I have a set of customer code in Office 97 which sorted as below: CustomerCode =========== SG-A SG-B

I have a bunch of medications that need to be listed on a form and be selected. I was wondering what is the best control to use for this and how will it save...

Is it possible to assign values to variables, in code (such as the On Open event) using a standard SELECT statement? I'm aware that RunSQL only works for...

Hi All, Thanks in advance. I group customer with a prefix "SAG-XXX" and "SAG-XXX". In Office 97, the sorting order is what I want: CustomerCode ==========