I've designed a report that starts every group on a new page, by including a page break in the group footer. This works fine, except that a blank page is printed at the end of the report. How ...
I have 1 main form and a pop-up form.
I click a button on the main form and it brings up the pop-up form.
On the pop-up form is a multi-select listbox, I select 3 IDs from the multi - selec...
I am trying to lock a control (textbox) in a sub on a change event on another textbox. I am getting this error:
run-time error 2166
You can't lock a control while it has unsaved changes
...
SELECT * FROM myTable WHERE myFIELD LIKE "*6*"
In the "*6*", * is treated as special character, so what is other characters that I treated as special character in Microsoft Access?
such ...
The regular background color for a Label is SystemGray = -2147483633 (or transparent).
On a TabControl I have an OptionGroup, where the Label also has SystemGray. But I want it to have the Ta...
I need to create a Order form for input into tables (1st-Order table and Product tb.) I create form with information on person who take order and insert subForm with information on order, but ...
Is there a way to not allow a blank record to be created?
I have a report with StartDate and EndDate fields on a report. I have another field on the report where I am want to subtract the StartDate from the EndDate. The format on the StartDate and En...
I have a RichTextBox control on a form:
"Microsoft Rich Textbox Control 6.0 (SP4)" OLE Class "RichtextCtrl" Class "RICHTEXT.RichtextCtrl.1"
It has a Locked property which I would like to s...
I have some SQL code which is run against an NCR Terradata database using NCR Queryman. I was hoping to integrate this code into an access (97) database.
I am looking to have a simple acce...
I hooked up a network sniffer to determine why an Access query was performing poorly when run with an Oracle ODBC driver. The query has 4 tables. 3 of the tables are "outer-joined" to the 4t...
I am trying to link tables to an Access 2002 mdb using a DNS-less connect string. I am a user on a network that uses Active Directory and Im connected via VPN. Note: I have been able to succe...
What can I use instead of docmd.setvalue in Access 2003? Thanks.
This is an easy quick 500pts.
We all know that access and excel store dates as a number...right?
I have a date in my access table 15/05/2005.... I need to convert this to the underlying ...
I have a Access 2k3 DB with the "Front End" and "Back End" all in one File. All users access the file across the network using a UNC path and get the error: "too many active users". Everything...
I'm trying to evaluate the Asset Tracking database template that Microsoft has on their website under their templates area, and Access 2003 keeps trying to install DAO when opening the file. T...
Hey guys
Is it at all possible to save a single report from MS Access into a file that can be opened with Powerpoint.
Any help would be very much appreciated.
Duncan
Hi,
New to using ADO (have used DAO up till now), and have what I think is a fairly simple question.
Background:
I have built a small app that will import the contents of an XML fi...
Hello,
Can someone advise where system.mdw file is located?
Thanks
i have a field on my form
Expr2: [SumChargesQry]![SumOfCharges]+[SumEarningsQry]![Expr1]-[SumPaymentQry]![SumOfPaymentAmount]
and i need it to see zeros if the field is null????
Hi all,
for some reason the database im referencing stores grades in a wierd way- splitting them by using either character 10's or character 23's (one represented by a square).
Im trying...
I have two fields in my Qry, Categories & Number of Calls. I need to calculate percentage based on number of calls.
Category Number of Calls ...
At my company we use Access 97 for our database.
We place a short cut to a MDE file on each user's desktop so they can have use of the database.
When they open the MDE file a switchboard a...
I have a specific report I want to setup such that when the report is opened these setting will be there.
(1) Margins (Inches) (2). Size: Letter (8.5 x 11") (3). Orientation: P...
Ok, I have a form that needs to display an image. So far, it does, if the image is a BMP, but I'd like to use JPGs as well. I'm using an image control, and setting it's "Picture" property to...
