Threads Replies Last Post 901 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   event ticket management database Hello, I am a novice at Access and am trying to deisgn a database to record ticket orders for a sporting event. I am wondering if it is possible to set up a field where the seat numbers can be chosen from a drop down list but only be chosen once so the same seat can not be sold twice. -- kathyg... 5 30.09.2006 02:52:40 Keeping Photo editor as the OLE server in Access? Hello, I've created a database inventory with many pictures in it that I designed to use photo editor from a previous version of Office since I can't find an ole server in the current or next version of Office. I'd prefer not to have to recode everything to make it work in one of the other cumbersome methods discussed for inserting pictures in an access database. I've installed jus... 5 30.09.2006 02:36:01 Why BMP file in OLE field says Package rather than Bitmap Image? I consistently get Package instead of Bitmap Image when I insert a BMP file into an OLE field in Access 2003. I have done everything I can think of and I still get this. I did precisely what Microsoft help says do and still no difference. The only way I get Bitmap Image is to insert New Bitmap Image which opens Paint with a blank file.... 1 30.09.2006 02:27:01 Using a query for a simple calculation -- maybe not so simple I use access for maintain a modified ledger. It tracks check numbers, dates, job addresses, vendors and amounts. I need to set it up so that if there is multiple jobs associated with one check number, I can allocate portions of the total amount of the check to each respective job. I have the table set up so that the "Job" field can have multiple entries, so on the query for that table... 4 30.09.2006 02:03:01 ´©¸® ´©¸®¾ß »ç¶ûÇØ ... 1 30.09.2006 01:40:06 UpTownGirl, look! hi~ uptowngirl. your a korean? nice to meet you ... 1 30.09.2006 01:38:42 UpTownGirl, look! hi~ uptowngirl. your a korean? ... 1 30.09.2006 01:38:26 Hi This is a multi-part message in MIME format. ------=_NextPart_000_003E_01C6E47B.A5A80480 Content-Type: multipart/alternative; boundary="----=_NextPart_001_003F_01C6E47B.A5A80480" ------=_NextPart_001_003F_01C6E47B.A5A80480 Content-Type: text/plain; charset="ks_c_5601-1987" Content-Transfer-Encoding: quoted-printable hi~! my name is hayung song. i'm 16 ages. i'm from korea.=20 ... 1 30.09.2006 01:31:53 ÇÏ¿µÀÌ ÇÏ¿µÀÌ ¹Ùº¸ ... 1 30.09.2006 01:30:16 ¸ðµÎ ¸ð¿© ¿ì¸® ¸ðµÎ ¸ð¿© ... 1 30.09.2006 01:27:37 ¤¾¤¾¤¾ ¼¼°èÃÖ°­ ²É¹Ì³à ´©¸® ±×¸®°í ´ÙÀº ¾È³ç~ ¤¾¤¾ ¹Ì±¹ »ç¶÷µé ¿µ¾î¸¸ º¸´Ù°¡ ÀÌ°Å º¸¸é ¸Ó¸® ¾ÆÇÁ°Ú´Ù. ... 1 30.09.2006 01:26:11 ¾È³çÇϼ¼¿ä ¾È³çÇϼ¼¿ä Àú´Â Çѱ¹¿¡ »ç´Â ¾ÆÀÌÀÔ´Ï´Ù Àú´Â 15»ìÀԴϴ٠ģÇÏ°Ô Áö³»¿ä, ... 1 30.09.2006 01:25:46 displaying images... hi...i'm lina.. erm...actually,i need some help from you all...i have make a database for the 38000 images..but the problem is..the data and the images is separate into different table(PhotoA,PhotoB,PhotoC) i have try to combine it into the Query(Query1)..but when i combine it..the images cannot be display..its only show the path..if you open form frmmain...and choose one from the tables ... 3 30.09.2006 01:17:11 URGENT...new and edit forms are locked! After creating 250 new horse show Entries, the forms to create new Entries and to edit existing Entries don't work. The new Entry form instead of being blank comes up with an existing record and a message that says "You can't go to the specified record.". The edit Entry form contains the correct Entry record but the form does not permit any data fields to be changed. I can operate no... 5 30.09.2006 01:16:02 How to Keep Date Format on Export? I am running a query on a database to pull a file number along witht the date it was filed. I am exporting this to a comma dilimited text file. The date field in my query comes in as mm/dd/yy, and I would like it to say "dd of mmmm, yyyy." An example is with , 09/29/06 I want it to say "29 of September, 2006". So I'm looking at design view of my queiry, and I go to the properties o... 5 29.09.2006 23:14:03 After Update Help! -- I have a Query linked to my form, I have a combobox drop down list with this row source(SELECT qryAHOPF.Name, qryAHOPF.HorseID FROM qryAHOPF; ) that shows my horses names, what would i need in After Update so it selects the horse in the dropdown list SELECT QryOwnerHorsePercent.OwnerID, qryHorseFinished.Name, QryOwnerHorsePercent.HorseID, QryOwnerHorsePercent.OwnerPercent, tb... 10 29.09.2006 23:05:18 worksheet calculation Want to increase an entire price list worksheet by a percentage or by decimal number. How can I change all the numbers (prices) on a worksheet at one time instead of calculating one at a time -- Kazoo... 2 29.09.2006 22:33:40 Using a form to enter report crtieria I utilized the guidelines in "Micrsoft Office Assistance:Create a form to enter report criteria" to create the macros, the form, and modify my report and the underlying query. Everything seems to work fine independently; however, when I open my report, and I enter the criteria, the form closes but the report fails to open. Has anyone else used these guidelines and had the same problem?... 2 29.09.2006 22:32:28 Code to send email to group of contacts I am using the following code (from Ron Hughes code to send email to all database at http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='CodeSendEMailToAll.mdb'. When clicking the command button, I click on Yes when prompted to create a new table but at the end the error message "Invalid use of Null" is displayed. Can anyone help? Private Sub SendEmail_Click() Dim str... 4 29.09.2006 22:03:33 Maximizing Access Database that is minimized Posted simular question in Monster Access didn't get response. Have the following code: DoCmd.Minimize Call Shell("msaccess ""N:\Databases\Memo.mdb""", 1) The above command minimizes the current database and then opens my Memo Database. I have a command button on the Memo Database that states Docmd.Quit Question: What could I put on the command button after the DoCmd.Quit to ... 2 29.09.2006 21:54:10 Making records in an access table read-only I want to define an access table so that records can be inserted into it, but once inserted, they cannot be updated or deleted. Is it possible to do this, and if so, how? Thanks in advance. ... 3 29.09.2006 21:44:10 Access 2003 Won't Update Pivot Tables Created in Access 2003 I have an Access 2000 database and a copy converted to Access 2003. I upgraded to Office 2003 Pro (and have all the patches). When I attempt to refresh pivot tables in either the 2000 or 2003 database (with the pivot tables created in Access 2000), I get the very informative Microsoft Excel error, "Problems obtaining data." If I move either database to another computer running Access/E... 1 29.09.2006 21:17:01 Flex Grid Control in Access I am trying to use a Flex Grid Active X control on an Access 2K form and I want to be able to edit the text in a cell. The normal method suggested by Microsoft is to create a text box and move it on top of the cell, enter the text and then update the Flex Grid on exit. The problem is that the text box control is always hidden UNDERNEATH the Flex Grid control (regardless of the Bring-to-... 11 29.09.2006 21:00:01 Control an outside program and capture its data Hello, I need to control a separate program from within Access VBA. Specifically, I need to 1 Open the program 2 Navigate to a form 3 Populate several text boxes 4 “send” the information with an F12 5 Read the returned information and populate a form within Access with the info 6 Recognize errors in this process The dreaded sendkeys appears to work OK for 1-4 but how can I ge... 2 29.09.2006 20:38:02 Normalization and splitting tables? hi, i have a simple database that contains a table called CLIENTS, consisting of fields: ClientID ClientName ClientAddress ClientPassword not every client will have a password assigned to them. is that a bad way to structure things? am i better off getting rid of the ClientPassword field and creating another table called PASSWORDS, consisting of fields: ClientID ClientPassword ... 4 29.09.2006 20:07:32 901 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>