Search results

it's a short-form way of checking for null and a null (empty) string in one shot. you can't use cstr because if it is null you get a runtime error trying to convert a null. so you could say: If Me.txtID = "" Or IsNull(Me.txtID) Then ... but when you use the short version (If Me.txtID & "" =...

just put all the tables into a query, add the columns you want, create a report based on the query and organize the fields in the order you want. use headers and 'sorting and grouping' to keep things together the way you want.

you can send the id when you open the 'add' form: docmd.openform "frmAdd",,,,,,Me.ID then in the 'add' form's Open event you could say: 'set the id when the form opens If Me.OpenArgs <> "" Then Me.txtID = Me.OpenArgs End If or you can not send the id, but when the form closes do: 'set the id...

you also have to use the correct terminology. what you're saying now is completely different than your first post.

i seem to recall someone trying to do this a long time ago. do a search for someone trying to nest subdatasheets. i don't think it was possible programmatically. (as i recall he seemed to know what he was doing, too). i think he was trying to access the table-level property 'subdatasheet' but...

haven't looked at this much but you said: if you manually set focus to the form and its subforms (which loads the embedded subform) the code works again. what if you set focus in code as needed?

you could use the On Exit event of the subform to ask the user if they want to save the record. if No, Me.Undo.

as soon as you leave the subform, the record/entries are saved. you could reset the focus to the subform then delete the record.

Screen.ActiveForm

Me refers to the form, not a control on the form. try: me.lstBox.rowsource but if the rowsource is a query, that will only get you the name of the query. then you'll have to get the rs from the query.

http://www.access-programmers.co.uk/forums/showpost.php?p=524039&postcount=13

agree with dcb. make sure there are no parameters. if you need them you could add: Dim prm As DAO.Parameter ... 'Evaluate and set the query's parameters. For Each prm In qdef.Parameters prm.Value = Eval(prm.Name) Next prm Set rs = qdef.OpenRecordset ...

add: DoCmd.RunMacro "macroName"

you could concatenate all the fields before Text3 into one textbox and all the fields after Text3 into another textbox and position Text3 as needed in between the other 2. then use conditional formatting on Text3. (format --> conditional formatting). might be tricky but possible.

- put the form in design view. - select the button. - view/properties. - go to event tab. - in the On Click event, select [Event Procedure] - click the small box to the right (...) - you should be in a code module for the form, and specifically in the On Click event procedure for the button. -...

i'm not checking this, but i think you have to go to 'Sorting and Grouping' then make a selection under 'Keep Together' or something like that.

Me.sfrmName.Form!chkboxName = True

Items is public. can you get to it by adding: using ShoppingCart; to Cart.aspx.cs? Edit: it's protected. well, not sure now unless you "unprotect" it. // A protected constructor ensures that an object can't be created from outside protected ShoppingCart() { } or perhaps store session...

still don't know what you mean by 'save the selections to the table'. you are already seeing values from a table. where are you trying to save the selections? and how. can you show us what you are trying now? can't explain what's wrong if we don't see. tnx.

you might also try: Dim srchplant As String srchplant = Me.Text18.Text if this textbox is unbound.