Recent content by tmd_63

Your DoCmd object needs formatting correctly. DoCmd.SendObject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile The EditMessage must be set to -1 to allow for editing the message before sending. You have set the editmessage to 0 (false).

Yes, I know how

If you want to use Date in a field, it is better to use the standard database naming conventions, ie for a basic date field the name is dtmDate. This tells you the type of field as well as stopping the system thinking it is a reserved command.

next look at the relations between the various tables (how the itemID's are recorded etc). think about what to want to input or display on the forms and reports then create the relationships, create queries which match the input from the tables, calculations and output. Then create the forms...

yes. you appear to be on the right track

This can take a long time. I know as I developed an almost complete MRPII database from scratch and it took me over nine months, working every evening in my own time to complete it. It covered everything from the customer orders to the stock status, to ordering parts for build, to assigning...

:D YAHOOOOOO! Solved it. The problem was that I needed to preset some variables first. Here is the code for one of the check boxes. Private Sub chkKVARH_Click() Dim GraphObj As Graph.Chart Dim objGrp As Graph.Application Dim objDS As Graph.DataSheet Dim objCht As Graph.Chart Dim Test As...

Solved part of it. The problem of the X-Axis not being set to a value was due to the time/date axis being a category instead of a time axis. I changed the code from Axis(1).MajorUnit to Axis(1).TickLabelSpacing and it now works beautifully. I still have a problem with the actual data. If you...

Len, The x-axis works fine as far as the data is concerned. It is just that the axis is currently set with the major axis setting of 24 (once per 12 hours of data). This is fine if the user is viewing a week worth of data, but if they are viewing a months worth, the major mark (ie the dates and...

Run-time error '1004' Unable to set the MajorUnit property of the Axis class

I have tried that but it still doesn't help with trying to get the majorunit to change on the x-axis. Here is what I have so far (which changes the primary Y axis instead. all other scales are inaccessable). Private Sub lstXAxis_Change() If Me![lstXAxis].Value = "12Hr" Then...

As a thought. Have you checked the data format property of the machines themselves. Some suppliers set up Windows for you and use the US format instead of the UK format and vis-versa. This would cause a problem if you are trying to save a date record of 7th Day of the 25th Month instead of the...

There is no way to colour the cells/rows in true datasheet view. But. You can use the standard view and set the text boxes to look like a datashhet view and colour them there.

I have a line graph that displays date-time categories for four values using four different lines. I also have two calender controls to change the start and end display days to reduce the data displayed and this all works fine. I need to change the major units for the X-Axis using code so that...

Hi Rachael, How much work have you done on charts? I have been having problems with line graphs and I am looking for details on the graph object's properties. I have now got a graph that will display four values on a time-line type graph but I need to enable/disable each of the values. I...