Search results

The syntax me.TblAcc.SubFamily is not correct. If you are using a multi-value field then you need this instead: cboCombo13.RowSource = "Select TblAcc.SubFamily.Value " & _ "FROM me.TblAcc " & _ "WHERE me.TblAcc.Family = '" & cboCombo13.Value & "' " & _ "ORDER BY TblAcc.SubFamily.Value;"...

Well, upon closer examination, it looks like you are trying to compare a date with 'REWORK' ORDERNO = ORDERDET.ORDERNO WHERE (ORDERDET.DUEDATE = "REWORK") AND (ORDERDET.DUEDATE >= "01/01/13") ORDER BY ORDERS.ORDERNO ;

Okay, in the form's ON CURRENT event you can use something like this (for this example let us say we have fields named FName and the "fake" control is named FName_Fake and LName and the "fake" is named LName_Fake) Private Sub Form_Current() Me.FName_Fake.Visible = (Len(Me.FName &...

rodmc - A shorter way than that is to use the NZ function Expr:Nz([CF1],0) + Nz([CF2],0) + Nz([CF2],0) ...etc.

Already told you - the LOST FOCUS of the actual control the real data is going in. See my code.

MSAccessRookie's solution should work for your immediate problem. However, if you have the possibility of things being added, then the table method makes sense as you can just add however many and it won't require any rewriting of the queries.

Put another text box over the one you want this to show. Put the text in as gray in that text box's Control Source like ="Enter Value". Then in the Got Focus event you can hide it: Private Sub ControlNameHere_GotFocus() Me.TextBoxNameForInputHere.SetFocus Me.ControlNameHere.Visible =...

What do you mean by translate to a table? Do you mean to put in a table the values and then be able to return the appropriate value based on the table? If so, what I would do is to first create a table with two fields ItemName ItemValue and under ItemName you would put V0XSLLS, VOXSLA...

I believe I found it. Put another End If in just above the Next and see if that helps.

My initial guess is this part: (ORDERDET.DUEDATE >= "01/01/13") In Access you need Octothorpes (#) instead of quotes on dates: (ORDERDET.DUEDATE >= #01/01/13#)

Maybe a little corruption creeping in.

You have your Next and last End If in the wrong place. It should be like this: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.Tag = "Required" Then If ctrl.ControlType = acTextBox Or ctrl.ControlType =...

Go to Control Panel > EASE OF ACCESS CENTER > MAKE IT EASIER TO FOCUS ON TASKS and down near the bottom is the ADJUST TIME LIMITS AND FLASHING VISUALS and then HOW LONG SHOULD WINDOWS NOTIFICATION DIALOG BOXES STAY OPEN.

Siblings should not be fields in the table. It should be RECORDS. So, somewhat like this: tblPersons PersonID - Autonumber (PK) FName LName etc. tblRelationType RelationTypeID - Autonumber (PK) RelationDesc (like Child, Spouse, Self, etc.) tblPersonsRelations PersonID - Long Integer...

They should be similar as it was ChrisO I learned this from. And apparently I need to do some revision as I didn't have it quite there to begin with. :D

Re: Referrring to a subfrom with "me" If the code is in the subform's module, Me would be properly referring to the current class object so it should work. But remember, it isn't instantiated as a form in the traditional sense when it is running as a subform.

Does each one of them have their own copy of the database frontend or are they running off of the same file from a central location. If the central location, you really do need to give them each their own copy. If pushing updates to the frontend is a concern I have a free tool to help with...

Okay first off you would need to use For Each ctl in frm.CONTROLS or did you just accidentally omit it in the code you posted here? Second, your reference to set them is not right. What I would do is create a Function like this in a standard module: Function SetFocusCtl(strFrm As...

I don't trust Name Auto Correct in the database. So, I use Rick Fisher's Find and Replace (but it costs). Another free tool is V-Tools and the tool in that called Total Deep Search. It can do replacements as well.

Can you make a copy of the table, try to make the change and if it squawks at you see if emptying it and then changing does it. If that happens then it is your data.