Hi, I have a continuous form and the aim is to filter its data using 3 combo boxes called cmbCategory, cmbSize and cmbStatus. These should filter on...

Vet Tech

12-10-2008 11:54 PM
tina

How can I change a table that looks like Client ID 2005 2006 2007 2008 1 y Y 2 Y 3 Y ...

janet

12-10-2008 04:33 PM
Rich P

I haven't seen anything about this on the NG yet. I wonder if anyone has run across it working with A2007 I use the following Code to send a report...

Lou O

12-10-2008 03:39 PM
Andy

I have my Access code window displayed on a second screen. When I do a Find or Replace, the dialogue box that appears pops up almost entirely off...

Wayne

12-10-2008 03:09 PM
Wayne

Hi, I want to link textbox and label in access report. I am making a report in which i want fields value in Week 1 to Week52 to be coloured according...

Deepak 13

12-10-2008 02:01 PM
Salad

I have a form that we use to add new sales lead information into a MS access 2003 database. The database is stoed on a Windows 2003 Server running...

LEX

12-10-2008 11:44 AM
LEX

Offshore Data Entry provides data entry, data capture, dataentry services, large volume data processing and data conversion services through offshore...

Kalpesh Patel

12-10-2008 06:27 AM
Agile Consulting

Hello everyone, Is it possible to secure an Access97 mdb with an A2003 mdw file? The A97 PC only has A97 installed on it. I was wondering if there...

franc sutherland

12-10-2008 06:12 AM
Agile Consulting

I have been tasked to create a report that returns every fifth (5th) record. How do I set up a report that returns every fifth (5th) record??? I...

zufie

12-10-2008 12:36 AM
banem2@gmail.com

Lyle / David, Thanks for the suggestions. These are great. I have no wish to develop anything in ASP if I can help it! Really appreciated. ALJ

Astley Le Jasper

12-09-2008 09:36 PM
Larry Linson

The reports, queries that I modified do not return results! What did I do wrong? Where do I start? All I can do is just tear apart and rebuild the...

zufie

12-09-2008 09:28 PM
Larry Linson

In access 97 you could just highlight a procedure highlight the code and hit F5 or the run code > button with something like this Call...

sparks

12-09-2008 06:47 PM
Albert D. Kallal

Thanks for your thoughts! Unfortunately, the problem is still not solved. David, lstclasses is not a multiselect listbox. MGFoster, I tried all...

damezumari

12-09-2008 05:35 PM
damezumari

I have recently upsized a client database to SQL Server. The application is used to book people onto courses at a Conference Centre/Adult Study...

teddysnips@hotmail.com

12-09-2008 10:01 AM
Stefan Hoffmann

Hi, I will be getting Access 2007 but I have Access 2002 on my machine. I want to keep Access 2002 and install new Access 2007. Will it be...

learning_codes@hotmail.com

12-09-2008 09:48 AM
Allen Browne

Hi, I want to link textbox and label in access report. I am making a report in which i want fields value in W1 to W52 to be coloured according to...

Deepak 13

12-09-2008 07:10 AM
banem2@gmail.com

Do any long time Access users happen to have a copy/file of this paper I wrote over 10 years ago? Given how well it was understood I know it's a long...

steve

12-08-2008 08:11 PM
steve

Going on in evaluation of Access 2007. Currently runtime. If starting (old) VBA code apps (Acc2k) then getting this "Security Notice" every time...

Robert S.

12-08-2008 06:21 PM
Anne Nolan

All, I've built a query within my DB that looks for unmatched records and insert the records into the primary table. How can I auto run the query...

Steve

12-08-2008 05:15 PM
MGFoster

i have problams when using the AppActivate statement in relation with the shell function when the argument to the shell function is a web browser

hprog

12-08-2008 04:14 PM
hprog

I have an invoice tracking database in Access 2003. I am trying to automate a Find Duplicates Query to run after a line is updated. If there is no...

lctabbert@gmail.com

12-08-2008 03:15 PM
Salad

I have a form with a timer that is set to fire every 5 seconds. (Access 2003 database) It works perfect when running using the full version of...

Mourad

12-08-2008 03:01 PM
Salad

Any idea my end user receives a "No Data" error when replicating? The front end is in Access. The back end is DB2. Thanks!, John

zufie

12-08-2008 01:49 PM
Tony Toews [MVP]

Who knows what method createNewDocument () of object Hyperlink is doing? It sounds that it is just opening a new empty document but if this is the...

hprog

12-08-2008 01:34 PM
hprog

Hi: Access 2007- I had to process the records of a table in an existing database sequencially. Someone said I could do this with VBA and ADO so...

eddo

