|
Sub Form Back Color...Transparent?
Hi, I inherited a database application that has a main form with two sub
forms. I added a picture to the main form but the subforms have a white Back
Color property of 16777215 shown in the subform's Detail section of the
property list. The Special Effect is Flat.
I can change it to whatever color I want except to transparent. I want the
picture on the main form to show through sub fo...
|
5 |
15.09.2006 05:39:05 |
|
|
Adding a new Record to a Subform - Programmatically!
Hello ALL!
I have a subform (which is not bound to the main form though it has a
SQL statement as its' Recordsource).
I would like to add a new record (based on a code snippet that I wrote
that determines the previous "business" day - allowing for Holidays,
Sundays etc.,).
My first record in the subform is the date of the query - based on the
Textbox entry in the Main form. I would l...
|
2 |
15.09.2006 03:18:45 |
|
|
Is there a way
Is there a way to add a date stamp to a text box on a form. This does not
have to go to a qry or a tbl. Just on the form so that before i pull my
payroll reports i can see if my District managers has approved the time. Or
does anyone have any suggestions....
|
2 |
15.09.2006 00:19:12 |
|
|
Link Master/Child Fields?
My Main Form has as its Record Source the Product_Family table. This is the
same table that is the Record Source for the "grandparent" control, a
combobox. Changes in the combobox are reflected in the first subform
"Company" Which has Company Subform as its Source Object. The controls on
this subform are populated by Query2 which is based on the Company table with
reference to the Produ...
|
8 |
14.09.2006 23:18:19 |
|
|
customize custom toolbar at run-time via VBA code
Can commands on a custom toolbar be added removed at runtime via VBA code?
Where can I find sample code?
Can the main Access menu (File, Edit, View, etc.) be shown or hidden via VBA
code? sample code?
Can the built-in 'Forms' toolbar be shown or hidden via VBA code? sample
code?
Thanks!
...
|
5 |
14.09.2006 23:16:45 |
|
|
Vertical ordering of continuous form
Hello,
By default with a continuous form the data scrolls vertically in a downwards
direction. Is there a way to make it so that the data scrolls horizontally
in a sideways direction?
Thank you,
Patricia...
|
2 |
14.09.2006 23:02:20 |
|
|
import and update file in my form
I have in my form command button by clicking on button i will import from
excel file data to tblImport table. The import part is working. The problem i
have, sence my excel file has 3 worksheets and each worksheet has name. So
when i import these 3 worksheets to same table i will need also update field
'TABNAME'.
It will work if i have 3 command buttons for each worksheet.
Please let m...
|
2 |
14.09.2006 21:15:02 |
|
|
Subform double click on a row?
I'm helping out another friend and Access isn't my strong point :)
Subform is created with a query of 50 columns out of a "property locations"
table. Subform shows only 10 columns defined out of the 50, and they are
stacked up. When form runs Access does a cross tab in it's display and
shows a grid. I'm cool with that.
How can I catch a double click on the row in that grid, and show...
|
3 |
14.09.2006 21:01:12 |
|
|
Patient Scheduling Nightmare
OK, I have been assigned the charge of sheduling 250+ patients in 5
physical therapy clinics. The system they were using before was a
centralized excel spreadsheet(by centralized I mean the patients were
not seperated by clinic but all lumped into one list, including the
patients that had stopped treatment meaning over 3000 patient entries).
I've changed it to one sheet for each clinic but I...
|
2 |
14.09.2006 20:43:08 |
|
|
How do you link corporate offices to branches in access?
I am trying to set up a way to link corporate offices to branch offices in a
access form that we use to track customers. ...
|
2 |
14.09.2006 20:36:25 |
|
|
Dynamic Form for Mold Tooling
I am building a database to replace a paper system that keeps a record for
each mold being used at the plant. With each mold is a specific number of
cavities (1, 12, 16, 64, 96, etc). Each mold has a certain numbering system
for the tools that can be placed within the caviites, there being a seperate
set of tools for each moldset (1A, 1B, A16, etc).
The problem I am running up against...
|
1 |
14.09.2006 20:14:01 |
|
|
value selected in combo box - not visible
I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In...
|
4 |
14.09.2006 19:54:02 |
|
|
Text gets truncated and garbled in memo field
I have a form with one text box. Users copy part of the data from a field on
one form and paste it into this new form's textbox. The data is correct in
the textbox on the new form after pasting. There is a button on the form that
runs an update query that inserts this memo text into a table. However, the
text in the table gets cut off and the last portion of the data is several
garbage c...
|
2 |
14.09.2006 19:46:56 |
|
|
Opening a specific record from a switchboard using a combo box
I think I have a couple of issues:
I created a switchboard using the switchboard manager. It works fine.
However, I want to add a combo box so the user can choose to go
directly to a particular person's record. So I've done that, and the
code I've written behind it is:
Private Sub Combo24_AfterUpdate()
DoCmd.OpenForm "Main", acNormal, , StudyID = Me![Combo24]
End Sub
So my first ...
|
2 |
14.09.2006 19:39:35 |
|
|
Sending information to two different tables
How do I input data into a form and have it sent to two different tables?...
|
1 |
14.09.2006 19:27:02 |
|
|
Search form by date
Hello All,
My database tracks daily system errors or issues that occur. I have a subform
that a user can enter updates throughout the day or week about the issue
until it is resolved. The problem is going back to enter an update into a
subform record several days later without clicking the previous button
several time.
I have a form that I would like a user to be able to type in a cert...
|
1 |
14.09.2006 19:18:29 |
|
|
PivotChart Aggregates/Summarizes Data Unexpectedly
Hi All,
I've created a pivot chart in Access 2003 based on a query. The chart
displays a dollar amount for a given report date. I do not need to aggreaget
the data. Therefore, I've enabled the "Plot detail Records" option on the
"Data Details" tab in the properties dialog for the Chart Workspace object.
The issue I'm seeing is the dollar amount is much greater than expected.
...
|
1 |
14.09.2006 19:10:02 |
|
|
dlookup
any idea why i get #name
=DLookUp("[OpenBal]","Table11","[Date] =" & Format([Forms]![Date3]!
[BeginningDate],"\#mm/dd/yyyy\#"))
thanks
--
Message posted via http://www.accessmonster.com
...
|
4 |
14.09.2006 19:04:46 |
|
|
new record input form
Is it possible to have the input for a new record, appear at the top of a
form rather than the bottom?...
|
2 |
14.09.2006 18:32:02 |
|
|
Make Query Conditional using a Text Field on my Form
I have a Form that prompts for selected information and an OK button that
opens this query:
SELECT tblCPVDSL.ID, tblCPVDSL.DslID, tblCPVDSL.ActiveID, tblCPVDSL.
ResoldVoiceTypeID, tblCPVDSL.Acct, tblCPVDSL.VpVciDlci, tblCPVDSL.
CustomerName, tblCPVDSL.Phone, tblCPVDSL.CKTID, tblCPVDSL.LATA, tblCPVDSL.
InstallDate, tblCPVDSL.Order, tblCPVDSL.CWCPtypeID, tblCPVDSL.dtmAdded,
tblCPVDSL.strModi...
|
3 |
14.09.2006 18:01:00 |
|
|
MS Access97 Date
Hi Everyone.
I'm trying to change a numeric date into a short date. Can someone
assist me PLEASE??
Thanks to all in advance!!!
...
|
6 |
14.09.2006 17:29:13 |
|
|
Return Day of Week Constant
I need to be able to take a date field and convert it to a day value. For
example I would like to input 9/14/06 on a form field (Cmb_Work_Date) and
display "Thursday" in another field (Cmb_Work_Day_of_Week).
Thank you in advance for any and all input....
|
3 |
14.09.2006 17:28:20 |
|
|
Another tricky one
We are making a db to collect pictures of animals & plants in the area. WE
want to take the picture on said object and have it automatically go into an
OLE field.
We have made the field and have managed to put a picture into it. HOwever
when we actually insert the .jpg file only the filenalme is displayed. Any
ideas? This is also a very small db thus I do not need any thing too fancy.
...
|
2 |
14.09.2006 17:28:01 |
|
|
Requery as part of Got Focus
After moving my pointer in my underlying table with the Clone, I want to
requery a subform that is part of the same main form.
DoCmd.Requery & Chr$(34) & Me!Parent![Group Subform] & Chr$(34)
DoCmd.Requery "Query1"
Neither of the above works -- where am I going wrong, Mother darling?
--
Dave
Temping with Staffmark
in Rock Hill, SC...
|
6 |
14.09.2006 17:23:26 |
|
|
Again on Calendar
Sorry I have already posted this once and got no reply I am in the wrong
place should I post this in a different section?
Thank you,
Lorenzo
Hello, I have an application to keep track of apartments's bookings. I have
it fully functional but I would like to add a feature and I would like to
have some guidelines for the implementation. Basically I have a reservation
table and an apartmen...
|
4 |
14.09.2006 16:45:25 |