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  >>   ws)]， 在 [要無法檢查您的 HTTP 伺服器上是否有新郵件。 帳戶: 'Hotmail', 伺服器: 'http://services.msn.com/svcs/hotmail/httpmail.asp', 通訊協定: HTTPMail, 伺服器回應: 'This operation is not permitted for this type of client.', 連接埠: 0, 安全(SSL): 否, 伺服器錯誤: 1203, 錯誤碼: 0x800CCCF7建立的檔案的類型] 下，按一下 [Comma Separated Values ... 1 11/14/2008 6:58:24 AM Enabling combobox based on output of option group, and how to filter a report Hello! Two questions: a) I have an option group with 2 radio buttons. If the output is 1, I want combobox to disable. If the output is two, I want it enabled. I have put the "If opgroup.value=1 then combobox.enabled=false End if" in the Form_Current, the Form_AfterUpdate(), the Opgroup_BeforeUpdate (), and the opgroup_AfterUpdate(). Yes, this is overkill, but the problem I am having i... 2 11/14/2008 3:54:34 AM Auto fill How do I use a list of names on one spreadsheet and have it use the list for inserting each name into a certificate, one for each name printed?... 2 11/13/2008 11:01:00 PM How do I do this in Access 2007? Hi, I have Access database has a customer table. The customer table has a customerID field datatype is autonumber (prim. key). I made a CustomerEntry form base on customer table. On customerEntry form has a textBox lookupCustID field. What should I do if I enter a value in lookupCustID, onexit event it lookupCustID exist customerID in customer table then display that customer record. If ... 2 11/13/2008 10:42:01 PM leading zeros in autonumber Hi, I'm an old SQL/FoxPro type, and the help here is great for dragging me kicking and screaming into the foibles of Access! My question: can I force a fixed-format onto an Autonumber field? I need the autonumber to display on a report with leading zeros, e.g. "000016." Do I need to convert it to text first? Not sure of syntax for that. Thanks!... 6 11/13/2008 10:35:01 PM How do I move row information down several spaces ? In 2003 Access how do I move row information down several spaces in the same column? I want to add new information in between.... 2 11/13/2008 10:16:01 PM force uppercase in part of expresssion I want to combine fields first name and last name, but I want Last name in upper case. The last name field in the table is forced to upper case with ">", but that does not work in the expression (well I can't get if to work. Probably a super simple question, but thanks. M... 4 11/13/2008 11:08:24 AM Remembering settings When I use the run command it does not list past settings, something I need for latex commands. The system does not remember other settings, like internet access, Is ther some way to adjust this? ... 4 11/13/2008 6:38:12 AM Encoding/Decoding Can anyone please explain the Benefits of Encoding/Decoding a Data Base and if there are any implications? Thanks for any help... 2 11/12/2008 10:59:39 PM How do I use count if in access? I am trying to add a count if fuction to my report. I run this query and I want it to ountif like Copy only. How would I show this on the last page of the report? SELECT [Vault Audit].[Loan Number], [Vault Audit].[Date reviewed], [Vault Audit].[Original Signed Note?], [Vault Audit].[Scanned Note?], [Vault Audit].[Scanned Mortgage?], [Vault Audit].[Scanned Title Work?], [Vault Audit]... 3 11/12/2008 9:25:06 PM Showing a report with records between two dates Now I know that the way you display a report with records between two dates is to set the Query criteria to something like: >#2/2/2006# and <#2/4/2006# Say I want to have the user input two dates and then hit a button that creates the sales report with sales in between those two dates. I have the form, named 'frmAdminCreateSalesReport' with two text boxes named 'txtStartDate' and... 19 11/12/2008 6:01:03 PM Importing data Hi I get an error when trying to import csv file with the following structure: "Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto ksiêgowe","Kwota","No¶nik kosztów: B100","304"," 490020","Zakup us³ug-Warsztat","594,00","Ogó³em US£UGI WEWNÊTRZNE NAPRAWCZE :","594,00" "Data:2008-10-17 13:15... 2 11/12/2008 5:44:09 PM Field won't display zero's I am formating a field and it wont disply the zero's in my entry.. eg K000123 display's as K 123. I have no idea how to change this and any help is appreciated. I am in design view and select properties of the "cell" and edit what I need there. It shows me K000000;;_ thanks in advance, will// ... 2 11/12/2008 8:06:02 AM Access Database with more than 1 user. Please, need urgent advice. Thank You. Hello, I have a Microsoft Access file in a network. Can I access the file from multiple computers? And can the users edit the database, using a form, at the same time? Thanks, Miguel... 3 11/12/2008 6:15:07 AM combining fields and other stuff I have a field I would like to out on a form that combines some data from fields in the database with some other stuff. AS an example let's say I have a Critters Table with a Animal field. The animal filed has a value "Brown Fox" in it. I want A field that adds the words A Quick Brown Fox runs fast. The Brown Fox is the only information I am storing in a table, so how do I join this ... 3 11/12/2008 3:49:34 AM Starting, setting up, customers to print out, say every 10 weeks Hi, I am very new to this, and access. is it possible(and easy or any pre-done templates or styles I can use?) to have a database which is set up, say on a 10 week cycle, or 2 week cycle or any other cycle, so that the customers details will show up in a list of jobs to do that day - we must be able to print this out for the workmen to take out on their runs. Then, in 10 weeks tim... 1 11/11/2008 9:41:00 PM convert to MS Access 2007 Hi, I have a pretty complicated frontend/back end database that exists on our shared network. It was developed in Ms Access 2003, will 2007 users have any trouble using it? I guess I'm sort of behind the times that I haven't really touched 2007 yet. Thanks! Varvara... 4 11/11/2008 8:34:08 PM "application is disabled,databases may not be created "what does . when i try to do something on Access 2007 it tells me " application is disabled, databases may not be created " how can i fix it ?... 5 11/11/2008 7:55:05 PM Comparison of string content problem I have the following code for trying to compare the contents of 2 different fields on a form. My problem is that I get the error message & focus gets set back to the 1st box regardless of if the contents match or not. Can someone help me see what I am overlooking? Private Sub txtRatingLabel_AfterUpdate() Dim iAnswer As Integer If txtCartonLabel <> ([txtRatingLabel]... 3 11/11/2008 6:09:02 PM Query to compare old to new table I have 2 tables. One old with User ID's and desk locations. I want to show only the users who's desk location has changed. Any ideas?... 2 11/11/2008 4:11:09 PM Do you have a Canadian Version? with Canadian address sales tax and payroll tax ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the me... 3 11/11/2008 3:03:54 PM Newbie Refresh question I split a database and set the back end tables up on a shared network drive. Then I created mde files and distributed to one other person so we could test. He entered records and I entered records at the same time. We both did not see each others records until we closed out our db's then reopened. Then we saw each others records. I tried the "Records > Refresh" command and that did not see... 3 11/10/2008 10:11:30 PM Ole Object Problems In our database we have an ole field in a table that we insert images such as excel, word and PDFs. The setting for the field is EITHER (embedded,linked). When I look in our table now, we have Package, Imaging, Excel, Word and now we have ARCO.EXCH.document.7 showing up and cannot seem to open these images without an error. Some excel files cannot even be opened either. Any suggestions a... 2 11/10/2008 10:03:01 PM Seperate records I have built a timeclock for my employees in Access. I can put the time clocked in in the field, but when I open the form to clock them out they get seperated as 2 different records. Is there any way to fix this and make them 1 record. ex. TIME IN TIME OUT employee a 0800 employee a 0900... 2 11/10/2008 9:32:17 PM why do I get this error "undefined function 'left' in expression I am a new user of Access 2007. This function worked in 2003 but will not work in 2007. The help button displays You entered an SQL expression that includes a Function procedure name that cannot be recognized. However this is a valide function ... 3 11/10/2008 9:03:59 PM 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  >>