12-08-2008 07:00 AM
Keith Wilby

how can i make a web query (that automaticly downloads from the web) in access via VBA

yoelhalb@gmail.com

12-08-2008 02:43 AM
Keith Wilby

Hello, I created a validation rule for table: ( <= ) "Custom error message" 1) If I try to save "manully" (shift+enter) a record which violates the...

zyzolus

12-07-2008 08:55 AM
zyzolus

EISWT-09 call for papers The 2009 International Conference on Enterprise Information Systems and Web Technologies (EISWT-09) (website:...

john

12-07-2008 08:32 AM
john

I guess I should have known that this was going to be difficult, but I'm trying to do it anyway. I have a calculated field in a query that Access...

Kelii

12-05-2008 05:53 PM
Bob Quintal

As the other thread got spam bombed I do try to restart it another time. The point is that we are having lots of old VBA code here. Embedded in many...

Robert Schott

12-05-2008 09:26 AM
Robert Schott

Note: Please disregard my earlier post. Here is a clear problem description, not my raw notes... --------------------------- Can someone help. If I...

jonceramic

12-05-2008 09:17 AM
jonceramic

I have an access database with three tables. I want to take all of the records in a field from one of the tables and update/insert them into the...

turtle

12-05-2008 09:04 AM
jonceramic

I have a table that is being utilized in an Access database. There is a number of updates that need to be made on a monthly basis. The updates are...

iwasinnihon

12-05-2008 03:13 AM
Agile Consulting

I seeking help with adjusting an end user's monitor so that she can see text on a form as greyed out instead of it incorrectly appearing as...

zufie

12-05-2008 02:27 AM
banem2@gmail.com

I've inherited a database lacking primary keys. I am in the process of changing this, and I have a question: -- There is a table 'geography',...

robert.waters

12-04-2008 09:44 PM
rkc

I’m working on a form to update my database. I have a Combo control (Combo1) that user will select RecordID I then have a couple of txtbox1 &...

Steve

12-04-2008 07:11 PM
CDMAPoster@FortuneJames.com

I'm using Access 2003, and have VBA code to copy some tables into a separate Access database. When that database opens for the first time, it has a...

bismuth83

12-04-2008 03:14 PM
bismuth83

I know how to import/export but I would like a direct read link to read the FM db (should be v3 or 4) from Access 97if there is any solution to do...

saintor1@hotmail.com

12-04-2008 02:55 PM
MGFoster

I have a report that provides summary data at the top of the main report. The summary data is supplied by two sub reports. If I run the sub reports...

KC-Mass

12-04-2008 02:18 PM
MGFoster

Can someone help. If I have this data.... auto date alloy 1 3/1/2008 1 2 2/1/2008 1 3 1/1/2008 2 4 ...

jonceramic

12-04-2008 11:01 AM
jonceramic

= DLookup("", "qryEcho5Sensors", "Station = " & Forms!!Station & " And Sensor Name =" & Forms!!Station) I need this code to find the "LastOfSoil...

markm.gis@gmail.com

12-04-2008 07:12 AM
paii, Ron

Thanks Fred, but I get an "Expected: End of Statement" error on the last bracket. My apologies, I was wrong in my original post : strFilterDate...

Kev

12-03-2008 10:50 PM
Kev

I have created a database with 3 forms: original order, additional order, and leftover tally which will be used next summer. My clients will each...

ccslantern@gmail.com

12-03-2008 05:34 PM
Mike P

Hi All, I have inherited a database that is giving me fits. I've fixed lots of weird errors the previous person made, but have come across...

jonceramic

12-03-2008 04:36 PM
jonceramic

All, I have a database that tracks resource workload. This database is used to provide management with reports to show which internal departments...

Steve

12-03-2008 04:34 PM
jonceramic

Hello and thanks for any and all assistance! I have a database that is used by several users on several different machines. The backend database is...

Del

12-03-2008 03:56 PM
boggs@ups.edu

using access97, normally with English locale, so "Select * from tbl where plannedDate = #" & format(date(), "Medium Date") & "#" gives me Select *...

Roger

12-03-2008 01:14 PM
Roger

I can not (policy) link or import data from excel. But they want me to display records from excel. I hope that makes since. They have a form in excel...

sparks

12-03-2008 01:12 PM
sparks

There are 2 tables with fields shown below. *** tbl_Employees *** idEmployee (pk) last_name first_name *** tbl_Tasks *** idTask (pk)

zyzolus

12-03-2008 02:30 AM
The Frog

Is there any way to insert a command into the Auto FE Updater .ini file to tell it to run either a batch file or .exe file before it does anything...

Wayne

12-02-2008 09:28 PM
Tony Toews [MVP]