Search results

I have an Access 2002 DB that is a friendly interface to a back end SQL 2000 server. This uses 'linked' tables. One of the fields within a table in the SQL table is formatted to dd/mm/yyyy hh:nn:ss. I wish to write a query that will allow me to select records between two certain dates. The...

PLEASE DO NOT RESPOND TO THIS. I HAVE DONE IT USING THE Me.com_asset_number.Requery Thanks Anyway.

I am creating a 'Delete Item' form. The user selects the Asset Number from a Combo List, this then displays the record details in the relevant field. The user then enters some details in the Delete fields, They then click on the Delete record, which actually just saves the record in the table...

Off to go at that now. Many Thanks

I have many text and combo boxes on my form. But for the purposes of this question I am only referring to three. Text1 = Asset_Number Text2 = Site_Ref Text3 = Location Text 2 and Text 3 contain relevant information in a table called 'tbl_locations' OK, based on an After_Update event of Text1...

Thanks Pat. I did the onload event for the form and did the DoCmd.GoToRecord , , acNewRec All sorted thanks very much

How would I get it so that as soon as you open the form you are looking at a blank record rather than the first record in the tbl? The Combo box works great but it would be nice to be presented with a clear screen on form load All the Best

Excellent Pat, exactly what I wanted. Many Many Thanks

I am almost embarressed to ask this. I feel it is such a simple thing to do, and yet I can't work it out. I have a tbl that I want to be able to edit the contents of a record through a form. I want to be able to select the records unique Identifier from a combo list of asset numbers. So...

Thank You. That is what I ended up doing anyway while I was waiting for a response. My thanks to you anyway

I have a form which contains alot of fields that are disabled until such time as a user has filled in other fields. When the user clicks on the 'Save' button, I would like the form to RESET itself to how it was when they first opened it (fields disabled etc) Without closing and reopening the...

Thank you for the response.

I have a 'Add new Data' form which is set to prevent edits delections etc etc. I created a duplicate of this form to create the Update/Edit records form. I set the properties of the new(edit) form to Allow Edits 'Yes' and everything worked great, until I set the properties of the form to Allow...

Thanks Rich I did it with this code Private Sub Warranty_Period_AfterUpdate() Dim dateX As Date If IsNull(Me.Date_of_Purchase) = False Then dateX = DateAdd("yyyy", Me.Warranty_Period, Me.Date_of_Purchase) Me.Warranty_Expires = dateX End If End Sub

Is that code doing the right thing? THe only reason I ask is that it does not appears to be work, albeit I have done what you said I was looking to add the date of purchase to one box, the amount warranty (in years) to another box, and then code take over and populate the 3rd box with the 1st...

Thanks, I will give that a whirl Toni

I have a warranty field that I am trying to create. I want the value of this field to be Date_Purchase (Date/Time) + Warranty_Period (Number) = Warranty_Expires e.g. 17/08/02 + 2 (years) = 17/08/04 I would like to do this calculation at the point of entering the record Anybody?

Off to have a look now Thanks

I know this might sound like a stupid question, but is there anyway around it? I don't have any patch installed, I assume thta it comes predone with Office XP In thinking about it if there was away around it they are not going to tell us are they cause then those who want to abuse the fact...

I have the code setup to email a report I have created in RTF format to a predefined e-mail address. What I don't know how to do is stop the windows message that comes up saying that " An Email is trying to be sent. This maybe a virus, Press Yes to continue with this request. I just want it to...