Recent content by BecoNorte

Thank You! I'll try that.

That could'nt be it ... I have other applications with the same amount or more linked tables ... the problem is with the Citrix environment. ACCDE works for everyone except in Citrix.

Ok, but it's only slow in the Citrix environment. The tables are on a SQL server. Is there a limit to the number of linked tables? I have 48 and 29 out of 48 are views on the SQL server.

Hi 1. Was this database ever converted to an ACCDB file from an MDB file? No, I built it using Access 2010 2. If so, how was it done? 3. Have you tried using it as an ACCDB file instead of ACCDE just to see if there is a difference? I just ran into a problem with running an ACCDR on Citrix...

Hello Users trying to open my MS Access application(accde file) on a file server via Citrix (Windows server 2003/Office 2010) are receiving this message: The database cannot be openned because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is...

Use the shell() function Private sub open_Another_DB_Click() Call Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE c:\MyFile.mdb", 1) end sub The first path is for the MSAccess.exe file and the second for the other DB

Boblarson you bit me to it! Nice process! Thanks for sharing. I use a self-extract zip file (or .exe file) combined with a batch file that will copy the mde file to the user's computer and place a short cut on the desktop. I also use the version number to activate the .exe file.When the user...

I don't think so, but you could add the criteria Like [Enter Name first initial] & "*" under the name field. The report will only give you names that starts with the letter provided.

You should create a mde file and give a copy to each user

Hello Try this: Under Private Sub RegisterFOButton_Click() ' Print report - remove the filter here DoCmd.OpenReport "Process_Sheet_Report_Generic", acViewNormal ' End Print report Add filter or criteria back here on your Process_Sheet_Query under Primary Key field add criteria...

Using a form you can add your GetUserName function when saving the record: txt_UserName = GetUserName() DoCmd.RunCommand acCmdSaveRecord Marco

Hello - I'm getting this error (invalid procedure call or argument - DLL error 0, number 5) on my accde file but not on the accdb. Any ideas on how to find what's causing it?

It does. It's on the toobox. Square icon looking like a form, usually next to the Tab Control icon. If you don't see it try the "More Controls" button.

If you have the form linked to the table you don't need code to to the update. To use the code you have to break the link and use code not only to update but also to load the desired record.