Search results for query: *

Using Word I have created a template form (.dot) with 'text form fields' for users to enter text. One of these fields is called OrderNo. Word has automatically made them bookmarks. I have created a command button which i want users to click which will save this document in a specific folder. I...

I would like to preview a report when a user clicks a button in a form. But i only want it to display records where [Duck] matches what has been entered on the form. For example if [Duck] contained the text 'black' the report would only show black ducks. Could someone give me idiot proof...

I have a form that displays the Months, Days and Hours that have passed from a certain date. When the [Months] value is displaying i want to hide [Days] and [Hours]. And the same if [Days] or [Hours] is displaying, i would like to hide the other two. This works fine as long as i scroll...

I've created a find record button on a form using the wizard. When you click on it Match comes up automatically set to Whole Field. Is there a way of altering the code so the default is set to Any Part Of Field? Also can I setup an unbound text box for the users to enter criteria rather than...

When a user clicks on a button to print a report on my main menu i would like a dialogue box to come up and ask for a password. When they enter the password i would like ***** to appear so no one else can read it. I have been looking through the old posts and i understand you can't have an...

I have a query which records Computer Id Numbers. I want to find out which Computer Id Numbers occur most often in the database. E.g, I'm not interested in the Id Numbers that only occur once. How can i get the query to return only the records that the user name appears more than once?

I've created 2 reports from queries, 1 calculates the NoOfItems processed, per person, per month. 2 calculates the NoOfHours available to work, per person, per month. I want to divide the NoOfItems by the NoOfHours to find out the number of items processed per hour. I can't find a way to link...

I use Lotus Notes to send email, so using the SendObject command to send email from Access doesn't work. The only way I could think of to send email was to use mailto in the hyperlink address. This function lets you specify the subject of the email, but is there a way to enter text in the body...

How do i get Access to display "Record 2 of 10 records" on a form. At the moment I've got it to display the total number of records using this control source: =" (" & Count(*) & " " & IIf(Count(*)=1,"record"," records") & ")" (This may...

I've created a new column in a query which tells me the time difference in hours between the [date raised] field and now(). Is there a way to get a message to pop up when the value reaches 1 hour? AND if there is can i get it to pop up even if Access is not open at the time?

I downloaded a module which picks up the user id from the registery. The data is displayed in a form using the following control source, =" " & atCNames(1) What I would like to do is to save the user id of the person who created each new record. Is there a way of saving this data for...

My form has a field for 'date_completed' I'd like it to be updated to Now() when a button is pressed. Thanks