There are many Jordan models available in the stores and each one has different style and color shades, which captures your mind. The company makes...

goodseller

10-06-2011 07:52 AM
goodseller

I would agree with you for the development side of things David, but not for all cases. In my experience there are a large number of databases that...

The Frog

10-06-2011 05:11 AM
The Frog

Can anyone please start me off on how to greate a google map with defined areas in different colours (I can do this with Mapoint) and more...

Phil

10-06-2011 03:16 AM
Phil

I have a form with a subform. The subform contains a bound combo box, from which the user can select a parent. The subform also displays some other...

Mo

10-03-2011 08:30 AM
Phil

I have an mde written in Access 97, converted to A2000, and used by all flavours of Access from 97 to 2010. One of the reports includes code to...

Owen

10-02-2011 10:26 PM
Owen

Hello folks. I used to know this trick but I've forgotten it. I'm using a form to enter a field that is of the format ZZ-YYYY-#### where ZZ is a...

ShadesOfGrey

09-29-2011 05:07 PM
Bob Quintal

I know not to store files in Access, only the path to the file. I know how to save the path into a text field. So, can I create a button to Open...

musicloverlch

09-29-2011 04:05 PM
musicloverlch

The integration of Web 2.0 and social media style features into Business Intelligence (BI) applications – and other corporate technologies and...

Jan

09-29-2011 07:44 AM
Jan

Hi Everyone, My shiny new Office 2010 has arrived and is installed. So far so good. I am working with some simple 'get up to speed' applications at...

The Frog

09-29-2011 03:38 AM
Jim Devenish

When I add a new button to a form and choose to use a wizard, the resulting code is in the form of a macro. Is it possible to get Access to create...

Jim Devenish

09-28-2011 07:22 PM
David-W-Fenton

Hi all, This is probably a silly question, but I'm fairly new to it and cannot find an answer anywhere! My question is, after I have created a new...

Mandu 666

09-28-2011 12:51 PM
BobAlston

Hi all, This is probably a silly question, but I'm fairly new to it and cannot find an answer anywhere! My question is, after I have created a new...

Mandu 666

09-28-2011 12:46 PM
Mandu 666

Hi all, This is probably a silly question, but I'm fairly new to it and cannot find an answer anywhere! My question is, after I have created a new...

Mandu 666

09-28-2011 12:43 PM
Mandu 666

I have a form with a lot of fields, combos, subforms etc on it. There is a print button to print an invoice which runs DoCmd.OpenReport...

Phil

09-28-2011 11:34 AM
Phil

in access2007, under options->current database, I unchecked this option save and close the MDB I reopen the mdb, and F11 is not disabled, it still...

Roger

09-28-2011 08:03 AM
ron paii

I have a database in Access 2007 with several large tables that I regularly need to export to comma-delimited text files. I can right- click each...

Aaron Rubinstein

09-27-2011 09:00 PM
Aaron Rubinstein

"Ed J." <ed (AT) smbpartners (DOT) com> wrote Thanks I should have added that the select query is already set up as an aggregate. Problem is I've...

buckskin

09-26-2011 04:34 PM
buckskin

I found a speed improvement in a sub select. Using "SELECT TOP 1" instead of "SELECT", a union query completed in seconds, instead of...

ron paii

09-25-2011 06:37 PM
ron paii

After running into this problem on the db that I had written for my client I tested a few things and have got this far: OS Windows 7 -patched MS...

Paul H

09-24-2011 04:39 PM
David-W-Fenton

I have a form, which works fine w/out the pain, but I need it to work in the pain. The form uses a listbox to select a persons name, which opens...

The T

09-24-2011 11:51 AM
Stephen Johnson

When I display the status bar on my forms in my Access 2007 application, the status bar shows the record selector, then 'No Filter', then a Search...

Norman

09-23-2011 02:08 PM
Patrick Finucane

DoCmd.TransferSpreadsheet acImport, is the acimport an append or an update or either or ? I need to import some data from excel but not sure...

sparks

09-21-2011 04:41 PM
ron paii

In earlier versions of Access I'd present a hyperlink in a form, the user would click on it, and an Excel or Word doc would open the document up. ...

Patrick Finucane

09-21-2011 12:15 PM
Patrick Finucane

I have some code in A2010 that interfaces with SolidWorks EPDM api using early binding. Some user don't have EPDM installed so I would like to...

ron paii

09-20-2011 05:08 PM
David-W-Fenton

I want to delete all records where the state equals "MO" for instance but yet I am getting states that people have left out. The field in the...

PW

09-20-2011 01:56 PM
PW

Hello NG Suddenly I get this error message, when i open the Runtime db, that are installed on another client than the dev.pc... "The database can...

bsn

09-19-2011 03:13 AM
bsn

Hi, on one computer compacting a mde, on close or manual, does not work. The next time the application won't start any more. With a fresh copy the...

Michiel Rapati

09-18-2011 03:35 PM
Access Developer

I have been looking thru Amazon for books that specifically address 2010 macro building and designing a Sharepoint app using Access 2010. Does anyone...

Patrick Finucane

09-18-2011 12:59 PM
Patrick Finucane

I have an instance where It's like this on a report: Title (grouped by) Detail: Artists Song Number. Everything works fine, except...

chrisdavis

09-17-2011 07:59 AM
Bob Quintal

We have trial where young children are tested for their levels of cholesterol to determine if they have hypercholesterolemia. The children visit the...

Mo

09-16-2011 11:57 AM
Mo

Hi, I'm fairly new to Access - taught myself the basics as I need to set- up a database fairly quickly for circuit boards that have been inspected...

Mandu 666

09-16-2011 09:38 AM
Bob Barrows

I have a query in Access 2002 which combines two fields (FirstName & LastName) into a new field 'FullName' using: FullName: FirstName & " " &...

Bob Darlington

09-15-2011 08:09 PM
Douglas J. Steele

Hi All, In AccessXP using Left, Mid, Instr, or whatever works I'm look to extract just the file name from a UNC style given path as...

bobh

09-15-2011 01:47 PM
David-W-Fenton

I am trying to merge membership data from my Access 97 database to a form letter in Word 2003. I have a form which contains members' personal...

Gina

09-15-2011 08:28 AM
Gina

I am trying to merge membership data from my Access 97 database to a form letter in Word 2003. I have a form which contains members' personal...

Gina

09-15-2011 08:27 AM
Gina

I created an Access 2003 database and attempted to link tables to an Oracle database. Access must have a limitation on how many tables it can list. ...

Know39

09-15-2011 05:50 AM
Phil

I can't work out how to intercept a second call to a function if a user clicks a command button a second time in rapid succession. I've tried...

Bob Darlington

09-15-2011 12:47 AM
Bob Darlington

When designing a Form is it possible to have both the Properties and the Field list open at the same time? When I open one, the other disappears. ...

Jim Devenish

09-14-2011 01:24 PM
Jim Devenish

I'm not sure if I found a bug or a feature in A2K7 :-). I have code that exports a query to Excel. The code looks something like: With...

James A. Fortune

09-13-2011 08:57 AM
James A. Fortune

I have been using the InetTransferLib for FTP and HTTP daily for more than 1-1/2 years. It has been mostly problem free. The only issue is that out...

Lou O

09-12-2011 04:38 PM
Lou O

I am helping a friend with a database (Access 2007). It is done using macros and I don't want to introduce any Visual Basic if possible. I want to...

Bill E. Hollywood, FL

09-12-2011 07:08 AM
Bill E. Hollywood, FL

I've got the idea. But there is no use in making separate table just for name. Cause both component and assembly can have more than 1 field in common.

stenogriz

09-11-2011 09:49 AM
Phil

In an import routine I have to deal with a table which holds, amongst others, a text field in which most records have date values, except for certain...

09-11-2011 09:30 AM
Phil

Hello all, I have an access report (which is a list of people) which has a field called "Address" which is a number. I would like to select all...

Daveo

09-09-2011 06:18 AM
Phil

periodically this function fails with the above error when executing 'If (Not (frm.RecordsetClone.EOF)) Then' since assigning the recordsource...

Roger

09-08-2011 10:31 PM
James A. Fortune

Public Function PPF(Cost As Double, Price As Double) As String Dim x As Long 'Dim x As Double x = Round((1 - (Cost / Price)) * 100, 0) Select Case...

Steve P.

09-08-2011 06:26 PM
Gene Wirchenko

Hi, I am having trouble trying to figure out how to build two queries: One that lists only clientids that exist in the reservation table...

PW

09-07-2011 07:38 PM
David-W-Fenton

This is the coding for a name search that filters the details. It works well but while John Smith is fine John O'Smith is a problem. Is there another...

Duncan

09-07-2011 05:13 AM
Stuart McCall

I got an acquired table in which Primary Key data type is text and the key is prefixed with letters DC followed by number strings, like...

rafeek

09-04-2011 01:18 AM
Rafeek

Thanks for various replies, ended up in hospital so I couldn't deal with them. Have found somewhere to host MySQL, and exported my BE database...

Phil

09-02-2011 06:44 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA]