Search results

I pulled the code lines out of an app, and I had a spare few minutes :) A good tip is while you're stepping through the code, hover the cursor over the name of each object - it will tell you if it's empty (Nothing). Work from the outside in. Get your code running just at the application...

How about... pointing the user to a form rather than a query/report. The form then runs the query checks the columns ...

To grasp the concepts, start with something more familiar. look at creating a new Excel spreadsheet from within Access VBA. There's less risk involved - tread carefully when you are accessing a mail system - see if you can get access to a test/dev one. You really dont want to bring your...

It should be - I've just been asked if it's possible to do this myself! Building/saving excel spreadsheets from access - definitely possible because I have done that. I'm now looking at: http://msdn.microsoft.com/en-us/library/office/ff197046(v=office.15).aspx Sounds possible to me...

I'd start thinking about this in a different way (if I've understood the requirement). If you google "automatically saving attachments in outlook" you will find examples. That can be set up to store attachments from specific senders in specific folders (not Access folders, shared drive...

Also... http ://support.microsoft.com/kb/179987 I added some spaces to allow the link to be pasted!

Try &H90 (144) for Numlock..., although I think I've misunderstood your issue! Your trying to avoid it being set on/off, not trying to do it...

I found this somewhere and use it in Excel for caps on/off. It may/should work from Access :) A bit of research should then give you numlock... Private Type KeyboardBytes kbByte(0 To 255) As Byte End Type Dim kbArray As KeyboardBytes Private Declare Function GetKeyState Lib "user32"...

Down to three SELECTS - much better. I couldn't get it to work as two. SELECT KeyKey, max(F2.ValVal) FROM ( SELECT KeyKey, F2.ValVal, max(F2.Prev) as Prev, F2.ValVal - max(F2.Prev) AS Diff FROM( SELECT tblData.KeyKey, tblData.ValVal AS ValVal, F1.ValVal as Prev FROM tblData LEFT JOIN (...

That's good thinking, I was doing it step by step, but if I work out ALL the differences at once....

I have just spent an hour developing this, it does what I need, but can it be improved upon? Basically I have a set of manual readings (valval) for a given item (keykey) We sometimes get some mad readings, but if the readings are a sensible distance apart (say 10) they can be trusted I...

I need to bring some order to a query chaos! Issues: Multiple programs and databases (.accdb) with many identical tables and identical queries. Many queries that would be identical except for "CustomerID", "Customer", "Customer ID" field name type issues Many queries that do the same things...

Thanks to you all for your help/ideas. In the end it was quickly sorted by repeating the expression in the "Group By" clause. I need to nest SELECTS so I only have the expression in there once (in the inner select), then I can refer to the field name in the outer select as was mentioned above...

The following code should sum a field depending on the date. The field IncidentYear is created and set to Last, This or "-" depending on the date. I should get three rows, one for each of the three values.. I get..... you tried to execute a query that does not include the specified expression...