| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Is there anyway to prevent a user from opening a record that another
person has locked? Before they try to type into it?
It would really help me a...
musicloverlch
|
07-29-2011 12:57 PM
musicloverlch  | 0 | 1 |
| | | I'm trying to build a string in Access 2007 VBA that I would pass a
value "Quarters" to, and a value "Consecutive" to. I'm trying to
identify...
Icarus
|
07-29-2011 07:55 AM
Patrick Finucane | 11 | 12 |
| | | I get this error "connection with the ole server was lost....." when
trying to open a query as a pivot table. this happens even if I use a
table...
BobAlston
|
07-28-2011 03:13 PM
BobAlston | 0 | 1 |
| | | Using 2010. I've got a combo box on a continuous subform that is based on a value list. When I attempt to select an item from the list, the list...
emanning
|
07-27-2011 06:50 PM
WhathaveIdone? | 1 | 2 |
| | | We have always used access for our databases.
Now they say we need sql.
I have messed with sql in the past. sql 2005 but really did not...
sparks
|
07-27-2011 01:41 PM
sparks | 2 | 3 |
| | | Is there some way to sort the output in Mapforce?
I'm using Mapforce 2008 to create an ASC X12 file from an Access database.
The HL segments of the...
Christopher M.
|
07-27-2011 12:53 PM
Christopher M. | 1 | 2 |
| | | I have a sql server table that is linked into access2007
I have a unique index on a field in that table
I have a form where I deliberately enter a...
Roger
|
07-27-2011 11:50 AM
Patrick Finucane | 1 | 2 |
| | | I am using a copy of Microsoft Office Professional Plus subscription
version database. I am running on a Windows XP sp1 virtual machine
running on...
BobAlston
|
07-26-2011 10:45 PM
BobAlston | 8 | 9 |
| | | I have a FE / BE database that I want available to a number of users. Access
2010. I'm guessing, but I expect the users will have different versions...
Phil
|
07-26-2011 09:27 PM
Access Developer | 9 | 10 |
| | | Someone somewhere raised an issue with this in the last few weeks,
that it doesn't work any longer in A2007. A client of mine reported
the same...
David-W-Fenton
|
07-26-2011 07:55 PM
David-W-Fenton | 0 | 1 |
| | | User was working along doing her usual thing when her database froze
up.
Repair and compact to the rescue -- but not quite. She could still
not...
pemigh
|
07-26-2011 06:01 PM
pemigh | 0 | 1 |
| | | I have one user out of 30 that is displaying incorrect information in
one subform. The database is split. The data is in an Access database
on the...
musicloverlch
|
07-26-2011 03:26 PM
musicloverlch | 5 | 6 |
| | | I get text in a text box that looks like this:
Hello
On computer COMPNAME the following happened:
New File:...
musicloverlch
|
07-26-2011 12:50 PM
musicloverlch | 5 | 6 |
| | | I created some forms in Access 2010 since applying Office 2010 SP1 and
those forms cannot be opened in Access 2007 in design mode, it reports
that...
Travis Crow
|
07-26-2011 08:49 AM
Travis Crow | 2 | 3 |
| | | These are old databases and were not build with any type of control on
date fields.
but some of them show a calendar control beside them and some do...
sparks
|
07-26-2011 06:56 AM
Vacuum Sealed | 4 | 5 |
| | | Can anyone point me to the workaround allowing me to use multiple
versions of Access on one machine?
I've got Win 7 64 bit - A2010 64bit and A2007...
christianlott1@yahoo.com
|
07-25-2011 08:43 PM
David-W-Fenton | 4 | 5 |
| | | The "red flag" in what I quoted is they begin with "Shouldn't take more than
two weeks", thus establishing their (most often their...
TC
|
07-25-2011 04:08 PM
Access Developer | 11 | 12 |
| | | Both my computers at home have 2010 installed. When I open the
property sheet in layout or design mode and resize, it's entirely slow
to redraw. I...
christianlott1@yahoo.com
|
07-25-2011 12:50 PM
christianlott1@yahoo.com | 5 | 6 |
| | | I have a large excel table of records which I want to import inrto
Access 2007. One of the fields being imported is a hyperlink cell in
Excel which...
Gina
|
07-24-2011 11:55 PM
Patrick Finucane | 5 | 6 |
| | | Hi,
What is required to do so? Create an install CD, download install
file, etc like the rest of the world is doing?
I can't find anything...
PW
|
07-24-2011 09:32 PM
Tony Toews | 10 | 11 |
| | | I have a query which interrogates activities in an append query and counts stats up by week,
replacing if the week is in use, and adding if it is the...
schwallyhoo
|
07-24-2011 10:20 AM
Kaj Julius | 7 | 8 |
 | | "Access Developer" <accdevel (AT) gmail (DOT) com> wrote in
