Search results

Just comment out these two lines and see what happens: strNameFull = [NameFull] 'THIS IS THE NULL Me!NameFull = strNameFull ' Copy name into new task record Like i said, there is no need to add namefull to the new record as it will do it automatically via the master/child links. It is still...

If u use acDataForm, then u have to specify the name of the object as the next argument. DoCmd.GoToRecord [objecttype, objectname][, record][, offset] e.g. DoCmd.GoToRecord acDataForm, "frmPlan", acNewRec I don't think i have ever used it like that. I guess if your trying to go to a new record...

Take out the acDataForm DoCmd.GoToRecord , , acNewRec U may need to check for a null value first. for example: If NOT IsNull(me!Version) THEN intVersion = 1 'for 1st task of new person, [Version] is zero If Me![Version] > intVersion Then intVersion = Me![Version] ... Me!Active...

Ahhh yeah i see what u mean. Only thing i can think of is to disable/remove the close button (x) and create your own close button on the form. The add some checking into that as well: Private Sub cmdClose_Click() Dim strFields As String strFields = checkFields If strFields <> ""...

Yup, nice and warm up here :cool: What's it like in Melbourne? My bro has all their cd's too :D What's your favourite song?

Well u have to keep your sense of humour, otherwise you'll go crazy! ;) 1. It's funny how u sometimes forget things. I just realised that the correct, and most likely easiest way to do the job series title is with a simple combbox. No queries or sub forms involved. Just create a combobox...

Do u have any other code in that same form/module? An AxtiveX control maybe?

Change this rs.FindFirst "[ID] = '" & Me![cboEvalNameSelect] & "'" to this rs.FindFirst "[ID] = " & Me![cboEvalNameSelect] The extra ' ' are only required for text. Or to keep all your code the same use: rs.FindFirst "[ID] = " & Str(Me![cboEvalNameSelect]) I'm not sure if your filter is doing...

Your query qryVersion has reverted back to a previous version i think, lol. Change it's unique value property to No and remove the criteria from nameFull. That should fix frmPlan i think. In your frmEval subForm properties, the Master Link is still set to name, should be now nameFull...

Try: nametemp = me!name btw, name is not the best word to use as a field in a table, as it's used by access a lot. For example, me.name will return the name of the form. Access can get confused sometimes, so it's better to add something to the front of your field names. Like if in your...

I'm not sure what's happening there. I'll post your sample back so u can have a look at what i did. Dave

1. The problem lies with your subForm, sfrmPlan. Change the Data Entry property for the form to No. I'm not sure what your trying to do with version. Your version combo does nothing but select a version form the list at the moment. It seems as if your doubling up a lot there. U have version...

So u have something like this?SELECT * FROM myTable WHERE [myID] = " & forms!myForm!myComboI've done something similar except instead of referencing the combo directly, i call a function that returns the value of the combo, and if it's blank u can return something else like '*'. so u would...

Assuming the last entry has the latest date? SELECT TOP 1 notes.Notes, notes.NotesDate FROM notes ORDER BY notes.NotesDate DESC; Will select the latest entry.

srchResult = DLookup("[level]", "Employee", "[user_id] = '" & me!TXTEmployeeidentry & "'") Thats assuming user_id is a text field...

As it says, you have either mispelled the name of your switchboard or perhaps u are confusing it with somthing else? In your database window look for your switchboard under the forms tab...

If your talking about a couple of fields from a single record then it would be easy enough to reference the fields from the report: forms!frmName!txtFieldName Otherwise the best way would be to use a query... Any reason why u don't want to use a query?

Not using RunSQL (that i know of anyway). U could if u were using ADO: Private Sub AddRecord_Click() Dim rst As ADODB.Recordset Dim intVal As Integer Set rst = New ADODB.Recordset rst.Open "Customers", CurrentProject.Connection, adOpenKeyset, adLockOptimistic rst.AddNew...

The find duplicates query should work if your only searching for duplicates in the SSN field. How do u know which record to delete? Are all duplicate records the same for each SSN?

Are u sure it's the backend and not just the database window for the front end? Look under Tools->Startup and see if Display Database Window is checked.