Search results

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

Can I assume, by the lack of response to my query, that Microsoft just will not work correctly for this type of problem. I have now found an alternative. I use date converted to a double number. Then change the axis to display a date.

Have a look at this snippit to see how to access the controls properties in a form. ' Call SetTextBoxProperties procedure. This is called from a form using the me keyword SetTextBoxProperties Me Sub SetTextBoxProperties(frm As Form) Dim ctl As Control ' Enumerate Controls collection...

Are these textboxes on the same form? If so where is the commands being run from (is it from onload)? If these textboxes are on the same form then the best way is to enumerate the controls of the form an look for the textboxes, then find the captions of the text box to find which one you are...

Your main problem is that your form datafield for the PIPEFILL is labelled Text7 and Text7 is not used anywhere in your calculations. Try looking throught the very long vba code behind SCREEN-EXTRA_BASE.BeforeUpdate .

OK. I am still having a problem with the use of a chart control and two calender controls on a form. Can anyone shed any light on how to do this in Access 2000 please.