Search results

I have a field ldate (lesson date). Next to that, I have a field ldow (lesson day of week). I am trying to return the day of week in that field based on the ldate then save both to the table. ex. I input 01/14/2012 in the ldate field I want it to return Sat in the ldow field. Is that possible ...

Thanks Paul. I looked everywhere but never found the "#" syntax. Thanks again. BTW, can a timer be set on the message box ?

Would someone tell me why the top part of this code doesn't do anything ? It executes the code after the else I have tried variations of the If Date syntax but it seems to ignore it Private Sub Form_Open(Cancel As Integer) If Date = 2242011 Then MsgBox "It is Feb 24, 2011"...

Ok, as usual, I am confused as to where I set the execution date of this. All I need is say, on March 3, 2011, it pops up a message that the license has expired, enter an unlock code. If code not correct, states unlock code incorrect and does not start. Don't need a warning or if previously...

Thanks David 1. What form does this code go in if in a form ?

Anyone know how I can have an Access program disable itself automatically on a given date without damaging the data but still be able to open (by programmer) and enable it ?

One more thing. How do I close the little form automatically when the report is closed ?

Works perfect Paul. As usual, you have bailed me out. Thank you so much. Also, thanks Larry for the form suggestion. Seems I understand that better. And thanks to the rest for you time and suggestions. Ain't a better forum anywhere nor nicer more helpful people.

Not sure I understand about the brackets nor making SrvAmt a calculated field I do queries in design view since I am not that comfortable writing code

Don't need to save any data. What I am trying to do is= Look at all customers whose monthly charge (SrvAmt) is more than a specified amount in anticipation of reducing some or all of those by the difference due to competition offering reduced rates, and, by the same report, see what financial...

This query lists all customers and their service amounts that are greater than a prompted parameter input. As in, I input 22, it lists all customers with service charge amounts greater than 22. I would like to add a column in a report that shows the difference in the SrvAmt and the input amount...

Thank you.

Is there a way to prevent data in a split DB from being imported by another program ?

Doesn't 2007 come with capability to make run-time ?

Doesn't run all that well with Win 7. Excel & Word seem to be fine but lots of problems with Access 2003 with Win 7. Matter of fact, Microsoft says it will NOT RUN with Win 7, although I do have it running except problems with Access.

I can't think of a better place to ask or better people to ask, but: I am using Office 2003 Pro. Since I have went to Win 7, Thinking of changing to 2007 or 2010 Is either worth the change as far as Access goes ? Would appreciate opinions.

Thanks I'll just manually compact it when it appears to be growing. It's a single user.

I have a split DB and have it set to compact on exit. However, I just noticed it does not compact the data file. Is there a way to do both on close ?

just working on a program for my brother-in-law. Needs a general info table, a parts table, and a work hour table at least as the 3 major tables. I thought about using 3 forms for inputs but that would be a little clumsy so I was thinking of an append query and doing all from one form. With...

When inputting information into multiple tables, I assume, which I hate to do, the best way is to use append query. If this is correct, is there a limit to how many tables can be appended to from an append query in a single form ?