Search results

Yes that can be done. I am assuming the steps should be done consecutively. So if you 100 checklist, 3 records. 1st record of 100 should be completed first? on current record, use the recordset method, go through the fields, if one of them is unchecked, set the focus to that field, if all...

Sorry, i think the extra open parenthesis is doing that. SELECT a.name, a.empnumber, b.[1981], b.[1982], b.[1983], b.[1984], b.[1985], b.[1986], b.[1987], b.[1988], b.[1989], b.[1990], d.[1991], d.[1992], d.[1993], d.[1994], d.[1995], d.[1996], d.[1997], d.[1998], d.[1999], d.[2000]...

From Access Clip: NotInList Event — Event Procedures Example The following example uses the NotInList event to add an item to a combo box. To try this example, create a combo box called Colors on a form. Set the combo box's LimitToList property to Yes. To populate the combo box, set the...

USe the NZ. (Null to Zero if Integer or Null To Empty String if string) [Forms]![MyForm]![MyParameter] OR NZ( [Forms]![MyForm]![MyParameter], 0) = 0 or NZ( [Forms]![MyForm]![MyParameter], "") = ""

I'm a little confused about all the words of threes and ones I am seeing, so I dont understand what you are trying to do. If you could send me your program, please.

Embed your union query (here called a) in another query ; A left joining the three tablles. Here, cut and paste an SQL editor. I used Access 2000, so tell me if it doesnt work, i'll redo in it in a 97. SELECT a.NAME, a.EmpNumber, b.[1981], b.[1982], b.[1983], b.[1984], b.[1985]...

DO a Union SQL.

You're right Pat, I didnt really read his whole story, just honed on his goal so I cut and pasted an old code. I figure, he'll figure it out himself. :)

after update of each textbox: dim winningstring as string winningstring = trim(str(me.textbox1.value) & str(me.textbox2.value) & str(me.textbox2.value)) if winningstring = 111 or winningstring = 333 etc then msgbox "won"

recheck the record sources.

drag the section label to page header, then on View, Sorting and Grouping, choose section, set keep together = whole group

Try putting a letter in front of the first entry so Excel when it sees it has an Alphabet in it, would treat it as string. Just one data.

Sub BetterLookingCheckBox() Dim ctlBLC As Control For Each ctlBLC In Me.Controls If ctlBLC.ControlType = acCheckBox Then ctlBLC.Value = "" ctlBLC.Requery End If Next Me.Form.REFRESH End Sub

Have you tried relinking first? Make a copy of the database program first , so you dont have to reverse it later. IF the tables are in the server , copy them into the database then run the your forms from the table in the database. If its fast, then could it be your rights to the server...

DoCmd.RunCommand acCmdPrint

Yes it can be done, by dashboard if you are talking about a chart, you can create a chart.

You can design your form to look like a table - datasheet view.

you can create a query ShortVErsion : left(stringnumber, 2) on one grid. THen create the combox from that query.

Really? What version of Access are you using? :confused:

Access keeps an internal count of total number of fields in a table and has a limit of 255 fields per table. Each time you modify a field or add a field, this count increases by 1. When you delete a field, Access does NOT reset this counter. So it's possible for you to have less than 255 fields...