|
viewing tables and queries
Sick and tired of opening and then re-sizing. How do I get Access to
remember the last size and position each time? Careful of response, more of
a user than a programmer. THX in anticipation......
|
4 |
23.09.2006 13:16:27 |
|
|
Bookmark a continuous form
I've tried looking at other posts on this but actually think they are more
complicated than I require as most are using subforms.
I have a continuous form and against each record is an edit button which
opens a single form for the prupose of editing. This form is opened in
dialog and the main form requeries when I close the dialog form.
However I want to bookmark the record in the ori...
|
3 |
23.09.2006 12:29:04 |
|
|
internet explorer 7 V7.0.5700.6
After loading IE 7 I am unable to access web sites that require micromedia
flash player. I hve V 9 loaded before the IE V 7 download but the system
does not seem to find the program. I am sure it is a configuration/setting
issue but I have tried everything I can.
Pete
...
|
2 |
23.09.2006 11:52:49 |
|
|
just clicking the number on index page the respective page opens..
...
|
2 |
23.09.2006 11:12:03 |
|
|
I want to delete a menu page which is printing on my documents
I need help. I believe I was hit by some bug or either I changed something
and can not figure out what I did. I need to delete the menu page from
printing when I sent a document to the printer. The menu/information page
looks like the following:
File name:
Directory:
Template:
Subject:
Author:
Crreation Date:
ETC,ETC
This page is printing out before each of my word documents. P...
|
4 |
23.09.2006 11:09:16 |
|
|
Text Wrapping in the Column Headings
Is it possible to have your column headings in a table in Access have the
text wrapping feature which is offered in Excel?...
|
4 |
23.09.2006 10:13:01 |
|
|
importing data from excel the come from a webpage
I copied webpage contents {Ctrl+A,Ctrl+C} and pasted{Paste Special,Text only}
it on Excel. What I would like to do is to transfer the data to Access table
without editing anything from Excel. Is there a code or a way in Access that
searches for a [fieldnames together with the data under it] in Excel
eventhough it is messed up, meaning the fieldnames are not located on the
first row and ...
|
1 |
23.09.2006 05:14:01 |
|
|
lost product key microsoft 2003
is there any way i can get the product key or do i have to purchase a new one
again?...
|
2 |
23.09.2006 03:52:01 |
|
|
Air Code Mr. Goldgar Cascade Listbox to highlite, select closest
Wow, was looking back through the post and found where you had replied. I
probebly shouldn't havn't started a new thread but was thinking I have never
seen a post simular to this one. I even checked Monster Access and couldn't
find anything simular.
If you can figure it out, This code should probebly be posted on your web
site. I can see where this code could be very useful for an ...
|
8 |
23.09.2006 03:23:13 |
|
|
Totals from 3 queries in one report
I have very basic Access abilities -- and unfortunately do not use it
regularly.
I created three queries because I wanted to total each query using different
selection criteria.
After struggling with not so nested ifs and recalcitrant parameters, I have
each of the three queries producing several different column totals based on
the criteria specific to that query. [e.g., one quer...
|
3 |
23.09.2006 02:58:01 |
|
|
Access closing by itself
Does anyone know of a setting that makes access close by itself when you are
not using it? or in microsoft.
But I think it only happens to his access database, no other applications....
|
8 |
23.09.2006 00:45:32 |
|
|
for loop question
In the following code I want for 'x' to be read as a variable (change
dynamically) in the sql statements, but it reads it as a character.
by the time the loop runs for the second it tells me that table x has
already been created.
I want for 'x' inside the sql statement to incremently change by 1
every time the loop runs. the FOR loop syntax is o.k., but maybe the
reason why it doesn't wo...
|
2 |
22.09.2006 22:36:29 |
|
|
Backing up open access database
I’m doing scheduled backups of an access database (which may be open) from
drive “C†to “D†using a batch file identifying an “xcopy†script. Can
anyone identify if I will corrupt the database in either drive if the
database is left open?
Thanks....
|
3 |
22.09.2006 22:17:48 |
|
|
ACCESS Scrambling
We have an access 97 database that someone was working on when we had a power
outage. When she opened it back up, the data in each record had been sorted
wrong. An example is The address from record one was in record 2. How can
this be fixed. I have always trusted access over excel more because of
sorting problems. Now I am not so sure. Any help would be appreciated.
Thanks...
|
4 |
22.09.2006 21:48:37 |
|
|
Convert Access to SQL Server, but keep Access front end?
I have been given an old Access application where the Access is not
only the database, but the front end as well.
There are forms, reports, and several buttons simply display the raw
tables, in what appears to be Access's native data table display.
I was asked to move the data into SQL Server, but keep the front end in
Access for now.
I know if this were an app using ADO, I could go in a...
|
6 |
22.09.2006 21:48:09 |
|
|
2003 unsafe expressions warning
We are just now installing Office 2003 on all of the pc's in our company.
When opening an Access Database we receive the warning about unsafe
expressions and would we like to block them. I changed the macro security to
low and no longer receive this message. Is there another way around this or
is there something we should be changing in every database? I'm not sure we
really want all...
|
3 |
22.09.2006 21:45:06 |
|
|
Populate field based on If statement
I am trying to populate a field based on an IIF statement in a query. My
problem is I need to be able to create an expression string.
I need basically for the field to populate itself with different criteria
based on a string of IIF statements.
Basics are that if the Age field is less than or equal to 3, then populate
Grade field as ES and if the Age field is equal to 4 populate Grade...
|
6 |
22.09.2006 21:44:40 |
|
|
Opening a Form w/ Subform as clean slate
When the form is opened, and nothing is inputted into the search field,
the subform has the first record viewable. The search field and subform
are linked. Is there a way to make it so nothing comes up when the form
is loaded?
...
|
3 |
22.09.2006 21:31:09 |
|
|
set the value event procedures
...
|
3 |
22.09.2006 21:16:15 |
|
|
Text in continuous subform
Hello,
I have this continuous subform with a few records. I need a label frame next
to some of the records to provide an explanation. Is there any way to do that?
I suspect that due to the nature of continuous forms there isn't, so I was
thinking about changing the form to a single form. I'd have to tell each of
my then multiple text boxes which record to show, ie. text box 1 is to show...
|
4 |
22.09.2006 21:06:02 |
|
|
on excel program, i am not able to move slide bar.
the slide bar moving from colums a-z+ i am not able to return back to
original colum.my work is stopped because of this.assistance needed
immediately, thank you.i have the windows xp-home version....
|
2 |
22.09.2006 20:38:40 |
|
|
ControlSource - Question
Hey all, hope someone can help me.
I have a form, with several fields and a button to insert information
from these fields into one table.
I also have a comboBox that gets information from another Table, but
inserts this information at the same table every field does (the table
name is Default).
My problem is, the way everything is working, when a user selects
anything from the comboBo...
|
2 |
22.09.2006 19:58:36 |
|
|
Data Access Pages & Subforms
I am trying to create a data access page from a previously created form. I
am doing this by using the Save As option. The data access page saves, but
when I open it the subforms within my form are gone. Can a data access page
support subforms? If so, do I first need to save each of my subforms as data
access pages and drag and drop them into data access page of my new form?...
|
2 |
22.09.2006 19:51:02 |
|
|
Combobox loses list
I have a form with a combobox to list equipment ID but I can't get the box
to keep the list after the form is closed. I have it where it will add an
item and prompt you for entry if it does not see it in the list but it will
not keep it. Any suggestions?...
|
3 |
22.09.2006 19:50:02 |
|
|
how do I run code from switchboard button
in the switchboard manager. if I enter the function name xxx() in the
Function field after selecting the command:"run code" and then try to run the
code by clicking on the appropriate button, Access returns an error.
if I enter the function name xxx() in the find case code instead of
rs![argument] then it all works fine. Unsatisfactory and of course this would
only work if this was the on...
|
9 |
22.09.2006 19:39:01 |