Search results for query: *

The code below displays the number of items that a user has open in the database on the front screen when they login. I pick up their username on form open, and use it in a query to find the number of their items. The following code is a subroutine that is called to write to a couple of text...

I have the following code. Which will email out when a record is overdue. It works at the moment if the record is 3 days overdue...hence the If statement: If (![Days Overdue] = 3) Then Ideally the condition should be a range of 1-14. I've tried but I cant get the syntax right?! Any help...

Dear All, I have a couple of text boxes on a form formatted so that a typed forename is in the format "Joe" and the surname is in the format "BLOGGS". Most users tab across the fields which start the blinking cursor at the first character of the input mask. But some users keep using their...

Hi all, I have this code which will eventually email all the users of my database each month, I am in the process of writing it. I would like to put a loop around the section of code below to collect all the entries from a table that I have called "Reported by List". This table contains all...

All, I have a combo box with name values in. It predicts a name as the user types if they appear in the list. The form then looks up other information stored about that person and populates other fields on the form. The list is sourced from a table called 'tblPersonnelList', there is a new...

Hello all, I have a form which user's can open as a read-only form or as an update form depending which button they use to access the form. The read-only version: DoCmd.OpenForm stDocName, , , , acFormReadOnly The update version: DoCmd.OpenForm stDocName, , , stLinkCriteria I have a Print...

hello all, I would like to stop the users of my multi-user database using the wheel on their mouse to scroll through records on a form. Is this possible? Thanks. ~Phil4tektips~ Grant us peace in our days work!

I've got this code: If ([Reported by] = ".") Then [User Opened] = strUserName [Project] = DLookup("[Project]", "Reported by List", "[Clock Number] = 's02506'") End If The code above is correct for looking up a text string and works. Trouble is I need the criteria of the DLOOKUP to be...

My users are spread over a wide area within the company. I have set up a multiuser database which prints out reports on click of a command button. I have the report page setup settings set to default printer. Unfortuneately the default for almost all the users is a black and white printer...

This should be simple, and I bet it is! I've been trying for a while now to take the value from an ID field across with me to another form and input it into a text box. I only want this to happen on a particular button click, I have therefore used Openargs on in the code of the form. The code...

I have a button on a form1 to open another form2. I would like to have this button open the form2 AND start some VBA code that is assigned to a button on form2. When I just put in code to start the VBA routine, it was looking for the code on form1 when it is actually on form2. How can I get...

As I am relatively new to MS Access I didnt know how to solve this problem, but I came up with a solution. I just wanted to know if it is crazy and will cause problems in the future or if it is perfectly feasible. By the way it is working perfect for me atm. I have a main data table with many...

I have a database which is going to have multiple users. I have split it, with my BE on a shared drive. I then replicated the FE so that the other users can have those. I can then update their forms, queries and reports from the Design Master. I wanted to add another table as a development to...