Hi. I'm trying to combine two spreadsheets. One is a list of company names. The other is a list of revenue from those companies, with the district...

acolby

08-21-2009 04:16 PM
Larry Linson

I have a report menu that only the manager should be able to see, I have a main menu for all the other staff, then I report menu that the manager is...

Elaine

08-21-2009 01:53 PM
bobh

I have a Form with a Subform placed on a Tab Control. The Tab Control has a button on it that brings up a dialog box that I use to enter a new...

jodyblau

08-21-2009 01:42 PM
Salad

Some time ago there was a thread on Best match for names. I would like to read the discussions again, but I can not find it any more. Can anyone...

hbinc

08-20-2009 04:31 PM
hbinc

I have a manufactured date field and I want to extract the year and month from this date and put them into 2 other fields I have...

Elaine

08-20-2009 06:03 AM
Bob Quintal

How to remove a previous filter when the Pivot Table is next opened. 'Filter On Load' is set to No, but the table loads with a previous filter set...

Clare

08-20-2009 05:18 AM
Clare

Q1. PivotTable not showing correct column of values: I have a table with a lookup column referring to another table . has two fields, ...

Clare

08-20-2009 04:26 AM
Clare

Hello Access brethren.... I've searched far and wide for a VBA routine/module that can extract text from a specified web page into my dbase (just...

Sainterboy1976

08-19-2009 10:22 AM
Rich P

I'd like to find out if a record was entered within the last 3 seconds, thought, the query would be like select col1 from tblA where 1=1 and...

Don84

08-18-2009 09:08 PM
Don84

We use an Access database to issue purchase orders. I split the tables into a separate database that is on a shared network drive as well as...

ChadDiesel

08-18-2009 07:33 PM
Larry Linson

Hi, The given field is of memo type, and it's Access 2000. running an update query generates this error, data are less than 500 characters but with...

Don84

08-18-2009 04:48 PM
Don84

Using A2003. I've got a query where I want to pull a range of people's last names. So if I want last names that start between "ma" and "mi", my...

emanning

08-18-2009 11:11 AM
JustBoo

This question should be an easy one to answer. I have a form (frmReports) that includes a list box (ListBoxRpt), a filter selection combo box and a...

Rolan

08-18-2009 06:15 AM
Rolan

this is not an Access specific question but i've participated in discussions on and off in this forum throughout the years and now there are lots of...

Ted Theo

08-17-2009 10:38 PM
Larry Linson

I'm getting this error: 'Run-time error -2147217913 (80040e07) The conversion of char data type to smalldatetime data type resulted in an...

Stonedjw

08-17-2009 09:29 PM
Tony Toews [MVP]

Hi, I'm trying to deploy an Access DB that sync's with our SharePoint server - all is fine with the full version, however Access 2007 runtime doesn't...

Simon

08-17-2009 12:36 PM
Simon

I have a (primary) form, continuous, similar to a log that presents some records. I can then filter this list to a smaller set. That works...

Salad

08-16-2009 08:41 PM
Salad

I am working on a report that has a subreport in the page footer. The subreport adds blank lines at the bottom of each page.The...

Steve

08-16-2009 01:10 PM
Larry Linson

I'm a Newbie having a bit of a problem with some code I'm doing. I'm trying to convert numbers into base 10, but the code is throwing up some...

Yvonne

08-16-2009 12:55 PM
Larry Linson

Hi All, I've done a fair bit of searching but haven't found anything that can help with this specifically. I want to extract a persons First name...

DeZZar

08-16-2009 12:12 PM
Larry Linson

Hi, Say I'm using Access 2000. I create a data source for a web app for db connection between the db and web app via a web server. Would this web...

Don84

08-16-2009 11:52 AM
Don84

