Desktop Shortcuts
Jul 11, 2006
I hope this is the right forum for such a question, if not I apologize in advance.
I have an application that is being used by six people. When the newest version of it was built, I altered the desktop shortcut on everyone's PC to point to the newest version. Four of these shortcuts still work, but two are behaving somewhat erratically.
In the case of these two, clicking on the shortcut sometimes opens the older version of the application. I have recreated the shortcuts and they work for a while, before reverting to the older link. Going to the application via Explorer works fine.
While I am getting more comfortable with VBA, this area is outside anything I know. Could someone advise me on what affects whether shortcuts work or not? Do they automatically 'refresh'? If so, when?
In case it's relevant, everyone here is using the same versions of both XP and Access and everyone has access to the same drives.
View Replies
ADVERTISEMENT
Jun 30, 2005
I am trying to build a simple form to add data to a table.
One of the fields on the table is for Shortcuts to other documents held on the server / computer, but I can't seem to be able to either paste or add a shortcut to the relevant field in the Form.
Am I trying to do something which can't be done or am I missing something ?
Many Thanks
View 4 Replies
View Related
Sep 30, 2005
Hi there,
I am using access a lot these days, and try to use keyboard shortcuts where possible (leave that mouse alone....), so does anyone know a way to get to the FILTER menu when viewing a form using the keyboard...i.e without having to right click on the field and then click in the FILTER FOR box.
In more detail, the form looks like a table, and I may want to filter on one field, then sub-filter on another etc.....
Then also a shortcut to REMOVE the filters would be good too.....
If I have to create buttons on the form with code behind that ok.
Thanks
View 4 Replies
View Related
Aug 18, 2004
I'm beginning to think it is a windows issue and not access issue. I have a couple of users that weren't able to click on the form shortcuts on thier desktop. They had been able to use them earlier in the day, but later double clicking them would not bring up Access. I had them use Window's explorer and try to click on the MDB file to bring up access, but that also didn't work. But launching Access directly, then open existing files, would open up the database for them.
Rebooting let them use the shortcuts.
Any idea what might cause this? They have been using the application for a couple of months without mishap until today.
Has anyone seen this behaviour before. If so, how did you fix it?
David
View 1 Replies
View Related
Aug 21, 2007
Ok this is a weird issue that has been troubling me, On some computers that I have, Access refuses to open databases through a shortcut. The only way to open any databases is to first open access the go to file open.
I've tried creating new shortcuts, as well as mapping a drive and making a shortcut from there...but nothing is working. Is there a setting that access has to preven this? The same database can be opened on different computer without a hitch....
View 1 Replies
View Related
Oct 31, 2013
Is there a way to prevent users from making a shortcut to a database? I have my database split and I want users to copy the front end and paste it on their desktop. However, there is a high turnover rate among the people who will be using this database. As a result, I'm concerned that the instructions to copy and paste the database may not be passed along. I would like to avoid the possibility of someone making a shortcut to this database.
I would also like to prevent users from relocating the database by inadvertently dragging and dropping it in a new folder.The only person who should be able to move the database or work directly in the master copy of the front end is the person designated at the "admin" in my Users table (that would be myself and one other person). Is any of this possible?
View 1 Replies
View Related
Apr 12, 2005
:rolleyes: I know there is a way of placing a form on a desktop to an icon which only allows the user access to the form only! Help pleeease
View 1 Replies
View Related
Dec 6, 2005
Hello,I need to know is there any way to protect a shortcut on desktop ?Bcz someone is deleting (I dont know by mistake or intentionally) shortcut of database shortcut. I thinking about its protection from deletion only unless you have to supply a password or code something like that.Any idea..?With kind regards,Ashfaque
View 1 Replies
View Related
Jan 21, 2007
Hi all,
Today some of my users (primarily Access 9 users from what I can tell) have started experiencing weird Crash to Desktop issues.
The issue occurs when the user clicks a command button, which in turn should open an unbound form.
All other database functionality is working correctly.
The form is unbound, contains a combo, command button, listbox based on a query and several textboxes.
On open code is -
Private Sub Form_Load()
Me.cboType.Value = "Mail"
Me.lstResults.RowSource = "SELECT qryViewMail.ID, qryViewMail.Date_Received, qryViewMail.Customer_Name, qryViewMail.MDL_MVL, qryViewMail.Category, qryViewMail.Type FROM qryViewMail ORDER BY [ID];"
Me.lblStatus.Visible = False
End Sub
This functionality has worked correctly up until now.
Has anyone experienced similar issues before?
Thanks,
Rob
View 4 Replies
View Related
Mar 28, 2013
My server provider is telling me that my server is Linux and I would have to upgrade to windows to be able to connect my database to the SQL.so i figured, if there was a middle man who could collect the information and pass it along?Is there an add on of sorts to allow access to behave this way?
View 8 Replies
View Related
Aug 4, 2015
In my frontend code, I include a table with a version #. In my backend, I also include a version table. The front end will compare wih back end, and if it's different, it will force to get the updated version that it's stored in the LAN.
However, I do not want the user to open the file directly from the LAN because it might cause slow performance problem if multi-user,etc.
So I want to implement a code to force the application to be open only from desktop.
So far, I have a strUsername which detect the user network environ. Then, it will check the application path to determine if it was opened from:
C:Users<strUsername>Desktop
If not, then an error message will prompt to alert the member to copy the file in the LAN and save on their desktop.
It works on my laptop, all fine. Today I didnthe test in my user desktop, but the message saying that the file has to be opened from desktop keep appearing.
I double check the user folder and the Username environ is (cd98) but the user folder was setup as "CD98" capital letter. Does that affect the coding?
How can I make my code to not distinguish between lower or upper case either for username and folder user as well?
View 4 Replies
View Related
Feb 7, 2014
I used to have a code that we used to copy data from a folder that was on the desktop using the code below.
Code:
DoCmd.CopyObject "C:Documents and SettingsAll UsersDesktopWetcleans
This does not work with windows7. I have tried the C:USERSPUBLICDESSKTOPWetcleans but that does not seem to work either. How to access a folder on the desktop ?
View 2 Replies
View Related
Nov 15, 2011
I'd like to have a custom icon for the accdb file for the users. I recall doing it for pre-2007 databases, but I can't figure out how to change the 2007 db. Is it possible with 2007?
View 7 Replies
View Related
Nov 12, 2013
I have a very simple database using the MS template 'desktop time and billing' for MS Access 2007.
[URL] .....
Any new template with the option for VAT or Sales Tax for each Billable Hour and each Billable Expense?
If this is selected or overwritten at time /expense input stage and then automatically added to the invoice.
Not sure why MS omitted Sales Tax from their design?!
Can Access Master add Sales Tax /VAT and then post as a new template?
View 3 Replies
View Related
Dec 17, 2007
I built a database application, and I need for more than just myself to use it at the same time. I have just learned that I should have built a project instead. Can I change my application "Maintenance.mdb" to a project or do I have to start over?
View 5 Replies
View Related
Feb 24, 2014
I want to zip my file of my Desktop with MS Access 2007.
View 5 Replies
View Related
Jan 26, 2014
I am using the Desktop services template as a starting point for an invoicing app. I would like to be able to add a product and/or service after the invoice is submitted so I can add a finance charge for invoices that haven't been paid yet. The template is setup to prevent items from being added once it is submitted. Looking for macro / rule that is preventing this action?
View 9 Replies
View Related
Mar 7, 2015
I was trying from a button on my form that will go to and bring up the desktop. I want it so I can put this database on anyone's computer and the button will work.
I am using this and it works but only on my computer.
Application.FollowHyperlink "C:UsersBryanDesktop"
I also tried this
Application.FollowHyperlink "C:Show Desktop.scf"
And
Application.FollowHyperlink "C:WINDOWSSystemShow Desktop.scf"
Both gives Runtime error 490 cannot open specified file.
View 14 Replies
View Related
Oct 21, 2013
How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.
The use of file is only in desktop.
View 3 Replies
View Related
Dec 5, 2014
I have converted desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA, and built an odbc connection for my front end. It works, except it is painfully slow. Its cos most of the recordsets that drive my front end are query based. And in many instances the queries are comprised of queries, not just tables.
Should i be creating my queries on the SQL server? Is that what people do when using Access front end with SQL server back end? Do away with Access queries? Or does the problem lie elsewhere? How do i network optimise my Access FE / SQL server BE?
View 10 Replies
View Related
Oct 31, 2014
I made nice little icons for my buttons, But when i transferred the app from laptop to server and run it on desktop comp icons get resized.
Guess it has to do with desktop resolution. How can i avoid this?
I tried with adding commands to playin pictures, but there are problems with focus, so that is not the best solution.
View 2 Replies
View Related
Apr 3, 2015
I have a split db that has been in use for a few years by about 12 people. The front end is compiled into an accde file.
Ocasionally a user (randomly) might get an error message "Microsoft has detected that this database is in an inconsistent state...." when closing the db and when that happens, a copy of the front end is automatically placed on their desktop.
This front end is always deleted and the original front end continues to work just fine afterwards.
Why are my users getting this error message? Why is the front end automatically copied onto their desktops?
View 6 Replies
View Related
Feb 5, 2014
I need codes to browse pictures from desktop or folder and insert into access DB.
I am using Access 2010.
I also want the code to only insert the name of the picture and then link its folder through the ID or some text,ok?
View 1 Replies
View Related
Jun 25, 2013
I am trying to use Microsoft's Desktop lending Library Template, I've altered it to suit me but there is one thing I can't seem to do.
On the (Asset List) their is a Action Column with Check Out in, when you click on it, it opens the Check out Form which is ok when you've only got one item to check out.
What I want to do is be able to Check out multiple items out to one contact in one foul swoop.
View 4 Replies
View Related
Aug 14, 2007
Here are some background . My company got a access file in a network drive.The data entry simply open the file in the network drive.But once the data has increased (~400mb) sudddendly,all process slow down. Like search , using report etc.Is there any method to imporive the situation?Some guys suggest me to copy the data file to the desktop and sync them.Can it it work?IF works,how to do that?
thanks gratefully for any ans
View 3 Replies
View Related
Mar 19, 2008
Hi there,
My problem seems somewhat simple, but I guess since I'm posting this it was quite the contrary. I've completed my form and have linked all queries and reports and created all my macros for the form. Everything looks great but I when I created a .MAF shortcut to access the form directly from my desktop, it opens the form really big and maximized. Every time I open it, I hit the 'restore down' box-in-box button on the top right and it makes it just how I want it. Can I retain this as a default setting when I open it? I've checked in the Form options but no luck.
Richard
View 4 Replies
View Related
