Hello, I have a table in access 2007 that stores vehicle Trip date, Vehicle ID, Start and End Mileage. I have created a form to enter the data. I...

Kissi Asiedu

08-25-2012 08:03 AM
Kissi Asiedu

I have a 2003 MS Access database using 2000 file format. The database was originally written with Access 2 (1995) and upgraded to where it...

PAR

07-25-2011 03:30 AM
Mr K Morris

Hi I have a access database which has been working for a number of years on a single computer. I have just put it on a network - 1 machine has fe/be...

David B

01-13-2011 09:16 AM
David B

When I converted the applicaton, everything went well and everything works. However, I do not have a navigation pane so I do not know how to get to...

Lee Buehler

07-30-2010 09:36 PM
Lee Buehler

I have a table with an address field. The data in this field for example is 1234 Main St.; 1234 Main Street. I want the data to be consistent,...

Kissi Asiedu

07-10-2010 09:08 PM
Kissi Asiedu

Here is an odd problem. I have a music database setup. It stored relevent info on a song and an object field to hold the song ( or is that a link...

Robert

07-07-2010 10:17 AM
Robert

I can use some help here. This is a lost password recovery script that connects to a MSAccess MDB. Any Help would be greatly appreciated. Thank...

Jim Rojas

04-19-2010 09:57 AM
Jim Rojas

I am trying to figure out how to center a control on an Access report. I have a 3 column report wherein the data flows down column 1, then repeats...

Mitch

04-18-2010 09:42 PM
Arvin Meyer

My page set up is for 3 columns with zero spacing between columns. There is a box around the set of controls. I have the pallette narrowed to the...

Mitch

02-03-2010 12:44 PM
Mitch

I have a database that contains these fields (among others): OrderNum Barcode ABC123 121212 G123 123456 ABC123 232323 G123 ...

Martin

11-30-2009 10:10 AM
Martin

It is many years since I last touched Access97 but this is the version i have been given to work with. I am trying to set up a nutrition database...

microbof

09-03-2009 07:42 AM
microbof

Hi All I know I'm probably doing something stupid, but I'm really stuck on this one. Basically I need to create 2 'caclulating' fields in my Access...

Mojo

06-21-2009 05:57 PM
Salad

Hi All I have a calc field in my continuous form and I'd like to total this up as follows: <form> <sub form> 3.50 6.50

Mojo

06-21-2009 11:47 AM
Mojo

Hi All I'm progressing with my db/app, but hit a stumble, trip - stumble, trip! My query drops data into 4 fields in a continuous sub-form - no...

Mojo

06-21-2009 09:26 AM
Mojo

Calling all bright sparks...... I have never used Access but I'm guessing it may be able to do what I want. I am an entertainer who would like to...

Musicman

04-30-2009 06:33 AM
Musicman

I am building an inventory database and need to generate a numbes that autogenerates. the problem is tht there are already some items that have...

Dad

04-09-2009 08:45 AM
Barney Gumble

I'm working on a pre-existing Access 2007 database Form. It has a combobox, the kind which codes the values it displays in the Row Source Property....

eddo

02-08-2009 07:35 PM

I have recently re-installed Access 2000. For my currency format if I enter 3.50, it appears as £003,50. Please how can I get rid of the leading...

Peter

01-31-2009 10:10 AM
Peter

Hi All I know this might not make much sense, but I'm hoping you can help! I have a table consisting of the following: StudentID StudentName ...

Laphan

01-25-2009 05:06 PM
Laphan

On one of my machines I am missing the calendar control. It does not tun up in the list of available ActiveX items. The machine in question is...

Mitch

01-14-2009 07:17 PM
Mitch

Thanks for the quick help. I can't get either of the examples to work. They both go to the next control. I tried a simple testDB with only the 3...

Orv

10-25-2008 06:31 AM
Orv

I have just moved to Access 2007 from 2000. Probably a stupid question, but how can a query definition be saved as a different query? I cannot find...

Peter

10-10-2008 05:48 AM
Peter

Guys, I have a database that basically logs service calls. The calls table has entries for call no among other things. This call number field has a...

}{

10-05-2008 04:31 AM
}{

how do you surpress a warning message?? The Data has been changed Another user edited this record and saved the changes before you attempted to...

Bill

10-01-2008 05:27 PM
Bill

I want to create a text file with a name which is the same as a field name and print to that file based on the contents of that field. I would like...

CLEAVE6@comcast.net

09-08-2008 08:26 AM
CLEAVE6@comcast.net

I want to create a text file with a name which is the same as a field name and print to that file based on the contents of that field. I would like...

CLEAVE6@comcast.net

09-07-2008 03:12 PM
CLEAVE6@comcast.net

I need to copy an entire database from my desktop to my laptop, both machines have Access 2003 Any advice will be appreciated

Dennis Frampton

07-16-2008 07:09 PM
DaveM

I am an old FoxPro programmer having trouble transitioning to Access, and I have a hot project to work on. I have a record for a company. That...

JF Main

07-04-2008 11:07 AM
Dave M

A little push in the right direction. I want to set up a form for data entry with 3 or 4 combo boxes. box one would be driven by a table that...

DBLEXPOSURE

06-18-2008 08:01 PM
Andy Roberts

Hi How can I disable the close button in access 2007. Reason I want to force a backup on exit and now I cant. The code for Access 2003 to disable...

News Lantic moenie del

06-11-2008 03:00 AM
News Lantic moenie del

Dell 530 desktop After several blue screens and other hassle, I got Office XP to install. Everything seems fine except for Access Xp I using the...

Ed

05-11-2008 04:32 PM
Ed

I'm hoping for some guidance here! The problem is this: I am running Access 97 under Vista, everything works great except I have a macro that does...

Beau Coup

03-14-2008 04:31 PM
Beau Coup

Hi, I have the following address fields in a table: flat_number house_name_or_number street village postal_town county postcode

H

03-08-2008 09:53 AM
drangsalino

Moved database from Access 2003 to Access 2007. Now every so often (too often) I get a message saying "The database cannot be opened because the...

Nick

03-05-2008 10:00 AM
Nick

Anything available that will clear users from a database lock after they crash. I know I can delete the lock but I would have to get everyone...

JohnLoper

02-28-2008 05:59 PM
JohnLoper

I have a couple of hundred Word Documents that contain 18 fields in a table. All the Word documents contain at least the same 18 fields. Can I...

Jack

01-14-2008 08:13 PM
Jack

Hello. How I can insert text in Microsoft Access memo field with my mouse (copy paste method)?

SoulSeeker

01-08-2008 05:02 PM
Patyrick Fisher

Hello, I'd like to insert .JPG images into a table. The field is defined as "OLE Object" and I've inserted several pics to test it, but in table...

RWH

11-14-2007 08:47 PM
RWH

Hi, I have the following code below, which works if I do the following Call No1 'Call No2 Exit Sub For whatever reason it fails at Me!.SetFocus at...

SRT

10-07-2007 04:12 PM
Eric IsWhoIAm

Can anyone help make a base for me ? I just started going to school partime for database programming MsAccess. I have this job as well that I just...

trunorth36@yahoo.com

09-30-2007 03:06 PM
trunorth36@yahoo.com

I'm new to Access and VBA. (I've been working with Pick/Universe forever.) I'm about going nuts trying to figure out something that should be (and...

