Search results

Wow, thanks for the magic. Works perfectly now!

I have a perplexing problem. I'm creating a simple db to enter borrower audit checklist data with the following tables: Questions -- A list of 17 pre-defined audit questions, with fields QNum and Question Audits -- One record for each audit (pk AuditKey is an Autonumber), and some borrower...

Runs very fast too!

I combined some code I found on a couple of different forums, and it works! Here it is: Dim cn As adodb.Connection Dim cmd As adodb.Command Set cn = New adodb.Connection cn.Provider = "Microsoft.ACE.OLEDB.12.0" cn.ConnectionString = "data source=c:\dbname.accdb" cn.Mode...

I do semi-frequent maintenance on db#1, and I can easily tell who's in there and boot them out when needed, because only certain users get in it, but it's a whole different set of users that get in db#2, and I wouldn't be able to tell who it was. Thanks for the suggestions. I'll consider it...

Not really liking that option. Was hoping for something a little cleaner and quicker, and without possible security issues. I'm building security procs into that database, and I'm trying to send it updated user IDs whenever we have employee changes.

Sorry, I need to do this in VBA each time before I run the append query.

I have an append query that adds data to a table in another database, but I want it to replace the data every time it's run. How do I clear the data before running the append query? The databases are not linked, and I don't want them linked.

I have a security-enabled .mdb file. It services multiple branch offices, and each branch is set up as a "user". The branch managers are set up with a desktop shortcut with /user and /pwd switches. The user is simply the branch number, so when they open the db, code and filters are used so...

Here's the code I ended up adding, if anyone's interested. If MsgTo = "jsmith" Then AttachName = PathName & "TaskList.pdf" DoCmd.OutputTo acOutputReport, "TaskDetailList", acFormatPDF, AttachName...

Thanks for your reply. The wording in msdn.microsoft.com for the Attachments.Add Source parameter is: That gave me the impression that there might be a way to attach internal objects. Apparently that's not the case?

I have a subroutine that works well for sending emails. A need has arisen to, in some cases, send an Access report as a PDF attachment. I know how to do this using the SendObject method, but that won't work in this app. I also don't want to have to first save the report as a pdf file. I...

Kept digging and found the problem. Updated the WHERE clause to the following: "WHERE [qryEAccess-AllInfo].EANum=" & [Forms]![EAccess].[EANum] & " AND ReqTypeSystems.ReqTypeCode=""" & PhFx & """;"

When I run the following code, I get the "Too few parameters. Expected 1." message when it hits the Set rsQry line. However, if I go to the Immediate pane, extract the TxtVal value, and paste it into the SQL window of a query, it runs just fine. Why would I get this message from VBA when it's...

Cronk, if you're referring to split database, no, it's not split. Marty, if it would help you, exchange the word User for Manager. All managers are employees, but all employees are not managers. Additional info is stored in the managers table that isn't needed for everyone else. However, a...

Thanks for replies. Martyh -- for db efficiency. The data stored in Users table is only needed for users. Cronk, but please reread my 1st paragraph. I need to know how it can delete records in the other table when Cascade Delete is not selected, and in fact, the relationship itself has been...

My db includes two tables, Employees and Users, both with a pk of EmpNum (Autonumber in Employees; Number in Users). Users is a subset of Employees, and in the Users table, the row source for EmpNum is a query of the Employees table. I had a relationship defined with a one-to-one between the...

I know how to administer users. I just couldn't find it. Thanks!

Still needing assistance with this, please.

I have a .mdb file I administer in Access 2010, and it utilizes user-level security. I read the link at http://office.microsoft.com/en-us/access-help/what-happened-to-user-level-security-HA010342116.aspx, but on my ribbon in the Database Tools - Administer group, it only has Replication Options...