Search results

Very useful posts rodmc. The only problem I see with that issue is that that person's PC will have to be on 24/7. And if many users start connecting to it for data it might slow down his other processes. If that computer freezes for any reason, the rest of the team is handcuffed. It may be...

Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=231904&highlight=Letter+Grade

Access locks the text file to maintain exclusive rights to it since it will be adding/editing/deleting. You'll have to open the txt file in a read-only manner (if possible) to avoid locking it.

Could be because the Feedback button is covering it :D

You'll need a textbox, name it txtPassword. Then, on click of a button, or even on lost focus of the textbox, run the below code Dim PassWord As String strPassword = "12345" If me.txtPassword = strPassword Then DoCmd.OpenForm "Menuboard Admin" DoCmd.Close acForm, "Menuboard Main Start"...

You're going to have to do it using VBA CurrentDb.Properties("AllowShortcutMenus") = False

You need to look at the left() function http://www.techonthenet.com/access/functions/string/left.php

Yeah you can have one combo box that selects the site, and have both combo boxes' row source set as shown below. Assuming your form's name is myFormName and your site combo box is cmbSite SELECT * FROM tblAssociates WHERE site = forms!myFormName!cmbSite Then all you'd have to do would be to...

Come on I'm sure someone has an answer

Nothing at all?

Any help on this would be appreciated fellas.

One way around it would be using the sendkeys statement to send CTRL+C to the form. You have to make sure the text is highlighted SendKeys "^c"

Hello all, So here's my dilemma. I work at a regional office and would like to distribute an Access Front End to all our Distributors. I consulted with our IT Dept and they wouldn't allow me to host an SQL Server that would be exposed to the net for IT security reasons, same reason why they...

You don't need MS Access for this, easiest way would be to run a scheduled task using Windows.

You need the following tables: 1) Departments 2) Divisions 3) Employee Linked via one-many relationship. (One Department Many Divisions, One Division Many Employees) Then you will need a table, Jobs, with the following fileds: JobID => Autonumber (Primary Key) JobDescription => Text...

Honestly Jon, this is getting way out of hand. Can't even browse at work anymore:

vBulletin 4 also makes it easy for members to create their own blogs and publish articles

You're saying all this mess that Bush left behind him can be fixed in 4 years? No way. I work for a big corporation and fixing our ex-manager's mess took quite some time.

You need to use the minute function and check if its > 20.

I've never worked with Treeviews/Listviews but here's some help on them: http://www.databasejournal.com/features/msaccess/article.php/3734331/Access-TreeView-ListView-Basics.htm I'd avoid working with ActiveX controls overall to avoid reference issues at distribution. What you're trying to do...