Robert Martin

09-30-2007 08:09 AM
Robert Martin

I have Access 97 installed on Windows 2000 Professional and XP Pro clients. I can login as administrator and use the export table wizard, no...

Dan

09-19-2007 07:01 AM
Dan

Hi All I have developed an Access 2002 App which installs perfectly onto Windows 98, 2000 and XP. Recently I tried to install it on a machine...

Steve

09-12-2007 04:35 AM
Steve

I have a DB set up where I want to export the records to a cd. I want to be able to create an autorun cd and have it based on HTML so when it opens,...

Orv

09-03-2007 08:32 AM
Orv

I have a search form which contains a non-linked subform. When I fill the criteria of my search and click the search button it returns the results...

Orv

08-26-2007 02:17 PM
Orv

I am new to Access and want to transfer data to and from outlook calendar ( from access ) I need the date, location, and subject fields does...

Mr K New

08-21-2007 02:11 PM
Mr K New

I have a report where I am trying to return the number of females and males above or below a certain age. I have no prolem with getting totals for...

Orv

08-20-2007 05:18 AM
Orv

Years ago I created an access db with a global image imbedded background and darned if I can remember how I inserted that image for use as the 'form'...

cover

08-01-2007 08:07 AM
Ken Snell

Wonder if someone can assist here, please? I have a Form which I've dragged onto another Form to have several things on the Form at once. I've...

kirkm

07-25-2007 07:13 PM
John Mishefske

I have been working on a database that i have set up to run on all the office machines with 2002 runtime. If I upgrade my office to 2003, and do work...

learning

07-14-2007 04:32 PM
Ken Snell