OK getting the user to confirm changes to a form is easy: Private Sub Form_BeforeUpdate(Cancel As Integer) Select Case MsgBox("Do you want to save...

Paul H

08-16-2009 11:45 AM
Larry Linson

Is the storage space requirement of a text field determined by the field size that has been set or by the actual amount of text stored in the field?

Wayne

08-15-2009 09:01 AM
Allen Browne

Hi all, MS-Access keeps changing my original sql if I switch to Query Design View mode. Is there any way to prevent this? It is combining...

th23ga

08-14-2009 09:01 PM
Bob Quintal

I have a document (.doc) inside the same folder as my DB. I have a table that stores the file path to this document. This DB is accessed by other...

Bull

08-14-2009 03:04 PM
Bull

I have a OLEBound10 box. I am trying to put an event procedure in the double-click event to automatically insert a blank Courier fonted WordPad...

Bull

08-14-2009 01:33 PM
Bull

Hi All, I inherited an AccessXP database that is not 100% normalized and I can not do anything about that. For a report that I am adding to this db...

bobh

08-14-2009 09:19 AM
bobh

I am trying to extract 6 lots of information about fonts for subsequent formatting of different areas of a report. I need such things as the Font...

Phil Stanton

08-14-2009 05:24 AM
Phil Stanton

I am trying to extract 6 lots of information about fonts for subsequent formatting of different areas of a report. I need such things as the Font...

Phil Stanton

08-14-2009 04:20 AM
Phil Stanton

Stuck with this one! Have a form which the user enters the first x number of characters for a stock code and presses search, this opens frmstockheld...

BobbyDazzler

08-14-2009 03:15 AM
BobbyDazzler

Can I make a copy of an access database so that I can do bug fixes while the original database is still being used, and later merge the fixes to the...

Dewey

08-14-2009 03:10 AM
Dewey

I'm trying to compact a database backend using the A2007 runtime. I'm doing this by closing the frontend then automatically opening the backend. ...

Wayne

08-14-2009 03:04 AM
Tony Toews [MVP]

ACCESS 2003 FE / ACCESS 2003 BE My clients are worried that their data may be corrupt. They have noticed that two of their records share the same...

Edward

08-13-2009 05:55 PM
Edward

i am trying to use the .FindFirst method in a recordset. however i keep getting a 3020 error? in my code below; i open a recordset with the...

bipin

08-13-2009 03:11 PM
bipin

Access “Record Lock” Problem Background: Peer to Peer Network – just 2 computers involved Both Computers using Windows XP and Access 2000 System...

Dan

08-13-2009 01:28 PM
Dan

I have a data table of approximately 10000 records that was originally an amalgamation of data from several similar tables from separate databases. ...

Wayne

08-13-2009 01:28 PM
Wayne

Apologies but my post a few moments ago omitted the code I have so far. Here goes:- Dim strMsg As String Dim StrBody As String DoCmd.OutputTo...

Vet Tech

08-13-2009 04:59 AM
Mr.Frog.to.you@googlemail.com

Hello, I'm trying to if the period is "Monthly" I want the field Price Amount to be multiplied by 12 and if the filed is Annual to just enter...

emarquez

08-13-2009 03:00 AM
DeZZar

I am trying to do a crosstab report. Can create a report that shows the correct number of columns to suit the underlying query. The underlying...

Phil Stanton

08-13-2009 02:58 AM
Phil Stanton

I've been away from Access programming for a while now, but I have a client who wants a little bespoke contact management system set up. I propose...

teddysnips@hotmail.com

08-12-2009 10:47 PM
kate

hi Bob, bobdydd wrote: MsgBox ExtractValue("Item name", Me!) Public Function ExtractValue(ATag As String, _ ASource As String _ ) As Variant

Stefan Hoffmann

08-12-2009 10:45 PM
kate

My boss wants me to pull the user's Usernames from their login screens and when a user adds or edits a record that the user's Username will be pulled...

zufie

08-12-2009 05:53 PM
Bob Quintal

1)How do I get my field, Date Last Updated, (Date/Time data type) to update automatically on my form header, after a record has been added or...

zufie

08-12-2009 09:17 AM
zufie

Environment: Acess 2003 with security via MDW file. A person would like their app to be run via the scheduler in the nighttime. This seems fairly...

Salad

08-12-2009 02:10 AM
Salad

I link to my PC at the client site using MS's Remote Desktop Connection and do some Access development work. If I am connected to the remte PC, I...

Salad

08-12-2009 12:53 AM
Tony Toews [MVP]

This seems like it should be easy, but I'm not finding an answer, so I'm hoping you Access Gurus can help me out. Running Access 97 Need to...

Jana

08-11-2009 11:57 PM
fredg

I'm not sure I follow. The code I posted is a function and that's what I'm using and that's throwing the error. I must be missing something....

Craig

08-11-2009 02:56 PM
Roger

Using A2007. I've developed a report where the user can choose 1 or more study types from a listbox. The report will then print data for just those...

emanning

08-11-2009 12:22 PM
emanning

I have a database that initally load business information. There are a number of other related forms loaded when a button is pressed. When I load the...

Duncan

08-10-2009 06:10 PM
Duncan

I have a series of reports that I run at the end of each month for each of the timekeepers. The reports are based on date parameters, so I enter...

Rosy

08-10-2009 06:02 PM
Salad