|
Combo Box Data
I have a combo box on a form That lists subjects last name. When I pick the
subject I want it autopopulates the entire subject record (This is a good
thing) The problem I am having is that everytime I entire the same subject by
way of the combo box into a new record it saves the subject again in the
database. So if I entire a subject into a record 100 times It will list his
name in the c...
|
7 |
11/17/2008 9:06:07 PM |
|
|
Jump ahead one month
I have a room reservation app that several forum members have been
kind enough to help me with over the last few weeks. There is a blue
rightward pointing arrow head at the top of the form that progresses
the users through the room reservation **one day at a time**. Please
see link.
http://209.200.80.147/test/SampleForm.html
The code for this button was suggested by a forum member and it...
|
10 |
11/17/2008 8:33:33 PM |
|
|
How do I add load zoom commands to control ole in msaccess 2003 fo
...
|
1 |
11/17/2008 8:19:02 PM |
|
|
Separate Records Merging
I am working with a report where records with the same last name are merging
onto the same page despite having unique first names.
How can I get the report to acknowledge the unique first name?...
|
2 |
11/17/2008 6:43:02 PM |
|
|
Wrapping Memo Field in Report
I have a memo field in a table and would like to know
when placing this field in a report how to format
it so that the Memo fields wrap.
...
|
3 |
11/17/2008 5:09:57 PM |
|
|
Multiple inputs to a field
I have a field whose name is nomenclature, I have another field whose name is
SAP number. Nomenclature is for repair parts and SAP number is the number
associated with the parts. I repair devices and want to put multiple parts
associated with the number into the fields. I have other fields in my table ,
ie, customer, address, ... On my form I am making and linking to these fields
I will ...
|
3 |
11/17/2008 4:01:06 PM |
|
|
Error message regarding duplicate values
I'm still working on my first database and am inputting select data to test
it.
This is a school database which includes teachers who may belong to more
than one dept. and/or have more than one title. I have tables that account
for these relationships (tblDepts, tblDeptsEmps, tblTitles, tblTitlesEmps as
well as tblEmps).
Today, I tried inputting information for Co-Dept. Chairs and am ...
|
2 |
11/16/2008 11:57:01 PM |
|
|
what are proper settings
I can not figure out the setting needed to make this work.
can you or any one assit me?...
|
3 |
11/16/2008 10:32:55 PM |
|
|
Multiple Records
I have a corporate database that has multiple directors, officers and
shareholders and would like to list all of the directors in one list box in
the form...so if I pull up ABC Company and click on the director name it
lists all of the directors. 2ndly when I search sometimes that person could
be in all three categories...is there any way that I can do a search and have
it pull up every...
|
32 |
11/16/2008 2:38:07 PM |
|
|
Database Review
Ken
I was wondering if I could send you what I have for review. I am not
getting the results that I should be with the subforms. It is showing 3
records for Director and 3462 for Officers and 3600 for shareholders...I am
pretty sure that one company doesn't have that many shareholders. LOL. You
would really help me out if you could review this and advise me of things
that I have done wrong...
|
3 |
11/16/2008 2:38:00 PM |
|
|
trouble with mail
i can't seem to get this to retrieve my mail from yahoo or any other sites....
|
2 |
11/16/2008 2:15:43 PM |
|
|
Access SQL
I am wanting to use an update query in Access - I notice that you can
assemble the SQL visually by clicking fields and putting conditions in
certain fields, but I also noticed you can edit the SQL directly.
If I write my own SQL will the visual bit still work ?
I want to update a number of fields based on a condition - the field I
want to update depends on the value already in the fiel...
|
4 |
11/15/2008 6:35:44 PM |
|
|
Summing an entire column in Excel
I am working on an excel sheet for expenses. Each time an expense is added it
is added to the end. I want a total at the top of the page. I do not want to
update the SUM formula each time a line item is added. If I sum from E7
through E10000 I get the correct answer even if cells E50 through E10000 are
blank but, when I try to print it, it gives me 67 blank pages. Is there a way
to find ...
|
3 |
11/15/2008 5:42:00 PM |
|
|
Using data in a CSV to update a DB
I have a CSV file containing some records - one of the fields is a
membership number that matches a key field in my access DB. I want to loop
through all the records in my CSV and then update the matching records in
the DB based on a condition.
I would like to do this in VBA if possible as I have used it before. How do
I open the CSV and loop through it - read the Membership Number and ...
|
4 |
11/15/2008 12:47:16 PM |
|
|
Access
Is there a way to include a value from a text box on a form as part of the
path name when using transferspread in a macro.
C:\documents\DeptScrapbyArea (insert deptNo from form text box).xls...
|
4 |
11/15/2008 5:00:13 AM |
|
|
"Id is not an index in this table"
My database was working fine until earlier today when my computer locked up
just as I was finishing entry of a new record. Since that point, I am unable
to open my database and get the above message (error 3800). Is there a way
to fix this error?- I am using Access 2007.
Thanks in advance...
Ang...
|
6 |
11/15/2008 2:18:48 AM |
|
|
Add a All Option in Combo for Report
I have a popup form when I select a report command button, the form has one
combo for names from a qurey where I can slect individual reports, I would
like to have an "All" in the combo drop down list.
My query's criteria is: [Forms]![frm_ReportSelector]![cboSelectInspector]
I seen something where I can add it to the criteria but can't find it.
Also a lot of post take me to a site that de...
|
5 |
11/15/2008 1:50:19 AM |
|
|
Web Toolbar
using VBA how do you close?
Thank you all
Bre-x
...
|
3 |
11/14/2008 9:26:10 PM |
|
|
Prevent/Allow multiple users editing new or same records
The answer to my problem is probably somewhere on the forum but I just can't
seem to find it. I apologize in advance if this has been rehashed over and
over.
Multiple users will be using my DB simultaneously. Users will open a form
(CreateNewDoc) to enter data and retrieve a five-digit document number that
acts as unique identifier to issue to and "name" electronic documents
(someth...
|
2 |
11/14/2008 7:11:02 PM |
|
|
Lookups
I am super new to Access, but am seasoned in Excel... have come to a point
were I think my Excel doc should really be in Access... so I'm trying it out.
I see that Lookups in Access are not the same thing as they are in Excel, but
I want to be able to, in Access, lookup a value and its corresponding piece
of information as can be done in an Excel lookup function.
I suspect that I am ta...
|
9 |
11/14/2008 7:06:26 PM |
|
|
How to set no Duplicated for comboBox list?
Hi,
What should I do that the combobox list not show the duplicated items?
Thanks for any help,
Mimy...
|
2 |
11/14/2008 6:19:52 PM |
|
|
How do I set format for table text field?
Hi,
I would like to set a table text field that character starts on left.
Please help!!
Thank you,
Mimy...
|
5 |
11/14/2008 3:46:18 PM |
|
|
Split form keeps opening up too large
I have a split form that keeps opening up way to large. I have tried
adjusting the Auto Center, Auto Resize, Fit to Screen properties but I'm
still having problems. Are there settings that will allow the user to adjust
the size of the popup form and for current size to be saved so it will open
the same way the next time the form is opened? There isn't a lot of info on
the form and it ...
|
4 |
11/14/2008 3:13:01 PM |
|
|
Permissions Error
I have designed 3 individual data bases in access 2003. These data bases have
been installed on a computer that runs access 2000.
One of the Data Bases opens without a problem. The other two will not open
with an error message that says:
"You do not have the necessary permissions to open this data base"
Could anyone please advise what the problem could be?
Thanks for any help...
|
2 |
11/14/2008 2:53:01 PM |
|
|
Importing CSV
Hi
I get an error when trying to import csv file with the following structure:
"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","304"," 490020","Zakup
us³ug-Warsztat","594,00","Ogó³em US£UGI WEWNÊTRZNE NAPRAWCZE :","594,00"
"Data:2008-10-17 13:15...
|
3 |
11/14/2008 2:33:01 PM |