Help building a filter on a form
Okay, I downloaded the Issue database template and simplified it greatly.
Now, I can't get the "search issues" form to work.
I have the following controls on my search form:
Application (dropdown list)
TextSearch (text field)
I'd like to modify the existing code so that when I make an entry and click
the "search" button, it will make the form footer visible (where the
"browse_all_issues" form is imbedded as a subform). That part works. But,
the next lines set the filter and turn it on...
Me.FormFooter.Visible = True
DoCmd.Mo...Can you ignore table validation on query append?
I have a table that has validation:
IIf([Document 1] Is Null,[Document 2] Is Not Null And [Document 3] Is
Not Null,IIf([Document 1] Is Not Null,[Document 2] Is Null And
[Document 3] Is Null))
This is because when my user fills out their form, they must select
one choice from List A OR one item from List B and one item from list
My problem is that I have an append query to add any new hires to the
table in an autoexec. The append query is failing because I am not
updating any data for the above Documents. Is there anyway for me to
get around the table validation on my append?
Any ...Append Query
I have a table "Rates" with the following data:
StartDate: 5/15/08 End Date: 6/23/08 Rate: $53
StartDate: 6/24/08 End Date: 7/15/08 Rate: $86
StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99
I have another table "Transactions". I want to create an append query such
that if I supply the StartDate and EndDate, the query will populate the
"Transactons" table with date and rate data from the "Rates" table for each
and every day within the date range. Example: If I supply the StartDate of
6/23/08 and the EndDate of 6/25/08, the query would pop...Using bitmaps with CPaintDC
Is the code below the right approach to displaying bitmaps to a dialog.
And is there any obvious problems with it, such as not being consistently
displayed on other monitors. Also I would need to display a number of
(small) bitmaps side by side on rows, and will need to add scroll
functionability to this dialog. Does anyone know of the best approach to
displaying these bitmaps in rows, and then adding a scroll for just a
certain area of the dialog where the bitmaps are displayed.
The member variables bmp and cdc are declared in the class declaration.
CPain...can i use
I am Pramod from INDIA. I have some code in C# and some code in VC+
+.NET. I want to know that , can I use my C# code in VC++.NET. if yes
what's way to use it give me example.
Thanks & regards
These articles may be intersting to you assuming you are trying to call
managed code from unmanaged code. If you are using totally managed code in
C++/CLI then it is less of an issue.
http://msdn2.microsoft.com/en-us/library/sd10k43k(...100% CPU used by SQL and HQClient
We are seeing both HQ Client and SQL tie up resources at the store servers
during connection to HQ. This can slow access to the store database by
registers for a long period of time.
Anyone else seeing similar performance issues on store servers?
This is a multi-part message in MIME format.
Make sure you're running 1.3 or higher. Consider more RAM and processor =
speed. Maybe even dedicate a processor core to it.
Jeff...All help is worthy
I have set up a simple database in excel, using barcodes (i found this
easier to scan and lookup, than access) plus the people working with
this will find it simple to use. I have however reached a giant full
The database is pulled from Dave Peterson's update log worksheet, which
works very well, the problems is that on a lookup sheet( using Vlookup
) where the user scans the barcode it will pull all info from the
"database" sheet in reference to the barcode, ie: barcode number,
surname,forename,address, early greenfees purchased,mid purchased,late.
Is it possible to manipu...Excel 2007 and Word 2007 Hangs when using the File -> Open command
I have a couple users that when they have Excel 2007 or Word 2007 open, and
click the File -> Open option, and choose a file, it either takes about 3
minutes to open the file or the program will crash. If they were to double
click on the documents or spreadsheets, the doc or sheet will open right up.
This is happening on the user's Hard drive as well as network drives.
Once you get a file opened in Word or Excel, however, the next time you go
to File -> Open, it's really fast to open the file.
...HELP: Need To Print Better Quotes
I am having a terrible time being able to print a good looking quote
from MS CRM. it either prints the plain quote (Address, amount..etc)
or i can print the product list (With no address, or nothing).. is
there anyway to print a normal quote as others do where you can have
the company informaiton and also all of the products that they are
buying listed there?
one would think that is the most basic feature that is not there..
don't you guys think?
ANY help you can provide will be appreciated..
Quoteless In DC :-)
Add a customized quote via Reports using Crystal.
>-----Origin...IF Function Help
How do I write a command that says:
=if(a1=1&b1=a number, c1/d1,"na")
How do I write the "a number" part?
Sincerely, Michael Colvin
> How do I write a command that says:
> =if(a1=1&b1=a number, c1/d1,"na")
> How do I write the "a number" part?
If I am reading your post correctly you want a cell to equal C1/D1 when
and B1= some some number
and for the cell to = "na" otherwise
=if(and(A1=1,B1=xx),C1/D1,&...Publisher documents do not print. Help!
I just set up a new computer with an HP Deskjet 5440 and Microsoft Publisher
2003. Documents print perfectly from every software package except Publisher.
Publisher documents don't print at all, even after I reinstalled the printer
The entire document or just the pictures?
If it is just the pictures, click the advanced print settings button in the
print dialogue, graphics and fonts tab. Be sure "Do not print any graphics" is
Look on the HP site to be certain you have the most current driver.
http://h10025.www1.hp.com/ewfrf/wc/softwareList?lc=en&cc=us...Help in my VB Code .. to Delete
This is a multi-part message in MIME format.
I have been trying to solve this problem since morning, and haven't =
really come up with a solution. it is frustrating. please help.
i have a datagrid and got a delete column
<asp:datagrid id=3D"dgdocument" runat=3D"server" =
AutoGenerateColumns=3D"False" EnableViewState=3D"True" =
<Columns&...Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein...Check query shows voided checks too!
I am running this query but its also showing voided checks! How can I make it
now show voided checks?
SELECT VCHRNMBR AS PaymentNumber, VENDORID, DOCDATE AS CheckDate,
DOCNUMBR AS CheckNumber, DOCAMNT AS CheckAmount
WHERE (DOCTYPE = 6) AND (DOCAMNT > 25000)
Add this to the end of the WHERE clause
AND (VOIDED = 0)
Microsoft GP/SBF Specialist
"Michael@nyresume.com" <Michaelnyresumecom@discussions.microsoft.com> wrote
in message news:7163A485-9E90-48C7-B931-C989827039D6@micros...Select Query acting like an Update Query
I am having trouble with my database where my select queries are acting as
update queries. If a user happens to accidentally or otherwise adjust the
results provided by the query, it is updating the information on the
table(s). I need to find out why it is doing this and how to prevent this
from occurring and altering the data.
On Dec 17, 9:34 am, Tboartz <Tboa...@discussions.microsoft.com> wrote:
> I am having trouble with my database where my select queries are acting as
> update queries. If a user happens to accidentally or otherwise adjust the
> res...How to configure replies when using multiple email addresses?
Here is my problem. There are several people in our organization that
receive email from two different email domains, for the sake of argument,
lets call them email@example.com and firstname.lastname@example.org.
Email from both email domains are routed through our Exchange server and
then the clients receive their email through their Outlook clients, (Exchange
2000 and Outlook 2002).
Abc.com is the primary email domain, and we have setup a partnership with
another company, hence the arrival of the xyz.com domain. When they reply to
an email, regardless if it arrives to their abc.com or xyz....Help Everything is gone. It's all been deleted.
I went on excel last on Dec 5th and I saved before exiting as usual. When I
opened the file today everything was gone. There is nothing there. The file
it's saved as is still there but it's a new page. I don't know what to do. I
need that information. HELP!
Are you sure you opened the same workbook?
What do you mean by "page"?
Excel has pages only when you print.
Do you mean a blank worksheet?
Are there any other worksheets available or just the one blank one?
Did you create a backup of the workbook when you saved?
If you "need" the inf...Use with Office Communicator saving Conversations (IM)
Our office just upgraded our email, and now we have Office Communicatior
available. OC allows the saving of conversations to Outlook. I noticed that
when a conversation is closed or saved and returned to after a time delay,
there are 2 conversations in the folder. Is there a way to only have 1
conversation in the folder? or to have the seperate conversations be
distinct, i.e. convo 1 at 930am and ends at 1015 is one, and another covo
starts at 215-225. now i'll have a conversation saved at 1015 that has all
im from 930, as well as a convo at 225 that has the 215-225 as we...Problem using a report from Access2003 to Access2007
I am trying to use a database created with Access 2003 in Access 2007 but
have come up with a problem.
The database contains a report which produces invoices for sales between two
dates. When the report is run the user is asked to input sale date From and
To (this is set up in the Invoice Query), Invoice Date and Invoice Start
Number - these two are set up as text boxes on the report. Invoice Date
conrol source has [Enter Invoice Date] and Invoice Start Number has
[Page]+[Invoice Start Number]-1. This works fine in Access 2003 and the
invoices come out correctly but in 2007 invoice ...Does anyone use "location" field in Outlook?
After all these years, I just noticed when I go to make an appointment in
Outlook (2003version, with BCM), that there's a second field after "subject"
which would seem to be the one everbody mostly uses. The appointment fields
1. SUBJECT: (example: "Conference call with Joe and Mary)
2. LOCATION: (does anyone use this?) Is the idea to put something like
"Annapolis, MD" meaning maybe a meeting there or something?
I know it's a hokey question, but wondered about some examples of how other
people are using it.
Standard following us...Can I use Rule to move digitally signed messages to separate folder?
Is there a way to move digitally signed messages to a separate folder using
a Rule? Other options for segregating digitally signed messages?
Thanks in advance.
deko <email@example.com> wrote:
> Is there a way to move digitally signed messages to a separate folder
> using a Rule? Other options for segregating digitally signed
I don't see that as a selection criterion in the Rules wizard.
...Need help with cursor spacing problem
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="ISO-8859-1"
I�m trying to fill in a form that�s MS Word based. I�m using MS Office X on
a Mac G4 with system 10.3.4.
When I type, the cursor seems to have an extra space between the last letter
and the place where I want to put a new one. In other words, I�m unable to
align the cursor exactly where I want it to go. It makes typing almost
imposs...Having Tabbed UI using CFormView in an SDI project
I want know whether we cud implement tabbbed UI using CPropertySheet
and Cproperty using CFormView or CScrollView in a SDI MFC project. If
Hope for Quick reply
It would be kinda hard to put a CView in a PropertySheet.
Try these instead:
...Dlookup in query
I have a query in which i want to use a dlookup which i have embedded in a
function. Strange thing is that the first record returns the correct value
and after that i get a invalid use of null.. ??
scenario (for testing purposes)
MyDate (set to date time)
MyAmount (set to currency - standard - two decimals)
Dummy (text field)
FutureDate (Set to date time)
Created a query with the two fields from table2
both fields added to the querygrid. Third field added as follows: Amount:
function GetPrice(FutureDate) as d...open excel 2007 refresh query from batch file
I have a simple script saved as "C:\refresh_excel.vbs" that opens an
Excel file, and does a refresh for a query on Sheet 1. I created a
scheduled task to run this every day.
It worked fine for previous versions of Excel, but since I have
upgraded to Excel 2007 it doesn't work. Any help it helping me figure
this out would be appreciated.
/*contents of refresh_excel.vbs*/
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls")