Search results

If you create a command button asn put your Lock code behidn it that will work. However, a couple of other points Instead of If IsNull(Me.Narrative) Then I would use If len(Me.Narrative.value & "") = 0 then This way you won't get confused between an initially Null field on New Record...

The question seems straightforward but as ever, the answer can be complicated. Essentially you need to compare two lines of data, albeit one from the original data and the other the latest set. Imagine how if you were doing it the hard way, you would have two sets of data and then compare...

Sounds to me that all you need to do is have the RecordSource for the subform sorted in DESC order, so that the latest one shows first.

Just create a macro that uses OutputTo for all your eseential tables that you want to export.

Have you looked here? http://office.microsoft.com/en-us/access-help/irr-function-HA001228861.aspx

I would be playing about with some kind of formula or LookUp table that depending upon the value of your text box, changes the height and maybe width of the textbox.

You will need to do this by writing some VBA code in Outlook. To do this you are going to need to be proficient with the Outlook Object model. Are you?

When you say 'Compare Date' with the Current Date, do you mean = or > or < Having done the comparison, then what?

Well after a lot of searching for inspiration, I just went for it and this works. Dim lngTaskID As Long Private Sub Form_Open(Cancel As Integer) lngTaskID = 0 End Sub Private Sub TaskDetails_AfterUpdate() lngTaskID = JobDetailsID.Value Call myRecord End Sub Private Sub...

I have a Mainform F-Jobs; SubForm1 SF-Job Tasks and within this subform is a second subform SF-Job Task Details. This second subform is a continuous form Within SF-Job Task Details there is a field JobDetailsID In essence it is [Forms].[F-Jobs].[SF-Jobs Tasks].Form.[SF-Job Task...

Try this Dim myForm As Object Set myForm = [Forms]![FRMHomePage] ' note the ! not . Dim myField as string myfield = "txtFirstname" myForm.Controls(myField).Value = = "Laoistom"

What is useful is when you use the Yes/No option for the Message Box. For example putting a Command Button on a form where you are enetering some data and you want the user to check it is correct before closing. Private Sub cmdSave_Click() If MsgBox("Have you Checked the Data?" &...

This post should not be in Macros - rather Forms. Anyway ..... If CustomerID is an Integer number then: Docmd.OpenForm "Your Form",,,"[CustomerID] = " & CustomerID.value If CustomerID is Text then: Docmd.OpenForm "Your Form",,,"[CustomerID] = " & CustomerID.value & "" If CustomerID is...

The simply answer to your question is run an append query of the Employee's names into your table BUT ..... Access is about relational databases so there should not be a need to keep enetering these Employee Names. You need an Employees table and from linked to an Attendance table and sub form...

Have you tried DLOOKUP for the appropriate msg stored in a table depending upon the values of your field? It would be quite a complex Criteria with lots of AND's but should be do-able. An alternative you be to make a table with the msg's in that incorporates the field values which would all...

No - its kinda unlimited as the subform you use is a continuous form. (see attached pic)

One way would be to create a table and form which lets call them 'Document Hyperlinks' and 'F-Document Hyperlinks'. Enter into this table the path of the .pdf. By using VBA code to 'browse' to the .pdf location, you can avoid having to type in the path. Have another text field as a descriptor...

Here is a bit of code I have written to display the Next to Last or Last But One record in a SubForm. Needed to use the RecordSource property on Load. Hope you can pick out the fields and tables names. Used the Variable myRx as otherwise the SQL statement became far too long-winded and...

Sure: good point that with the Private Sub. My error but it doesn't seem to make any difference - (are you surprised it compiled?). That's about 10 databases I have to change now. Thank you for pointing out this technical error. (copy and paste is a wonderful thing!) No rush as the good...

I have a Main form with a Sub-Form in single form view. The subform is showing the last record. I have a button on the Main Form which when pressed I want to change the Sub Form to New Record. The Button code below errors because I have the wrong of Data Type for one of the arguments...