How can I move data from one open form to another? For example, the current form has a variable intHeaderKey. Suppose it contains 1234. On another form,...

I am trying to pass a key from one form to another form, not a sub form. In the originating form I have the following code: Private Sub...

Hello, When I display a form in datasheet mode, then return to Form Display, some Long dates display as a string of # signs. Can anyone point me to a fix...

We have recently upgraded to Access 2007 and I have a form that causes Access to crash when I make a control (text box) dirty by typing in it, then move to...

I have a database that is closing down each time i right-click on a form. It doesn't matter whether i try to use a custom shortcut menu or the default one....

I have two simple forms... "First" and "Second". If FIRST is open, I can open SECOND from the database window... no problem. (Then only code behind these...

I have a Form “Developments� with a subform “Lots�. My “Lots� table has a auto number key . I want to display fi;tered “LotDetail� form...

We have 2 simple forms...."events" and "stop orders". With "events" loaded and opened I can open "stop orders" from the DB window. If I put a CMD button on...

I have a form that requires the user to enter a value based on what the data is on the previous record. Does anybody know how to do this?

I am trying to work out how I can set the properties of a field so that it stays greyed out unless a particular field's entry is True. I am writing a database...

Hi I am trying to simply my code in a application by using a sub routine to amend the control properties of a form but I can't seem to get basic to accept the...

Hi, I have setup a db to records peoples tasks and need to secure it. I know there are two main ways (MS built in and build it yourself) but am not sure what...

Is it possible to have up to 12 names selected from a multi select list box appear in up to 12 seperate text boxes?

PROBLEM I have an Access 2000 databse I developed on a Windows 2000 machine. This application uses custom menus with VB code to turn the menu items on and off...

Hi All, Have been tearing my hair out (what I have left) trying to figure out the VB for the following; I have a table which contains a column of Product...

Using Access 2000 I've created a Pivot Table in my form & when I open the Pivot into excell it won't "refresh on open" even after I've selected that option...

Hi, I would like to complete and controls on a form, and have a third control be automatically populated from a table where is the primary key. Given...

My colleagues and I have a problem that occurs while designing access forms and it isn't helped by the fact that our applications have a lot of buttons on...

I have a report that displays in a snapshot viewer control on a form. I make changes to data on the form based upon the information on the report. After I...

I have set the database window option so that the database container window remains hidden when the database is opened. Everything works fine. When I call the...