Search results

I did try that earlier and it didn't work. I found the issue though. I had use access special keys turned off as well. I didn't think that this would have effected access from displaying errors, but it did. It's fixed now.

Hmm, am I really the only person that this has happened to!?

Sorry, no dice. Doesn't do anything.

Okay, I know I brought this upon myself, but I need to fix it and I don't know how. A couple weeks ago, I was playing around with the ability to disable the ctrl break command from working in access. Well, ever since I did it, my porgrams will no longer stop execution and tell me where an error...

Hi there, does anyone know if access is capable of making some more advanced reports -- ones that would not be tabular in the slightest. I designed a cabling database that holds all the cable records for the University I work for. It's basically done using two tables, an object table (which...

Naturally an overstatement. Regardless, I'm up for the challenge of having to learn to use ASP or any other application that will get what I need done.

Hello, I need some help:o. I am designing a database application that will store users telephone records and allow them to view only theirs. This information needs to be kept secure. I have implemented ADS login authorizations, made the system runtime, and blocked out any overriding abilities...

Okay so I was a little bit dumb when I was thinking about this problem. I forgot that Access will automatically close an accde file that a user chooses not to allow code from. So I made my file accde. But also, I figured how to get rid of the control break sequence. Except the funny thing is, I...

Hi, I have set up an autoexec macro as so: Not [CurrentProject].[IsTrusted] MsgBox "Please add this database to a trusted folder" ... CloseDatabase Now, I designed this code so that no one can avoid the security features I have on sensitive data, as when the...

-akt01 Essentially what you are doing in the vba script is building a virtual table (2d array), this is how I picture it anyways. The DAO.Recordset is an object and I named mine rsmyrs. The next line Set RsMYRS = CurrentDb.OpenRecordset(Query) populates the recordset I created (fills in the...

I'm sorry but the snapshots aren't an option. I can't be telling people to download a program just to view their invoice for work we did for them. And I tried the pdf method except I heard some issues that the files took to long to open and download because of their size.

Hey there, I've reached a quite annoying problem. I have code that runs through a list of closed requests and will open the invoice and send the invoice as an attachment to the email listed on it. All of this works well. The only problem is, there are no formats to send it in that work for me...

I figured it out. Thanks though. I kept searching on a bunch of other sites. If anyone is curious as to the answer, simply set the parameter of [EditMessage] to False in the docmd.sendobject method.

Hi there, I have managed to find a way to loop through a recordset as defined by the current reports record source and filter, and to read an invoice's email field and send that specific invoice to that email. The problem I have though is that the email client will open up (Eudora in this case)...

If either of you are interested, here is a piece of code that will disable the by pass key , holding down shift, on start up. It's unnecessarily long, but I didn't write it, I found it a couple days ago; you can definitely shorten it if you desire. I don't know why, but all the suggested methods...

I've set up my database to access my company's ADS to enforce login credentials, but its recently came to my attention that users who are running microsoft parallel on a Mac cannot get in the system. It seems that the LDAP query does not work. Has anyone came across this problem? Does anyone...

Sorry but this is my LAST Reply to this! Turns out the For loop is completetly unnecessary. Just the two dsiables: DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Menu Bar", acToolbarNo If you do use the commandbars.enabled = false command you will disable your property sheet bar...

...And Naturally of course, I have found the solution to my problem. If anyone cares, this will hide EVERYTHING on the top. This will truly Lock Down your data base: Private Sub LockDown() DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Menu Bar", acToolbarNo Dim i As Integer For i =...

Okay. I've looked through the forums and have found a bunch of stuff on automating the hiding of toolbars and menus on startup. One problem though...I cannot find a way to hide the Option to "Customize Quick Access Toolbar" (right click on the ribbon and it will come up). So long as this is...

I think I may have found something deep in the forums that can answer my question. If it doesn't work though, I will bump this. So for now, ignore please:)