|
subreport doesn't show up in report
After the switch to the new version (ms2007) a subreport in my database
doesn't show up. The place on the page where it should (used to be) is
blank. Can anyone help???
--
jmb...
|
1 |
12/10/2008 3:57:02 PM |
|
|
sending screenshots
I am testing a system and using an access 2007 database to hold tests and
issues information. When a test fails, I store the details along with any
references (screenshots in a word document) in an "attachments" field on my
database. I then send reports (snapshot format although this is not crucial)
to the system vendor with the test details and I would like to include any
referenced doc...
|
8 |
12/10/2008 3:55:01 PM |
|
|
linking normalized tables in forms
Hello,
I'm working on a database tracking subparts of oil wells in
production. The subparts, which we call targets, are identified by a
combination of fields including an overall well name and a set of
physical location identifiers. The physical location is denoted by
area + pattern + zone. Zones belong to patterns, which belong to
areas, which belong to systems, but zones have a many-m...
|
3 |
12/10/2008 3:25:15 PM |
|
|
Query Input
I need some input to help create a query between two of my tables.
The first table is structured like this:
tblBusinessHours
ShiftID - PK
Shift - Text
StartTime - Time
EndTime - Time
EffectiveDate - Date
EmpID - Number
The above table is used to create business hours for our hourly employees.
These can change depending on the business workload. That's why I have an
effective d...
|
2 |
12/10/2008 2:15:02 PM |
|
|
Report Error
I have a daily report that I run. When I click the command button I am
prompted for a date. For some reason when I enter todays date 12/09/2008 I
get an error stating that the expression is typed incorrectly, but when I
enter any other date it works. Any suggestions as to what I'm doing wrong?...
|
4 |
12/10/2008 2:14:04 PM |
|
|
Open Access 2007 with a form already open
How do i get access to open up with a form already open?
Im hoping to have all the information on the navigation pane hiden so
database is only accessable by using options in a frontend menu using form
functions ...
|
3 |
12/10/2008 1:43:01 PM |
|
|
Calculate Percentage
I need a formula that would calculate the percentage of clients who have been
in a homesless shelter less then than twelve months who have no more than two
placements settings.I Have the following fields in a query. DOE and # of
placements. Can someone help me
...
|
6 |
12/10/2008 1:38:55 PM |
|
|
I get a copy of the database called db1 when I close my database
Everytime I open and close the database the record lock transforms into a
copy of the database called db1, if I do this 5 times then there are 5
separate db's created such as db2, db3 ect...
How I can change this so that a copy is not created?
Thanks,
James...
|
5 |
12/10/2008 1:19:43 PM |
|
|
Text Effects
Hi,
Bit of a long shot but I was wondering if it is possible to add effects to
text on forms in Access. By effects I mean similar to websites; flashing or
scrolling text for example.
Not hugely important but thought I'd ask. Be grateful for any information
on this. Many thanks....
|
2 |
12/10/2008 1:03:06 PM |
|
|
I need help with checking emails
This is my first time using MS outlook. I was wondering if it was possible
to check my inbox(s) and how?
...
|
3 |
12/10/2008 11:38:20 AM |
|
|
having trouble with cancel
Hi
I can not get a cancel to work I have try a few variations but it still wont
work.
I have pasted the code below.
thanks
Jon
Private Sub ButUpdate_Click()
On Error GoTo Err_ButUpdate_Click
Dim db As DATABASE
Dim rst As Recordset
Dim blnok As Boolean
If Me![CmbFreeStsteStatus] = 2 Then
Me![ChkFreeststateDone] = -1
Set db = CurrentDb()
Set rst = db.OpenReco...
|
2 |
12/10/2008 8:40:13 AM |
|
|
trying to veiw access file
hi. i was sent a microsoft access file on a disk...i downloaded microsoft
access latest trial version...it will not open the file from the disk...i
guess they are 2 different versions....how do i open file if the version of
the file is different than the access version i downloaded...
|
3 |
12/10/2008 5:45:13 AM |
|
|
Lost macros and forms...happened right after zipping
Help...I have a project (in MS-Access 2003) that has a form and corresponding
macros that I have spent the better part of the day developing and was saving
locally on my hard drive. I zipped the file this evening so I could e-mail
it to someone. When I went back to open the original file, it just opened
blank without any tables, queries, forms or macros...I tried to compact &
repair an...
|
2 |
12/10/2008 2:47:54 AM |
|
|
Access
I work at a company that produces there product in Ln. Ft. is there a way in
access to enter data as "10' 2"" or even the equilivent "10.17" and have it
able to calculate a sum for the entries. I have it set up now that the entry
is a number I have selected all of the formats but it is unable to display
them correctly and always wants to do a count instead of sum.
...
|
2 |
12/10/2008 2:41:26 AM |
|
|
Primary Keys & Forms
All,
I have a table set up for New Employee Information. This table has an auto
number primary key field(which will become the Employee ID). I have a second
table for Employee Training which includes a foreign key. I have a
relationship set up between these two tables (Employee ID, First Name and
Last Name fields).
I have created a form to enter training information. I would like...
|
5 |
12/10/2008 12:00:24 AM |
|
|
Pictures in Access Database
Hello all,
I hope that someone will be able to help with the following. I have an
access 2000 database in which we treat orders. Sometimes we receive
wet and crushed goods. For this reason, my supervisor asks me to
develop something in our database, which enables us to see the images
of the wet and crushed cartons. I want to be able to click on a link
or a button on my access form and to s...
|
4 |
12/9/2008 11:56:04 PM |
|
|
how do i unhide items in access 2007
My office just upgraded to office 2007 and my access 2003 databases had
hidden items and i cant unhide them.. how do i do it?...
|
3 |
12/9/2008 11:32:50 PM |
|
|
Referencing a dropdown list box on a form
I'm trying to reference a list box. It defaults to 'select all' or lists
various business units. I have no issue with the 'select all' and then all
records by business unit shows up; I am having an issue with the query to
reference the list box though. I know how to reference it using the query
screen, [forms]![form name]![name] but can't figure out what is missing from
my SQL stateme...
|
5 |
12/9/2008 10:15:01 PM |
|
|
Access 2007 Runs Slower?
I took my database that I was using with Access 2002 and it seems to run a
lot slower in 2007, which I upgrade my computer as well, so it is much faster
too. Any idea why? When going from one record to the next, it would happen
almost instantaneous in 2002, but 2007 doesn't, takes a few seconds, the
spinning busy circle shows....
|
7 |
12/9/2008 8:19:19 PM |
|
|
workgroup file
I have my workgroup file in a different folder on my server but do I need to
only have read/write access for my users to the mdw file? Can I set up
windows security to that folder without "List Folder Contents" set to allow
so they cannot get into that folder directly? Will this prevent users from
getting into that folder and possibly deleting my mdw file. Is this a
safe/secure way?...
|
9 |
12/9/2008 7:50:01 PM |
|
|
Basing one data entry form on a previous record
Hello, I have been searching the forums for a solution to this problem and
have not seen anything that helps me out.
I am creating a data entry form that requires the user to make multiple
entries per associate each day. I was trying to streamline this process by
including a check box (or other control) that would copy some of the repeated
fields such as employee ID, date and number of...
|
7 |
12/10/2008 12:29:36 AM |
|
|
Adding info to imported text.
I receive invoices in a .txt file in which I import to Access to pull out
Stock Keeping Units (SKUs) along with some additional information (i.e.
description, value, country of origin, ect.) on the same line. The problem is
the store number is not included on the same line. Though the store number is
in the listed in the header. Is there a way I can pull the store number from
the header ...
|
5 |
12/10/2008 7:00:08 AM |
|
|
One page limit via print macro
I have a command button on a form that prints the form via a macro. SQL:
Private Sub PrintFunction_Click()
Dim MyForm As Form
Dim pageno As Integer
pageno = Me.CurrentRecord
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, MyForm.Name, True
DoCmd.PrintOut acPages, pageno, pageno, , 1
DoCmd.SelectObject acForm, MyForm.Name, False
End Sub
However, righ...
|
5 |
12/10/2008 4:43:01 PM |
|
|
check excel before importing
Hello everyone. Using Access 2003 on Windows XP
I have an excel spreadsheet I recieve from a customer that I import to
an Access table. This customer has the habit of changing the excel
format.
Is there a way I can grab the first row of the spreadsheet (which
would be the column names) and insert them into a table to check them
against the known column names that make the spreadsheet val...
|
5 |
12/10/2008 5:01:01 PM |
|
|
Delete Record question
Hello,
There is a database used by one user daily. Not big maybe at most maintain
about 50 records. Every month some records need to be closed so they don't
show on a report and the database has over 200 records that are not needed
for anything.
So my question is this:
Is it safe to place a button on the form to delete ALL records where the
Balance Change cbo reads "Closed"? I nor...
|
11 |
12/9/2008 7:38:16 PM |