Threads Replies Last Post 227 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  >>   Field concatenation into a combo box Hello Gurus, I have inherited an "Animal Info" database (in Access 2003). It has a form which enters information into an animal "Pedigree Table" which is the main part of the database. In the form there is a combo box which runs a query from a separate "Person Table". "Person Table" has 5 fields: Last Name, Title, First Name, Address, Postcode The query li... 6 12/25/2008 2:07:32 PM Syntax Although I've taken 2 Access courses, have Cashman's book and read countless posts; I'm still uncertain re: "wording" & syntax. I've created a form with a comboBox and subform. I named: the form "AllCountry", the comboBox "ComboCN" and the form used as the subform "BrSch" In writing code should I use: "cboComboCN" to refer to the combobox? "Form!AllCountry" to refer to the ... 3 12/24/2008 6:37:48 PM Won't work in Office 2007 I have a form with a control that is supposed to show the link for a table in the mdb. Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me the path and name in Office 2003 but gives an error ( #Name? ) in Office 2007. Help me.... 5 12/24/2008 6:37:02 PM Content management Is it possible to build a content management tool in access for personal use to capture and monitor my personal documents and pics , Email .etc ? I was looking for an access template that will do the job but I couldn't find it ! can any body help me on that ? ... 4 12/23/2008 9:05:34 PM anybody use MySQL? any different than using MS SQL in terms of linking tables etc... any gotchas?... 5 12/23/2008 3:17:21 PM Seeing Access 2003 table in Access 2007 I recently upgraded from Office 2003 to Office 2007. When opening Access 2007 and using my Access 2003 database, I get the error message "Your Microsoft Office Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5." I get this error message 11 times. I have no idea what this file is. Then, when Access 2007 opens, my tables/reports/form... 6 12/22/2008 8:19:01 PM Save Query Results to Multiple Tables So I have successfully created my query against a reporting database and now need to copy the data returned to a differnt table (and a back-up table) so that each day when I run the query I get e new set of records and do not update the records from the previous days query. I do not understand the "Make-Table" query command, where it is or how to use it.... can anyone walk me through the... 7 12/22/2008 5:08:03 PM delete records from one table if not in another how can i delete records from one table if the records do not exist in a matching table? i am making a backup of a table before an import is performed. the users may need to undo the backup so i need to be able to delete only the new records. this is not working, but you get the idea: DELETE tblPatient.* FROM tblPatient INNER JOIN tblPatientBackup ON tblPatient.PatientID = tblPatient... 15 12/22/2008 4:58:20 PM Default Value In the primary table, I have an "ApproveDate" field, the next field (ReportDate), I want a default value to be 6 months from ApproveDate. What is the expression for this? -- Dine Lene... 5 12/22/2008 4:02:38 PM How to transfer data from Excel sheet to External application( Forms) Hi I'm Srinivas. Is there any macro or a software using which i can transfer the Data from Excel Sheet (Rows) to External Form software with respect to Heading Description on Form & Excel Sheet. Below is the sample of data in excel sheet which i have to load in external application all this data are in one row . with mentioned Headings Date ---- 8-Mar-00 Name ---- Diawe M Gunon... 2 12/22/2008 1:23:17 PM Convert Text field to Date field within existing database Hello, I'm trying to convert a text field to a new date field within my database. The existing text field has the following format: "DDMMMYYYY:HH:MM:SS" (e.g., "24APR2008:14:12:17"). In Desin View, this field is formatted as "GeneralDate" in the field properties, but set to "Text" in the Date Type column. When I tried to change the Date Type to "Date/Time", I get an "not enough memor... 7 12/22/2008 1:09:04 AM Inventory & Barcode usage, how to auto search and open up entry data after scanning the code Hello, I have a complex (to me) situation here, and I really need urgent help because I would like to have it done as soon as possible. I have read a book on the basic Access last 2 days, but it is not helping to accomplish what I am trying to do. So here is what I would like to do... I need to create a database for inventory management (tracking computer equipments in a building). I al... 5 12/21/2008 9:59:07 PM Add "Record Created On" Field to a Query Can I add a field to a query that shows the date a record was created on? I want to run this query every day so I need to know which records where created on which date? How do I add this field to a query table, or do I have to create a seperate table and then join then to bring the record date over? wishing I understood everything I know about Access <grin> Darrell... 7 12/21/2008 8:02:00 PM Memo text box I have put a memo field into my database and I wanted to know how to "wrap" the text so that the text entered goes to a new line (so to speak) when it reaches the length of the text box or if an entry has already been made in the Memo box and the user wants to add a new comment, I would like for it to start on a new line. Is this possible? The reason for asking is because sometimes we... 7 12/21/2008 4:36:10 PM highlight user input paramter I have a text field in my database which can be quite lengthy named “Main Description”. I run a report to search Main Description for a user input parameter. Let’s say I’m looking for the word “Snowden”. Right now the report will print every record that contains the word “Snowden” in the Main Description. I have 2 questions: 1) Can I make the user input word “S... 3 12/21/2008 3:12:03 PM Meddlesome space within folder name in code I thought this question was answered, but apparently not. I have a command button on a form to open a new database, but the space between Ken & Smith in the code below is preventing the DB from opening. Private Sub cmdGoToPaybacks_Click() On Error GoTo Err_cmdGoToPaybacks_Click Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE S... 4 12/20/2008 11:07:01 PM Show the date of the last time the query was run My swithboard has a button wich runs an Update query (it updates one table fields from another table linked to Excel datasheet). I run the query only when the data in Excel has been changed. At times I have to print some reports with old unupdated data and only then perform the Update. I'd like to add LastUpdate field on the switchboard, wich will show the date when the query was run last... 6 12/20/2008 10:23:01 PM AutoSum (sigma) symbol has disappeared from toolbar How do I locate? How do I re-add the symbol to toolbar? ... 2 12/20/2008 6:15:57 PM Opening 2003 security database in 2007 I have read thru on how to open a 2003 database with user level security in 2007 and it doesnt seem to work. I greated the database so I do have admin access but it won't let me even type in a password. Any ideas on how I can gain access to my 2003 version on 2007? ... 3 12/20/2008 1:49:01 PM Display data horizontally using concatenation I have subtables which list data for each patient such as Med1 Med2 Med3 When I created the subreports, naturally the meds are listed this way. What I want to do is have them listed this way to keep my reports from being too long: Med1, Med2, Med3 I have tried Duane Hookum's code, but just don't understand enough to get it working right (eg What's DAO and ADO?). Is there a si... 6 12/20/2008 12:21:01 PM Unlocking a Database in order to Edit Info I am trying to unlock a database program in order to edit the information with no luck. I imported data from FP Bento into something similar to the Home Contents Inventory database template but made from a new Form, then tried to update the information in a cell but had no luck with adding/deleting information. My IT DB rep ( who deals mostly with Oracle) suggested I should find and de... 4 12/19/2008 7:50:01 PM Command button to open another database? I have a command button on a form that opens another form within the same database. Is it possible to have one that opens a separate database? Right now my code for the former is: Private Sub GoToCMLabels_Click() DoCmd.OpenForm "frmCMLabelsDataEntry", acNormal, "", "", , acNormal DoCmd.Close acForm, "frmCMDMSearch" End Sub If possible, what would the code look like to ... 6 12/19/2008 3:43:02 PM Permission Denied 2007 I have a simple data base that I upgraded from 2003 to 2007. Everything works as expected except a macro (called from a form) that creates a text file of email address. I get a Access error "Permission Denied". I assume there may be something I have to change with user permissions, but I can't figure it out. Any help would be appreciated. Thanks John... 8 12/19/2008 1:04:29 PM Including a memo field when doing a search I have 2 combo boxes one which is the account number and the other is the name combo box which allows the user to enter the entire account number or just a portion of it. I purposely put an account number in the memo box as sometimes we will have old account numbers that we make reference to when the client gets a new account number (different type of account gives them a new account nu... 2 12/19/2008 12:29:17 PM What does it mean "You do not have exclusive access?" ... 3 12/19/2008 5:31:17 AM 227 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  >>