Search results

I don't recall, but it is possible that I may have originally thought this would be the way to do this when I first started this project over a year ago. How would I import into a new blank database? Build a new database file, then just import everything one by one, or is there a way to do it...

I cannot find a way to get rid of this prompt. Of all my databases, this is the only one that has this prompt. I want to get rid of this before distributing the FrontEnd. Thank you,

Thanks again! I have another question though... Is there a way to add this to the module so that I don't have to add it to the open event of every form?

OK, this worked! Private Sub Form_Open(Cancel As Integer) If Globals.UserAccess(Me.Name) = False Then MsgBox "You do not have the required permissions to access this tab." DoCmd.CancelEvent Cancel = True End If End Sub Thanks!

I'll dig around that and see if I can figure that out, but if it is the issue of the Navigation form and a naming issue, wouldn't I still encounter the same problem?

I have created some user access IDs and I have a login form that transfers the user's access ID into a TempVars. Here's my issue. I'm using a Navigation form, and I have an Admin tab that only I will have access to. I know the "If" part of my On Load event is working because when I log in as...

Thank you for the help. It was a bit confusing in the nomenclature because I didn't know we're referring to the Target form as a subform, and I also did not understand what you meant by "container" until I started clicking around within the navigation form to see that there is a box around the...

OK I got it with this: [Forms]![frmContrax].[nsfContainer].[Form]![ID]

The form isn't actually a subform (unless you mean that any form within a navigation form is a subform).

OK, this is also not working for me. I have a criteria in the line of my query as follows: [Forms]![frmContracts]![ID] This works great when frmContracts is opened on its own, but when it is within the navigation form, I get prompted for the parameters. So I tried the recommendation above...

Hi, I am aware this is an old thread, but in the interest of not starting a new one when not necessary, I have a question about this. I have successfully used the suggestion in this thread to append the date: & "_" & Format(Date(),"yyyy_mm_dd") & ".xlsx" How can I specify a default path. It...

It is a macro. Here it is. And yes the fe is now installed on my c: drive while the be is on the shared drive.

OK so I am using the front end installed on my desktop with the backend on our shared drive. It is working fairly smoothly when on the actual network rather than via VPN. I have run into an issue; however... My "Save as Outlook Contact" button is now giving the error "The command or action isn't...

I realize there is a lot more that can be done with VBA. The problem is, I don't really know VBA. I just piece together a little here and a little there. I've converted many macros and sometimes they don't convert well. I'm 100% self-taught on Access. So I try to make it work the best I can with...

I do have an autoexec that closes everything up. The strange thing; however, was when I had a co-worker test the distribution, she showed the ribbon unhidden. I think the network requirement asking to trust the document interfered with the macros (hide toolbar, load form modal,etc).

Thank you. Yes. I can see in the early days (beta testing) having many updates to the front end, which is why I wanted to do it this way. But that makes sense. Let me ask...if there are multiple copies of the front end, then I could potentially edit some versions of it that leave out some...

I placed the be on our shared drive at work, and it is crazy slow. The front end resides there as well with a shortcut that users can copy onto their desktop. Any suggestions on how to make this not so slow?

Can the backend of a desktop access database be stored on a webserver?

That did it! Many thanks! :)

I have discovered that the "*" does not seem to work as a wildcard in my code. I want the graphic to show up for records whose Company begins with "EMD". What is the correct way to express wildcards in vb coding? Thank you, Private Sub Form_Current() If (txtCompany = "EMD*") Then...