Search results

Hello all, I'm trying to implement a replicated database for users in the field. However, my boss, who knows little about these things, is afraid that we'll be losing data somehow. I'm trying to reassure him that this won't happen (often anyway). Can someone explain to me how Access keeps...

Adding to Fornatian's post... Therefore you can SORT ON or SEARCH BY FirstName or LastName. If they were in the same field this wouldn't be easy. The problem you may be thinking of is joining them which is a rather simple... Textbox.ControlSource =FirstName& " "& LastName

Steve, Yeah, I tried that already and it didn't work. Thanks for your input.

look into DAO.recordsets...You can set a recordset to your subform's recordset and then use rs.FindFirst method will take you to the actual record in that subform. i.e. rs.FindFirst "[MemberID]=" & Me.MemberID Remember to set the rs=nothing when finished!

Don't know how familiar you are w/ DAO.Recordset, but when you set the recordset it's set to the first record in the recordset. You may need to use rs.MoveLast method to populate the recordset to use Count. Now were you to set a subform to the same recordset, then all 6 should be displayed.

Say you want to subtract the data in one column from the next. Try the columns property... Me.FieldName.Column(0)-Me.FieldName.Column(1) If this makes no sense then look up "Columns" property in help. HTH

You can do this one of two ways:By 1.)adding a field to the query or 2.)adding a textbox to the form and setting its controlsource to the equation you want. I'll submit the former. Go to your query and add a field to it. (i.e. calculated field). You can make as many Calculated Fields as you...

You need to add the Where Condition to the OpenReport Statement. Docmd.OpenReport "YourReportName",,,"YourRecordNumberField="Str(YourForm'sTextFieldThatHasTheRecordYouWant) Try that...

OnClick: If Me.EOF = true then DoCmd.GoToRecord , , acFirst Else DoCmd.GoToRecord , , acNext End IF

Could you try putting the [totals] field in the page footer instead? Also try setting the CanGrow, CanShrink = true for the larger controls in the details sections(if any exist that is). Just a few thoughts.

Would you submit your button's code?

I don't know if this helps, but in the OnOpen Event for your form put the following code.... DoCmd.GoToRecord , , acNew Then in the form's AfterUpdate Event put the following... DoCmd.GoToRecord , , acFirst HTH

I think you can only change the default in design view>>then change the defaultview property and then re-open the form again in form view. BE WARNED! This looks really bad. I've tried it. You can try the Echo command at the begin and end of your procedure to clean up the look, but this can...

That's really wierd. I can get the other calendar control to do the same thing w/ a little work. It's too bad because it seemed that this control did everything that I needed. All is not lost while I learned quite a bit about references that I didn't know before. Who knows...one of these days...

KevinM thanks for all your replies on this. I cna't believe that I haven't got it yet. All the references are there, but this DTPicker control still doesn't show up on the one machine. I'll keep at it. I just wanted to thank you.

It's not in the list for that machine That's just the thing...It's not showing up in the list of ActiveX controls as it does on the other machine. So I've developed this app on a particular machine and now it's going to hose up on any other machine because of this control? How can this be? I...

It's actually DTPicker Here's what the property sheet shows... MSComCtl2.DTPicker.2 It's just a combobox/calendar control for picking dates. It's a Microsoft Common Control. I can't find that class. Does that tell you anything? I think I need to add a reference to that class, but where is it?

I'm looking, but it's not available though.

Hello all, I've had no luck scouring the prior "missing references" posts to resolve this. So here goes... I've added a DataTimePicker control to my app. It works quite well, but I'm missing that control reference on another machine I'm using. Can someone clue me in on how to add that control...

Look at Tab.Value indexed starting at 0 you could put the code in the On Change Event on the tab control itself select case Me.tabControl.Value case 0 case 1 etc... end select or something like that