news:98jasrFna0U1 (AT) mid (DOT) individual.net:
It would take me a while to get back...
BobAlston
|
07-22-2011 06:40 PM
James A. Fortune | 22 | 23 |
| | | I'm using an unbound multi select list box in an Access 2010 accdb.
I want to apply a filter to the form so that it displays data for the
currently...
Bob Darlington
|
07-22-2011 05:15 PM
David-W-Fenton | 6 | 7 |
| | | Hi,
I see Type won't work. On a form that has textboxes, comboboxes,
option groups, and the user can enter in dates, text, etc I don't see
how I...
PW
|
07-22-2011 05:11 PM
David-W-Fenton | 49 | 50 |
| | | I'm trying to use the event when a person moves to a different form by
clicking on the built in Access application tabs.
Is there something I can...
christianlott1@yahoo.com
|
07-22-2011 04:42 PM
Access Developer | 7 | 8 |
| | | This has been put off for too long, but now I have to convert a 2000
application to 2010.
The database comprises multiple front-ends and multiple...
JeffP
|
07-22-2011 03:56 PM
Tony Toews | 2 | 3 |
| | | I have created a number of custom ribbons in Access 2007 with
"startFromScratch = true". Despite that, most of these ribbons
contain an Access icon...
Norman
|
07-22-2011 09:47 AM
Norman | 0 | 1 |
| | | Hi NG
Win7
Access2010
I have made an runtime packet(Access2010 packet wizard), and installed it on
an Win7 pc without Office2010...
For a while...
bsn
|
07-22-2011 03:15 AM
bsn | 1 | 2 |
| | | I have a query with (at present) 223 records, sorted from highest
percentage to lowest percentage.
I would like to create two more queries. One would...
septimus
|
07-21-2011 11:56 AM
Bob Barrows | 1 | 2 |
| | | I have created a custom ribbon with <ribbon startFromScratch='true'>,
which works except that the Acrobat group is still visible. Anyone
know how...
Norman
|
07-21-2011 10:40 AM
Norman | 0 | 1 |
| | | I have written a query which eventually returns via a crosstab a list of completions of activities
by financial week number as in:
Week ...
schwallyhoo
|
07-20-2011 03:32 PM
schwallyhoo | 3 | 4 |
| | | The query below has worked fine under Access 2003. We're about to
convert to Office 2010 so I tested it there, and received "Data type
mismatch in...
Composer
|
07-20-2011 05:32 AM
Albert D. Kallal | 3 | 4 |
| | | The use of Social and Collaborative Business Intelligence (BI) will
allow information to be directly linked to decisions made within...
Jan
|
07-19-2011 08:33 AM
Jan | 0 | 1 |
| | | Hello All
I am deep in to schedule territory and have a question for those souls
that have some experience in creating these beasts.
I have a...
flymo
|
07-17-2011 11:05 PM
Tony Toews | 6 | 7 |
| | | Hi,
I want the user to click a button on a form and display the "About
Microsoft Access" screen.
What is the VBA code to do that?
Cheers,
Barry
Barry Edmund Wright
|
07-17-2011 02:46 PM
Barry Edmund Wright | 3 | 4 |
| | | Anyone successfully using Access front ends to MySQL and using stored
procedures in MySQL to serve as efficient data sources to Forms and Reports.
I...
BobAlston
|
07-17-2011 10:47 AM
The Frog | 7 | 8 |
| | | I have a FE / BE database arrangement. The BE contains a TblBackups table
about backup information, basically date & time and file size. A form in...
Phil
|
07-17-2011 05:12 AM
Phil | 6 | 7 |
| | | It's possible to purchase full applications over the web and download
one file to install it on a computer. Is this possible with Access?
When we...
PW
|
07-16-2011 04:11 PM
Tony Toews | 6 | 7 |
| | | hi,
i have an access application with several reports which are printed on
different printers
the printing is always 1 original and 1 copy which...
Gerhard
|
07-15-2011 02:18 PM
Patrick Finucane | 3 | 4 |
| | | I've got a 2010 accdb that print previews a report. Here's the code:
DoCmd.OpenReport "<report name>", acViewPreview
If I attempt to print this...
emanning
|
07-14-2011 05:20 PM
Barry Edmund Wright | 1 | 2 |
| | | I have two combo boxes on a form, can get them to sync fine but when I movefrom record to record I loose the contects of what was selected. For...
vvariety
|
07-13-2011 02:01 PM
David-W-Fenton | 3 | 4 |
| | | I have two combo boxes on a form bound to an underlying table. Combo 1 is bound to Category, Combo 2 is bound to Product. I would like to filter...
vvariety
|
07-13-2011 10:34 AM
Vacuum Sealed | 2 | 3 |
| | | Access is awfully slow for _EVERYTHING_. Move to SQL Server / Accsss Data Projects if you really care about performance. I'd even go so far to...
a a r o n . k e m p f @gmail.com [MCITP: DBA]
|
07-13-2011 03:23 AM
Access Developer | 1 | 2 |
| | | Hi
A200 has a limit or 32,000+ objects.
What is the definition of an 'object'?
Does it include controls on a form etc as they are referred to as...
JeffP
|
07-12-2011 08:03 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA] | 3 | 4 |
| | | I have a query which pulls out the following data from a crosstab query, where the target week is on
the timeline axis, and the Target is what is...
schwallyhoo
|
07-11-2011 06:43 PM
James A. Fortune | 1 | 2 |
| | | I have windows 7 and I need a way to open my access application
automatically when Access10 starts up. Can someone help?
Peter
Peter Jason
|
07-10-2011 01:43 AM
Access Developer | 1 | 2 |
| | | I have a database that has been in service for 5+ years now. The
database is stored in Access 2000 file format and is split into a
front end/backend....
Liz O'Donoghue
|
07-09-2011 10:57 PM
James A. Fortune | 1 | 2 |
| | | I have a table in Access 2000 where a date and an autonumber (invoice no.)
are used in a form. For some reason, I now have a situation where some...
Mike Alpha
|
07-09-2011 01:28 AM
Mike Alpha | 14 | 15 |
| | | Hi All,
I'm trying to capture the text of the control's label in a function
that I would place on the code sheet of the form and don't know...
bobh
|
07-08-2011 03:44 PM
bobh | 4 | 5 |
| | | Using Access 2010. I've got a request from a user to develop an Access report that shows medical residents assigned to teaching doctors by month. ...
emanning
|
07-08-2011 01:59 PM
emanning | 8 | 9 |
