Threads Replies Last Post 363 Pages: <<  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  39  40  41  >>   unreferenced control prob Hi, I've got a combobox that I want to check before the user commits the current record. How do you do it? I've tried the following and got a combination of runtime errors, there's gotta be an easier way If Len(Forms.frmStory.PubCode) <> 2 ... doesn't work If Forms.frmStory.PubCode = null ... If Forms.frmStory.PubCode = "" Help appreciated Thanks Nick ... 3 05.09.2006 22:14:14 Form troubles I have the following code in the AfterUpdate event of the Part combobox, it works as expected and I can save, close and reopen the form with field values still in tact: Me.Ref_Part_NHL = DLookup("[AS Part#]", "ExcelARefParts", "[PART#] = [RefPart] And [Variable] > 0 And [Part#] <> [AS Part#] And [Model#] = [Model]") However, if I add the following (along with the above code)... 1 05.09.2006 21:41:02 Invald or Primary Key Cannot contain a null value Can anyone tell me why I might be getting this message when I add the following code in the AfterUpdate event of one of my 3 primary key fields in my table called NewParts, which has a left join to the below table ExcelBRefParts in my query, which is the data source for my form. When I click Close, I get the message, but all three primary key fields are complete. Any ideas? Thanks muc... 4 05.09.2006 20:46:01 Combo Box Columns I have a combo box on a login page which has 4 columns. Once the right user id and password are entered the login page goes to a form that is unbound and has a subform on it. The subform is supposed to show open tickets for the person who logged in. I am having problems getting Column(3) from login to the query that is to show their tickets. I have tried so many things I really do not know w... 12 05.09.2006 20:39:03 validation code failing I have the following code in the before update section If Me.primarycarechoice = Null Then Cancel = True MsgBox "This child has no carer. Please correct." Exit Sub primarycarechoice refers to acombobox. For some reason this never triggers. I put a stop on the code and checked to see the value of Me.primarycarechoice which reports being NULL and yet this code doe... 4 05.09.2006 20:08:09 Display data from table to Status Bar Text I try to display data from table to Status Bar Text but not working. Example: I want to display text in status bar from one table with ID number 10. In Table I have some comments. It's this possible? Suggestions for this action? Thanks!... 3 05.09.2006 19:53:01 recordset clone recordcount ? I'm trying to display the current rowcount in my form caption. I'm using the recordset clone recordcount to do this. I get the correct count after I filter the records but when my form first opens, the count is always just 1. In what event can I get this count after my form opens. I can do it in 'on current' but then it updates after every record navigation and I only need it to update w... 2 05.09.2006 19:49:02 record change property what property (?) indicates if the record being displayed on a form has changed (i.e the user has moved to a different record within a table by any of the means available to them: navigation buttons, command buttons, list box options to move to a specific record... etc...) thanks in advance, mark ... 2 05.09.2006 19:10:11 Shutdown anomaly My application opens a series of forms, all non-modal; most have a Form_Load procedure. Everything works fine, except in this one case: If the series of forms is open and Access is shut down by closing the top-level window or by executing a Quit command, one form’s Load procedure runs during the shutdown process, showing all sorts of error messages, because resources needed by the load... 6 05.09.2006 18:47:20 Auto Populate a Date I have a date box that I need to have auto populate depending on whether a check box is check or whether something is choosen out of a drop down box. Example, If the compliment box is checked then I need the date to auto populate with a date that is 30 days from today - and if an option is chosen out of the complaint drop down box then I need for the date to auto populate with a date th... 13 05.09.2006 18:45:55 form-subform error trapping? I have a form with a subform embedded. (Invoice general data - invoice concepts data) They are linked in a relation one-to-many by an integer field that must be captured by the user (invoiceID) When the user tryes to insert new records in the subform, and the invoiceID is missing an error occurs I want to trap the error positioning the cursor in the invoiceID field and sending the mes... 5 05.09.2006 18:41:37 OutputTo Statement/Query not working I have a form with a listbox. The user selects items from the list box and it calls a query that is supposed to find records based on the list box responses. The list box returns the numeric id of the record which works fine when there is only one selection. If more than one item in the box is selected and I try to call the query - I get an error because I am passing a string to the q... 1 05.09.2006 18:24:02 Can not open an existing form with new critera I am trying to get a Search form to display its' results in an existing form, but I have having a very hard time trying to do this. In a module, I load in the primary identifier, form name, and SQL into some variables, and then I attempted to open the form via these codes: Forms.Item(m_strFormName).RecordSource = m_strTempFromDataSQL & m_lngSiteMtrNum DoCmd.OpenForm m_strFormName, ,... 1 05.09.2006 18:08:02 Number of Table Fields Is a 25 field table going to be slower than a 16 field table? I have a 2 tables but its looking better if I have both tables into one, thus the 25 field table. Is that too many fields in a table? Thanks DS... 3 05.09.2006 18:01:09 TreeView control questions Hi! I have a couple issues with the TreeView control I'm wondering if any of you would have an answer on. Issue 1: When I use the drag/drop feature, the child I drag gets placed at the top of all the other existing children of the node I dropped it into. If I close the form and get back in so it re-builds the tree, it's in the correct order I want it in. Is there a way to automatica... 1 05.09.2006 17:28:03 Unable to make an MDE file ... When I try to create an MDE file, I get the error "Microsoft Access was unable to create an MDE databae." What could be the problem? How do I trace the problem? Thank you, -Me ... 2 05.09.2006 17:08:02 wrong calendar.. Hi all.. I have created an calendar with a period of a half year.. The first month of my calendar is always the current month.. Unfortunatly almost all months are correct.. However, as you can understand this isn´t good enough for me.. I want it to be witout any mistakes.. Is there an access hero who can help me? The calendar is a subform so it is easy to extract from the DB to send i... 5 05.09.2006 17:03:00 Manipulating Datasheet Row I have a parent-child form where the child is a datasheet that houses multiple visits about the patient. On the child datasheet form, I have two txtboxes, Pt Test Date and Next Test Date. I want to have three cmd buttons that will help enter data on the Next Test Date. Each cmdButton would be 1 Week, 2 Weeks, 1 Month. So when the user enters a date of 9/1/2006 in Pt Test Date and click... 5 05.09.2006 16:39:36 SQL Syntax Error I keep getting a Syntax Error on this code, any help appreciated. Thanks DS MONEYSQL = "INSERT INTO SalesDetailsMoney " & _ "SalesDetailsMoney.SalesID, SalesDetailsMoney.LineID, " & _ "SalesDetailsMoney.ItemID, SalesDetailsMoney.QtyPrice, SalesDetailsMoney.GroupID, " & _ "SELECT SalesDetails.SalesID, SalesDetails.LineID, SalesDetails.ItemID, " & _ "SalesDetails.Quantity, SalesDetails.... 4 05.09.2006 16:39:25 ARC VIEW GIS 3.2 with ms access->set the datasource in arcview to Hi, I have my dataentry form in msaccess 2003. i am using Arcview GIS 3.2 to show my data into GIS format. The problem is that i cant show my data in arcview dynamically. means if user adds data to the access forms,every time i have to import that data to the arcview application. so is there any way that my data is automatiically updated in arcview as well or if i can specify my datasou... 10 05.09.2006 16:05:57 list box, auto selecting row I am using a listbox to gather multiple columns of a query. Originally, it was designed that many rows could be returned, but now only 1 row will ever come back. I want the form to open and automatically select that row so that I can reference items via "listbox.column(x)" If I don't select the row, the references are all null and if I use "listbox.selected(0)" that I found somewhere,... 1 05.09.2006 16:05:45 Cascading Combo Box and Additional Parameter I have cascading combo boxes where the virus chosen limits the test combo box. I would like to also limit the test drop-down list by an additional parameter; I would like only the RRT-PCR tests to come up, excluding the cELISA and PCR tests. In other words, The code below results in the following tests being selected, when the virus AIV is chosen: Mtx RRT-PCR H5 RRT-PCR H7 RRT-... 7 05.09.2006 16:05:01 Subform filter fails My filter in a called procedure results in a Null for the record, but I can't see why. The calling procedure is on the main form, SWB, and the called procedure is in a utility module. The subform, EndwmtSubFrm, should go to the specified record, but doesn't. EndwID is a string, and it does pass correctly from the calling procedure. Would appreciate any advice on where the problem mig... 1 05.09.2006 15:29:02 Syntax Problem: Refer to string not fieldname Hi. I have the following code running to generate an sql string from another functions OnClick event (i'm using a querydef): Function BuildSQLstring(strSQL As String) As Boolean Dim strSELECT As String Dim strFROM As String Dim strWHERE As String strSELECT = "tblIndividual.Forename,tblIndividual.Surname " strFROM = "tblIndividual " If ChkGender = -1 Then strSELECT = strSELECT... 3 05.09.2006 15:16:02 calender problem Hi, i have an apointment booking form from ourline.com The problem is in admin, whereit should display thw days of the month.it is only showing as many days asthe number of the month.eg; jan shows 1 day, feb shows 2 days, up to december, which whows all 31 days. it also shows the day. eg shows the 6th september as a saturday. here is the code if anyone can help would be great, Thanks. ... 1 05.09.2006 15:04:06 363 Pages: <<  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  39  40  41  >>