This is a brief view of how I have a spreadsheet set up.
COORD QNTY MEDIA STATE
LAA 2 Newspaper NM
LAA 1 Yellow Page AZ
BJD 1 Newspaper IA
LAA 1 Newspaper NM
BJD 3 Yellow Page NY
What I want to do is have a...
We use a terminal server for out of office staff. On occasion I need to shut the server down for maintainence, but still want to give our people the opportunity to access information from the database via the web (secured website) in case they need to look up phone numbers or information while...
I am running Server 2000 and have people remotely access our database on the server. Within the database, I want to have the ability to allow them to click a button that will automatically insert the :to, subject, and text into an email. This part I have down--the problem is that it wants to...
I want to have the "APUpdated" field populate with the current date and time whenever a change is made to the record. Have used the code below with no success.
Private Sub Form_DataChange(ByVal Reason As Long)
[APUpdated] = Now()
End Sub
When I use this code in the BeforeUpdate it works...
Thanks Lilliabeth.
The first run did not work, modified the code to read as below and works fine. I'm not real familiar with this code stuff yet, but know enough to get by on occasion. Do appreciate you pointing me in the right direct.
Private Sub Form_BeforeUpdate(Cancel As Integer)...
I have created an unbound field named "RemainingDays". I want the value of this field to be the field "BMDueDate" subtracted by the current date. The code below does not give me any errors but the results for every record are "-491". What am I doing wrong? Thanks for your help
Private Sub...
I would like to have a field in my table that uses the Now() function whenever any field in the record has been revised. Not sure where to start on this one. Thanks for your help
I have a command button that when clicked is supposed to take me to a new form, start a new record, then change the size of a field and set the focus on this field.
Problem is, the form opens but then I get an error saying "Object Required" and the debug points to the "DateCreatedBy.Left =...
I have this code that does what I want it to do. However, I want to take it a step further and have it search within the "AFLastName" field for a match as well. How can I modify this code to search both the "AMLastName" and "AFLastName" fields?
Private Sub AMLastName_Exit(Cancel As Integer)...
Remou, thanks for your help. I am working on your code and using it as a platform to educate myself on recordsets.
MajP, thanks for your input as well. Your idea was something I considered. You nailed it on the head in that I know enough to be dangerous but not enough to be effective. I...
This is the format from the input mask in the properties box. I have even tried to edit the existing formats--shows that it works in the example but then does not work when I use it in the form. Is there an over riding format for the entire program that is forcing it to default to this. You...
I was afraid someone was going to suggest a recordset. I have zero experience on that as well. If you could point me in the right direction I'm pretty good at figuring things out.
Where do I put the code you wrote and how do I access it? Thanks for your help
I have this string in the input mask of a field "99/99/00;0;_". I want to have the format be 5/21/05 but it keeps showing up as 5/21/2005. I have tried "9/99/00;;_" as well with the same results. What am I doing wrong?? Thanks for your help
I have a form that puts information into multiple fields of the "databasehistory" table. Within this same form I would like to have the ability to write information to the "apstatus" field of the "databaseparents" table. I would like to do this without a subform as this form needs to be in...
I get a "cannot open the specified file" error message. It points to the "Application.FollowHyperlink strInput, , True
" portion of the code.
I also tried this code instead "Application.FollowHyperlink [CompanyWebsite], , True" but get the same error message. I have tried taking the brackets...
This is what I have tried but it does not work--I have tried flipping things around but are clearly taking blind shots.
Private Sub Website_Click()
Dim strInput As String
strInput = Me![CompanyWebsite]
Application.FollowHyperlink strInput, , True
End Sub
I looked at the F1 help for SendObject and think I have a handle on the bcc: part. Unfortunetly--the rest of it was complete giberish to me on how to do the rest of my goal.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.