Can this be fixed? I have a combo box which is filled with lots of choices on a certain form. I click on the combo box and want to scroll down...

Otie

04-10-2005 04:41 PM
Ken Snell

Hi, I have a MS Access db MDE which is linked to some SQL tables on a server. Now in my company we are using a certain IP address. The same DB is...

S

04-08-2005 07:12 PM
S

I have a database linked to an Excel file and has been working fine for the last few years, now I can't create a new linked database or use linked...

A Katon

04-08-2005 12:20 AM
A Katon

hello, I just developed an .adp application linked to SQL Server 7, I compiled the application and obtained a ade project disabling also all the...

ansi_c

04-07-2005 03:58 PM
Ol!v!é

i am experimenting with forms and the add and delete buttons. currently the pirmary key is a long integer that autoincrements. i am starting off...

Steve

04-05-2005 10:33 AM
Ira Solomon

I've been posting questions here the last week, but if you don't know my situation: I have a "Print Labels" button on the subform that sends the...

ChadDiesel

04-04-2005 10:37 AM
Ira Solomon

Is there a simple answer as to why my database will not save the data that correctly appears in the AccountID textbox on a form to the table when I...

Otie

04-03-2005 03:33 PM
Otie

I am trying to create a report from a table that includes a list of dates. In the report I want to group the data as follows: FIRST SECTION: All...

jaydeeman

04-02-2005 03:50 PM
Ira Solomon

Congratulations.....I think? :-) David Hodgkins, MCSD, MCDBA, MCSE JSTAR Software Solutions 4402 Sweet Cherry Ln. Kalamazoo, MI...

David

03-31-2005 06:53 PM
David

Hello Again, I want to assign a number to each record that will be part of a shipping number. I want the number value to count up until the...

ChadDiesel

03-30-2005 10:57 PM
Ira Solomon

Hi, I've been trying to use a Sub or Function in VBA to connect to a database, make a query and return the recordset that results from the query....

lenny

03-30-2005 08:06 AM
David Hodgkins

Everyone on this group has been a great deal of help. I have another question that I could use some help with. Once again, here is a picture of my...

ChadDiesel

03-29-2005 06:21 PM
ChadDiesel

I'm new to Access and need some advice. I am trying to setup a database to print labels and reports for our shipments. I have set up a table...

ChadDiesel

03-26-2005 05:08 PM
ChadDiesel

at school we have a database, with local files in access and files central in a sql (msde) server. in the program you can login with your name and...

benny

03-25-2005 11:53 AM
Sean

Set dbsCC = OpenDatabase(Path & "\CC.mdb") Set Clients = dbsCC.OpenRecordset("Clients") At any time how can I tell how many records are in...

Oin Zea

03-25-2005 11:34 AM
Sean

Just in need of a bit of advice. I'm currently building a database to store information about different products. Currently about 350 products with...

Bex

03-21-2005 09:12 PM
Ira Solomon

I have been trying to set a recordset = to a table and thus designate the recordet's type as 1 (dbOpenTable). Everytime the code executes, the...

BennyD

03-21-2005 04:17 PM
BennyD

I have been trying to set a recordset = to a table and thus designate the recordet's type as 1 (dbOpenTable). Everytime the code executes, the...

BennyD

03-21-2005 03:29 PM
BennyD

Hi, I made a query to a table and then based a lookup filed on that query. Now when I refresh the table I do not get the relationship error -...

buck

03-19-2005 08:08 AM
buck

I'm looking for ~user-friendly access based sales quoting database. I'm using a filemaker pro dbase and though it is easy to use, I'm...

bw

03-18-2005 05:02 PM
Jesse Aviles

Hi, I am trying to figure out how to run 3 reports and attached them to one email using a macro. I can only get 1 report per email message. Help! ...

Heidikf

03-15-2005 11:20 AM
Ira Solomon

I am trying to update a memo field in a table from a form that I have created. The form is unbound, and once the user makes their changes, they have...

Andrew.Donnelly@Shell.com

03-15-2005 01:21 AM
kevindotcar@gmail.com

hi there.. I want to print a control on a report, based on the criteria of whether the value in the control is null or not... My hunch is that I...

Helen Martin

03-12-2005 04:25 PM
Ken Snell

