Threads Replies Last Post 153 Pages: <<  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  >>   Imported hyperlinks will not work. We have a "third party" application we are importing new/updated records into our database with a hyperlink field which is specified as text. The field in the database is specified as a hyperlink. The hyperlink field does not work with the updated fields What has to be done to "fix" this. I am not a programmer so be easy on me.......... 1 03.08.2006 14:11:02 Append query form + subform Hi everybody, I am using the query example by Mr. Browne to duplicate a record in form and subform. This is for a database storing data about music cd for a small library. They don't have money to buy a problem, but would like to have a versatile system. I am not very good at this, but I did not want to say no to them. This is the code I am using: ------------ Private Sub CopiaInc... 4 03.08.2006 13:09:47 Primary Key Question Hello, I'm still trying to grapple with primary keys. I have many tables that, through the help of these forums, are normalized. But many of them do not have--at least I do not think they have--natural keys. So I'm using autonumbers all over the place, which makes me queasy. I know there are debates on using autonumbers and please, I'd like to not see a repeat here; I'd just like it if an exp... 7 03.08.2006 11:16:22 enclose Good morning it Would Like to know as I can enclose in a table of access an external document kind a picture or enclose the link of that document for afterwards in a form perform atraves of a botao that document. Since ja a lot obliged... 2 03.08.2006 11:08:24 Report filter Hi, I have a form called "OM_ASP_Scan" . User will search by "Tag No", numbers that created by autonumber and input some information to update. I also have created two combo box to specify print range between "Tag No" and a command button to preview a report. In the On Click event I've entered the following code: Private Sub Command48_Click() On Error GoTo Err_Command62_Click ... 3 03.08.2006 09:48:20 Having scanned files in records? I suspect this is a simple one, but then I'm new to this. I'm interested in the idea of transforming my paper archives into scanned archives. Of course, I could just scan documents and thrown the PDFs into a directory. But it occurred to me that it would be even nicer to have those scanned PDFs somehow in a database, so that I could search for things, etc. So I was thinking about the ... 3 03.08.2006 05:52:24 access runtime locks I have developed an access runtime application in 2003 Developer (XP) that is looking at a database on a server and being used by multible users as an inquiry only. I am getting "Locks" on the server and when this happens nobody can get in. Most of the users are on Office 2000. I am using Office XP. Seems like the locks come when I get in the database. Also a another problem a few user... 2 03.08.2006 05:26:34 still cannot found sadly, my report still cannot count of books that's teacher borrowing. In details ; Teacher's name; Book's name; date of borrowing; Notes; l also need to count the numbers of teaching using library for borrowing books . Thanks in advance... 5 02.08.2006 20:58:37 Parking ticket database Hi, I need to create a database to track parking tickets. The tickets come in books of 50 and each ticket has a number. The tickets are numbered sequentially. The database will need to track who the ticket book was issued to, the date it was issued, the ticket numbers for each ticket, and the outcome of each ticket (ie voided, issued). The problem that I am having is that each ticket will ne... 11 02.08.2006 18:24:58 Find a certain key Hi, I have a menu screen that gives the options to add a new record, edit an existing record, or run any of a number of reports. All are working correctly except the edit. How can I cause it to go to a certain key? My key is last name, first name. Let's say I have 3 Jones - Ann, Bob, & Mary. I would like to be able to enter "Jones" or just "J" and go to the first one (or to the ... 13 02.08.2006 17:57:52 Relational Form Stupidity please educate me.. I have 2 simple tables employee, tasks. I have a form for tasks, that I want to automatically identify the employee using environ("username") and is a matching record exists in the employee table then pass the EID to the task form and save it with the task record. I have created a qry that works ( SELECT userid, empid FROM emp WHERE userid=environ("username");) and... 5 02.08.2006 16:13:32 my first report This is my very first report attempt. I'm making a report from a query . The report lists the dates of an event in one column and the total time spent on each event in another. I would like the report to give me the total time spent on each event between 6/1/2006 and 8/1/2006. Can anyone help me?... 2 02.08.2006 15:54:12 sort by month in Microsoft Access How can I sort in a report to show months in proper order instead of April, February, etc. Can I add something in report design to do that?... 2 02.08.2006 14:41:47 How i can use Excel With Access? hi i have 4 Excel sheet i want to put them in one form is there is a way to do that? & do i'm going to use VBA thanks for any help ... 2 02.08.2006 12:55:35 Holland Newbie Hi, Kind of frustrating knowing Access can help a lot within my organisation but not know how to. I would like to use it for invoices and stuff but can;t find out how I must implement my thoughts. All my customers are already in a table. I would like to setup a standard invoice layout (report) where filling in a personal ID (in this case a number made to be the primairy key) is e... 2 02.08.2006 12:52:22 Can we show our table in access to the users My project will be finished . but l need to know , can we show our table and queries to the users because some of my report l created based from my queries and some of my field data will be empty because of combo box Thanks in advance... 3 02.08.2006 10:17:01 Generating a PK with autonumber- FRUSTRATION! I am trying to join 2 tables [in a very poorly designed database] in order to restore the entire contents of one field in a backup table to that same field (Yes/No type) in my new table. I have tried an update query, but I keep getting an error ("not enough temporary disk space..."). I've given up on that approach, after MUCH troubleshooting. My next idea was to just do it by hand... 8 02.08.2006 08:37:08 Why linkchildfields code not work My code From Cmdclick event is Me.Plan.LinkMasterfields Me!Plansub.form.Plan.LinkChildfields Where Plan is control name on Main and Subform (Yes/No type) when I click cmd button, It shows error message method not found Where am I wrong ... 6 02.08.2006 03:33:01 Changing fiedl to "Not Visible" with code. I have a field on a form that I need to display only when the field has content so that when it is empty nothing shows. Is this possible? Thanks, Robin Chapple... 4 02.08.2006 03:22:46 More from the Backpacker Hostel in Panama After 2 months of experimenting and bothering you all with my questions, I am starting my database project all over again. The small backpackers hostel in Panama. I have decided to "clean my slate" and try to incorporate all my new understanding in a completely new set up. I am trying to normalize and simplify. I realize now that as a database USER, I had jumped ahead with form desig... 4 02.08.2006 02:39:11 FIELD VALUE TO BE RECOGNISED I need my Customer Name field to be recognised by the database to avoid missing information in reports due to data entry typos when the customer name field is used as part of the query. Is there an easy way to do this if my database is only 1 table? If not I guess I'll need a customer name table to relate to my outbound manifest table. I was hoping to avoid this for now, but if that's wh... 5 02.08.2006 02:06:01 Relationships I am fairly new to setting up Relationships. Is it always advisable to have an autonumber field in every table when setting relationships. I notice this is the case with the Northwind Data Base. What are the benefits? Secondly, is it fairly rare to use 1 to 1 and Many to Many relationships?. Could you give me an example of Many to Many. I would assume you would use 1 to 1 where one in... 8 02.08.2006 01:18:02 Where's "Left" & "Format"? I'm an occasional Access programmer and was asked to write an application for my church. I wrote a few queries and reports on my home computer. When I went to install it at church I got an error with one of my queries ZIP5:Left([ZIP],5) saying that it didn't know what Left was. I also got an error on a report where I had on the header: Format(Now(),"yyyy") where I was trying to displ... 5 01.08.2006 23:12:25 Importing Excel to Access Can I Import the information I have in an Excel File to a new Access Document? Thank you.... 2 01.08.2006 22:35:48 How to use range categories in an access query HOw could I break down column of values into categories base on preset ranges of these values and disply the correspning to these ranges categories For example <25,000 category I 25000< but <50000 category II 50000< but <250000 category III Thank you Eugene NY... 2 01.08.2006 20:20:02 153 Pages: <<  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  >>