Search results

I need help on this one, too. I have found that those two properties don't really work the way I expected them to. In the mean time, here is something that may help you. On the other tab for the form, the first two properties are Pop up and Modal. Also, on the Format tab is a property for...

If the row sources for the list box and combo box are the same (especially the bound column for this solution), then on the click event of the list box, set the combo box = to the list box forms!MainForm!subform!ComboBox = me.listbox If they aren't the same, please post how they are set up.

Not that I am questioning you...just trying to make sure... In the table, the data is actually now only 255 characters? If this is the case, are you doing an update or append query? Or on the form, only 255 characters are being displayed. If this is the case, are you sure the other...

Have you checked to see if it is on your Install CD for your operating system (Windows)? Typically, those types of files go in the System Folder (ex. C:\Windows\System --> for Windows 95). (I am really not sure about that .dll, but this is one place I would check, so I thought I would post...

You can put a statment to requery the show dates combo box on the After update of the show names combo box. It will look something like this... On After Update of the Show Names me.ShowDatesCombobox.requery I am assuming that you are using the value of the show names combo box as part of the...

You almost got it! Your line of code should be: Me.RecordsetClone.FindFirst "[URL] = '" & Me! [combo8] & "'" (I added another ampersand after your combo value and another quote. I know its hard to read like this but after the me![combo8] is: ampersand, double quote, single quote, double...

On the Open event of the form, check to see if there are records. If me.recordsetclone.recordcount = 0 then... This will give you some control if there are no records (send a message box ,etc).

Can't you create a report for them to print? On the report, you can make the text field grow (by setting the CanGrow property for that field on the report to yes) to whatever length. Then you could put scroll bars on the screen and have the best of both worlds (it seems like you need to have...

here are a couple of ideas (may not be the best)... 1.) you could hide an unbound field on your form and update it every time the value you want as default is updated. Then set the default value for the field to: =nz(me.txtHiddenFieldName,"") When a new record is created it will put whatever...

I think that you might have to build a criteria statement using a string variable if you want your form to be that dynamic. You could then set the filter property ( the filter would be like the WHERE clause of a SQL statement, but without the word WHERE) of the form (or report) to that string...

Hi MackDaddy, I am not sure I understand what problem you are having. You have loop through the items selected property of the list box. To store other values besides the bound column of the list box, you have to reference the column by index. Columns are zero-based, meaning 0 is the index...

I sent you an e-mail with an attached database with a sample of how to do it. Is this the same problem as the one you have posted under queries? [This message has been edited by DML (edited 07-07-2000).]

I am assuming that you are using these dates in a query or SQL statement. Could you post that statement, please?

I don't know whether the Macro will do it, but I know you can set a particular tab's focus in the "On Open" event of the form by: Me.MyTab.pages("PageName").setfocus

If the query for the list box doesn't take too long to run, you could put the requery statement on the "On Current" event of the form. Then, every time the user moves to a new record on the form, the list is refreshed. Watch out, though. Current fires a lot and this may (but may not -- you...

I am not sure I understand the question, but a table is where your data is housed (always). A query is a way of viewing (and manipulating) that housed data. You could actually experience a performance increase by using a query in some cases. A little House Cleaning Tip: If you begin to use...

Is your form bound directly to the table? If so, you can make a query out of the table that the form is bound to. In the query grid, select the sort option for the field or fields that you want the data sorted by . Bind your form to that query instead of just the table.

By "without using Visual Basic", do you mean you don't want your users to have to use Visual Basic? You can "build" a SQL statement based on the user's input in Visual Basic, which would allow the user to choose any number of fields and a value for those fields. Is that what you are trying to do?

Here's another way (just to give you options): NOTE: If Yes/No field is Check box then use the following code. If it is a combo or list box, you will need to adjust the code accordingly. On the After Update event of the Yes/No field, put this code: if [me].[nameofYesNoField] = Yes then...

To add to Pat's advise, you can use: Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.ControlType = acTextBox Then If Right(ctrl.Name, 1) = "2" Then ctrl.SetFocus ctrl.Value = "2" Else ctrl.SetFocus ctrl.value = "1"...