Search results for query: *

Brilliant, works perfectly. Thanks for you help

That sounds fine, doing it through the form Can you walk me though this code a little bit? No experience with it. What exactly needs to be changed to match the fields in my database? Thanks Dim rs As New Recordset Set rs = CurrentProject.Connection.Execute _ ("Select...

I have a table that holds course dates and times. There is an ID coulmn in that table which was originally an autonumber. The ID is the primary key for the table. When I was upgrading a part of the database, I had to remove the automnumber designation from the ID column and changed it to...

I would like to use a query to validate data and supply any non valid entries on a report. What I need suggestions on is how to compare data from a column in one table to data in the other table. For example I have a table with customers, each customer has a unique ID (1,2,3). The query list...

What is wrong with the following Order BY clause??? SELECT Attendance.attendance AS Expr1, Count(Attendance.attendance) AS CountOfAttendance FROM Attendance GROUP BY Attendance.attendance ORDER BY Attendance.ID;

and an ORDER BY clause looks like....?

ok I need to add a twist to this, this data needs to be sorted by another data element in that table. Do I write GROUP BY Attendance.ID; rather than GROUP BY Attendance.Attendance; ???????????

ok here is what I got from your post. Both the table and the cloumn are called attendance, which probably isnt the smartst thing in the world. Where does this code go, I'm not sure what to do with this? SELECT Tableattendance.attendance, Count(attendance.attendance) AS CountOfattendance

How can I count the number of unchecked or checked yes/no entries from a table in a query? when I use the "count" feature it shows no data in the query?

it is on a file server being networked yes. How can you minimize the risk of this happening.

What causes a database file to become corrupt. I have encoutered this problem a few times in the last week. I realize that access can try and fix the file. But it seems to be happening too often to just have bad luck. It seems like its being caused by something. Any thoughts?

ok, I have succesfully made the shorcut work with the help of all your tips. But I still have a problem, with a direct link to the database on file server it will let you in without a user name or password. How do I secure the database so that if a person does not use the link i created it will...

no that dosnt seem to work either. what does the /wrkgrp do am i suppose to replace the "wrkgrp" with something spcecific to my database?

Below is line command line options. The system tells me that the text contains "options" that access can't work with. See any problems? C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE C:\209.243.34.9\Registration\db1.mdb C:\209.243.34.9\Registration\System4.mdw

how can i create a link that includes these three componets? """"""""""" "C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\XXXXX.mdb /wrkgrp C:\YYY.MDW Where Green is the location of Access, Red is the location of your...

how does the wizard not secure the database?

this seems kind of ridiculous. you can only apply password security to people who you want to use the database, but anyone else with access to the server has free run of the program?

while that is an interesting thread. I am looking to use access's built in secuirty group levels. Please post any other suggestions.

I have setup user and group accounts on my database and while working locally on my machine the securirty works. But the database is sitting on a file server and when I load the database and the "workgroup information" file it only prompts myself for passwords and usernames and no one...

I would like to setup user groups in my database. I am not familar with the access securiy features. I would like to have three groups, one with full read/write access, one with read, edit and write access and an administration group. Can someone walk me trhough this process? Thanks