I have a problem that I didn't cause and can't think of a way around. We get trade files every day from big companies and I have an automated Access...

musicloverlch

03-25-2013 04:50 PM
Phil

Hi All, I thought I would just ask the question(s) here instead of searching thru who-knows how many documents to figure it out. The company I...

bobh

03-25-2013 10:18 AM
bobh

Is Access 2010 using vba 7?

Ron Paii

03-23-2013 11:47 AM
Albert D. Kallal

Hi guy's I have a form based on the following query. SELECT tblData_S1.dtfJobDate, tblData_S1.anfRecordID, tblDriverDetails.txfDriverName,...

Living the Dream

03-22-2013 06:23 AM
Living the Dream

I'm looking for info or experience on 'Best practice' using MS Terminal Services (WS2008) with Access Runtime 2010. After a year, it has worked...

pdh6767@gmail.com

03-21-2013 11:09 PM
pdh6767@gmail.com

Is there any merit in checking Ace or ADE 'versions' or Service Packs in these post Jet 4 days ? Is Ace now fully absorbed into Access and using the...

pdh6767@gmail.com

03-21-2013 10:51 PM
pdh6767@gmail.com

JetComp (Prod Ver 4.0.0326.0) - seems ageless, but does it work OK on 2010 & 2013 BE files ? I haven't been able to find anything much on recent...

pdh6767@gmail.com

03-21-2013 10:49 PM
pdh6767@gmail.com

I was asked to create a small database for a non-profit agency. They have internet service but do not have a local network and have no way to share...

Patrick Finucane

03-21-2013 10:38 PM
pdh6767@gmail.com

Hi In VBA I have a Memo field called txtBuyerAddressBank that contains customer addresses and phone numbers. I want to delete the last line with...

bobdydd

03-21-2013 09:46 PM
Access Developer

Specifically pictures of the Relationship screen, and also query screens.

Peter Jason

03-21-2013 05:21 PM
David Hare-Scott

A2010. I have had WindowsUpdate turned on forever so I assume Access is upto date. I got a database form an external person, external computer. I...

Patrick Finucane

03-21-2013 05:33 AM
JB Guernsey

I have a small form to add a person's name to a table, with standard buttons like add, delete and going to previous, next, first and last...

AA Arens

03-18-2013 07:48 AM
Hagen

I need to deliver an Access accdb, tables for viewing data only, no front end. Is it possible to make the tables read-only so the user can only look...

bededobedado@gmail.com

03-17-2013 12:16 PM
Joan Wild

Hi, I want to use the Find and Replace feature. I am looking for the VB code that enforce Match setting of Find and Replace to be set to "Any part...

AA Arens

03-17-2013 03:09 AM
AA Arens

Hi, I have an Access form where the user can pick what category color he/she would like to export a calendar appointment item to Outlook as. Some...

PW

03-15-2013 10:02 AM
PW

I have a client database built using Access 2010 that will use a normal front end and store the tables in Sharepoint 2010. I would like to find a...

BobAlston

03-14-2013 09:23 PM
BobAlston

In my applications, the user can change the color of the sections of a formand subform by checking a checkbox. When the form get programmatically...

Norman

03-14-2013 10:56 AM
Norman

This is driving me insane! I am not familiar with VB or SQL, so I'm usingthe standard Access functions/UI. I am building a reporting database that...

jcampbell474@gmail.com

03-12-2013 02:17 PM
Rob Parker

