Search results

Hi, I have found the answer to most of my problem, thanks to previous posts. I am using the Undo command on a Date field. However it seems that my code is maybe not staying on the event to action the undo. After it runs the Focus goes to the next field Me.LeaveDays and the value is...

Did you end up using the Undo command? What was your code solution if you did? Having similar issues, but not duplicates. lightray:(

Hi, sorry for the delay. I think you would need to use the StrConv Function where you can convert your input to other types, vbUpperCase; vbLowerCase; vbProperCase; etc, check it out in Access Help, then process the string. I haven't used it before so don't know that much about it.

Did you find a solution to this problem? lightray

I suppose you could put the original in with visible = No if you still want to sort. And use the text Align to justify that! lightray ;)

Sorry, wasn't focusing on that bit, and should have mentioned previously, create an unbound text box for the equation.:D

There is no point posting things that don't work! I have been using this solution for many years. lightray

No code needed I know this is an old post, but another simpler solution is: IIf(IsNull([Me.DateField]),"A.S.A.P.",[Me.DateField]) in the Expression Builder ;) lightray Access 2000

Sorry, cant do it right now, no MS access here. perhaps tomorrow lightray

Can you post the code behind your search box? lightray

I would have a Students table, each student would have StudentID (autonumber) You would then want a Conversations or Chats Table This would also have a ChatID (autonumber) a Date Field and StudentID and Conversation. A topic field might also be good in here. In the Student table list all things...

Hi, You seem to have left the Teachers out of your schema, your PURCHASES seems to be your contract. Try and keep it simple. Student goes to Teacher (who has the contract rate) if a teacher has multiple contract rates then you may need a contracts table. Instead of tblPrivateLessons (note...

Hi Pat, thanks for your input. New Zealand administers a UK type standard when it comes to accruing [Annual Leave] more so when it's a government division. I've set my mdb up to query or requery every instant of a record change [Add or Change ]. There isn't likely to be more than 100...

Thanks Oldsoftboss I was starting to turn that way, you've supplied the nudge I need. Not so big forms so will be a breeze. ;)

When you execute the DoCmd one of the parameters after the [Where] parameter you can specify how the form will be opened; acFormAdd; acFormEdit; acFormReadOnly; and one other I am not changing anything dynamically I was just wondering what happens when you open a Form DoCmd ,,,acFormEdit and...

So that's the acFormAdd of the DoDcmd right? A further Q? When you are in Edit Mode and you can add a new newrecord, does the AllowEdits condition toggle (True/False switch) to AllowAdditions? or does one condition remain overall ie the AllowEdits? Thanks again, this Post has helped me solve...

Bingo! gemma that was right on the mark. Thanks for your time.. :) lightray

Putting it in the Current event didn't change anything. Surely if you can just set it once for the form mode Edit or Add(it):) that it will ripple through once set? Doesn't work in open or load events either, anyway. :( Will have to settle for leaving it in the LastName field, better for when...

Sorry gemma, fire fighting on a few fronts here. Thanks for getting back, primarily I am trying to set a condition so that if form is in edit mode it does A, else it will most likely be in Add mode so do B My final code was: If Me.AllowAdditions = False then Me.cboEmployee.SetFocus Else...

Well my code started out alright then hit a snagg! If Me.AllowEdits = True then Me.cboEmployee.SetFocus Else Me.[JobTitleID].???? only gives me the option of value? anyone tell me what I'm missing? lightray :confused: Edit: It would help if I picked a Name on the playing field... should...