|
How to do vertical concatenation
If I have a query that returns two fields, let's say, MyID and
MyComment (which can be null) and I have data that looks something
like this:
MyID--MyComment
1--------Must do
1--------
1--------Not Entered
1--------Give to sally
1
2--------Not ready.
2--------Okay to go
3--------
3--------
4--------Rufus has.
How do I get it to return one line per MyID with a concatenation of
the...
|
7 |
11/11/2008 6:53:45 PM |
|
|
Link to Outlook Addresses Slow
Greetings,
I would like the display names in an Outlook global address list to be
available in a combo box on a form. I have created a linked table to the
Outlook Global Address list in the database, and am referencing the table in
the form, but it operates at an unacceptably slow speed. I can select the
names, but the autocomplete takes minutes find the name.
Is there some way of ...
|
2 |
11/11/2008 6:24:03 PM |
|
|
DoEvents appears not to work
I have the following:
Function M5_Process()
DoCmd.SetWarnings False
Call Shell("C:\ScheduledTasks\01.bat", 1)
DoEvents
Call Shell("C:\ScheduledTasks\02.bat", 1)
DoEvents
DoCmd.RunMacro "M1_BringInData", , ""
DoEvents
DoCmd.RunMacro "M2PrintReport", , ""
DoCmd.SetWarnings True
End Function
The first Call Shell runs 01.bat that takes about 15 secon...
|
3 |
11/11/2008 4:35:33 PM |
|
|
different query behind form
How do I create a select case? I have only one form but depending upon what
button is selected from the main menu, will determine what query should be
used? I'm assuming it is a select case but I can't figure out how to
document it. I have a main menu, 3 options, high success rate, moderate
success rate, low success rate. Depending upon which one of the three
buttons is selected will...
|
2 |
11/11/2008 4:07:21 PM |
|
|
Import File Location(s): Check for File Existance
I am sure that someone out there has come across this situation and has a
good solution, thank you for your tima and assistance in advance.
I have several databases which import files from network and ftp locations,
but the problem is that I am not the only persone using these locations and
from time to time other users will move files to other locations (archive,
etc...) in order to "c...
|
2 |
11/11/2008 3:36:16 PM |
|
|
application.filesearch pdf files
I am working in access 2003. I am looking to implement code to search a
directory for all files containing a text string. File types are doc xls or
pdf. I am using application.filesearch to do this and it works for .doc and
..xls. Used appication.filetypes.add to add doc word and excel filetypes. How
do I add pdf file types?
if I exclude the .filename = "*.pdf" then I get word and excel f...
|
1 |
11/11/2008 2:50:11 PM |
|
|
Cannot assign printer in code.
Because a printer attached to Server 2003 will not function I need to direct
Word Automation to print to another printer - but cannot.
This is complicated please bear with me.
I use the following code:
"oWordApp.WordBasic.FilePrintSetup Printer:=strHP1160,
DoNotSetAsSysDefault:=1" which works well for any printer on any PC on the
local LAN.
'strHP1160' contains the string pointing to...
|
1 |
11/11/2008 12:12:01 PM |
|
|
Reference a module in a remote database?
I'm opening a remote Access database and reading each module in it. This
works. What I'd like to do now is open each module to get at the module
properties.
The following code snippet works to list the modules in a connected
database:
Set cntModule = LookupDB.Containers("modules")
For Each docModule In cntModule.Documents
debug.print "Module: " & docModule.Name
Next docMod...
|
4 |
11/10/2008 11:48:53 PM |
|
|
Parameter passing from module to query
Dear Access Community:
I am new to Access - especially coding. I looked for the answer to my
question, but wasn't able to find an answer to this exact question. Your
help is much appreciated.
I use the code below to ask the user to enter a manager ID (either 1190 or
20368). The value is stored in the variable InputMgrID. Based on the
response, the program opens one of two forms (frm...
|
6 |
11/10/2008 10:25:24 PM |
|
|
Multiple checkbox to input multiple text into a single field...HEL
Hi All,
I have a form with 6 check boxes, unbound. What I want to do is when check
box one is marked true, I want "1" to be input into a field; when check box 1
and two is check, I wanted to have "1 +2" to be input into the desire
field...and so on. I have 6 check boxes so I want to be able to have all the
possible combinations and I do not know which method to use. Could someone
s...
|
8 |
11/10/2008 9:24:11 PM |
|
|
getting False value on empty fields
Hi
I am using MS access 97, I try to run an application that has a simple
form with textbox
however everytime I have an empy field, I get the word "FALSE"
Can anyone help me??
Thanks
Efrat...
|
3 |
11/10/2008 9:19:41 PM |
|
|
Query to retrieve only the latest records
I have the following query in a VBA app.
SELECT tbl_Price.DIV, tbl_Price.Dept, tbl_Price.Section, tbl_Price.EffDate,
tbl_Price.Cost, tbl_Price.Fee, tbl_Price.Price
FROM tbl_Price
WHERE (((tbl_Price.EffDate ) In (SELECT [EffDate] FROM [tbl_Price] As Tmp
WHERE [tbl_Price].[DIV] = 'ABCD'
GROUP BY [DIV],[Dept],[Section],[EffDate] HAVING Count(*)>1 And [Dept] =
[tbl_Price].[Dept] And [...
|
2 |
11/10/2008 8:55:01 PM |
|
|
Print based on control
I have a form with a print button that prints a report for the data in that
particular record. When the button is clicked, a prompt appears asking
“Print Comment?â€. If the control is checked (true) then I would like it to
print the data in the comment field along with the data for that particular
record. If the control is false I don’t want the comment data printed, only
the dat...
|
4 |
11/10/2008 8:25:01 PM |
|
|
Assign a Module to a Form Button
I have created a module to send an email whne a form is completed. I wnat a
command button to click and execute the module. I can't find where I can
select a module to run at the "on-click" property. How do I do this?...
|
3 |
11/10/2008 5:49:56 PM |
|
|
unknow link specifications
Folks, thank you in advance for your help.
I have a directory of tab delimited text data files I would like to link to
my database (programmiclly) and do some processing(programmiclly). Each text
file has a header row of field names and then the data. I have no way of
wading thru the hundreds of files and using the link wizard to manually
create a link/import specification. I need all the...
|
9 |
11/10/2008 4:06:01 PM |
|
|
use lbox recordset property w/ ado memory recordset?
i created an ado memory recordset (no disk-based persistent underlying table)
as follows
Dim r As New ADODB.Recordset
With r
.Fields.Append "Field1", adVarChar, 64
.Open
.Sort = "[Field1] ASC"
End With
then i added 2 records to r and verified that they were actually "there"
record 1: Field1="AAA"
record 2: Field1="BBB"
then i set the recordset property for a 1-column...
|
3 |
11/10/2008 3:23:01 PM |
|
|
Insert Form Field in a Module
I have a module that sends an email with a message the "Proposal XXX has been
added" I want the XXX to be the field "ProposalNumber" from my open form
"SetupNewProposal". What is the syntax for adding this to the string??
Dave...
|
5 |
11/10/2008 2:49:01 PM |
|
|
Loop through ADO recordset, update records, and count updated reco
Is the following possible:
1) I want to my code to start at the first record in a ADO recordset.
2) For each record determine if two fields called "Gender" and "Position"
meet specific criteria, if so update a field called "Deploy" in that record
to true.
3) Then I would like for the code to count that record it just updated the
"Deploy" field to True. When the count of field "Deploy...
|
2 |
11/10/2008 2:46:08 PM |
|
|
OrderBy toggle issue.
MainForm source is employee table and Subform's source is a query based on
employee table that does a propercase format in the seperate name fields
[namesort] was added to sort these since the seperate last, sfx, first and
middle were not referenced in the query.
Data is in the table in SSN order (default from the load method used)
MainForm shows detail for a single record (Single form v...
|
2 |
11/10/2008 2:29:01 PM |
|
|
Assign a value to a Textbox
Hi all
I have a sub form with 3 textboxes. I also have 3 employeeID fields on the
form that are set when a button is pushed eg
employeeID1 = 1
employeeID2 = 5
employeeID3 = 26
These values relate to a table Customers.id so that if customer.ID = 1 then
the name is Bloggs, if it is 5 then simpson etc. Is it possible to get the
textbox on the subform to show Bloggs if the employeeID1 = 1 a...
|
2 |
11/10/2008 12:03:46 PM |
|
|
Percent completed
I have code which runs various queries in a specific order. Due to the length
of time it takes for the queries to run, I would like to have some sort of
progress indicator. The queries are being called using, of course, DoCmd. How
can I produce a progress indicator, either a procress bar or just a %
complete box, to show progress as each DoCmd is completed? I would not want
to click OK a...
|
3 |
11/10/2008 2:26:52 AM |
|
|
Appending PDF files when saving
My database generates a series of reports as sequentially numbered pdf files
which I then combine into a single PDF document using a pdf converter. Is
there a switch or command that I can use when saving a pdf from Access that
will simply append the file being saved as a pdf to the pdf file that is
already in the target directory?...
|
2 |
11/9/2008 8:28:42 PM |
|
|
Referring to Sub-Form Control in a Query
How do you refer to a sub-form control (on an open form) in a query? The
code below is incorrect and opens the "Enter Parameter value" window.
Forms!MainForm!SubForm.Forms!ControlName
...
|
2 |
11/9/2008 2:59:35 PM |
|
|
RUN MANY QUERIES FROM VBA
HELLO MY NAME IS NEOFYTOS
i have five queries that i use them in order to delete at the same time
related records in one database
i want these five queries to run at the same time
what code i have to use in vba in order to run these queries from a command
button.
my queries name is for example Q1,Q2,Q3,Q4,Q5
--
THANK YOU...
|
3 |
11/8/2008 2:22:01 PM |
|
|
Compact and Repair
I was hoping someone could elaborate on how to automate compact and repair on
a db. I have a db that i wish to implement for a charity. It is split
(front-end ... Back-end...). the db is half way around the world and on a
network that I cannot access so I need it to operate independantly.
Typically, I always administered my Dbs and ensured they were optimal
(compact and repair). In...
|
4 |
11/8/2008 2:16:00 PM |