Search results

Sorry Mr K... I realise my mistake. I use a label instead of a text box. Using a label gives a property of hyperlinkaddress... put a space in there. J.

I have an honor of 52 on America's Army... but I had to work hard for it... and I still suck!!

Put a <space> in hyperlink subaddress. I use this to give the appearance of a hyperlink, but then create an on-click event instead. Once the on-click event starts I pop-up a message saying... something like "opening... please wait" (okonly). Then docmd.hourglass false to remove the hand...

Gromit, Can you post this as a '97 db as well please? Cheers, James

Can you explain why you want to do this? If it is just a matter of giving them extra information to help them type in notes, or something similar... then you could use an 'if' condition on opening the form and then open a message box... A little more information may give you a better solution...

Put your table in design view. Change the spending data type to Currency. Change the number of decimal places to 2.

Don't think that you can run an insert query as part of a recordset?! Any time I do an insert I use the following syntax. Dim strSQL as string strsql = "insert into tblTableName values ('It', 'is', 'this', 'easy');" DoCmd.RunSQL strsql

Sorry... have a habit of not reading posts properly. Experiment with the following to see if they work. 1. Date on hire <=[choose date] AND Date off Hire >=[choose date] Or Date off Hire Is Null (or default) 2. Date on hire Between [start date] And [end date] Or Date off hire Between [start...

In the infamous words of Shaggy... "It wasn't me"!! ;)

Hayley, Still sounds very similar. Are any of the linked documents open by another user?... because I think that this would cause the same problem. J.

Sorry mate... I'm tripping... forgot about the major part of the syntax for Date range input in criteria: Date on Hire >= [enter start date] Date off Hire <= [enter end date]

Create the queries that you want. In the first query (single date) put [enter a single date] in the criteria section. In the 2nd query (date range) put [enter start date] in the Date on hire field, put [enter end date] in the Date off hire field. By doing this a message will pop-up that tells...

I have seen something similar recently... Try closing your database and then opening the spreadsheet. You may have to focus on closing it in vb and then setting the excel object to nothing before opening the spreadsheet. I have just written some code to search through my inbox, find...

Russi, I can highly recommend a book - SAMS Teach Yourself SQL in 24 hours (2nd Edition). Most of the examples are oracle, but they also show examples from Sybase, SQL Server and dBase. Very good explanation, break-down, examples and exercises. You need to be a little wary as I recall some...

Hey Christine, Did I ever suggest the technique that I use to overcome this problem? I just trap for the interruption code and output a message that tells them to wait. If Err = 2501 Then MsgBox "You have attempted to cancel the output of the emails." & vbCrLf & _...

Creegfire, I am happy for you to PM me with your db. Or alternatively send it to <removed my email... sorry> J.

Creegfire, This code works for me. In fact I recreated your table and field names and while testing I accidentally sent 3 emails to fictitious email accounts... phil@msn.com isn't fictitious !! ... and he didn't know German!! I have the following references libraries ticked: visual basic for...

Creegfire, A few things. - Firstly, look at your code and ensure that tools, references, microsoft outlook is ticked. - include End Function at the end of your code. - include dim dbs as database in the PROC_DECLARATIONS section - it doesn't like the word E-mail, so I changed this to Email -...

You could do it all on one form. Create a 2nd massive list box that holds everything you would otherwise put in your datasheet. The source for the 2nd list box is reliant on the selection of the 1st list box. Create an after update event procedure for the 1st list box that has...

Hallelujah!! - Finally created something that works. It's not pretty but it does the job. The following creates a self-extracting file using the standard Winzip package by utilising the Sendkeys functionality. Note: Please be sure that your users aren't keyboard happy if you intend to use...