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 01:44 PM
Mitch

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

02-02-2010 05:11 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 11: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 08: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 06: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 12:47 PM
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 10: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 07: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 09: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 08: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 11: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 06: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 08: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 07: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 06: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 05: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 06: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 09: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 04: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 08: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 12:07 PM
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 09: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 04: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 05: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 06: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 10: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 11: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 06: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 09:13 PM
Jack

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

SoulSeeker

01-08-2008 06: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 09: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 05: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 04: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 09: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 08: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 05: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 09: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 03: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 03: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 06: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 09: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 08: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 05:32 PM
Ken Snell

Good day mates, I'm trying to build a database to keep track of information that will be stored when my client kicks off his brand new Taxi Cab...

Knowledge

07-02-2007 09:38 PM
BAM

I have several long lists in txt format that look like this: Name of Co Address City State Zip Tel Fax Website Email Contact.

BAM

06-27-2007 08:51 PM
BAM

I have been trying to no avail to create a calculated field on a form I have used the expression builder, I have typed in code manually, I have tried...

Stahlhelm

06-18-2007 08:56 AM
Ken Snell

I've had this problem with both Access XP and now Access 2003. I have a table with yes/no fields, properly formatted. I have a "make table" query...

Paul Danaher

06-16-2007 09:38 AM
Paul Danaher

I can use the sum function in a query to get the total number of "yes" entries in a table, but I finish up with a negative number. I've tried working...

Paul Danaher

06-16-2007 09:33 AM
Paul Danaher

I am looking to create a db that works with infopath. so I can have discipline records, training records and the like. if there is anyone that is...

Michael

05-20-2007 12:17 AM
Michael

Other developers in this newsgroup will have certainly found or developed a dependable technique to include updates to an active database, which is...

ajaynava@yahoo.com

05-12-2007 10:58 PM
ajaynava@yahoo.com