|
Subreport Wizard
Using Access 2003, updated today with service pack 2, the subreport wizard
does not appear when I insert a subreport into an earlier report. I went back
to the installation disk and reinstalled all the wizards. Still nothing.
Suggestions?...
|
2 |
29.09.2006 20:06:00 |
|
|
Append query
Hello,
I have three related tables, A, B and C, with both A and B being in a
1-to-many relationship with C. A-> C <- B
I want to populate table C by taking one record [ID] from table A and many
records [IDs] from table B, and have in table C - which contains fields with
FKs from both table A and B's PK IDs - a number of records with one and the
same FK from table A, but all the ...
|
7 |
29.09.2006 19:10:02 |
|
|
Object Folders in Access
Hello,
It would be great if Access allowed you to make folders in the database
window. In other words, when looking at the 'tables' view in the main
database window of an MDB file, you see a list of all the tables that the
database holds or is linked to. It would be nice to be able to put folders
in that view, so that you could group the tables by relevance.
Suppose you have a bu...
|
3 |
29.09.2006 20:05:01 |
|
|
Right mouse button doesn't work in Access sometimes.
A data entry program was created and when I try to use the right mouse button
to check properties on fields in reports, the mouse button does not work but
key F4 does. ...
|
2 |
29.09.2006 19:01:21 |
|
|
Memo fields truncated by TransferText
Ok, so this is a topic virtually beaten into the ground on this
newsgroup. After searching and working on this issue for a while, I
have decided I won't get any further much faster without help.
As the topic states, my memo fields are being truncated on export. I am
using a VBA script in my Access 2003 database to read in a CSV file,
process it, and export it into CSV again. I have verified...
|
2 |
29.09.2006 18:58:31 |
|
|
Cannot make MDE
Running Access 2003 on Windows XP Professional. Database has 2 forms (1 of
which is hidden), 88 queries (including Deletes and Appends), 3
converted-macro modules (and one VBA that I had some MVP help with!), and 6
tables (2 structure only).
VBA code is compiled, datbase is repaired and compacted. Performance is
analyzed and I have a few relationships that it's asking for (I am not ...
|
4 |
29.09.2006 18:52:48 |
|
|
using a form to control show hide fields in a query
i am looking for a way to cause fields in a datasheet subform to be added or
hidden if a check box is checked. i have a form that has a huge list of
records from a query and it would help if some columns could be hidden or
added to the results.
...
|
2 |
29.09.2006 18:51:46 |
|
|
Checking for opened form
Hi
How can I check in code if a form is currently open i.e. running?
Thanks
Regards
...
|
5 |
29.09.2006 18:51:01 |
|
|
Input Parameters for a Stored Procedures used by Forms
I have the following stored procedure which features input parameters that
are retrieved from a form and then the resulting records are displayed on a
report:
ALTER PROCEDURE quality_user.SP_NCR_Details
(@StartDate datetime,
@EndDate datetime,
@Inspector varchar (50) = NULL)
AS
IF @Inspector IS NULL -- return all records
SELECT NCR, Issued_Date, Qty_Rejected, Disposition, Item, ...
|
2 |
29.09.2006 18:34:00 |
|
|
what are .dll files and how can they become corrupted?
I've been having problems opening Access over the past day and I think I've
isolated the problem to various dll files used by Access not being tied to
the correct registry.
What are dll files? Any reference materials on them?
(And yes, I know modifying the registry is potentially dangerous, and yes
the computer's been backed up.)
Thanks.
Dave
--
Brevity is the soul of wit....
|
4 |
29.09.2006 18:23:40 |
|
|
Access 2007 with Dual and Quad Core CPUs
Does any one know if Access (in the future) will take advantage of the Dual
and Quad Core CPUs????
If so, Like what OS and Office version will???
Thanks,
Gary...
|
3 |
29.09.2006 18:16:46 |
|
|
Query Help
I have a query that pulls alot of data with many dates. I would like to set
the querey to prompt for a range: enter Start date- then enter End date. Once
those dates have been inputted the query just shows the date range entered.
Help would be much appreciated.
...
|
4 |
29.09.2006 18:15:02 |
|
|
What is the limit on fields to pri in Access and can I change it?
I am trying to print an inventory d/b from access. I get an error " too many
fields to print, please decrease the amount of fields and try again" What is
the limit and can it be changed?...
|
8 |
29.09.2006 17:47:02 |
|
|
Relative path & image
Hello!,
is possible use relative path in access? for example use "photo\image1.jpg"
instead of "c:\db\photo\image1.jpg", I try it but I cann't, but in Visual
Basic if is possible.
Other question but relationated, Is posible don´t put a path to the picture
in the image control (in desing) ?
The Database will be move frecuntly and it will give error in the form load
because the path...
|
2 |
29.09.2006 17:41:06 |
|
|
Can't specify help file in package wizard
I have created a custom help (.chm) file for my access application using HTML
Help Workshop. I thought that I would be able to specify the help file name
when I ran the package wizard. However, when I get to the package wizard
screen where the help file may be named I find that the Browse button is
"grayed out" and I cannot type anything in that help file field. Did I miss a
step here?
...
|
1 |
29.09.2006 17:13:01 |
|
|
I am having problems merging access to mass mailing in Word.
This was working last month. I am going through mail wizard and when it
comes to previewing/editing addresses, it says I have no addresses. What did
I do and how do I fix it?...
|
1 |
29.09.2006 16:50:02 |
|
|
Rounding issue
I am trying to calculate a value on a form from known information. everything
seems to work properly except with one specific set of data.
ROUND((2.65/8.48)*0.4,2)
The actual non-rounded answer is exactly 0.125, so you would assume that
with the "round" the answer would be 0.13, but for some reason Access is
returning 0.12. This same formula is used on 30,000 other sets of data and i...
|
7 |
29.09.2006 16:39:55 |
|
|
Structural problem: Add unknown amount of data through a form
My database is coming along, but I am now stuck. My project tracks
employees, who are assigned to a work section, by each day, and what
"station" they are working at. I have a form which allows an end user
to input a work roster for each date. The form allows for a name to be
put into each work station field. This is not a problem. My unknown
variable that I can't seem to deal with is wh...
|
16 |
29.09.2006 16:38:59 |
|
|
remove text
i have an address field called addr that list the street address, city,
state, zip
ex
33 Oliver St, Reading, MA 06103
i want to get rid of the comma after the street address the city, state zip
...
|
14 |
29.09.2006 16:28:11 |
|
|
tick all check boxs with one click
I have a Form called "Paid". Within the Form I have a Subform called
"Paidsubform". What I would like to do is Check one box on the Form and this
to be applied on all the records on the Subform.
--
Thank you for your help...
|
6 |
29.09.2006 16:22:38 |
|
|
Nested IIF question
We have a database for tracking clients through a series of classes. There
may be 4, 5, or 6 classes in a unit. We want to do a report that shows the
LAST class date in the unit. I suppose I should use a nested IIF statement,
but I'm not sure how to do it. I want to say that if Class 6 date is null,
print the date of Class 5, but if Class 5 date is also null, print the date
of Class ...
|
9 |
29.09.2006 16:19:04 |
|
|
Apply filter command button code
The following code:
Private Sub Command160_Click()
If Not IsNull(Me.Combo59) Then
Me.FilterOn = True
Me.Filter = "[Company] = '" & Me.Combo59 & "'"
Else
Me.FilterOn = False
End If
End Sub
Is correctly applying a filter, but subsequent clicks only repeat the last
filter I applied. After I remove filter (using the menu bar button), and
move to another record, with ...
|
2 |
29.09.2006 16:15:01 |
|
|
Cont for nothing in a char column
I can't seem to get my count right? Below is my query and return data to
show what is really there. Any ideas on how to get the count proper?
SELECT Alterations.Date, IIf([Shirt 1]=" ",0,1)+IIf([Shirt 2]="
",0,1)+IIf([Shirt 3]=" ",0,1)+IIf([Shirt 4]=" ",0,1) AS ShirtTotal,
IIf(IsEmpty([Shirt 1]),0,1)+IIf(isEmpty([Shirt 2]),0,1)+IIf(isEmpty([Shirt
3]),0,1)+IIf(isEmpty([Shirt 4...
|
8 |
29.09.2006 16:14:20 |
|
|
Run Excel Macro from Access and save changes to .CSV format
I am trying to run an Excel Macro from MS Access. The code will open a
..CSV file
along with my personal.xls. The desired result is to make some type of
modification to
the file (Remove extraneous commas, etc.) and then save it back into a
..CSV format.
The code seems to work but I believe it is erring when Excel fires a
dialog trying to
confirm if I really want to save into .CSV (loose an...
|
5 |
29.09.2006 15:54:44 |
|
|
Is there any way to "block" these posts that are dated in the futu
I use IE to view this board, and these Chinese char posts dated three days
ahead are always on top of my view......
|
6 |
29.09.2006 15:41:02 |