Merging List w/ a Form
Can anyone assist me with merging a form created in Excel
with a database (or list) also created in Excel? I know
how to merge an Excel worksheet to be used as a database
for Word in the Mail Merge command, but my FORM, with
which I am trying to merge my database, was created in
Excel and needs to remain under its format (not be
converted to Word). I am filtering the information I need
from the database to be imported to the Excel Form.
Any help would be appreciated. Thank-you.
If you're trying to display information from one record in the database,
there are sample files here...Dynamics Security Console and Dynamics Web Services
I need help
I have created a server with windows server 2008 32 bit and installed MOSS
I have done all the standard setups and created all the websites ect
I have installed Dynamics Webservice witth SP3
When I run Dynamics Security Console and select applications and then
SecuritySerivices. I get the following error
"Could not access the SecurityService service. Unable to connect to the
...dynamic field content of parameter combobox
I have to filter my Crystal 9.0 report with a parameter combobox field in
Microsoft CRM. The data for this parameter field has to be loaded out of a
database field dynamically. I have found the possibility to load database
field values in a parameter field but this will not be dynamically. If there
is a change in the database content the parameter field content will not be
updated. I hope to create a combobox control is no problem.
Is there a way to turn this into reality?
Thanks for your help
...Calling VBA subroutine from a query?
Can I call a VBA subroutine from within an Access query? I wrote some English
to Metric conversion routines in the Access VBA code and would like to run a
query on the data that will return coverted values. I need to be able to
execute this from outside the database (run the query from another program).
Yes. The function must be a Public Function in a standard module. You use a
calculated control to return the results of the query.
Dave Hargis, Microsoft Access MVP
> Can I call a VBA subroutine from within an ...Filter Report by Form
I'm using the following code from the wonderful Allen Browne which
works perfectly in an either or scenario (either by Start/End Date(s)
OR filtering by client name; but I don't know what syntax to use to
filter by Start/End date(s) AND anything typed in the client name
field. I'm sure it's easy but I can't get my head around it. I
appreciate any and all assistance!!
Private Sub cmdPreview_Click()
'On Error GoTo Err_Handler 'Remove the single quote from start of
this line once you have it working.
'Purpose: Filter a report to a date r...Button on Form to Run Report based on Query with Parameters
I am busy working on a stock control database (and job control).
When I have a Form Open, it shows several fields, including JobID (Which is
the PK for that job) (frm_Invoicing)
I also have a Query that when Run, it prompts for the JobIDNo.
I have a report based on that query. (rpt_CustJobsInvStock)
I have added a button onto the form (onclick -> DoCmd.OpenReport) to open
and automatically print the report,
But I just cannot figure out how to get it to get my JobID from the form,
and to Automatically add it as a Parameter for the que...Center Access2007 Form in the middle of access Main Window
Is there any easy way to center access 2007 forms in the middle of the
screen (Monitor) or access main window.
and give me good result
I think there is no built in feature to achieve this goal. You may need to
create a new form and configure it as the main window. You could enumerate
forms and create buttons etc to open forms from this main form. For
example, you could use hte following code enumerate forms in your database:
Dim db As Database
Set db = CurrentDb
Set cntContainer = db.Containers("Forms")
For Each doc In cntContainer.Documents
In building a form to allow users to print a "blank form"
I've constructed as an Access Report, I'd like the user to
be able to select the number of copies to print.
It looks like the PrintOut Method would be a good choice for
this, but I'm not smart enough to know quite how to get the
"Copies" argument to get its input from the textbox on my
form, where the user will enter the number of copies they'd
like to print.
Does the report have a record source?
Microsoft Access MVP
If I have helped you, please help...email form script to show email adresses of all recipients
I see there is a field in the attributes called torecipients but I cannot add
it to the email form. Is there a way I can script this into the email form to
show the email addresses of all of the recipients. My idea involved creting a
new attribute called all_recipients and adding it to the form then doing a
onchange for each of the to, cc, and bcc fields to update all_recipients. SO
far it doesnt work. All the field returns is "undefined". Any help is greatly
...Dynamically change pick lists?
Has anyone found a workaround for the following :
dynamically change the choices in one pick list based on the selection
in a second, associated pick list.
I know this question has been asked before, just wondering if someone
found a resolution for it.
I haven't tried it yet, but it is my understanding that
the first picklist that will modify the valid values in
the second picklist. HTH,
>Has anyone found a workaround for the following :
>dynamically change the choices in one pick...Fill Form And Get $5000 To Your Home.
Fill Form And Get $5000 To Your Home At http://ukcitygirls.co.cc
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque. please don't tell to anyone.
...Matching Zip coded in a Query
I have query that joins two tables using the Zip Codes (only show the records
where the Zip codes match). The problem is that in one table, the listing
of zip codes, it is 5 digit zip codes. In the main table some of the zip
codes are 5+4 zip codes. My current query leave out the 5+4 Zip codes. I
want all the records as long as the 5 digit zip codes matches.
I quess I could delete the - and the last 4 digits on the main table, but it
would be nice to retain the whole zip codes. Is there a way to do this?
to compare to the original ...Updated records in forms
Each record in a form is a work order. School, contractor, days of work, etc.
I have a pop up calendar to select a week ending date for each record.
Record 1's week ending date is Nov 13, 2009. Record 2's week ending date is
Nov 20, 2009.
When I change the date in record 2, it's changing the date in record 1.
Each record's week ending date become all records' week ending date?
Can I use a pop up calendar in a record and be able to retain the correct
week ending date for each record. If so, how would I be able to accomplish
Thanks for your inp...requery subform from sub form
how can i requery subform from subform ?
"a" <firstname.lastname@example.org> wrote in message
> Thank you
> how can i requery subform from subform ?
the work correctly
"Stuart McCall" <email@example.com> wrote in message
> "a" <firstname.lastname@example.org> wrote in message
>> Thank you
>> how can i requery subform from subfo...Queries and reports in access Need help please
Hello everyone ,
I have a little issue to setup a database. I created a table with
approximately 20 columns. The columns have an entry of Yes or no base on a
questionnaire from survey. What can I do to get a result of my table I would
like to know how many "Yes" and "no" I have. I don't know how to add them or
get this information.
Thanks in advance
The first answer to your question is that your table structure is not
really the best for this situation, and it will be a lot easier if you
can set it up differently. Is your database design set in ...union queries
I need to build a query which combine records from a number of similar tables.
Building a union query works great with "normal" records.
Problem is, these tables contain attachments in some fields and MS ACCESS
2007 treat these fields as multi-value fields and does not allow building
APPEND or UNION queries with multi-value fields.
I am so frustrated with this, because I would like to base my searches and
some other queries on this.
On Fri, 26 Feb 2010 05:54:01 -0800, Dawie Theron
<DawieTheron@discussions.microsoft.com&g...Query repeated values
Hello everyone. Sorry for such a newbie doubt, but since my Access and SQL
experience is a bit “trial and error” I don’t even know what to search for
here in the forums that so I can help myself.
I have two tables A and B.
First table has people’s NAMES field.
Second table has a field with people’s ABILITIES but some are repeated:
WORD – Marc Wilson
WORD – Andrea Smart
EXCEL – Francis Junior
COREL – Andrea Smart
COREL – Andrea Smart
I’m trying to build a query to point out the duplicated lines, in this case:
COREL – Andrea Smart
...Date field behavior differs between forms
I have two forms with seemingly identical date fields. In one, if I place my
cursor in the middle of it, the first number I type gets put in the far left
of the field. In the field on the other form, if I place the cursor in the
middle, it starts typing right where I am. Any ideas?
I have thoroughly looked through the properties of each field and each form
and I cannot find what is causing this behavior. I would love to get both of
them to start placing typed characters at the far left instead of where the
Check the Text Alignment property of both controls (not ...Conditional Formatting In a Datasheet Form
I am trying to “Condition Format” a column on my form so it will highlight
the individual cell if another cell in the same column has the same value.
The form is in Datasheet view and it can not be changed from that due to the
way I built the database.
I have tried to build the condition format like so,
Condition1 “Field Value Is” “equal to” [Column Name]
and all it dose is it highlight the cell in the column when I input a record
into it, regardless if it is a duplicate or not.
Is there a way to accomplish this?
Thank you for your time,
On Thu, 1 Mar 2007 10:34:06 -...2 queries, a date range and a report?!
I'm pretty much a novice access user, and am designing my DB with the
frequent assistance of these forums. However I'm now trying to do something
that I can't find any reference to - Can anyone advise?
I have a report that is to be printed from a form using a print control
button. The report consists of 2 queries which look up 2 different types of
"item" by date range.
I want to be able to prompt the user once for the start and end date. If I
put a start/end request on both of the queries, then the user has to enter
the dates twice, and when you choose...relative references when copying Sheets containing form controls
I've been given a spreadsheet that I need to take copy various sheets
from, the sheets contain form controls, when I copy the sheet to a new
workbook, named ranges and so on come across fine, but the references
to the input ranges of for example the drop down box controls become
hard coded to the original sheet, I don't want this..
Is there anyway to alter the way excel copies so that the references
remain relative rather than absoloute????
What did you include in the addresses for those references?
I put a listbox from the forms toolbar on a worksheet.
If I used a range like: $b$...Wretched Queries!!!!!!
Hi,In my database each entry has several scores assigned to it (fordifferent attributes). Each score is in the 1 -4 range.I would like to construct a query that will select those entries thathave even so much as a single attribute that scores below a 4 and, ifpossible, only return the attributes that fell below standard (4).The database will have each employee (entry) assessed on a dozen or sodifferent attributes, each of which will be rated with a score of 1 -4. I would like to be able to find out which employees had a score inany attribute below 4 and which attributes those were, and only th...Some queries of User Interface Thread
Recently I started working on User Interface thread , But certain
things are quite confusing. Hope I will get some clarification from
all of you.
1: The thread does not receive user message sent by PostThreadMessage
when I am doing some lengthy operation in Run() method (overrided
Run() function ) , Can you tell me why it is so ? I have written a
handler for user defined message, But it's of no use when I am doing
lengthy operation in Run().
2: I read that the Run() function provides a default message loop for
user interface thread. How Run() function works internally ? How it...Data Not Displayed in Query
I have a ODBC query built to pull data from a table in Access and linked to
another database table.
The query seems to work fine to compare data from the two tables, however
there are a few blank fields displayed in the query. I cannot figure out why
these fields are blank as there is data in the second table. If I try to
enter data it dings and wont let me. It is obviously there, but it not being
displayed in the query.
Any ideas on a fix would be greatlu appreciated.
What is the data type of the blank fields? There's some things that Access
Is...Help needed with IIF in my query
I have several fields in my database that are date fields. The data type in
my table for these is date/time and formatted as short date. In my query
(I'll use one field as my example here). The result I want is if there is a
date in the field then say Y for yes, or N for no. Pretty simple. I don't
know why I keep getting a data type mismatch in criteria expression error.
The fields in my table are date fields and formatted as short date. Is there
something wrong with my IIF or can you suggest a better syntax to use. Please
let me know. Thanks. Here is my formula: