Tech Newsgroups: Getting started with Microsoft Access

restore to original setting. how. Reload?

fritz - 24 Nov 2007 7:37 PM - 2 messages

fritz. (less than 3 month on comp.) vista home 32 pre installed . EMachines i have all mixed up my programm so bad. i dont now where to start. desktop seems to be split. 1 w/ 32 folders. 1w/ 21 folders and a public desktop. ...

access 2007 switchboard

chill - 24 Nov 2007 7:08 PM - 4 messages

hi i create a form and i want to use it as a switchboard . how can i make it to start while the dba opens ? thanks ...

Compatible programs with Access program

Jorge Cervantes - 24 Nov 2007 4:58 PM - 2 messages

I am currently using 2003 Access (from 2003 Office Suite). I am going to get another computer which I need an access-compatible program. Is there any open-source program or shareware which is compatible with Microsoft 2003 or 2007 Access program? ...

Conflict with short date and default input mask

Doug - 24 Nov 2007 7:41 AM - 2 messages

Hi, I created a short date field. The format is dd/mm/yyyy when displayed. The input mask is set to 99/99/00;0 (default, I didn't type anything). If I edit an existing date, say change 12/14/2007 to 12/15/2007, I get ...

Setting position of a popup window

Doug - 24 Nov 2007 7:22 AM - 3 messages

Hi, Is there a way to get a popup window to position itself near the control button than launched it. My date selector popup appears all the way to the left, and the control button is all the way to the ...

Parameter issue

Loretta - 24 Nov 2007 4:46 AM - 2 messages

I just started a new job where I use an Access database that was already set up. I have very little experience with the program (only data entry, really). I hadn't worked with it in a while and forgot how important column headings ...

Help with searching

Richard - 23 Nov 2007 8:41 PM - 2 messages

I am working on a multi-user form / subform one to many relationship. Two data tables, master table (tblWarehouse) primary key set to WarehouseID / autonumber child table (tblPurchData) primary key set to PurchaseOrderID / autonumber with a foreign key WarehouseID from the master table. I am using a ...

Print icon grayed out on Access 2007?

Nigel Molesworth - 23 Nov 2007 3:47 PM - 1 message

I've got a database that has been running fine for ages, currently being managed by Access 2007. I did a bit of tweaking a few weeks ago (this may be a red herring) then a week ago I noticed that the Print icon was greyed out ...

Conditional background colours

Andy - 23 Nov 2007 3:41 PM - 3 messages

Hi I have a form where I use conditional formatting. I simply want the background of the boxes to become the same colour as the standard background of the form. When I go into CF, I only get a few colours to choose from - ...

Label template L7161Avery?

Elizabeth W - 23 Nov 2007 9:58 AM - 2 messages

Does anyone have this template that I could use?Thank you ...

DLL problem

PaulHollingshead via AccessMonster.com - 23 Nov 2007 9:42 AM - 8 messages

I'm an experienced coder and have worked with many DLLs in the past but this one has me beat. I'm creating a software link between our dental system (Access97 & 2000 - yep we cater for people with very old hardware) and a french digital xray system ...

How do I get a form to wait for a popup to close?

Doug - 23 Nov 2007 9:20 AM - 3 messages

Is there a way to get the VB code that opens a popup to wait until the popup is closed before continuing? ...

How to add back to top in web page

Veronica - 23 Nov 2007 1:33 AM - 2 messages

Hi, I'm self taught in web design and I'm using the MS SharePoint. Man I should have got FrontPage Again. Well What is done is done. I'm working on a information resource website to help the homeless and help ...

E-mail command button

dcc15 via AccessMonster.com - 22 Nov 2007 10:48 PM - 13 messages

I have a Form with a send message cmdbutton that I have been trying to automate by adding some code (am new to VBA and learning). I understand some of what I have done but not all... When the cmdButton is clicked a "Object Required" MA Access message pops up. ...

How do I use the ampersand, &, symbol in a label in Access?

Mama - 22 Nov 2007 8:16 PM - 2 messages

Hi everyone, My & is not showing up in the header, only a dash/line. Why won't it show up? ...

Windows Communication Foundation

EDWARD HYMAN - 22 Nov 2007 5:46 AM - 2 messages

Is Windows Communication Foundation available for Visual Studio 2003, ASP.Net version 1.1? Edward ...

drop down lists

MelB - 22 Nov 2007 3:56 AM - 2 messages

I am trying to create basic drop down lists in access and am having the hardest time. I am working with Access 2002 and did not install it myself on the computer (and don't have the disc). Is it possible that I am missing ...

product key

woody - 22 Nov 2007 12:45 AM - 1 message

i downloaded the trial version of office 2007 but i can't get the product key to use it ...

Subtracting two sum fields on a seperate field on query

instereo911 via AccessMonster.com - 21 Nov 2007 7:20 PM - 5 messages

Good morning, I have a table that looks like this: Date | Unit| Call Recvd | Call CFC| I have a query setup with the following fields: Field: Date Table: Large Group Total: Group by Show Field: Unit Table: Large Group Total: Where ...

Appending to normalized split tables

Grand Pappy - 21 Nov 2007 4:53 PM - 3 messages

I may not be using the right terminology ... Imported an XLS (table > import) and ran Table Analyzer Wizard, which split the one (pre-normalized) table into two. The two resulting tables didn't exist before and were created as part of this process. ...

What to learn next

Regi - 21 Nov 2007 4:15 PM - 15 messages

Hi, I am a self taught begining Access user. I would like to learn more. What should I concentrate on? VBA, SQL, both, something else? Thanks for your advise. PS I LOVE this discussion board and it has helped me alot. ...

name parser

mcnews - 21 Nov 2007 3:12 PM - 7 messages

anybody willing to share a name parsing routine? tia, mcnewsxp ...

Data shows in query but not report

Lori - 21 Nov 2007 2:23 PM - 5 messages

Hi, I did a query to so I could do a report to list all our companies bank accounts and numbers. When I run the query all the data shows up fine. But when I do an autoreport - tabular, the bank name does not show up. It is the ...

Help With Simple Report? Thank you in advance

RobertKellerman8 via AccessMonster.com - 21 Nov 2007 1:40 PM - 4 messages

Hello, I have multiple employees. I track each employees work to provide them with feedback. Each employee enters information into an accounting system. I have a form that I use (given to me) in access that allows me to enter the ...

Refresh data on form tab

Andy - 21 Nov 2007 10:42 AM - 11 messages

Hi I have a form with 5 tabs. The first tab is editable, and the other 4 are just reports relating to the data on the first. When I change the data on the first form, this is not reflected in the other tabs. I've read, and ...

Making a report with only records matching certain criteria

Doug - 21 Nov 2007 7:59 AM - 4 messages

What is the simplest way to make a report where only the records where a field matches a certain date are included, and the user first selects that date (from form or popup)? (I can write the SQL to select ...

Enable All Fields When Creating New Record

scadav - 20 Nov 2007 9:53 PM - 3 messages

Hi, I have a problem that I am hoping someone can help me with. I tried searching for a solution to this problem, but could not come up with one. Anyway, I have button in access that opens a form and adds a ...

sample db for incoming inspection?

daniel - 20 Nov 2007 9:12 PM - 1 message

hello my name is Daniel, and im need a sample of db such worck with access, im been worck with visual, but acces its so hart to me, some one help me ...

filter to exclude "all containing" from the query

Leo Rod - 20 Nov 2007 8:49 PM - 4 messages

Good afternoon, I need help; when trying to exclude all the records that contain an specific combination of letters: "TRF", even when I'm able to do it in Microsoft SQL, I can't find a way to make it work in access. ...

filter to exclude "all containing" from the query

Leo Rod - 20 Nov 2007 8:44 PM - 1 message

Good afternoon, I need help; when trying to exclude all the records that contain an specific combination of letters: "TRF", even when I'm able to do it in Microsoft SQL, I can't find a way to make it work in access. ...

removing duplicate

Hendrix10 - 20 Nov 2007 8:37 PM - 2 messages

I have a table that has mutliple records for the same person. I know how to create a query to remove duplicates but i don't know how to create a table to remove duplicates but keep the most recent record. ...

viewing information

Terry - 20 Nov 2007 7:01 PM - 3 messages

I'm very new to access. My boss wants me to design a form to enter information on testing a produce. He wants to be able to view all the information that he enters for the month. He wants to be able to view ...

crosstab query

tony rizk - 20 Nov 2007 2:41 PM - 2 messages

I'm building a crosstab query. Is it possible to make the sum of two different valu under the month. Example under january column two amount in $ & Euro separately. ...

Report question

Bianca - 20 Nov 2007 11:32 AM - 9 messages

Hello, I have created a report where one of the columns is "Status" where the status can be Valid or Cancelled. I want the sum of the Valid and Cancelled separately because then I have to subtract the two and get an average. Also I ...

Help Access 2003... in ComboBox query doesnt populate right..

Ahmed - 20 Nov 2007 9:24 AM - 4 messages

hi, thanks in adance ... I had writen Access 2003 Datbase... Forms were working befoe.. now upgrading to Windowvista Combbox query does no show the alphanumeric LAstname,First name etc... Primary key populate But ... these fields are just blanks... can anybody help please ...

Help Printing Current Record

Richard - 20 Nov 2007 4:26 AM - 5 messages

I am working on a multi-user form / subform one to many relationship. Two data tables, master table (tblWarehouse) primary key set to WareID / autonumber child table (tblPurchData) primary key set to PurchaseOrderID / autonumber with a foreign key WareID from the master table. I want to be able ...

Decimals in Table

Novice2000 - 19 Nov 2007 10:14 PM - 3 messages

Hi, I have a table that I want to change the fees from two decimals to 3 so that I can change a fee to 0.005 Each format I try results in this number not being displayed in the table. ...

outlook email questionaire

jwhack - 19 Nov 2007 9:04 PM - 4 messages

I have a questionaire that I want to email clients, have them answer the questions, and then return it to my email by clicking a button (they won't have to enter my email address) The answers will be text of varying length. ...

Really don't know where to start - Outlook with Access

Longshot Phil - 19 Nov 2007 7:01 PM - 2 messages

I'm trying to get Access to make folders in a mailbox. copy e-mails into a folder under my inbox, and place them in the mailbox in the folder that was just made with the current date. After all of that running a macro while ...

Required Field.

John - 19 Nov 2007 4:51 PM - 2 messages

Hi. I have a question about adding a required field or validation rule. I have a access db already set up. on the form where you enter the info there are drop down menus to select certain criteria instead of having to input ...

printform

mcnews - 19 Nov 2007 2:24 PM - 5 messages

is there anything like the VB6 Me.Printform command that prints the contents of a form? ...

Option Groups

Jen - 19 Nov 2007 11:52 AM - 3 messages

Hi.....I've created an option group on a form with 6 possible choices. It is bound to a field in a table and seems to be working fine except when i generate a report from this table, it prints the numerical value from the ...

Is this the way to go?

Jim - 19 Nov 2007 3:26 AM - 5 messages

Years ago I did a little work on several Access data bases, for my own use, but that was the end of it and I quickly forgot everything that I knew - which was little. Now I'm about to start again to try and make a data base that will be ...

Can't create "drop-down list box"

Doug - 18 Nov 2007 10:38 PM - 3 messages

Hi, I can't figure out how to create a drop-down list box. The help file says it exists. The icon in the help file matches the combobox in the toolbox. I tried using a combox box, both with and without using the ...

converting seconds to mins

time convertions - 18 Nov 2007 7:58 PM - 3 messages

I needs to convert seconds to mins how d o i do it in excel Eg: i need to convert 236 secs to mins how do i do this.. the answer should be 3 mins and 56 secs how do i do this ...

help writing turabian style

ms.honey76 - 18 Nov 2007 2:28 AM - 3 messages

need help writing turabian style paper. ...