Search results

Here’s my question/problem: Let’s say I have a field in my table containing social security numbers. However on my form and report I only want the last four digits to show… How do I do this…? I can not for the life of me remember how to do this… Thks in advance, Don

Dave I am not sure if you have found an answer to this problem… However, the way I do this is; I make no changes to the field type in my table…for the most part it is set to text… I use a button with this code in the OnClick event… ####### Code Starts Here ####### On Error Resume Next...

Thank you both for responding... I know have it fixed... Don :D

This is one of those that will most likely turn out to be easy but, I can’t for the life of me figure it out… Here’s my problem… In one column in one of my tables I have about 61 different numbers assorted throughout some 50000 records. What I need is an update query or something to change...

Try The Code below: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmSeachResults" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Close acForm, "frmCallSearch" Hope This Helps... Don

Rich: Thanks for your reply...I'll give it a try. Don ***Edited because of a typo :D

If I understand your question; All you need to do is this; On the Data Tab in the Properties of the form; set the Data Entry option to Yes... Hope This Helps... Don

Fornatian: Thanks for your reply… However; I was aware of how to print to different trays using the page setup for each report, what I am looking for is a way of doing this with code instead... Thx Don :p

I have reports of two different types… One type can be printed on plan paper (Tray #1)… The other needs to be printed on letterhead (Tray #2)… I know how to do this in the properties of the printer; and in the page setup on each report however, in the long run I think it would be better doing...

When you created the combo box… If you selected to look values up in a table…You can just edit the contents of the table. If you selected to type the values to use…You can go to the properties of the combo box and edit the row source on the data tab… Hope This Helps Don

VC I am not sure if I understand precisely what you are trying to do. What I think you are trying to do is this; I think you want the current date to be placed in the Drop_In_Date field when a new record is added. If this is the case then all you need to do is this; In design view of your...

See we all learn new things... Now only if I could remember the things I have learned... So many new things...so few brain cells left... Thanks Again Pat Don

Sorry Man...I guess I am still asleep this morning...I misread your question...Try this instead... DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim stDocName As String Dim stLinkCriteria As String stDocName = “The Form Name You Want To Open" DoCmd.OpenForm...

If I understand you correctly… You could do something like this on the OnClick Event of your button; DoCmd.Save acForm, "THE NAME OF THE FORM THAT YOU WANT TO SAVE" Dim stDocName As String Dim stLinkCriteria As String stDocName = “The Form Name You Want To Open"...

There isn't a way to decompile the mde file. Unfortunately you will have to do it all over again. Once you complete the database again...By all measures keep the original. Don

lmao :D

Here is what I figured out… I am running two different split databases… With both databases opened; one of the backends has a ldb file while the other does not. The differences between the two databases; The one with the ldb file has an Access Switchboard… The switchboard needs to access a...

audrey As rockman said both of your graphics are Sweet... Graphic #2 would be my choice of the two... I could be wrong but, I'd say you are one of those graphically gifted individuals. Don :p *** Edited because of a typo in rockman's name... Maybe a spell checker would be a good thing to...

The BeforeUpdate Event will only come into play when a user attempts to exit (close, move on to the next record, etc...) the form... If the combo has a valid value; the event will go un-noticed and, the form will close; if the combo box has a null value it will trigger the event and, it will...

The BeforeUpdate Event is place on the properties of the form...Not the field... When leaving the form...If the field has a null value it will pop up the message box...Once the OK button it clicked it will then setfocus back to the combo box field... Don