Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paulminne

    Emailing specific records

    Hi, How is it possible for me to email a report, containing the details of the current record I am viewing on a form (selecting 1 record from a query). I have placed an email button, however when I use the button all the records are placed in the attachment. Thanks..
  2. paulminne

    Sql UPDATE table query

    Hi, I am having trouble with an UPDATE query which is very simple. I am trying to simply update a number field in a table with an integer stored in a variable. The syntax: DoCmd.RunSQL "UPDATE STOCKFORSALE SET [QTY]= intQTY WHERE [stockID]=" & Me.txtStockID.Value The Error: A box is...
  3. paulminne

    Selecting part of a comma separated field

    Hi, I have a combo box which is populated with a concatenated expression from two fields in a table (ie. expr 1: [Surname] & ", " & [FirstName]). What I am trying to do is just select the Surname contents of the combo box and store it in a variable, and the FirstName contents and store them...
  4. paulminne

    form open

    cool thanks...I actually had a look through the search stuff and couldnt find what I was looking for. I have used some of the suggested code which works fine, however I am getting an error on something else related. I am trying to determine which form is open, then depending, I am trying to...
  5. paulminne

    form open

    Hi, I was wondering if there is a way to check if a form is open, from the click event of a button on another form? And if so, was wondering what the syntax may be... Thanks
  6. paulminne

    option buttons on continuos forms

    Sorry I forgot to mention, both the option button and text box are unbound. Im not sure if this makes a difference, I would assume it does. Regards, - Paul
  7. paulminne

    option buttons on continuos forms

    Hi, I have a form which has a 'default view' of continuous. the form has a text box and an option button in the body (no header or footer). Currently if an option button is selected, all the option buttons are selected (and vice versa), which is what should happen. However, I want to make it so...
  8. paulminne

    Linked Tables

    Hi Darrylle, Thanks for the information. I think I should be right without putting any record locking in place, primarily because there are only two main users of the database, and thousands of records. Therefore the chances of the same record being referenced are very small. Regards, - Paul
  9. paulminne

    Linked Tables

    Hi, I have 3 databases created in Access 2000. Database 1 (Contact Database) is used as a central store for all contact information. Database 2 (Service Database) is used by another department to keep records of all services, and database 3 (Compliance Database) is used by another department as...
  10. paulminne

    Hi, I was wondering if there is

    Hi, I was wondering if there is a way to clear the contents of a query from the click event of a button on a form? Currently I can set a dummy field into the SQL statement which returns no results, and subsequently clears the query, however this isnt really a viable solution. Thanks, - Paul
  11. paulminne

    looping records and adding to a query

    OK, sorry I know that was a little confusing. In essence, what I want to do is loop through a number of records in a query. Then with all the records found matching a certain criteria, I want to place them into a report and print the report. But I am unsure how I should go about this. Any...
  12. paulminne

    looping records and adding to a query

    Hi, I am trying to loop through a number of records in a query and select them based on a condition. Once the records are selected I want to create a record in another query and continue the loop until it is finished. More simply. 1. Loop through records in query 2. Find record based on...
  13. paulminne

    Counting records in query

    Hi, I need to be able to simply count the number of records within a query from the click event of a button on a form, and then display the results of the count into a text box (on the same form). However am struggling to do so... I know there must be a simple solution, but I cannot for the...
  14. paulminne

    counting days between 2 dates

    Hi, I was just wondering if there is a way to count the number of days in between 2 dates in the 'medium date' format? If so, where/how might I begin to code this? Regards, - Paul
  15. paulminne

    Matching date fields

    Hi, I have tried changing this from string to date and back again with no luck. I have also run some error checking and have determined that it is a problem with matching it to the date() function...for some reason it wont match with the fields in the format I have stored them in the database...
  16. paulminne

    Matching date fields

    Hi, I am trying to run an SQL query to select all of the records from a query with JobDates matching a date entered into a text box on a form. The text box contents is automatically populated by date(). However it doesnt seem to find any matching records, even when I am sure there are records...
  17. paulminne

    error select records based on 2 WHERE conditions

    Thankyou...that was exactly my problem because it is working fine now... Thanks heaps, - Paul
  18. paulminne

    error select records based on 2 WHERE conditions

    Hi, I have a form with a text box and a combo box. I am wanting to match a record based on the entries in the text and combo fields, however when I run the SQL I am getting an error stating 'Type Mismatch'. The code is: ****************************** Private Sub cmdPrint() Dim strInput as...
  19. paulminne

    sql to select a record from query

    Hi, I have a form with a combo box on it. When a name from the combo box is selected I want to display the related records from a query in a report, however I am getting an error when running the code. The error states "Syntax error (missing operator) in query expression...
  20. paulminne

    formatting a date from dd/mm/yy

    Hi, I have a field in a report which is copied from a textbox on another form. However, it is being formatted as dd/mm/yy even though I have set the 'format' property of the text box to 'long date'. Is there a way to format this field to long date (eg Sunday, 17 March 2003) ??? Regards, - Paul

Part and Inventory Search

Back
Top