Hi all, I have a question regarding creating Left Joins. Suppose I have a database with the following tables: Person { (primary) id ...

rg1117@hotmail.com

03-11-2005 08:51 AM
rg1117@hotmail.com

I got stuck converting a claris works database from an old mac to access on a pc. I'm a C++ programmer and don't know a lot about access. This is...

jim.bello@eracent.com

03-07-2005 05:07 PM
Ira Solomon

Hello, 1. I received a mail from Larry but it doesn't work, I'm not a programmer. How can I simply make a field (street) begin with a capital letter...

Marc Verdonck

03-06-2005 05:59 AM
Marc Verdonck

I'm running Access 97 on Windows 98. I need to make large tables and queries with approaching but not exceeding 225 fields (columns). Access is...

Proteus

03-04-2005 09:37 PM
Ira Solomon

I hope you understand me, I'm not speak english very good. I have a problem with SP in SQL Server 2000. This is my SP: CREATE PROCEDURE TablaPlana...

Gema

03-04-2005 08:17 AM
Gema

Hi, I'm using access 97 on windows 98. I have table with 162 fields in it. I need to withdraw this information in a (totals) query with 164 fields...

Proteus

03-01-2005 02:38 PM
Proteus

Hi I am trying to calculate the sum of several intervals over a period of months/yers Imagine a machine i stopped by fault for say 3 minutes and I...

Anders Nielsen

02-28-2005 11:02 AM
Ira Solomon

Hi.. I built this a form in my database, and for some reason, if I accidently move the scroll button on my mouse, the form starts streaming through...

Helen Martin

02-27-2005 08:41 PM
kevindotcar@gmail.com

Hi, I am real new to databases and hoping someone can help. Main-table is a huge spreadsheet that I imported into Access Site-table has a bunch of...

Steve

02-27-2005 06:10 AM
Steve

Hi and TIA! I have a simple report that my users export to excel. They like using the Main Menu / Tools / Office Links / Analyze with Excel...

Reggie

02-25-2005 01:20 AM
Reggie

Karl, Do you really want a database? I think You can use Google Desktop for index and search in your Excel files. k> Does anyone know how to do the...

Igor Shekalev

02-22-2005 09:39 AM
Igor Shekalev

Sorry for this question - I am a newbie. I currently have coded some pages to show a listing based on a particular record (i.e. UserID=). I assumed,...

magmike

02-20-2005 11:51 PM
magmike

I am new to using Access, and hope that someone will be able to help with a problem I'm having with my database: I created a skills assessment test...

Joe Ahearn

02-20-2005 03:49 PM
Ira Solomon

A few years ago, I did something very stupid. Because I didn't know how to code in a carriage return on my website, and because the memo fields...

magmike

02-18-2005 01:48 AM
magmike

There are times in my database that I might like to output some things to a PDF file instead of the the normal printer. Is there a way, via VBA, to...

Bill Agee

02-17-2005 04:13 PM
J. Clay

Good day, I have inherited a very complex Access database that has a plethora of tables, queries, forms modules and reports. Within a few tables are...

Jeff Jones

02-12-2005 05:12 PM
Ira Solomon

Hi Group, I hope this is the place where somebody can help me. I have a MS Works'97 file here and I can't get back to the originator of the file...

Leo

02-12-2005 05:08 PM
Ira Solomon

I have an Access 97 database were I am opening a recordset in a module referencing a control on a form. For some reason when the code executes I...

Giganews

02-10-2005 11:42 PM
Giganews

Using Access 2000 and have a look-up list in need of editing. CAN they be edited? Each time I try to edit, I wind up with a blank look-up list...

Marilyn

02-09-2005 09:20 PM
Ira Solomon

Greetings, I would like to open a form from within another form. I need to suspend the sub until the second form is closed. I can do this easily by...

Tony T

02-07-2005 10:21 PM
Tony T

If you living in Metro Houston and are a heavy back-end web developer with strong ACCESS & SQL SERVER conversion experience please call me at...

Steve Michaels

02-04-2005 04:48 PM
Steve Michaels

Im working on a MS ACCESS 97 database and want to use flash buttons. have managed to get a normal button to work but still have no joy with...

Ian Wilson

02-04-2005 08:15 AM
Ian Wilson

pardon my ignorance, I am new with this programming. using a .mdb file is there a way to tell Visual Basic that the .mdb file is on a ftp...

Oin Zea

02-03-2005 04:40 PM
Ottomano Nicola

I have been trying to connect to an .mdb file protected by a password created using Access 2003. I fond some information on Microsoft DAO...

Oin Zea

02-03-2005 01:57 AM
Oin Zea

Hi, I am trying to create some queries in MS Access that read from yables in PeopleSoft. I have ODBC working on the client where I am developing, I...

John Smith

01-30-2005 08:41 AM
John Smith

I have been trying to connect to an .mdb file protected by a password created using Access 2003. I fond some information on Microsof DAO...

Oin Zea

01-30-2005 02:38 AM
Oin Zea

Am using a form with a combo box listing various peoples names and want someone using this to be forced to use a name from the pull down list versus...

cover

01-29-2005 07:45 PM
cover