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;
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?
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...
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...
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?
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.