Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score If Null
DS - 22 Oct 2005 7:59 PM - 3 messages
Is there a way to write a statement for this without using IF over and over again? If any one of these 3 boxes are Null then do this..... As opposed to... If IsNull(Text1) Then DoCmd.OpenForm"1" ElseIf IsNull(Text2) Then ...
Score alone
rob p - 22 Oct 2005 6:07 PM - 2 messages
Once I'm finished and ready for a user to run the program, I know you can set up switchboard to run. Is that the typical way of setting this up? Or is there a way to save something to the desktop (switchboard form or ...
Score How to type and see and hear the letters come on screen?
ties - 22 Oct 2005 5:00 PM - 4 messages
I find very useful graphics with text being typed and coming on screen in a some demonstrations of  how to do something, (instructions) where the person typng the text is explaining what he is doing and where the viewer can not ...
Score date format into text
Akrt48 - 22 Oct 2005 3:57 PM - 10 messages
Help,  I have an access data base that I have to transfer information into another db.  The setup of the other one is where there are birthdays or just dates they are done in text format eg 19651031 the first data base says ...
Score Saving my A2K customized toolbars?
StargateFan - 22 Oct 2005 7:18 AM - 3 messages
In Word, I keep a backup of my normal.dot; for Excel, my Excel.xlb. What file do I search for on my hdd to save the one I've just customized for Access?  I've done a search for all files on my hdd ...
Score Microsoft asks for product key to download. Mine won't work
Llamacek - 22 Oct 2005 6:41 AM - 2 messages
If I try to download a template to access, it asks me for the product key. Mine won't work, although I have already registered my office professional. Am I doing something wrong.? ...
Score Field label names get cut off on form
Pat B - 22 Oct 2005 1:10 AM - 3 messages
I'm new and trying to learn this on my own, so any help will truly be appreciated. I've created my table and when I import that table into the form view, my column headers (from the table) are cut off on the form as lable ...
Score Small business accounts to balance sheet
alphonse kumahor - 21 Oct 2005 10:28 PM - 2 messages
When is microshoft going to produce accounting package? i.e.  Sales account; purchases account; nominal ledger; trial balance and balance sheet? ...
Score Pull Combobox info and populate other Controls (DynaSets)
Data - 21 Oct 2005 9:53 PM - 3 messages
I have 1 combo box and 5 other Controls. I am pulling using a query to pull the records and putting them into combo box. I want to be able to select an item from the combo box list and then populate the other 5 ...
Score create a data base
Pauline - 21 Oct 2005 8:56 PM - 4 messages
Hi, I'm new at access. I was wondering how do u recreate a form (questionaire) into access. Then creating a database of this form so that agent can input info from the questionaire sheet into the data base. By doing ...
Score Rows and Columns in database
Fehn - 21 Oct 2005 8:50 PM - 3 messages
How can I show this form in a datasheet view. I havent created this in access yet but i have this in excel. It goes like this: Description    10/1/05   10/2/05  10/3/05.... etc. ...
Score On solution startup, table open and minimize?
StargateFanFromWork - 21 Oct 2005 8:38 PM - 7 messages
I've seen DBs where on startup a particular table or form, etc., can be seen to open but then is minimized in the background before the switchboard or other comes up and stays up.  How do we do this pls?  The particular screen ...
Score Error Message?
Randy - 21 Oct 2005 7:44 PM - 2 messages
How do I fix this error? The database has been placed in a state by user 'admin on machine n350013205 that prevents it from being opened or closed. ...
Score append query greatly increases number of records
George - 21 Oct 2005 6:22 PM - 6 messages
When I make an an append query with same type names number of fields the number of records increases more than 10 fold. Any ideas? Thanks ...
Score Put blank record at top of form
Randy - 21 Oct 2005 4:50 PM - 7 messages
I created a continuous form, but I want the blank record for data entry to appear at the top of the list of records rather than the bottom of the list.  Is there a way to get it to move to the top of the list?  I ...
Score Link Excel to Access
Tom - 21 Oct 2005 2:56 PM - 2 messages
When I link to a Excel using Access I had a mismatch.  So I went into Excel and changed the column from a General type to Text type and saved the file.  I then opened the linked Table in Access and noticed that the field type was ...
Score Need help with vb code
wayne - 21 Oct 2005 12:16 PM - 3 messages
I have an application where I retrieve access 97 data with a query, export it to an excel spreadsheet (test.xls) and use a button on my form to open excel.  I need some help with the code to have excel open directly to the ...
Score HELP
Stevene James - 21 Oct 2005 8:53 AM - 20 messages
Ok people i appreciate this might me a bit long winded but ANY help would be appreciated. i have a table called "Customer_Details" and i have 3 other tables calls "tariff 1", "tariff 2" and "tariff 3". The Customer_Details table has a form with the same name and on that form ...
Score H E L P !!!! word is not working!!HELP!!!
kikkisouse - 21 Oct 2005 6:20 AM - 2 messages
HELP!!!!!!!!! Thank You Sheila Wells ...
Score a date bug?
JethroUK© - 20 Oct 2005 10:43 PM - 9 messages
access seems to change the format of date fields just for editing e.g 20-Sept-05 (defined format) becomes 20/09/2005 13:07:00 (whilst editing) it's not the first time i've noticed this strange behaviour (97, 2K & XP) - ...
Score setting up email with microsoft
not computer savvy - 20 Oct 2005 9:29 PM - 2 messages
how do we set up email  via microsoft when we have radrunner as our service? ...
Score Data entry then print?
Randy - 20 Oct 2005 8:15 PM - 6 messages
Whenever I enter the record and then go to a report based on that record the record does not show up in the report it is blank.  Its there but it appears that the table has not accepted the record when I ...
Score Task Bar Mess
Janet - 20 Oct 2005 5:51 PM - 3 messages
Since switching to Access 2003, every time I open a form, report, table, etc, a new tab shows in the task bar.  Is there anyway to turn this off? ...
Score & im stumped again
kyle - 20 Oct 2005 5:26 PM - 3 messages
Ok in the page footer of my report I have a lable which says A&P, however the & always disapears!!! So my question is how do i get the '&' to stay visable and not disapear... thanks ...
Score Basic Direction Required
Mad_Gerbil - 20 Oct 2005 5:22 PM - 8 messages
I develop in .NET, typically using a 3 tier approach where I have client machines connecting to SQL server.   Anyways, I got pulled onto a project where they want Access to connect to a SQL server so that the users may have ...
Score Creating an order form using one table and autocomplete
mirrax - 20 Oct 2005 5:07 PM - 3 messages
I have one table with product number, product description, and product price. I want to create a simple order form in which I can enter the product number(and it will automatically fill in the entire number as I type) and the ...
Score forms and tables HELP!
mac - 20 Oct 2005 4:25 PM - 4 messages
Hello, I need help.  I have set up a form and it works okay, except that I have 3 dlookup fields.  When I look at the table all the data is there except the 3 lookup fields.  How do I fix this? ...
Score up & running
Robert - 20 Oct 2005 3:42 PM - 15 messages
I do not have time...can anyone suggest partners/MVP's that will create for fee a small business solution using Access 2000. ...
Score combine variable names in a query
lily - 20 Oct 2005 3:07 PM - 13 messages
I have several unbound fields named: "SetNum1", "SetNum2", "SetNum3"... in my form, I need to do the same thing for each of these fields, say: Private Sub x_delrecord_Click()     Dim dbs As Database, rstCustomers As DAO.Recordset     Dim successcount As Integer ...
Score ListBox Value
DS - 20 Oct 2005 2:16 PM - 7 messages
I want to be able to click on an Unbound Listbox even if it hasn't any records in it and return a value to an unbound textbox.  This value has absolutly nothing to do with the contents of the listbox.  I just need ...
Score Front End Management
Ed Warren - 20 Oct 2005 11:53 AM - 3 messages
I need the link to the software that allows one to manage multiple MsAccess Front End databases. I know it has been posted here several times but I can't seem to find the combination of terms to find it in a search. ...
Score I keep getting message telling me I need to install ocr software
POP'S - 20 Oct 2005 5:56 AM - 2 messages
I use works suite 2002 and when I try to view some scanned objects Iget a message telling me I need to install ocr software ...
Score Calculating elapsed time
WKN - 20 Oct 2005 1:34 AM - 8 messages
I am trying to calculate the elapsed time between between two time periods. The begin time in the afternoon (PM) of one day and the end time is the morning (AM)of the following day. Example =HoursAndMinutes([TimeOut]-[TimeIn]) When I use the expression above for the time period Jan1, 2005 Begin Time ...
Score NEED ACCESS SOLUTION QUICK!
ibeetb - 20 Oct 2005 12:46 AM - 7 messages
I and a coworker have taken over a process from consultants where we work to produce 1 report where the all of the data is kept in Access. The way the process was formed, we each have many separate databases, stored locally, ...
Score ca i used word 2000 for read mail filesl
goldwing - 19 Oct 2005 11:55 PM - 3 messages
i removed  microsoft office standar edition 2003, since then i cannot  open the files  in my mail, i try whith others program  don,t work, i try with  word 2000, nothing, so is it possible to open files from mail ???? ...
Score How do I turn off my out of the office auto reply?
Dierdre - 19 Oct 2005 6:11 PM - 3 messages
I am having a problem turning off my out of the office auto reply. When I attempt to select Out of Office Assistant from the tools menue a dialoge box appears stating: The command is not available. See the program documentation about how to use ...
Score Display of relationships - one-to-many etc.
mogens - 19 Oct 2005 5:40 PM - 7 messages
In various tutorials the one and many symbols (infinity sign) are displayed at the end of the lines connecting two tables key fields. But in my MS-Access (2002) there is only a line with no "1" or "8" (turned ...
Score populating a new field in a table
Giz - 19 Oct 2005 5:07 PM - 3 messages
Hi, I have just added a field (called "Org Data Set" ) to a table with over 40,000 records. I want to populate each record identically with the name "DEQ". Do I have to write a query to do this or is there a way to mass ...
Score Query produces incorrect results
Net - 19 Oct 2005 4:28 PM - 6 messages
Hi, I need help with a query that produces results out side of the USA states. The following query produces incorrect result: SELECT Location.Country, Location.Description FROM Location, USA WHERE Location.State<>[USA].[Abbr]; I also tried: ...
Score Linking field to combo box column
Stephosu - 19 Oct 2005 4:25 PM - 3 messages
I am trying to figure out how to activate subsequent fields only when "other" is chosen from my combo box titled "Vendor Name".  This way when a new vendor is used by an employee they will be guided to add the vendor's info (phone#, ...
Score Listbox loaded from previous listbox value
JESwan - 19 Oct 2005 3:45 PM - 7 messages
I have 2 list boxes. The 1st loads from a query. I need to load the 2nd list box based on the bound filed #1 of the 1st listbox. 1st list box is a provider list with providerID 2nd list box is a membe list with providerID and MemberName ...
Score JS-Q1: Hard coding date
Jack Sheet - 19 Oct 2005 3:31 PM - 2 messages
Hi all I want to hard code a date/time stamp in a field dedicated for that information within a record, that shows the system date/time at point of creation of the record (presumably the point of initial saving of the ...
Score crosstabs
Wim - 19 Oct 2005 2:47 PM - 3 messages
I have a small database with 3 columns: Name, Company, District. I want to get a table with the Companies as columns, Districts as rows and the Names in the cells. I tried the "crosstabs" function but that gave me ...
Score Now() function question
Randy - 19 Oct 2005 2:30 PM - 3 messages
Whenever I use this function it puts the date and time into the field even though the imput has a short date. What should I do to get a short date with Now()? Or should it be coded something else? ...
Score multicompany open licence or seperate boxed versions?
Suza - 19 Oct 2005 2:07 PM - 4 messages
I now have 2 conflicting replies to whether to purchase a multico licence or seperate boxed versions of MS Access.   I have 7 users. Any advances on ideas? So far I can purchase a boxed version for £129+VAT and will need a further 6 ...
Score open licence advice
Suza - 19 Oct 2005 1:11 PM - 3 messages
I believe I could get an open licence for this software which might be cheaper than if I buy seperate boxed versions.  I have 7 machines at the moment. How do I buy this? I believe I may have to go through a dealer rather than ...
Score permutation & combination of Lock and Enable properties .
sam - 19 Oct 2005 12:51 PM - 2 messages
What are different results of Lock & Enable properties, What type of SQL query I should write to get data from data field on daily basis, monthly basis, quarterly basis, yearly basis. ...
Score How do I Set up Send/Receive Emails Automatically?
Shariff - 19 Oct 2005 9:06 AM - 3 messages
I use Win XP with Outlook 2000 installed on it, i cannot receive the email automatically instead i have to click on send/receive to download all the emails from the exchange? Please advise how can i configure to receive the emails Automatically. ...
Score Table Quandry
DS - 19 Oct 2005 3:07 AM - 4 messages
I have a problem setting a Table(s) I tried seperating things but it seems that this is all thats working or perhaps I'm missing something. Heres what I have.....They are all Primary Keys escept the last 2 fields.... ...
Score Print and email with one command button
gcollcom - 18 Oct 2005 11:16 PM - 2 messages
Newbie here trying to use one command button on a form to first preview a report and then email the report. Here is my code: Private Sub Mail_Form_Click() On Error GoTo Err_mail_form_Click     Dim stDocName As String     DoCmd.RunCommand acCmdSaveRecord ...
Score Set up Field in Access Form
Robert Kemp - 18 Oct 2005 8:46 PM - 2 messages
I have a field setup to enter pounds in a field per defect. I would like to set up another empty field for the total acumative pounds in 1 field. How do I set up an acumative sum of all records in one field. ...
Score I get the message that I have an error (Ox800CCC32)
Brenda - 18 Oct 2005 7:33 PM - 2 messages
When I try and send an email, I get this error message??? Help Please!! ...
Score Switchboard and Publishing with Word
kyle - 18 Oct 2005 3:58 PM - 4 messages
Is it possible to have a button on my switchboard or even my form that will publish a table into word. Right now I am closeing my form and then clicking on the table that i want to publish and then using the tool bar to publish it. ...
Score setfocus back in an exit event
lily - 18 Oct 2005 3:41 PM - 6 messages
in an exit event, I check the field value, if something wrong with the data entered, I need to set the focus stayed at the control until user entered a valid data, I wrote like this: Private Sub SetNum1_Exit(Cancel As Integer) ...
Score seeking a donation checksheet/template listing items value recip
AnneMarie - 18 Oct 2005 3:26 PM - 5 messages
We are looking for checklist of items that we can check off (clothing) and easily list items like household, kithcen items,  games, ect.  To avoid the notebook paper list of pants w/ talley marks. Thank you ...
Score Label Wizard pulling wrong information
Missie1 - 18 Oct 2005 2:06 PM - 9 messages
Hello ! I have never used Access before.  A friend of mine set up the program for me so that I can enter new names/addresses into a database and then print labels using label wizard. I have been adding and deleting people from my database all week.  Now when ...
Score trying to understand a basic query procedure
Eric Lin - 18 Oct 2005 5:00 AM - 2 messages
I'm getting started with SQL and MS Access, and I'm using an example and very simple database made of 2 tables. table                           contacts: ...
Score hotmail
soobee - 18 Oct 2005 3:43 AM - 2 messages
When I want to send a new message on Hotmail, the toolbar is not visible on the blank page.  How do I get it back? It used to be there? ...
Score Stock management
colvin - 17 Oct 2005 8:29 PM - 9 messages
I have a d/b with a table containing over 1000 tropical fish, I need to manage the stock of this table. Ie I need to know what my current stock is, how many of a certain species has died , what sort and how many of a species ...
Score Quick! Need to print labels from database
ToriSC - 17 Oct 2005 8:25 PM - 5 messages
I need to print labels from a database I have under "forms." How do I do this? ...
Score Multiple Versions used to create one presentation
PharmD - 17 Oct 2005 7:58 PM - 2 messages
I am having trouble downloading a ppt presentation that was created by one person using ppt 2003 and sending it out via an e-mail and another person adding on to this presentation using ppt 2000 and sending out via e-mail.  ...
Score how do I reduce stock as it sells
colvin - 17 Oct 2005 7:31 PM - 2 messages
I have a database where I can order and list tropical fish from various suppliers - i would like to expand the db so that I can track my stock. I would like to input the amount of each species of fish I have and at the end ...
Score Printing labels?
Randy - 17 Oct 2005 4:09 PM - 10 messages
I have used the following code to print out labels based on a suggestion in the archives, but I get an error message.  "Can not find object referred to" The error refers to [SkipControl]= "Skip" Can someone help me with this.  Here is the code.  I have also entered ...
Score Sum by name
Akrt48 - 17 Oct 2005 4:03 PM - 7 messages
I have a table that has some information regarding employees.  I am trying to sum up the financial information by the employee name.  I have 3 fields that have such thing as dues, initiation, and hours for the period.  I want a ...
Score ControlTipText Popups when tabbing in Access
GW - 17 Oct 2005 3:29 PM - 4 messages
Is it possible to have ControlTipText ToolTips (balloon tips) appear in Access when fields are tabbed into, not just when there is a mouse-over of the field? ...
Score Set label report to print one label per record
Randy - 17 Oct 2005 3:00 PM - 3 messages
I am trying to set up Nick Hutnicks suggestion for printing labels.  He says to make sure you set up the label report to print one label per record. I don't see any settings for this. Could someone tell me how to ...
Score Retrieving data from database using VBA received Error # 424
Net - 17 Oct 2005 1:47 PM - 6 messages
Can someone help in retrieving data from the Access 2000 using VBA. I have the following code where on OpenRecordset I receive: Error # 424: Object required Option Compare Database Dim valYear As String Dim valMonth As String Dim sMonth As Double ...
Score Form design
Jack Sheet - 17 Oct 2005 11:40 AM - 12 messages
Hi all I want to create three forms: One form is just for reviewing the entries on existing records in a table. No amendments would be permitted and no additional records would be permitted. One form is for editing existing records in a table, but additional records ...
Score reference guide to system functions
sasan3 - 17 Oct 2005 11:10 AM - 3 messages
Where can I find an online reference to all access functions (i.e. OpenRecordset(), dlookup() etc.), their parameter list, usage, etc.? Thanks. S ...
Score New user problems-new record
cerdelac - 17 Oct 2005 5:21 AM - 3 messages
I am in a marketing class.  I opened a new Access database and created a form that was based on a survey created in Word.  I started from scratch creating a nice looking survey and intended on entering the information gleamed from ...
Score Combining (appending?) tables to form a 'new' table
jlwood44@hotmail.com - 16 Oct 2005 11:11 PM - 8 messages
I have imported several tables from EXCEL that are my class lists and other info.  I would like to combine these lists to make a master list of my students.  How can I combine the tables to a new table - and realizing that a ...
Score Checkboxes and Option Groups
PC Datasheet - 16 Oct 2005 10:56 PM - 21 messages
How can the label for a checkbox and the labels for the options in an option group be addressed? When a checkbox gets the focus, Access draws a dotted box around the label. When an option group gets the focus, Access draws a ...
Score Insert a macro into VBA code
Tom K via AccessMonster.com - 16 Oct 2005 9:57 PM - 6 messages
I have a main form with 2 subforms. I need to include a macro in the second form that checks some controls for null values. The problem is that in that form there is allready an event procedure (code) in the on current event. It ...
Score Better Coding 2 SQL Commands
DS - 16 Oct 2005 9:13 PM - 4 messages
I have to run 2 SQL commands, This is what I came up with but I'm sure there is a cleaner way.  It works but cleaner would be better! Thanks DS Private Sub Command4_Click()      CurrentDb.Execute "INSERT INTO JobsDept(DeptID,JobID) VALUES(" & ...
Score Please make powerpoint a stand alone app like a regular program.
†_hilda4jc_†- 16 Oct 2005 7:22 PM - 2 messages
I have works suite 2002  but I don't need all of it... I do need powerpoint for my graphic presentations which I don't have. It is not included. Please make it a stand alone application or tell me how to get it as a stand alone ...
Score COUNTING
Akrt48 - 16 Oct 2005 7:06 PM - 5 messages
I am having troubles counting in a report, I have zeros in a particular field, cannot delete them, but I want to count everything without zeros.  Have tried count([fieldname]>1) doesn't work what am I doing wrong? ...
Score Import and Update Specifications
garmani - 16 Oct 2005 9:40 AM - 2 messages
Hi Perhaps one of you good people will be able to help me. I import order details from our order system into an Access database table, this is quite simply an extract from Crystal saved to Excel format and imported into the relevent table. ...
Next »