Search results

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

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

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