|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Friday, 4 August 2006
|
| Sort customers by postcode and print reports . Julian 23:35:03 |
| | Hi,
I am a very beginner in databases. I created a database table in Access 2003
and OOo 2.03 that includes name, address, postcode, phone numbers etc of our
customers. I would like to sort customers by areas of London, UK by the
first part of the postcode. The London postcodes are the form of E19 4PR,
NW5U 4RT. So I would like to print a report (customers arranged into Word
tables - normal tables, not database tables) for example which includes the
following zones of London: North East, East and South London and which are
represented by the following postcodes E(1-18), SE(1-29), SW(1-29).
Thanks,
Julian
|
| |  6 answers | Add comment |
|
| Jay Leno Message Board FUN......WIZ he is Bullitt 22:28:17 |
| | Subject: Earth IS The Black Hole of the Universe ! ( NBC )
On Thu 08/03, NBC
From: NBC Jay Leno Message Board
I thought you might be interested in reading this web page:
http://boards.nbc.com/nbc/index.php?act=ST&f=8&t=637679
From,
President of the United STUDS
Regards,
The NBC team.
http://boards.nbc.com/nbc/index.php
Reply Reply
|
| | 1 answer | Add comment |
|
| Access 2002 3709 Import Error SarahK 21:12:55 |
| | All,
I am trying to import a table from Excel, but I get the 3709 error,
search key not found. Any ideas? My TransferSpreadsheet method
statement is:
DoCmd.TransferSpreadsheet acImport, , "tblStaging", strFilePath &
"Temp.xls", True, ""
Thanks in advance,
Sarah
|
| | Add comment |
|
| Remove blank fields from a calculated text box Olveres 20:31:25 |
| | Hi,
I have managed to work out how to add new lines into a calculated text
box. However in this text box some of the outcome fields are empty
however when previewing the report it includes the blank fields, so
each section of the report is the same size, my field is set to can
grow/shrink, but I think my inclusion in the code for the calculated
box of all 15 outcomes (I have no choice) is what's causing each
calculated box to be the same size on the report. Is there a way of
making it only select fields where there is text? So some questions
will have three outcomes, and be three lines deep, whereas others with
more outcomes will be larger boxes in preview, at the moment each box
is 15 lines deep regardless of how many of the outcomes actually
contain any text or not.
Thanks for any help that comes my way, I'm not the most well versed
access user.
Oliver
|
| | 2 answer | Add comment |
|
| Problem quith query criteria Icony 19:20:09 |
| | Hi everyone,
I have this slq code
slqtext = "SELECT [total_installs].[UnitГ© Administrative] From
total_installs, uachoisi WHERE ((([total_installs].[UnitГ©
Administrative])='*afe*'));"
which makes a query that only accept values containing "afe". It works
perfectly.
Here's the problem : I would like to change the "*afe*" part for the
value of a table. Something like "*[table].[value]*" cause the value
changes while my program is running.
Any ideas ?
Plz excuse my poor english.
Alex
|
| | 4 answer | Add comment |
|
| Patch for Access 97 and 100% CPU usage Hobi 18:08:29 |
| | Hello Access user,
do you still use Access 97 and have the problem with permanent 100
percent CPU usage (see MS-KB Q160819) ?
This could be very anoying on notebooks or fast machines with loud
cooling fans.
I wrote a patch for Access 97 witch addresses this issue.
See http://www.mouches-volantes.de/ACC97TAM/ACC97TAM.htm
Greetings,
Mario Hobert
|
| | Add comment |
|
| Email from Access Guest 18:07:12 |
| | Hi - I am trying to hyperlink to an email address from the fields in my
access table. I am sure this must be simple but I can't find it
anywhere.
If I set the properties of the field to Hyperlink, it just liks to a
webpage. If I prefix the email address with mailto: it works, but I
can't expect my users to remember to do that (and I have about 15,000
email address already in there!).
Anyone got any ideas on how to achieve this?
Many thanks
|
| | 7 answers | Add comment |
|
| False row selection in subreport Richard 14:53:32 |
| | I have a Report and subreport where the rows in the Report are selected
on a three part primary key. ID,YEAR,PERIOD.
The subreport has a data select statement on a second table related to
the first with the same
three columns ID,YEAR,PERIOD
I have an problem when there is no data for the subreport on PERIOD but
there is data for ID,YEAR but the previous PERIOD this is selected.
When data exists for the correct PERIOD the previous PERIOD data is not
reported (correctly).
I wonder if this might be to do with the underlying relationship in the
SQLServer database.
I found this did not pre-exist the report creation on my production
system (though it exists now)?
Any clues?
|
| | Add comment |
|
| Strange Report Problem Karl Irvin 12:00:41 |
| | When a customer previews an Access report there are no numbers on the
report. All the text is there but the numbers are blank. (there are numbers
that should be printing)
The font is Arial TT and the report previews/prints OK on many other
computers.
I had him check the font on his computer and on the sample numbers printed
OK.
Reinstalling our program and Access was no help.
It's an A2000 mde that the customer is using and he has A2003
Any ideas?
|
| | 3 answer | Add comment |
|
| Question about filtering in Data Access Page using a Command Button Guest 11:29:23 |
| | Hi,
I made a simple data access page with a search button that does work
properly, but now I would like to add a filtering to the command button
also.
Ideal solution would be like this:
When you press the command button it prompts you a search word (text
string) and then it filters the record set and shows all the records
that match for that search word. I also would like to use wildcards for
partial matches. Is this even possible with a command button?
I know that the "Filter by selection" button on the navigation bar does
basically the same thing, but the problem is I need to use partial
matches (and thus wildcards) because the record text strings are not
all similar even if they mean the same thing.
I would also like to know if it's possible to use command button as
hyperlinks?
Hopefully somebody can help.
- A.J.
|
| | Add comment |
|
| listbox in access Jonnh 11:26:48 |
| | as I can add him information to the second column of a listbox where
already indicates him that it contains 2 columns according to the
following example:
table: with 2 fields idcodigo / name
when I execute the search I don't have problems. The problem it is
given when in the listbox I execute the following command:
listbox.addnew alone idcodigo adds me the code, and the second field
doesn't not add it to the other column you that method adds it
according to the index.
|
| | 1 answer | Add comment |
|
| Embedded printer addresses nrandell via AccessMonster.com 07:51:53 |
| | I'm running Access2000
Have a front end app with 20 users scattered around the state with a back end
server db centrally located.
Takes a long time for outlying users to load the app. Eventually a message
"Cannot find the file ('hull') (or one or its components).Make sure the path
and filename correct and that all required librarys are available" displays.
When you OK thru this, the app eventually comes up (sometime 5-10 minutes
total).
In looking inside the app .mdb file, I can see my local network printer
(used in development) address embedded 30-40 times. I'm wondering if my
outlying users app is trying to locate/attach to my development printer and
that is what is causing the error & delay? Any ideas on this? And how would
I prevent the front app from carrying my development printer address.
I'm lost - thanks for any help.
--
Message posted via http://www.accessmonster.com
|
| | 8 answers | Add comment |
|
| Make a single label Chris_huh 03:18:09 |
| | Using the Label Wezard you can easily make labels for all the records
in the table, but is there a way to make just one.
I have a form that shows the data from a single recordset and on that
form i have a button that i need to be able to link to a label for just
that records data.
How can you get the ID for that record to be passed to the label report
so that only that one is shown.
Also, i don't know if it is possible, but is there a way to allow the
user to select the label to print (i.e. where on the page the label
will print) so as to save paper?
|
| | 1 answer | Add comment |
|
| How to retain information from a table that is purged and imported daily. Afr0ninja 03:16:28 |
| | Hello!
I'm fairly new to access, but I'm starting to get the hang of it.
This will be a bit lengthy but hopefully it'll have enough information
for some kind soul to help me out. I'm currently working on a database
where I export data from another program, import the data into access
and then run various queries and what not to generate information
needed for business planning. I can't link directly to the existing
program, so I need to export about 10 reports that I import into
Access.
My problem is that in order to keep the data current I have to
purge my tables and then import new data to replace the old at least
once a day, sometimes twice a day.
To try to track some trends and what not, I need to save some of
the information (generally from queries) So I guess my question is...
When I import my daily information to the table, how can I take a
'snapshot' of the various queries I run and then store the data into
another table? Best ideas I've come up with so far is perhaps making a
macro that copies the data into a new table, however if I do that, then
I'm going to generate a ton of new tables which would take up a ton of
space and would probably prove to be difficult to merge back together
if I wanted to make a monthly or yearly summary type report. I've also
thought about doing the same thing with excel sheets, but again, ton of
sheets, pain to consolidate.
My final thought (and I don't know if this is possible, though
probably the easiest solution) is that when I update my reports the
main reason for purging the current data, and importing the new is
because the new reports generated will have some of the same
information as the last report. Each new report could have anywhere
from 1 to 1000 new lines of data in addition to the information
contained in the last report. Is there an easy way to import the data,
have it compare what is already existing in the table, and then append
only the new information?
Sorry for the obnoxiously long post, any suggestions or
information would be greatly appreciated.
|
| | 2 answer | Add comment |
|
| Minimize Access 2007 Ribbon Guest 03:15:18 |
| | Hi Everybody
I have a 2003 application that I am trying to run under 2007, The code
seems to work OK but the Ribbon is a big problem. It just takes up too
much space away from the application.
Does anyone know a quick and easy way to code a 'minimize' of the
Access 2007 Ribbon when the application starts so that the user cannot
restore the Ribbon or use any part of it?
I would have prefered the Ribbon to be made invisible, but I read that
this is impossible. Is this true?
Thanks
Den
|
| | 7 answers | Add comment |
|
| IIF statement in query field name expression builder Sbowman 02:03:04 |
| | I'm trying to get a query in access to give me a parsed string if the
field contents are not null and the value from another field if the
field contents are null. I have the following in the expression
builder:
ADID: iff([User Logon Name]<>"",
(Left$([User Logon Name],InStr(1,[User Logon Name],"@")-1)),
([Pre-Windows 2000 Logon Name]))
I keep getting the error "undefined function 'iff' in expression"
It's been a looooooong time since i've dealt with Access...please take
pity on me!!
Thanks,
Shelley
|
| | 3 answer | Add comment |
|
| Access ability to create table aliases Rudodoo 00:43:00 |
| | My company uses coldfusion to create web applications and we currently
are using TOAD as a front end to creating SQL queries. I was wondering
how is Access compared to TOAD on its ability to provide a front end to
an Oracle database
Also, does Access have the ability to create table Aliases for whenever
you create a query in design view and then view it in SQL view (or does
it have the ability to assign table aliases at all)
My dept. uses access 97 but there are others who have access 2000
installed so if you could provide some suggestions using 2000 as a
model
|
| | 3 answer | Add comment |
|
| Duplication of Tables Gregc. 00:14:08 |
| | Hi
I have put together a database, with mulitple tables. The tables are
joined via a relationship. For some reason MS Acces, are duplicating
the tables, within the relationship window. Is there a way to over
come this.
Greg
|
| | 3 answer | Add comment |
|
| Relationship Question: Balaji Balaraman 00:09:18 |
| | Hello,
I have 6 Tables.
I want to have same primary key for all the records...
Is that possible?
Thanks
Balaji
|
| | 2 answer | Add comment |
Thursday, 3 August 2006
|
| HOW I CAN USE RECORDSET AND SEEK IN ACCESS Jonnh 23:54:28 |
| | I DON'T KNOW USE RECORDSET, MATCH, FIND AND SEEK IN ACCESS ONLY IN EXCEL
|
| | 5 answers | Add comment |
|
| How to disable hyperink warning message SteveM 23:50:34 |
| | I have a hyperlink field in a form. The links map to documents on a
local drive. When I attempt to open the doc via a link I get a MS
Access waring message about hyperlinks that I have to click through. I
want to hand off the database to a client. Is there a way to disable
the warning?
Thanks,
SteveM
|
| | Add comment |
|
| Correllated Subquery, unresolving outer references Guest 23:41:59 |
| | I'm trying to form a correlated subquery (right now, it's MS Access
running to linked tables in MS SQL, although I have tried to make the
same query against the MS SQL tables directly).
The goal in the query below is to filter out near-duplicates.
What I have is similar rows in my database, and the differences between
the different rows lies in a date field. I want to be able to filter
out the "newest" dates
What happens is that Access treats all of the references in the
subquery as variables to be filled (and so prompts me), but if I use
the full table name, it defeats the purpose of a corellated subquery
(namely, to be able to use an outer reference).
SELECT dbo_ace_sites.longName, dbo_ace_taskCore.onsiteDate,
dbo_ace_taskCore.status
FROM dbo_ace_taskCore AS A1, dbo_ace_sites AS A2
WHERE (((A1.site)=[A2].[shortCode]) AND [A1].[onsiteDate] Between
DateValue("1/1/2006") and DateValue("7/1/2006") AND
(([dbo_ace_taskCore].[onsiteDate]) In (select Max(A1.onsiteDate)
FROM dbo_ace_taskCore A3 WHERE A3.shortCode = A1.shortCode )));
I'd love either a explanation of what's going wrong here, or how to fix
it, or a link explaining exactly how to write outer references with MS
SQL/Access (and the guide at
http://www.aspfree.com/c/a/MS-SQL-Server/Subqueries-and-Query-Expressions/2/
isn't the proper syntax).
Thanks
|
| | Add comment |
|
| Exit Access Enginerd477 23:29:34 |
| | I have a button on my switchboard that say's exit. for now all it does
it exit the current application and keeps access open. i was wondering
if there was any code that when i press this button it causes access to
close as well.
Any help is greatly appreciated.
|
| | 5 answers | Add comment |
|
| Referencing problem Guest 23:08:01 |
| | I have code in the OnExit event of a control on a subform. The code
works properly in this instance. If, however, I put the same code in
the OnExit event of a control on a Tab Control of a main form, the code
errors out at the 2nd line. The error number is 13 and the description
is "Type mismatch". Both controls are memo fields. I suspect that
"Screen.ActiveControl.Parent" is not referencing the form as intended.
Thanks for any help,
Mark
'*********************
Dim frm As Form
Set frm = Screen.ActiveControl.Parent
If frm.Dirty = True Then
frm.Dirty = False
End If
'(rest of the code)
'*********************
|
| | 21 answer | Add comment |
|
|
