Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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