Generally speaking, Forms are used to manipulate/view data, reports are used to view data. If you'll notice, there are no AfterInsert, BeforeUpdate etc etc...
I havn't heard of Alpha in years. They made some database software in the early 90's but never really caught on. I had some old Alpha discs somewhere........
Thank you all for your help. It ended up working out with the update query. Thank you Leeba ... From: ade_suryaatmadja [mailto:ade_suryaatmadja@...] ...
How can I grab the environmental variable %username% in Windows through MSAccess in VBA code? I want to know which user logged on to WINNT network. Knowing...
The best way is to use the API call as shown at http://www.mvps.org/access/api/api0008.htm rather than use the Environ function, which can be misled. Jon ...
Yes, you have to concatenate them. This is done by specifying the control source (under the data tab in the properties sheet) as =city & " " & state & " " &...
Hi everybody, I would like to know why Access 2000 does not show a field in the query result after you use statistics and a criterion for that field. I know...
I'm not sure I have understood your problem, but it seems that you want to have in the result of the query both the names of your Clients in Seattle and the...
Clauss Gilbert
gilbert.clauss@...
Apr 2, 2003 9:28 am
9624
I have a data entry form that opens up audit records. One of the fields is the audit data. I want to have a subform that will automatically display all of the...
I'm sorry, I meant to say "Audit DATE" for the field name, not audit data. ... From: Sandra Maroney [mailto:smaroney@...] Sent: Wednesday, April 02,...
I'm still new to access, sorry. trying to develop a more usable database for an agency that has been
inputting directly into one table. So have split the...
This was copied from MSDN. Copy and paste the link below into your browser's address bar. ' ' More than an incremental improvement AutoNumber fields provide a...
select x, y, count(*) from table group by x, y having count(*) > 3 will give you the ones that have at least 3 In query designer look at the totals option,...
... FAO Simon Larson reply, Why have you given me the code that will list all x whose y is greater than 3 when I want to list only the x whose y occurs most...
Clauss: Thank you for your answer. Unfortunately, no that was not the answer to my question. So hopefully, I will explain it right this time. Basically, all I...
is it possible to have users access a database without having security rights to the actual database. that is, the user must not be able to see the actual .mdb...
The "Where clause" in any type of query is merely a delimiting device ... you're basically telling the database to show you all records which satisfy this...
Hello would any body help me please I have created a report, it reads from a crosstab query and then display the result through DAO code. My problem is when I...
I've designed a simple form to track the training courses that employees have taken. The way it works is that the employee's employee number, first name and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
