Search results

Hi, MS developed the MS Access Runtime, included in MS Office Developer Edition, which run you Access-application.

OK, Maybe you could do something with this: http://www.lebans.com/setgetsb.htm it's designed for Forms, but (I didn't look) maybe it can be altered to apply it on a memofield.

Steve, You can use this code ie in the Click-event of a commandbutton on your form

I got the db and have send it back to you. The problem was that you assigned a Control Source to your Calendar, so clicking your calendar sets the value of “MyDate”. I deleted the control source and it seems to work properly. Greetz

Hi keden, I'd think the only thing you need is to put the code in the AfterUpdate-event of numb_of_p to open the second form (DoCmd.OpenForm "ppl"). After closing the second form you come back in the first. Each time you enter or change the value of numb_of_p, the second form is opened. Is...

I don't think you've to use CodeContextObject. This will also do:Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.Recordcount = 0 Then Beep MsgBox "You have No Records for the mentioned Period", vbOKOnly + vbInformation, "No Records" DoCmd.Close acForm, Me.Name End...

samehkh, Wouldn't that result in the same problem? A listbox standard starts at the top op the list, so u've still to scroll down to see the last item.

OK. see PM for the address

This is right for Standard modules, but when you declare a Public variable at Form-module-level, it is used as property of the form and so it comes back into the intellisense list. Private variables don't come back there. Keep in mind that the value of the variable only is hold while the form is...

Hi snicker, This can't have to do with the code on Calendar1_Click, but must have to do with some other code in your forms class. Is it possible to post the full code here (or attach a db with only the required form and tables)

Hi, What type of subform do you use? Datasheet or Continuous? What do you expect from the sendkeys?

That's for the most Free Trials, but your boss pays? The tools aren't so very expensive I thought?

You can do it without a query, by looping through the table with a recordset, but that's a lot slower than a query. Why don't you want it in a query? You can read a value from a table/query ie with DLookUp (well documented in Help)

1. Link the tables into the db where you want to create de query. When you've writing rights on the networkdb's, there will be no problem. 2. Yes, Create the query with the querydesigner, then save it and from VBA run DoCmd.OpenQuery "myquery" Or: Switch to SQL-view of the query, copy it and...

OK, The VBA-project is Locked? Try Google: "VBA password recovery" with seemly good results

But you can select all controls on a form and set the option for all that control in one time, so you've to set it one time for each form.

You could do that with an UPDATE query. For 'Change into' you refer to the field on your form. When you don't add criteria, de field will be updated for each record. Luck, Bert

Okay, Is it an .mdb-file or .mde? If .mdb, try starting the db with Shift-key pressed. Luck, Bert

Use this from Sue: Mo End Prof =Sum(IIf(([Prof]=yes),[dollars],0))+sum(iif(([Prof2]=Yes),[Dollars2],0)) But replace , with ; in an expression Bert

And this one?If Nz(Me!Delivery,"") = "" Then Me.Address2.Visible = True Me.Company2.Visible = True Me.Delivery.Visible = False Me.Address1.Visible = True Me.Company1.Visible = True Else Me.Delivery.Visible = True Me.Address2.Visible = False Me.Company2.Visible = False...