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

...works fine for one form, however returns an error for other stating "Application-defined or object-defined error"... Here is the code: ***************** If (CurrentProject.AllForms("JobsBooked").IsLoaded) Then MsgBox "Jobs booked is loaded&quot...

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

...record in another query 4. Continue Loop 5. (If any more records are found, then continue to add them to the new query) This is the code so far: ********************************************* Dim strDate As String Dim strStartDate As String Dim strFinishDate As String Dim i As...

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

...populated by date(). However it doesnt seem to find any matching records, even when I am sure there are records with the same JobDate. The code: ********************************** Dim strInput As Date Dim db As Database Dim rs As ADODB.Recordset Dim strSQL As String...

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

...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 String Dim strName as String Dim db as Database Dim rs as...

...running the code. The error states "Syntax error (missing operator) in query expression '[consultant]=Paul'." The code looks like this: ************************* Private Sub cmdPrint_Click() Dim strInput As String Dim db As Database Dim rs As ADODB.Recordset Dim...

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