Search results

R. Hicks Thanks and I will always help people if I can… My methods are not always the best ones however, they are the only ones I know… I am still learning a lot about Access and VBA by asking & answering questions… Sometimes I know how to do what peoples are asking… I just can’t always put...

R. Hicks I have been accused of doing things the hard way However in my defense... It was the only way I knew to achieve what he needed... We all learn new ways of doing things...As I may have just learned something new... And I try help people where I can... Don

This may not be what you are looking for... This will show the age but, it doesn't update until you leave the record and come back... However This is what I use: I place the below in the OnCurrent event of my form... Private Sub Form_Current() Dim SerToday As Date Dim SerBirthday As Date Dim...

The way I do this is: Say I am wanting to transfer the ContactID from form1 to form2 On form1 I just have a button that opens form2 On form2 in the Default Value Field of the ContactID field I put: =[Forms]![form1].[Form]![ContactID] Hope this helps Don

Ok I give… After reading numerous postings on “listbox” I still have no ideal how to do what I would like to do or, even if it’s possible. I would assume with the capability of Access almost anything can be, if you know how… I may have over looked a post that answers my question. If this is...

Is it possible to pull info from a table into a msgbox... I have a msgbox informing them that the record has already been added...I would like to tell them by whom and on what date... I have two fields I'd like to pull into the message... CreatedBy & EntryDate I'd like my msgbox to be...

If you are adding new info after you click the buttons then you could use the OnClick Event on each of the buttons…You could do something like this: Private Sub AddCreditAdditionalInfo_Click() On Error GoTo AddCreditAdditionalInfo_Click_Err DoCmd.OpenForm "frm-tblCredit", , , , acAdd...

Glad I was able to help... And yes "WE" learn alot in these forums...

neideb I think I know what you are wanting to do...I have e-mailed you an example of what I think you are looking for... Don This is a reply to a questiion he left here... http://www.access-programmers.co.uk/ubb/Forum4/HTML/004853.html [This message has been edited by donbettis (edited...

I believe the problem to be in the fact that the query is filtering the table. I haven't figured out how to make it work this way...However I did find a work around... I created one form based on the table itself...This is the Form that Sales will use to enter New Contacts...On this form I...

It appears to work... It doesn't appear to be very clean though...

As for the User Stamp... I am not sure what your login process is... As for Date/Time I have a Note Field on several Forms... In the table the field Data/Type is set to text. On the AfterUpdate Event of the notes Field I do the Following... I apply the Date/Time after the note is written...

I am not Pat Hartman!!! However if I understand what you are needing to do. This should achieve what you are wanting. After changing the code below to match your info, place it in the AfterUpdate Event for the BirthDate field. Dim Answer As Variant If DCount("[Name]", "TableName"...

You could base your report on a query. Make a query based on the table where the data is stored… In the criteria for the field of say ContactID put some like this… [Me]![ContactID] This tells the query to only load the Record containing the current forms ContactID EDIT BECAUSE: The Above...

I am not sure if this is a Query or Form Question...Maybe both... Here’s my problem… I have a SubForm based on a query. The query is designed so that only the current users records are shown. On the SubForm I have an AfterUpdate Event on the PhoneNumber field, to help Prevent one...

shacket Yes I am trying to return the results of 2 fields and, Believe it or not but this works... I tried using a query to do this... I couldn't get it to work... I am learning new stuff everyday... Chris RR "Curious as to why this is in the BeforeUpdate Event" Well to be truthful... I...

Here's my confusion... I have a form which contains 6 zipcode fields (ie... Zip, PrevZip, EmployerZip, CoZip, CoPrevZip, CoEmployerZip) I can use the code below on one field and it works great...However I can not get it to work on more then one field in the same table... I have even tried...

Thx to you all for the answers...

How does one take away the ability to edit a form by right clicking on it? I am using "DoCmd.ShowToolbar "Form Design", acToolbarNo" on an On Open Event to take the menu bar away... However I still have the ability to right click and edit the form... Thx... Don

Thanks...Now I know what I was doing wrong... [This message has been edited by donbettis (edited 11-01-2001).]