Search results for query: *

Not really, but a friend came up with a way of doing this in Notes. I haven't had much chance to have a look at the code, but it seems to work. Let me know if you are interested and I will dig it out and post it.

The document must have got corrupted with all the messing about i did. I've re-created it and it works like a charm! Thanks for all your help.

Sorry to pester you again. Everytime i change Saveformsdata to false and run the code i get an error message saying i'm out of disk space. I can't be out of space because when i change it to true it works fine. Any ideas? If you don't thats fine, at least i can save the raw data. Thanks again...

It works! Thanks very much! Just one more question. Can I save the layout of the document instead of just the data in the fields? This is so i can view and print the form again.

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...

Cheers! I'm off down the pub now.

Thanks for your speedy response! I've tried that out and when i click my button a box comes up saying 'Enter Parameter Value' Underneath it says 'black' If i enter black in the box, the report comes up exactly as i want it. But is there a way to get it to enter black in the box for me. Or...

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...

Wow! that was a fast response. Thanks, that works fine.

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...

Thanks, it works beautifully! [lipstick2]

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...

Thanks Yes that has counted the number of times that the ComputerID appears, but i want to be able to view the Description for each occurance. When i try to bring the Description field into that query, it only returns the Descriptions which match exactly. How can i view the ComputerID and...

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?

Thanks everyone, i've realised why i can't join those 2 queries: 1 (NoOfItems)has several records per person per day. 2 (NoOfHours)has one record per month per person on the 1st of every month. Can i get Access to sum all the records for 1 month in the one query so i can relate it to the one...

Yes, i get this message 'You have chosen fields from record sources which the wizard can't connect. You may have chosen fields from a table and from a query based on that . If so, try chosing fields from only the table or only the query.' I think it's because some of the tables are linked via...

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...

Hi PaulF I'm sorry that doesn't seem to work, i get this message Compile error: User-defined type not defined is it something i've done??