Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Lebans ExtractInventoryOLE question
dasadler - 30 Jun 2006 10:51 PM - 2 messages
I am trying to extract embedded pictures from a table in a database using Lebans ExtractInventoryOLE utility (which, BTW, is very cool). There are about 50 records but I am only able to extract seven pictures.  When I do an inventory, it seems that the only pictures I am ...
Score Summary Query - grouping by Month
Jay - 30 Jun 2006 9:32 PM - 2 messages
Hi, I have a table containing a date/time field.  I have a summary query based on this table which was set up using the wizard.  I stipulated to group by month when asked. (i.e. All records in April 2005) ...
Score ad-hoc query
wgaskill - 30 Jun 2006 8:26 PM - 6 messages
I must be stupid, but I can't figure out how to do an ad-hoc query in Access. I can generate the SQL statement in VBA, but I can't get it to pop up like a regular query.  I need to generate the SQL statement based on user choices, ...
Score Send Record to new database
Linda RQ - 30 Jun 2006 2:37 PM - 2 messages
Hi Everyone, Acess 2000. We have a database that has been used to enter patients, room, treatments they are on etc...This is a flat database even though patients can have multiple treatments.  Suffice it to say it works well for what it's used for ...
Score How to create tables with images in them
zm - 30 Jun 2006 2:27 PM - 3 messages
I'm trying to create records with a picture in each. Can someone show me a sample table ...
Score MM/YYYY edit mask
mcnewsxp - 30 Jun 2006 2:18 PM - 3 messages
anyone know of a way to get an edit mask that allows and stores a valid date in MM/YYYY format. if not a valid date then at least prompts the user to enter data in MM/YYYY format. BTW - 99/9999;0; does not do it. ...
Score Acesss 2002 - 2000 Format?
Joan NYC - 30 Jun 2006 11:27 AM - 3 messages
I haven't used Access in some time and am creating a simple PIM I have Office XP (2002).  However when I create the new database it shows as Acesss 2000 Format.  Is this correct? Thanks much. ...
Score Reminders in access
Andy UK via AccessMonster.com - 30 Jun 2006 11:00 AM - 5 messages
Hi, I have set up a basic dbase containing a list of subscribers to a news letter. I have the date of subscription as a field name and would like to set up a reminder one month before the subscription is up (working on a 12 month basis) ...
Score highlighting in Multi List boxes
Kamitsukenu - 30 Jun 2006 9:53 AM - 20 messages
Hi there, I've got a textbox on a form that you can enter a quantity, plus a multi list box that displays a list of tables, plus their record quantities.  I was wondering if it is possible to 'highlight' (or select) the ones equal ...
Score I get error on script page permission denied and info is correct
Loutrade - 30 Jun 2006 7:26 AM - 2 messages
I keep trying to add an email account, but I can not get access. I keep getting error has occured on script page it say access denied, but I have tried multiple accounts and my info is correct. any advice I have newer ...
Score Unbroken reference to owc10.dll version1.1
bangaram via AccessMonster.com - 30 Jun 2006 5:16 AM - 2 messages
Hi All,   i developed a database named TFGGQualityDB.Its working fine on my desktop system. when i tried to open the same mdb file on Laptop i am getting error like your database points missing or broken owc10.dll file. on both systems i ...
Score How to Compact Database
Nova - 30 Jun 2006 3:21 AM - 3 messages
I set compact on close in my program. It works normally when used for stanalone, After that I put this program in server, When extit program it create new file eveytime. why?. How can compact database on network ...
Score What is the main function of Microsoft Access?
sarita - 29 Jun 2006 10:34 PM - 3 messages
I am doing a self tutorial on Microsoft access and i was wondering what the primary function of access is.. Can someone help me? ...
Score Printing from MS Web Site
Dave Mackler - 29 Jun 2006 7:44 PM - 2 messages
None of us can figure out how to actually print a page from the MS support site.  Any page we go to cuts of 30% on the right side, even after selecting "Print this page" option. How does anyone actually print out this valuable information?? ...
Score setting the value of a text field based on the selection in a comb
fifi - 29 Jun 2006 3:37 PM - 11 messages
hi, i have a combo box  that let you select 1 of 4 categories.  Now I would like the fee to populate based on the selection. Example if cat=1 then me.fee=40 if cate=2 then me.fee=60 ...
Score SImple Division
pj - 29 Jun 2006 2:20 PM - 2 messages
How do I divide a number by 100 in a query? ...
Score Storing information in linking tables
Tom via AccessMonster.com - 29 Jun 2006 2:15 PM - 6 messages
Hi I was told that you shouldn't store information in a linking table (many to many) except keys, Is this true? tom ...
Score Seriously Numpty Query Question
TheScullster - 29 Jun 2006 2:07 PM - 4 messages
Hi all We are looking to link an Access database to Great Plains, SQL based accounting software. To assist with testing of the link I have been creating tables to provide discrete sub-sets of data for controlled import to G Plains. ...
Score How do I set up an Access database from scratch?
PolymerScience - 29 Jun 2006 11:42 AM - 4 messages
I need a database for a small company. We have an idea in mind that involves a search window to look for the products. When this information is entered in, then another window will pop up showing all the information about that ...
Score pleas help me
louis - 29 Jun 2006 9:14 AM - 4 messages
how to add items in the field to chosse from it for example i have field it's name "name" and i want to inter louii or dani or dina to chosse one from them thank you so much for your help ...
Score How can i make the handwritten convert to text ?
Isabelle - 29 Jun 2006 4:08 AM - 2 messages
I Just bought an electronic pen to take notes, using the microsft OneNote program, however every time i try to convert the handwritten to text it does not work! I AM clicking the right buttons i already tried the trainning ...
Score Why does my Database not open sometimes
AK - 29 Jun 2006 1:42 AM - 2 messages
Hello, I am going crazy. Sometimes my mdb opens just fine, other times I get the hourglass and after about 5 seconds, it goes away and leaves me with the access main page but with no database opened up. What is happening. The db does  not have a password that I set. Just using ...
Score getting dates in order
Winnie - 29 Jun 2006 1:41 AM - 2 messages
Hope this makes sense Using the generic ledger database in access 2000 I enter a transaction and dates are in ascending order When looking at the individual accounts the transactions are not in order. Help please ...
Score Query Help
DS - 28 Jun 2006 8:43 PM - 3 messages
I have a Query.  It has a StartTime and an EndTime field.  Both Fields are Date/Time Type.  I made an expression that reads... Expr1:=IIf([EndTime]<[StartTime],[After]=-1,[After]=0) The After field is a Checkbox, essentially I want the CheckBox to be ...
Score Change table or query in a form?
fox - 28 Jun 2006 6:59 PM - 3 messages
Hi!     I have a question about form's table/query. Now I have a form, however, it's data come form a exiting table/query. Now I make a new query, can I change its link to the new query? Or I have to remode the form? ...
Score HELP !!!!!!!!!!! mdf files
Maggie - 28 Jun 2006 6:30 PM - 3 messages
hi, I need to send an .mdf file in an email and I cannot do it. I cant even zip it. I cant do a thing with it. I stopped sql server and that doesnt seem to have helped, since I thought it was accessing it. I shut everything down too. ...
Score where can i find sample student and course database...
pearlprint - 28 Jun 2006 6:04 PM - 2 messages
...
Score Problems Adding Pictures In Forms
WC PC Guy - 28 Jun 2006 5:03 PM - 2 messages
I have set up a database to list information about people and I want to add their picture to the form. I want it set up like on NorthWinds sample database. I have tried copy and past from the sample data base but it still ...
Score HELP again!! -- Regular Expression
siLver - 28 Jun 2006 3:28 PM - 2 messages
Hi, I'm using Access 2000. Had search all over, but couldn't find stuff that say regular expression in vba.. I trying to write a function, which has a input string(values are parse over from a table in Access). ...
Score PLS HELP - Using dialog box..
siLver - 28 Jun 2006 3:17 PM - 2 messages
Hi, I'm doing vba with Access 2000. Am kinda lost now.. I got this problem here. I got this user interface which needs to have a dialog box for the user to chose the path/directory of a folder which ...
Score Complex Update Queries
Jon - 28 Jun 2006 1:52 PM - 3 messages
I have two large databases, contacts (~300 records) and master (~2500 records).  Both databases have a column SSN and rank amoung about 30 other columns.  What I need to do copy the rank from master to contacts where the SSN is the same. ...
Score Junction Table
Christo Yssel - 28 Jun 2006 9:41 AM - 2 messages
Hi, I need to confirm that I have done this correctly: I have the following tables: Suppliers SuppliersID (pk) Products ProductID (pk) SupllierID (fk) UnitPrice (from supplier) one-to-may relationship between products and suppliers Every supplier has many products but products have only one supplier ...
Score Beginner's question
Sandro Fergnani - 28 Jun 2006 8:55 AM - 2 messages
Hi all and greetings from Italy ! I'm writing my first Access app and I have a question. I have a button in my form that delete the current record. Since there is a one to many relation between the table where the to be deleted record is ...
Score Excel spread sheet linked via Access question
Renetta - 28 Jun 2006 3:18 AM - 3 messages
Hi, I've seeked assistace regarding excel and how I could limit what is entered into a cell.  Now I've done a Validation and it works. Now that I have done this and I've linked my spreadsheets to MS Access and another question comes up. See, ...
Score Design problem
Christo Yssel - 27 Jun 2006 9:59 PM - 3 messages
Hi, I am not sure how to solve the following problem: I have 3 tables, Suppliers, Adresses and Clients The address table must store addreses from suppliers and clients. A Supplier can have more than one address, postal and lets say delivery (same for ...
Score Access 2003 and subforms
Christo Yssel - 27 Jun 2006 9:44 PM - 5 messages
Hi, In Access 2000 it was not possible to have a form with more than one subform at the same level, only nested subforms. Is it still the same in Access 2003? Thanks Christo ...
Score Uploading informations from a query...
John Muff - 27 Jun 2006 7:56 PM - 3 messages
Hi, I have a form, pulling info from a table(1). There is a dropdown menu on the form used to retreive information from a query, linked to a second table(2).  How would I extract ALL of the value selected on the dropdown query to show ...
Score Error in User, no error in Admin
Lori - 27 Jun 2006 7:05 PM - 8 messages
I have a user here in the office that is getting an error when he clicks on a command button I set up to close the form and it points to the code I wrote for the button.  I went in and pulled up the same form and it works fine.  I ...
Score repost - two front-end users were able to update same record
Freeda - 27 Jun 2006 5:41 PM - 11 messages
I have this code on my form since my Lender ID is not autonumber, I had problems (before) updating my records.. Private Sub Form_Current()      If Me.NewRecord Then         Me.txtLenderID.Enabled = True ...
Score identical field in multiple tables and would like to populate all
kujtimh - 27 Jun 2006 5:28 PM - 2 messages
I have multiple tabels all containing one field that is identical. How can I enter the data in this one field in all tables, just by entring it once? ...
Score Send Keys??
Chris - 27 Jun 2006 4:00 PM - 8 messages
When should you send keys?  Is there a better way; rather than using send keys? ...
Score HELP PLS!! -- assign values into combo box
siLver - 27 Jun 2006 3:43 PM - 3 messages
Hi, I'm using Access 2000 trying to do some vba here. Had no idea how izit possible to assign these values into a combo box. I have a table with 2 fields that contains (1) Start_Year (2) End_Year both ...
Score Which Event property should I use to refresh subform data?
David Newmarch - 27 Jun 2006 2:55 PM - 3 messages
I have a combo box on an Order Details subform which doesn't display the correct drop-down list (for selecting subclients of the agent placing the order) unless you hit F9 to refresh the data each time you go to a different ...
Score How do I set up slides to cycle automatically in Live Meeting ?
sedasi - 27 Jun 2006 12:23 PM - 2 messages
I want to set up 3-4 slides to cycle prior to the statr of my meeting so that when attendees lofg on they will know they ae on the correct site. These slides will also provide useful tips on how to use Live Meeting. ...
Score Using Keyboard Up and Down Arrows with Combo Boxes
Jack G - 27 Jun 2006 11:31 AM - 10 messages
In most Windows Applications with combobox-like dialogs, you can start typing in the box and after a few letters use the keyboard up and down arrows to select the specific entry you want from the list.  With my Access ...
Score sir how create merge cells and the aNY DCOMAND OF THAT ONE
p.sriramachnadramurthy - 27 Jun 2006 10:46 AM - 2 messages
...
Score Updating a very large database
Dimitris - 27 Jun 2006 8:56 AM - 2 messages
Hello, I have a very large database with 1,7 million records and about 100 fields. My problem is that I have a field with numbers but that field is a text field and I cannot filter that field to find specific numbers. For ...
Score Need to change user interface so navigation of tables is easier
Andrew - 26 Jun 2006 10:04 PM - 5 messages
I am currently maintaining a database which is being reviewed and updated by many users.  Due to the number and length of the fields in the database, navigation of the table involves scrolling over almost 3 screen-lenghts to ...
Score commas in string
AndyM - 26 Jun 2006 5:34 PM - 3 messages
I have a combo box called "stressbox." After an update, I'd like it to open a separate form called "stressqueue" and find all entries for where the value stresseng (on the form) has the same value as stressbox. This is a problem ...
Score Northwind Database
Lynn - 26 Jun 2006 4:15 PM - 2 messages
I need to create a small database to keep track of some parts.  I can easily strip down the Northwind database and have exactly what I need.  One of the most important things I need to be able to see is how many parts are on hand ...
Score "Simple" Global Mailing List - 1 table or 3?
Nunnsby - 26 Jun 2006 3:51 PM - 2 messages
Hey all Thanks for taking the time to read this msg. I am a "newbie" to Access, so bare with me here. I have a fairly simple request, but am struggling the basics of it, so any help would be highly appreciated. ...
Score Auto Number
LindaC - 26 Jun 2006 12:32 PM - 3 messages
I started using the Recipe Wizard which included the RecipeID field that is an Auto Number.  I entered 96 records and then accidentaly pressed something (not sure what) and the field is still there but it now a Number, not Auto ...
Score store ,for machinery items
quality generatos - 26 Jun 2006 9:50 AM - 2 messages
sir, i am a store keeper,i need to find out incoming stock and out going stok and cash price also,if you can possible pls forwod me                                  thaknks ...
Score How to convert form .doc to .rtf (I have Word 2003)?
ELLY - 26 Jun 2006 3:13 AM - 2 messages
How to convert form .doc to .rtf (I have Word 2003)? ...
Score Memo Box Problem
John Calder - 26 Jun 2006 3:11 AM - 5 messages
Hi I run Win2k with Access 2K I have 2 Memo boxes in a form. The 1st one is set to Default in the "Enter Key Behaviour" in the "Other" properties. This allows the curser to tab to the second memo box after I have ...
Score How do I sort Mac and Mc together alphabetically?
penrod - 26 Jun 2006 2:15 AM - 10 messages
I wish to sort a list of names alphabetically in access. How do I keep names Starting with Mac and Mc together or sequential? ...
Score how to link access data to excel's pivot table
Holly - 25 Jun 2006 3:11 PM - 6 messages
I have over 100K records in access, which exceeds the limit of rows in excel. Can i link excel to access database to pivot the whole table? ...
Score Weekday only in Datediff function ?
Ken - 25 Jun 2006 12:01 PM - 5 messages
I'm trying to calculate the number of weekdays (Monday to Friday) between two dates, I can use the Datediff function to get all days between the start and end dates but can't figure out how to get the ...
Score Dir function in Access 2003
ZX10 - 25 Jun 2006 11:37 AM - 7 messages
I am converting a database from Access 97 to 2003, and cannot get the DIR function to work. Even creating a new database, with a single form, and one text box =dir("C:\autoexec.bat") doesn't work. In all cases I get   #Name?   error. ...
Score How to convert existing text to proper case
Shub - 25 Jun 2006 3:10 AM - 3 messages
I created a new table by importing the data. The text in some of the fields are either in upper case or lower case. How do I convert the existing text to proper case? ...
Score Ordering dates in a report
Jim - 25 Jun 2006 12:53 AM - 9 messages
Each month we receive payments from clients and then print a simple Access report listing each clients name, payment amount, and day of the month the payment was made as shown below. Client    Amount    Payment Date ...
Next »