Some of my users really need to see queries so they can sort the data in a number of different fields (e.g. sort by date instead of alpha by last...

Nance

03-12-2013 05:52 AM
Nance

I have a database called Analysis, and anothe database called Test In the Analysis database I have added a reference to Test and can see all...

Phil

03-11-2013 04:42 PM
Phil

Hi, Just wondering if it's possible to do the following; Here's the (imaginary) table Pickles - Dog Mittens - Cat Lucky - Budgie Larry - Horse

buckskin

03-10-2013 03:44 PM
Patrick Finucane

A simple request to folks posting here: Please snip messages when you respond. A certain amount of relevant info in the message you're responding...

Joan Wild

03-09-2013 02:35 PM
Access Developer

Hi, This code (taken from the book "Access 2010 Programmer's Reference") does not work, as most of the example code I have encountered from that...

PW

03-08-2013 11:22 AM
PW

I am updating a Access 97 database to 2010. I was distressed to discover that 2010 doesn't have the ability to natively bold the first line of a...

chrisawood80@gmail.com

03-07-2013 09:28 PM
Douglas J Steele

My accdw database created in Access 2010 does not automatically display startup form in Access 2013. This is an Access database with tables stored...

BobAlston

03-07-2013 06:46 PM
Albert D. Kallal

Sync error. Your application has encountered errors while attempting to synchronize with the server. Your web application may be in a bad...

BobAlston

03-07-2013 11:59 AM
BobAlston

Oracle In Classical Antiquity, an oracle was a person or agency considered to be asource of wise counsel or prophetic predictions or precognition of...

amani.abdulhadi@mediu.ws

03-07-2013 04:17 AM
amani.abdulhadi@mediu.ws

I've got a report that lists bond funds. The zinger is that some funds are denominated in US Dollars and others are denominated in Pounds...

(PeteCresswell)

03-06-2013 03:32 PM
(PeteCresswell)

Hello all, I have a fixed width text file in ANSI coding and I am trying to link it inAccess 2007; however after I link it in access, some chinese...

Matthew Tsang

03-06-2013 07:43 AM
Patrick Finucane

Is there a way to use vba to check that the current user has permission to create / delete files in a specific folder? -- Bob Darlington Brisbane

Bob Darlington

03-05-2013 03:27 AM
Phil

Hello all- I have several automated databases kicked off of a dedicated machine that generate data for reporting. I have noticed that over time the...

RobBrouil

03-04-2013 01:55 PM
Ron Paii

Hi, I getting the error when trying to set a value of long integer to the value of a textbox on a continous form in the current event of...

PW

03-04-2013 12:14 PM
Patrick Finucane

I have read a little about this topic but obviously not enough. I would like to list certain reports in a listbox to enable the user to select the...

rwpearson@clear.net.nz

03-02-2013 10:54 AM
Phil

Hi, I am concerned about corruption and the size limit if I move my Access 2010 application to something like Amazon Web Services (instead...

PW

02-27-2013 11:32 AM
PW

Hi All, I have an Access2003 query which updates a field in a SQL Server table it is very slow and I want to change the query to a pass-thru...

bobh

02-26-2013 03:55 PM
Ron Paii

I have a Form that displays the list of items for a Bill of Quantities (BoQ). The basic information displayed includes: Name of the item Quantity of...

Jim Devenish

02-23-2013 03:17 PM
Hagen Weidlich

3431 577 SW Dexter Cir, Apt 201 1442 SW Haygood Loop, Apt 101 Lake City, FL 32025 (386) 438-8968 Local PD: (386) 752-4344 From: "6StringStu"...

Trailer Trash Suzie

02-23-2013 09:27 AM
Trailer Trash Suzie

Hi All, In Access2003 I have a pop up form(frmSelects) which the user(s) select some criteria on then click on a button called 'Go'. The vba of the...

bobh

02-22-2013 02:37 PM
bobh

I have here an old A97 password protected database (not user protected). As A97 used a very simple XOR-encryption it's normally easy to get...

Peter Müller

02-22-2013 04:49 AM
Peter Müller

We have a database that is linked to a backend database. when we removed the links it lost all forms and reports. Is this normal? Is there any way to...

sparks

02-21-2013 06:34 AM
sparks

I have a main form with 2 subforms, the first being Promises and the second DonorsSubPaymentsMade. The 2 have MasterFields & Childfields set so that...

Phil

02-21-2013 02:26 AM
bsn

This database is Access 2010 with SQL back end. There are a couple of forms in this contact management/Sales tracking database that display the same...

BrianDP

02-20-2013 06:37 PM
Patrick Finucane

I have a main form. on it a subform, and on the subform a subsubform. inthe on DoubleClick of a control on the SubSubform I can find the name of the...

Phil

02-19-2013 05:21 PM
Phil

Does anyone happen to know the name of the Outlook 2010 instant messenger window? I'm trying to FindWindow it. Thanks, Stan

Aikistan

02-19-2013 10:25 AM
Aikistan

hi I have an on call database that needs to calculate 1 session per weekday or 2 sessions for saturdays, sundays or a bank holiday. I have added...

elaine_c_james@hotmail.co.uk

02-19-2013 03:06 AM
Phil

I want to embed some images (png) in some of my Access 2010 application forms. But when I embed a 13kb image, my compacted db increases in size by...

Bob Darlington

02-19-2013 12:25 AM
Bob Darlington

Using MS Access 2002, Windows 7. Back-end size of the main mdb is about 65 MB. We have two, geographically separated field offices, and we need to...

croy

02-17-2013 09:18 PM
Access Developer

Hi Everyone Another monumental task which requires me to confer with the Masters of all that is Access with what seems a complex problem! I have...

Living the Dream

02-17-2013 07:41 AM
Living the Dream

Hi, Win7 64-bit, Access 2010 32-bit. A client reported this last week and the good thing (I suppose) is that I can duplicate the error on my PC...

PW

02-16-2013 06:14 PM
PW

Hi, Using Office 2003 and XP. We want to email pdf's of merged Word docs (again 2003). I can open the word document and change the active printer to...

fs

02-16-2013 03:30 PM
Access Developer