Search results

To add to what Bob has explained. This message is because you are using a nexted "IF" statement which must end with "End If". Look at Bob's entry number three it is If Me.DateValidUntil < Date() then Me.lblDateValidUntil.ForeColor = 255 End If When you enter the statements for the...

Bob if this was the only thing I miss, life would be great.

The statement must include a "then" such as If Me.DateValidUntil < Date() then

I may be easier size your forms for the lowest screen resolution and then just center them on high resolutions. This way you wont have to resize the forms.

John this is good, but I avoided it as his quarter begins in June and not July.

I'm not sure how you are planning to have the user enter the dates but you could use the Month(datevalue) function. It will return a number from 1-12 of the date value. You could then check if the month is between 6 and 8 for quater 1, 9-11 for quarter 2, etc.

In datasheet view, you can't use a combobox. Set your form view to continuous and you should get all the records your expecting.

I had a similar problem with Access 2003 and couldn't figure it out. My control was a tex box. The solution was to delete the text box and replace a new one. The new one responded correctly. I don't know why, but it fixed the issue. Try replaceing your current control.

Raghu, When you are using the Title for example in your insert, you are using the text from the screen in your insert. This text is already changed. In you before update event you could use Title.OldValue. The oldvalue property has the value currenly in the record in the database. This...

Leif, Sorry it took so long, by you should be able to retore your application using me.restore, just before you window pops up. This should place your window where you expected it. Don

Bob, I first designed with sub forms but the users demanded the sub data sheets as they want the form to expand and collapse as they do with their present Lotus Notes system. Notes is going away at the end of the year and Access is their choosen replacement. So I'm stuck with the datasheets...

I have a form in datasheet view with two nexted sub data sheets. I need to determine which datasheet (main, sub or sub-sub) sheet has the focus. Acitvesheet always returns the main sheet. I'm using 2003. Thanks in advanced. Don

You could set the window to be the top most using one API call. In a modulal enter Private Const HWND_TOP = 0 Private Const HWND_TOPMOST = -1 Private Const SWP_NOMOVE = &H2 Private Const SWP_NOSIZE = &H1 public Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal...

Thanks, I'll check it out. Any ideas on displaying the icons in place of the link path?

I'm storing links to Excel, Word and other documents in a table. I then allow the user to open the documents by double clicking the link on a continuous form. I would like to display the exe icon of the program that drives the document such as excel or word. Does anyone know of how to do this...