Search results for query: *

Hi guys, I have a question that has had me stumped for the past couple of weeks so I'm hoping one of you will be able to point me in the right dircetion. I need to match people to activities, using the following information: there are three activities (A,B,C) there are 4 skill levels per...

Hi Duane, I got it all to work!After another day banging my head against the Access wall i have finished it in time for the weekend! thanks for your help. (Iwasn't pulling your leg, but I had copied from onprint to format with deleting it) Mark

It was, but when I moved to the Format event the same happened, or didn't actually haha.

Hi guys, Thanks for your tips. I am now trying to do this the following way: I have two tables: 1. One containing two fields: all dates from 1/1/03 to 31/12/10 and the season(to be filled in) 2. A table containing the season name, beginning date and end date, as these can vary. this table has...

In answer to your questions: 1.The only lines of code causing errors are the positioning lines (.left , .width, .top). i get error 2101: the setting you have entered is incorrect for this property. 2. The values of the variables are calculated correctly, there are no excessively larg or...

Hi My problem is as follows: I need to assign seasons to dates. To do this I have 2 tables: one with a list of all dates from 1/103 to 31/12/10 (not done by hand!)and one in which the beginning and end date of the season (summer/winter) are listed. I need to combine these two somehow so that...

Hi Duane, I realized I was going about it the wrong way - i was plotting lines between two coordinate points. Using the examples you suggested I have altered the code as follows: Me.CurrentX = 40 Me.CurrentY = 25 If DEP.Value < ARR.Value Then DEP = 7 + DEP End If...

Hi Duane, Thanks for your tip, I am looking to see how I can adjust the 'Calendar' sample to suit my purposes. However, I have drawn the lines another way. I have created a standard A4 report on which the lines are drawn based on calculated coordinates. These coordinates are a function of time...

Yes, I have gotten that far but I can't get these properties to work for labels or text boxes even though I know they should. For example: Label401.Left = x1 + 100 (for a calculated value of x1)yields a run time error: 2101 The setting you entered isn't valid for this property. I get this for...

Hi, i have designed a report that draws horizontal lines based on arrival date and type and whose length is function of duration (in days and hours). I have done this by converting the times into x-coordinates and types into y-coordinates. This allows me to plot the horizontal lines for...

Here you go.... The error seems to pop up randomly, sometimes it doesn't occur and sometimes I have to press the 'go to last record' button up to 5 times before the error is no longer displayed. Thanks for your trouble. ' Main Page is cont. form with all visitnumbers listed. ' QuickLMOForm...

Hi, I have designed two forms, one of which has a subform. I can access and both independently and alter the controls. However, when I try to open the one with the subform from the other and then enter data I get an error stating that '.....would have no record on the one side' and also that...

Yeah, I know my wording wasn't too clear. It's both number and single. But I have just changed the regional settings to US (default is Dutch) and then the problem doesn't occur on my computer so I guess the problem might be somewhere else entirely. Thanks, Mark

Hi, I have what appears to be a very simple yet extremely annoying problem: I am developing an application in MS Access 97 and I can't enter decimal values in numeric fields. And yes, I have changed all the formats that would allow me to do this. Here is the clincher: if I open my database on...