Search results

For those of you using CDO for email automation, which do you prefer? I have am app with a large # of users with email. Would you: Require each user to provide their userid and password for authentication OR Have a company wide generic email for this purpose. The latter would be much easier...

MySys tables are system tables that can be made visible by going to: Tools --> Options --> View Tab. Make sure the "System Objects" is checked. You can also try to compact & repair the existing database using vba. Do a search in the forums. There's also a jet compact utility you can try. I've...

Split the database and give each user his/her own front end. Split the database and give each user his/her own front end. Split the database and give each user his/her own front end. I vote for option 2. :D Seriously though, you are heading for a corruption nightmare if you don't.

Yes I have it. I was looking to retrieve the info because I am using it in an "About" form. Doing it this way I can use the form for other apps and just fill out the properties.

Got it.... It's "UserDefined" So to get items from the "Custom Tab" change cntCurr.Documents!SummaryInfo to cntCurr.Documents!UserDefined

Well I found this and am able to get the data on the summary tab: Function GetSummaryInfo(strPropName As String) As String On Error GoTo Err_GetSummaryInfo Dim dbCurr As DAO.Database Dim cntCurr As DAO.Container Dim docCurr As DAO.Document Dim prpCurr As DAO.Property ' Property not...

Is there a way to read the database property fields from "FILE" --> "DATABASE PROPERTIES" (see attached image). I know how to call and change the startup properties, but haven't found out how to do this one yet. Thanks, Craig

Thank you. I was using: Forms![MyMainForm]![MySubForm].Form![RecordID] And it was not working correctly. (Told you I was having a brain fade) :D Thanks again.

Ok... so I am having a brain fade today. I have a form that has a few command buttons and a sub form. The main form is not tied to any record source. My sub form has a record source and I have it set up to be in datasheet view. What I am trying to accomplish is: When I select a record in...

If you have customized the menu bars: in the customize dialog box, highlight the menu bar/toolbar and click the reset button. If you have just disabled full menus etc in the startup, just enable them

Each user that has access to the app does indeed have their own profile. My levels are: No DB access (for obsolete users - I want to retain any data from previous employees, etc.) Read Only Access Read/Add - Users can add records only and read them. Read/Add/Edit - A select few (process...

That does make sense. I have a friend in another company (who is an ISO coordinator) basically said the same thing. The argument from others in my company for keeping the audit records hidden was basically for disciplinary measures. Though I really haven't been able to get across the point I can...

LOL of course the db doesn't become iso compliant. It's a tool to help the company become compliant. :) I'll have to read up on the data protection act, but but if I am tracking record changes, I have a hunch that complies. I am leaning toward letting admins only view the changes, then they...

....that is the question. :) This question is really for those of you familiar with the ISO 9001 Quality Systems. I am creating an ISO compliant database to track items such as: Documentation Control (SOPs, Instructions, Forms, etc) Corrective Actions Non-Conformances Employee Training...

Thanks for the concurrence. :D Not so sure my knowledge is superior :p but yes, put it in the save button click procedure. You may be surprised at the result.

I really don't understand the need for the error. So I usually handle it in this method: Error_Handler_Exit: Exit Sub Error_Handler: Select Case Err.Number Case 2501 Err.Clear Resume Error_Handler_Exit Case Else MsgBox "Error No. " &...

To get rid of the message disable the warnings: DoCmd.SetWarnings False DoCmd.RunSQL strSQL1 DoCmd.SetWarnings True

You have to trap it at the source. Meaning trap error 2501 in the save button's "click" procedure.

You are welcome.

In my former job, we had a Mitutoyo dial indicator with a device on it that put the measurement value wherever the cursor was. It worked in Excel, Access, Word, etc. so it was a snap. I'm not sure if this is what you are referring to though. It may or may not be the same.