| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | But how do you connect to the table location? Is there a VPN involved?
Yes, with SQL Server and straight ODBC there are some performance...
Neil
|
11-30-2011 01:28 AM
Neil  | 27 | 28 |
 | | Hi Access experts,
I want to create my own database. The data collection will be
extremely pain-staking. I would like to create a Access database...
klar
|
11-29-2011 03:49 PM
tom r | 7 | 8 |
| | | I've got a continuous form with a bound combo box (suffix)
the rowsource for the cb is "SELECT * FROM
qryQuoteBookingDetailSuffix WHERE quoteId =...
Roger
|
11-29-2011 04:42 AM
Neil | 7 | 8 |
| | | I have a query that displays around 600 entries for about 65 students
that are grouped by name and then by time and day of their classes for
that...
Deac
|
11-28-2011 10:14 AM
Patrick Finucane | 1 | 2 |
| | | I have Access2010.
I have a "tblProducts" in my database linked to "frmInvoice".
Some of the products require different names for the same thing, ...
Peter Jason
|
11-27-2011 04:20 PM
Peter Jason | 2 | 3 |
| | | There is a weird problem with an Access2003 database I am using.
When you first open a form with radio buttons the first button is
preselected, and...
GS
|
11-25-2011 01:50 PM
GS | 1 | 2 |
| | | Can anyone help with the following statement? I am clearly declaring
the strings incorrectly but can't work out how.
Dim StrValue1 As String
Dim...
FireyColin
|
11-25-2011 10:40 AM
FireyColin | 2 | 3 |
| | | Hi there,
I need your experts' help again.
I have set up a query in such a way that it reads out the first letter
of a firstname to get its...
Sabine Newsgroup Access
|
11-24-2011 07:54 AM
Sabine Newsgroup Access | 0 | 1 |
| | | Hi,
I am going to convert our application that we sell and distribute (MDE
in Access 2003) to Access 2010. How do I use the current menu...
PW
|
11-23-2011 04:32 PM
PW | 4 | 5 |
| | | Hi,
We have an application that we distribute as an Access 2003 MDE. We
just had a client call us and question why on one of their PCs that
the...
PW
|
11-23-2011 01:39 PM
PW | 1 | 2 |
| | | Hi All,
In AccessXP I have a form, in the form's open event I have code to
check for a date in an attached table and if it is there I continue...
bobh
|
11-23-2011 01:25 PM
bobh | 2 | 3 |
| | | I don't know the answer to that but I'd just try a different method.
At work we use GroupWise and they have a com api I can reference from
the code...
christianlott1@yahoo.com
|
11-23-2011 12:14 PM
Neil | 1 | 2 |
| | | Hi,
I want to delete some rows in a table depending on the contents of a
string (which contains the field name in the table).
For...
PW
|
11-23-2011 12:07 PM
PW | 13 | 14 |
| | | using access2007 and sql server 2005 linked tables
trying to create a transaction with many UPDATEs, INSERTs and SELECTs
this is required to get new...
Roger
|
11-22-2011 07:33 PM
Roger | 0 | 1 |
| | | I'm trying to create an ADODB transaction that
updates records, reads records, etc
tblQuoteDetail is a linked table to sql server 2005
this vba...
Roger
|
11-22-2011 07:04 AM
Roger | 0 | 1 |
| | | Many of us have encountered the problems with continually having to decompile
Dbs after applying SP1. Has the problem been fixed, and if so, what is...
Phil
|
11-22-2011 04:25 AM
Phil | 0 | 1 |
| | | Many of us have encountered the problems with continually having to decompile
Dbs after applying SP1. Has the problem been fixed, and if so, what is...
Phil
|
11-22-2011 04:20 AM
Phil | 0 | 1 |
| | | I'm using
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml,....
to create an xml worksheet where alpha column are left-justified...
Roger
|
11-21-2011 07:43 PM
Douglas J Steele | 1 | 2 |
| | | Am just playing with mappoint 2010 and using the following to add pushpins
Private Sub AddPushpins_Click()
If Nz(ZoomHeight) < 5 Or Nz(ZoomHeight)...
Phil
|
11-21-2011 10:36 AM
Phil | 0 | 1 |
| | | I'm using Access 2002 and 2010 and have a VBA routine which happily creates
multiple emails and dumps them into the client's Drafts folder in...
Bob Darlington
|
11-20-2011 09:34 PM
Bob Darlington | 4 | 5 |
| | | Lets say I have a table
ID AutoNumber
Colour Long
Sample Data
ID Colour
1 255 (Red)
2 16711680 ...
Phil
|
11-20-2011 01:33 PM
Albert D. Kallal | 14 | 15 |
| | | <christianlott1 (AT) yahoo (DOT) com> wrote
Thanks. That worked great for getting the user ID and password in place.
Couldn't get the Log In button...
Neil
|
11-19-2011 05:27 AM
Neil | 7 | 8 |
| | | I realize that a database can not be compacted if it is open. I
created a few "work" tables in the code MDB and a few append queries
and regular...
PW
|
11-18-2011 05:08 PM
ron paii | 11 | 12 |
| | | I have a Form called 'frmPolicy' upon which are two text boxes called
respectively 'txtPolicyNo' (datatype
nvarchar) and 'txtPolicyVer' (datatype...
FireyColin
|
11-16-2011 09:50 AM
FireyColin | 4 | 5 |
| | | I want to produce a continuous report on A4 paper landscape in 2 columns so
that it can be published as a book. The half pages (A5 size)...
Phil
|
11-13-2011 08:48 PM
Arvin Meyer | 3 | 4 |
| | | I've got a table with fields bookingId, quoteId, bookingDate
I want to get the max(bookingDate) for the max(bookingId) for a given
quoteId
select...
Roger
|
11-13-2011 01:10 PM
Kaj Julius | 2 | 3 |
| | | I have a Access database - front end/back end set up. One of my
clients has just set it up to run on a local area network using a
wired connection...
Owen
|
11-12-2011 11:10 PM
Albert D. Kallal | 2 | 3 |
| | | My client has a SQL Server 2008 backend with an ACCESS 2007 front end.
Most of the tables work fine linked using ODBC. However, two of them
do not...
Jim Mandala
|
11-12-2011 09:43 AM
Jim Mandala | 2 | 3 |
| | | Can anyone tell me what's wrong with this syntax?
=DSum("", "OtherCountryTax", "
= Forms!! AND = Forms!!
!)
FireyColin
|
11-11-2011 11:48 AM
jbguernsey | 2 | 3 |
| | | I have been looking for a way to send an email from access with an
independent file attachment. In other words without using the
sendobject method...
Lou O
|
11-11-2011 08:28 AM
Jon Lewis | 14 | 15 |
| | | I want to set the margins on a report to specific settings
so I'm thinking this will set the prt object to my default printer
Dim prt As Printer
Set...
Roger
|
11-10-2011 11:16 AM
Patrick Finucane | 3 | 4 |
| | | I have 2 reports that both use the same subreport. The linking filed is
MemHeadOfHouseID. They are RptPaymentRecord & RptPaymentRecordUnPaid.
The...
Phil
|
11-10-2011 07:36 AM
Phil | 2 | 3 |
| | | I have had this set up and working for a long time.
perfect until now.
I am assuming a microsoft update of some kind.
Set WordDoc =...
sparks
|
11-09-2011 02:49 PM
sparks | 9 | 10 |
| | | A while back I mentioned I had an application in A2007/2010 that
opened with the NavigationPane (database window) closed. However, if
I attempted to...
Patrick Finucane
|
11-09-2011 01:50 PM
Patrick Finucane | 0 | 1 |
| | | I have no clue what I am doing in VB but a database in Access that was
used to import files is no longer working and I hope someone can
assist me....
Megan Ruhnke
|
11-09-2011 04:23 AM
Phil | 1 | 2 |
| | | I'm doing a project for work and I need to know the best way to
approach this problem. I had originally solved this delima using an
append and an...
faraa
|
11-08-2011 10:51 AM
faraa | 2 | 3 |
| | | Got a function:
=================================================================
Public Function ResetDateFirst_GetOrCompute(...
(PeteCresswell)
|
11-07-2011 07:49 PM
(PeteCresswell) | 2 | 3 |
| | | Per Albert D. Kallal:
That's what I was trolling for....
The whole post is a "keeper" in spades...
Thanks!
--
PeteCresswell
PW
|
11-07-2011 06:11 PM
PW | 30 | 31 |
| | | My developer box now has Excel 11 and 12 installed on it.
The users, however, have only Excel 11 and the Access app they
are using is predicated on...
(PeteCresswell)
|
11-07-2011 02:58 PM
agiamb | 6 | 7 |
| | | I have a cmd button with this code
On Error GoTo fExit
DoCmd.OpenForm "frmImportShootSheet", acNormal, , , acFormEdit
fExit:
On Error Resume...
Roger
|
11-06-2011 11:44 AM
Phil | 13 | 14 |
| | | A2K How to insert a bitmap correctly?
I want to insert a bitmap from file.
I tried to do it with appendchunk.
The result is that I see only "Long...
Jürgen Meyer
|
11-06-2011 09:34 AM
Jürgen Meyer | 2 | 3 |
| | | Hey there
on a daily basis i import data from an excel sheet into access and
append it to a particular , in this table there is the ID field...
Dominic Sundar
|
11-03-2011 09:15 AM
Patrick Finucane | 1 | 2 |
| | | Hi,
I'm not sure my 'Subject' above summarizes the problem well.
The database was originally an Access 2003 database (.mdb), but I
converted it to...
Gilgamesh
|
11-02-2011 02:08 PM
Tony Toews | 9 | 10 |
| | | I have created a report with a few concatenated fields, I want to be
able to hide some defaults I have created in the concatenated field.
For...
Dave
|
11-01-2011 05:43 PM
Patrick Finucane | 2 | 3 |
| | | I have created a report with a few concatenated fields, I want to be
able to hide some defaults I have created in the concatenated field
itself.
For...
Dave
|
11-01-2011 04:43 PM
Dave | 0 | 1 |
| | | On 31/10/2011 16:07:49, "christianlott1 (AT) yahoo (DOT) com" wrote:
Thanks Christian
Don't thin that helps, but I will look into it forther.
I am...
Phil
|
11-01-2011 04:23 PM
christianlott1@yahoo.com | 2 | 3 |
| | | Thanks for the link. Looks like I can customize this to my need. ;-)
On Fri, 21 Oct 2011 10:29:37 -0700 (PDT), "christianlott1 (AT) yahoo (DOT)...
JackonLI
|
11-01-2011 03:19 PM
Access Developer | 12 | 13 |
| | | I have a provider report that has a group footing at the provider
name. I would like to run this report and save the output of the
report as a .pdf...
Annette
|
11-01-2011 12:05 PM
Patrick Finucane | 1 | 2 |
| | | We had a guy here make determinations on a table(s) and replaced
missing values with numbers.
something like if missing -9, unsure -3, etc
so now...
sparks
|
11-01-2011 07:51 AM
Bob Barrows | 12 | 13 |
| | | Access 2010. I am finding it difficult to find records using
FindFirst.
In the code below I open the same file in two recordsets. The...
Patrick Finucane
|
10-31-2011 05:42 PM
Douglas J Steele | 3 | 4 |
