|
two questions: table question and Is there away to link an outside document to access
I'm not sure if this is possible; I have a database currently that
lists all of our products with related information. First I have a
query that downloads information from a table, I need to update this
once a month to capture newly added information like new product #'s.
Also with this new data I need to create new table fields so a user,
on a form can enter in information that will download...
|
3 |
10/24/2008 8:40:35 PM |
|
|
a "popup" form
On a status page, i have a query-fed list box (which has multiple columns).
what i'd like to do is when someoen clicks on one of the records, i'd like it
to open up a small form that shows some information that isn't shown in the
listbox already (there isn't any room and it'd look crappy.)
Batch Status Page is the original form. Earliest Date in Batch is the
"subform" if you will. I...
|
8 |
10/24/2008 5:06:37 PM |
|
|
Searching Form and Subform
Dear friends,
I have a form frmCases (from tblCases) and a subform frmMessagesSub (from
tblMessages). The two tables are linked (one to many) using the CaseNummber.
A field in the tblCases is called CaseCode, also in the related tblMessages
the same field (CaseCode) is found.
I need in my Form to enter a CaseCode and then to search the MainForm and
also the subForm for that CaseCo...
|
5 |
10/24/2008 4:59:05 PM |
|
|
If Then Else
Would someone take a look at my code and see what I missed please. My goal
is to choose dates for when we acquired the item, drop down for Product
Number 1-3 (cbxProdNo) and a dropdown for a text Item (cbxItem) and view a
report of the result.
Private Sub cbxItem_AfterUpdate()
Dim strsql As String
Set db = CurrentDb
Dim rst As Recordset
...
|
5 |
10/24/2008 2:11:48 PM |
|
|
OnChange event delete records
I have an [Invoice] form with [Service] combo box. Depending on the service
selected one of six [Details] forms display for user input.
I would like the [Service] OnChange event to wipe out the [Details] of the
existing service. Each service's details are in a separate table, as is the
invoice. The tables have enforced referential integrity. I want to ensure I
delete only the disp...
|
9 |
10/24/2008 1:59:01 PM |
|
|
Stop #deleted from showing in a subform
Access 2000 base code
I have a form with four subforms. I have code that deletes one row from
each of two different subforms. When I do that I see #deleted displayed in
the subform's controls briefly then the controls are blank. I don't want to
see the #deleted at all.
I've tried docmd.echo and application.echo. That does not work.
I tried to requery on the subform, that worked, n...
|
2 |
10/24/2008 5:25:15 AM |
|
|
Play sound or video files
I've tried using shell filename but I got an error. How do I iniate sound
and video files from with Access?
Thanks,
...
|
3 |
10/24/2008 4:09:04 AM |
|
|
VBA-Field Pop up
Hello. I am trying to get the vba in the double click of a field to do two
things.
1. Unlock the field
2. Run a macro called "mcr_ZoomWindow" that creates a pop up window that
allows you to see area of 4"x4" or tryping space.
The below code is what I got so far and it obviously doesn't work.
Can you help?
Thanks.
Iram
Private Sub ECSS_Call_Notes_DblClick(Cancel As Integer)
Me.E...
|
3 |
10/23/2008 11:48:02 PM |
|
|
code filing
Using Access 97 I coppied my db from this coputer to another - worked fine.
Now that I have coppied it back again the following code is failing:
nz(LastDate,dateserial(2005,12,31)) >= nz(DateFld,date())"), 0)
Run-time error '62436':
Function isn't available in expressions in query
...
|
6 |
10/23/2008 11:31:43 PM |
|
|
Multiple If Then Else Statments
I am new to coding and fairly new to access. I set up a dialog form that has
two control boxes, the first one is a regular text box with a date mask and
the second one is a combo box with three drop down options "DSAC"; "ORR";
"URB". I created two Command buttons, the first one is to view a query of
all the current animals, the second one is to run a macro which then opens a
report to ...
|
5 |
10/23/2008 10:09:33 PM |
|
|
Writing to and Reading from DB Properties window
I am looking for a way (VBA or Macro) to write a value entered into an
unbound field on a form to the DB properties screen - File>Database
Properties>Summary>Category and also to the Custom tab to the Group which is
also a text value.
How do I reference these values later if I want to use them on a report or a
form.
I have looked at the "Set Properties of Data Access Objects...
|
4 |
10/23/2008 9:05:02 PM |
|
|
Do not want form to advance
Hi All,
Access 2003 on XP.
I am rebuilding my database.
How do I make it so that a form does not advance to the next record (or try
to add one) when you hit enter?
Thanks!
...
|
3 |
10/23/2008 8:41:31 PM |
|
|
Reprinting
I added printing of a report to a command. but I want the command to generate
printing number on the report any time i print the report. secondly I want
the printed report to be store in a different table with the printing number
generated, so that I can reprint the report base on the code generated on the
report...
|
2 |
10/23/2008 8:38:28 PM |
|
|
Using entered fields to complete a record entry
I have 3 tables, an employee info table, a table of various actions and
subactions and a transaction table that draws from the first 2 tables.
On a form that looks to create new records in the transactions table, I
select the employee that it affects drawing that info from the employees
table(no problem here), then I select an action from a combo box populated
from the actions table. B...
|
4 |
10/23/2008 8:35:54 PM |
|
|
Incomple Query Clause
Hello,
I am trying to retreive a value from my database depending on which value
the user selects in a combo box. Here is my code:
Dim strSQL As String
strSQL = "Select ID FROM 'Computer Inventory' " _
& "WHERE 'PC Name' = " & Me.cboComputerName & ""
CurrentDb.Execute strSQL, dbFailOnError
Me.Requery
I keep getting an incomplete query clause error. I can't seem to fi...
|
5 |
10/23/2008 8:15:01 PM |
|
|
Append Query
I have an append query that updates daily which is ran through a
macro. Is there away to prohibit duplicate information or prohibit a
accidental duplication if someone ran the query manually?
Ryan...
|
8 |
10/23/2008 5:48:42 PM |
|
|
Combo can't find new record in subform
Using ACC2000:
In the main form there is an unbound combobox [cbobabyname] used to select
baby records in a subform. If a new baby record is created, the save command
button includes the code to requery the cbo. This works fine. Yet if the
new name is selected the subform opens on the first record in the recordset.
In debug, one can see that the recordcount for the main form records...
|
2 |
10/23/2008 5:44:01 PM |
|
|
Program Down Arrow
Hi Groupies
I would like to know how to program the down arrow button so that you can
move down to the next record in the field on a continuous subform.
The subform that I have is used in a couple of different ways in our
inventory database. I don't want to create a copy of the same thing just so
that I can change the tab order. However, when returns are being processed,
the only col...
|
5 |
10/23/2008 5:11:52 PM |
|
|
Carry Over Data in a Subform(SingleForm) within a Subform
Ok. Starting New Thread.
I have a subform within a subform
for adding multiple Job Contacts(tblsitecontacts) for each Job
(tblJobOrderInfo). The parent subform is within a Main form containing
Employer Information(tblEmployerInformation).
Some jobs have more than one contact and some employers have more than one
job order. When the contact info is the exact same for each job order an
...
|
1 |
10/23/2008 4:54:24 PM |
|
|
Calendar Control Problem
I have several forms that use calendar controls for users to easily select a
date which is used for criteria in pulling up reports and/or forms. On each
ON LOAD event of the forms, I had the following code to automatically choose
the current date on the calendar control:
Private Sub Form_Load()
Me.ChooseDate.Today
End Sub
Up until today, these controls worked ...
|
1 |
10/23/2008 4:21:01 PM |
|
|
set focus method
I created a form with a test boxt and command buttom. I need a situation when
I click on the command buttom, specified amount which i have put inside my
coode should appear in the text box. when i wrote this code and run computer
was giiven me this error:
You can reference a property or method for a control unless you the control
has a focus
My code
Private Sub optWith_Meal_Click()
...
|
4 |
10/23/2008 4:20:02 PM |
|
|
Test scoring app w/data entry form,item response table,subtest tot
I know it is highly recommended not to store a calculated field in a table -
I have read numerous questions and replies here similar to mine and I want to
ask anyway.
I am working in A2002 but will move it to A2007 within the year. Right now,
in 2002 (XP).
I have a tblData containing multiple records indexed by kid ID, date tested,
test ID, and scale (subtest) ID. A kid could have 4-...
|
1 |
10/23/2008 3:51:00 PM |
|
|
Msgbox for "Nothing to Delete"
Hello. I have a delete button that uses code I found here, but I want a
msgbox to say there is nothing to delete if the user is going through the
form pushing icons and the record is blank (for training purposes). It
seems so simple but I cannot figure it out.
Here is the button code,,,,,how would I have a msgbox pop up if they hit the
delete button and there is nothing to delete?
...
|
8 |
10/23/2008 3:03:42 PM |
|
|
Linked CSV Locking
I have several CSV files that I have to link to in the database I'm building.
They have to be linked because they update periodically throughout the day.
However, others need to link to them as well, so I'm looking for a way to
import them several times each day so users aren't locking each other out of
the files. Right now I'm planning on having an OnTimer event on my main form
that ...
|
12 |
10/23/2008 2:27:01 PM |
|
|
Can't refresh/requery/repaint textboxes
Hello All
This is a continuation of a problem I posted last week.
I have a form with 6 unbound text boxes that show various calculated values
(using DLookups etc.). The only problem is that the values are not
displaying when the form is first opened: the only way I can get them to
display is either to click on them, or to tab through them.
I have tried using the following commands i...
|
8 |
10/23/2008 1:58:09 PM |