Forms

Remove Filter Sort
Hi I want to refresh the data in a form programatically. I have a main form where the user can update a value in the form's underlying data by double clicking a control on the form. Doubleclicking opens another form that allow him to update the value. The reason why there is a separate form just for up... 1 Jul 2008 18:31

Forms based on a query
Hello, I created a query based on an inner join between two tables: SELECT Panels.[Panel Name] AS [Panels_Panel Name], Panels.BreakerCt, Panels. [Location Name], Panels.[Panel Building Number], Panels.[EMTS Number], Panels. Source, Panels.Manufacturer, Panels.[Main Breaker Rating], Panels.[Main Bus Rating], Pa... 1 Jul 2008 17:29

Transfer contactID to Event Registration
On a Contacts form, I want to be able to register a contact for an event, and when I click on the button I want the contact's information to appear on the registration form. I have this code that I thought worked, but only opens up a blank registration form. Any help would be greatly appreciated. Private S... 1 Jul 2008 16:27

Access set fields equal using visual basic
I have a form which acquires info from the user, including a date. I would like to put another spot on the form, invisible to the user, which would be two work days prior to that day. later on i use this date in tables which are auto-linked to the form. i'm trying to use visual basic, with something to the e... 2 Jul 2008 12:55

Save Command?
I need to put a save command inside an If Not statement. I've tried a lot of things but can't get it to work. The one here in my original code is old. What should it look like. Public Sub cmdSave_Click() ' Put focus on "key" control Me.ContactFirstName.SetFocus If Not SaveIt() Then Exit Sub ... 2 Jul 2008 08:48

Text you entered isn't an tiem in the list BUT IT IS!
Hello All: I have an issue: I have a combo box on my form that looks up chemical products from query. I can select the combo box and use the dropdown to select chemicals to add to the record. All has been working great until today. There is one particular product that when I choose from the combo box list... 1 Jul 2008 15:25

Text you entered isn't an tiem in the list BUT IT IS!
Hello All: I have an issue: I have a combo box on my form that looks up chemical products from query. I can select the combo box and use the dropdown to select chemicals to add to the record. All has been working great until today. There is one particular product that when I choose from the combo box list... 2 Jul 2008 21:10

RoundDown
I'm using this to Round Up. Public Function UP(MyField) UP = Int(-100 * [MyField]) / -100 End Function Is there something that I can use to Round Down? Thanks DS ... 2 Jul 2008 11:54

Variable in module to reference form
I have a routine in a module that I use to pass and order number and set the focus to a form, change the contents of a control, then fire its after update event to update the form. Normally I call the form and controls specifically, but I want to change the form name to a variable so I can use the same routine... 2 Jul 2008 16:01

Return the week # for a given date?
"John Vinson" wrote: On Wed, 10 May 2006 08:04:01 -0700, Sarah <Sarah(a)discussions.microsoft.com> wrote: Does anyone know of a function or set of functions which can retrieve the week number for a given date? For example: Given date 1/16/2006 would return 3 for the 3rd week in the year.... 1 Jul 2008 14:23