Search results

Sorry, been a long day... I opened a file "Something" Did stuff to it SaveAs "Something Else" Close the file ReOpen "Something" Close "Something" Close Excel obviously I didn't close excel before I reopened the file, as I said in previous post!! Without: ReOpen "Something" Close...

In my previous post to this thread I suggested that there might have been another instance of excel running that hadn't been closed down.... but then I remembered that that is nothing like the problem I had! It was only a couple of weeks ago as well! If only I had a good memory!! My problem...

I looked on microsoft's website to help me out, followed what I found out... and it still didn't work!!!! I want to know how to reference excel constants from access during automation. I'm getting a "Variable Not Defined" message, when (according to what I got off the MS website) I shouldn't...

I know this thread is from a long time ago, but the code from it is great!!!... but I've got a few problems! Whenever I use the functions, the email appears as an unsent&unread draft email in notes... is this just because I'm using an ancient version of notes (3.something - it's on my work...

That definately explains it!!! And by the way, yes, the Academy is on Oxford Road, just a stone's throw from the Uni building, just up the road from the hospitals. have fun!

I had exectly the same problem... every time I shut the computer down it came up with an error msg something like "OLE Automation error, could not access memory at location ......" The previous poster's suggestion to use .Quit is what did it for me! I noticed that when I shut down there would...

It's easy really... ----- Private Sub btnReport_Click() Dim PeriodArray(13) As String, MyCount As Integer, PeriodWrite As Integer Dim EndDate As Date Dim StDateAsDbl As Double, EndDateAsDbl As Double Dim SQLStrHead As String, SQLStr As String Dim dbs As Database Dim rst As Recordset Dim...

Setting the locked property to TRUE means that the FIELD is locked... you cannot edit that field in any record. The date& time thing is no longer an issue - what I want to do is make sure that when a log entry (i.e. the log text) is entered, it cannot be edited. Could I perhaps use after update...

Although I'm not on a tight deadline, I do need to get this done quite soon, and that was my original thought, to have (3x13) 39 queries and to output it to excel. Whilst this is quick and dirty, I aspire to beauty and elegance (well, apart from my girlfriend!) If in the next couple of weeks I...

Whilst looking on microsoft's website about automation, I came across some code: Private Sub Graph_Click() Dim MyExcel As Object, TitleArray As Variant, DataArray As Variant TitleArray = Array("Dogs", "Cats", "Penguins") DataArray = Array(34, 53, 12) Set MyExcel =...

I have a table with data for the past year or so (new data added every day), each month I need to produce a graph based on this data for the past 13 periods (28 days each period). There are 3 cause codes A, B and C. I need to count how many instances of cause A, B and C there are in every 28 day...

Cheers Shay and Pat, I've used the single field and before update event. But is there a way I can also stop the log entry from being changed? With locked, the field locked is locked in all records... this is good for the date and using before update (but not my rubbish original way of doing...

I want to create a basic log book, OnEnter I want to put the date and time into a field (easy peasy!), I then setfocus to the next field... but how do I stop the date and time from being edited again?? Locked and enabled are for the whole field, I just want to lock each record as I go along...

I need to compare the two sets of values to see if they match. The user enters the first set in a form and this is saved in a table. The second set of values I want to create by selecting one value, and returning all related values (as stored in a separate table). i.e. the first set of data...

What's big problem with using word??? And surely snapshots were designed for this very purpose... surely it's your job to convince your boss that snapshots are the way forward and that if customers do have any doubts about it, then he has to pursuade them!! I'm sure your boss just doesn't have...

Sorry, was being thick!! Didn't know how to do calulated fields in queries... done it now, thanks for the pointer!

Ok, so I need to use a field to store the date difference... but how do I put the date difference (or anything for that matter) in all the fields?? If I have a table "DateTable" with Fields "BeginDate" and "DaysBetween", what do i need to have in the query and how is this referenced in the...

I want to show on a tabular form the date difference between todays date and some date in the past, I also need this interval to be printed onto a report (and exported to file as well). Do I need to create a field to hold the date difference or can it be calculated whenever the form/report is...