Threads Replies Last Post 363 Pages: <<  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  31  32  >>   ActiveControl and PreviousControl no longer have Name property i tested with an access adp and a new mdb and neither ActiveControl nor PreviousControl have the Name property that is referenced in the access help or in google searches. what is up with this? ... 3 14.09.2006 12:15:36 know which control has focus when button is clicked i am working on an error reporting system for a data entry application. the user will click a button that opens an error reporting form on which the user enters info about missing or questionable data. the user will ship off a spreadsheet that contains a list of errors to be corrected by the sneder of the original data entry form that is used by the user to enter data into this system. we ... 5 14.09.2006 12:11:34 ComboBox Back To Blank The data on a form is put into a work table, once the data is entered, the data is appended to a permanent table, the work table is deleted and the form is refreshed ready for the next job. A combo box pulls jobs from a form and then inserts data automatically into other fields. My problem is that after the data is moved, form refreshed, etc. the job stays in the combo box. I need it to ... 3 14.09.2006 10:57:01 Retrieve files from File Folder, to a Listbox Hi! I have a File Folder with some documents. Those documents are classified in a table where I add some information about them. Each time a document is created, in the File Folder, I have to create a new record in the Table. What I would like to do, is a Form with a ListBox where it can be populated with the current contents of the File Folder. How can I do that? Thanks for ... 2 14.09.2006 10:46:04 Access DSN Provider I get an "object required" error when I call my function below as GetMaxDataDate("C:\temp\myData.mdb") The error is on the "Set Conn" line. I've checked my syntax, but Access doesn't seem to like my DSN. Can someone help me with the "Set Conn" line below? CODE ******************* Public Function GetMaxDataDate(sDBPath) Dim objRS As ADODB.Recordset, Conn As ADODB.Connection,... 2 14.09.2006 09:24:54 Delete button Hi, i am creating an inventory system. I have a problem in my delete item form. I hope when i click the delete item button ( which means that item doesn't exist anymore in the office ) ,the details about that item doesn't appear in the form anymore. But my bos, wanted me to save the records in other tables so it would be easier for later use. Right now i don't know how to duplicate the reco... 4 14.09.2006 07:42:01 brown dot on left column of code Can someone please tell me why if you click on the left hand side of a line of code that a brown dot appears and the code is highlighted in brown. What is the purpose of this? Mazza ... 3 14.09.2006 07:35:18 Using VB to Modify Data (Add a Record) in a Sub Form HI all, I have a form with some data that has a subform with some related data. I have an edit box and a command button on my main form. I simply want to drop the contents of the edit box into a field on the sub form when the users click the button. But I can find nothing in the documentation or online with an example of how to do this. This happens to be an "Access Data Project" (.adp... 2 14.09.2006 06:57:45 TransferDatabase broken by new PC The following code runs fine on my old computer (a Dell with XP SP2 on a Windows SBS 2003 domain): DoCmd.TransferDatabase acLink, "ODBC", "ODBC;" & _ strConnectionString, acTable, "dbo." & TableName, "dbo_" & TableName It links an existing table in a SQL Server database to an mdb. When I run the same code on a new PC (also a Dell with XP SP2 on the same domain) I get an e... 7 14.09.2006 05:51:39 Default Value Question Re-Post, origanlly posted on access.forms Hello all, Is there a way (module or something), that will Set the Default Value of a Certian Field to a Value I assign to it? Specifics: 50 Forms in Database. All Forms Have a Field [SeatNumber]. I would llike all the Forms to be Static i.e: SeatNumber=5 (for all 50 Forms). Right now, I have to Open the Control Properties for All 50 Forms... 3 14.09.2006 05:50:26 Create Blank Excel file Programmatically Hi, Does anyone know how to programmatically create a blank excel file with the 3 standard worksheets (sheet1, sheet2, sheet3)? Thanks, Sarah... 3 14.09.2006 04:47:01 Pre-filling fields with previous entries... I have a main form bound to a recordsource with a subform that has a linked set of records. As the user moves thru the subform, I have a routine like this to put default info into the various fields of the subform: Private Sub Form_AfterInsert() Const cQuote = """" Me!txtDate.DefaultValue = cQuote & Me!txtDate.Value & cQuote Me!cboGrower.DefaultValue = cQuote & Me!cboSupplier.Value & ... 2 14.09.2006 04:15:46 Table is not updating... Hi, I have 3 tables: tblProjects Pr_ObjectID PK Pr_Date Date/time tblContracts Ck_ContractID PK Ck_Date Date/Time ...... and tblMileStones MileID Autonumber Ms_Pr_ObjectID Number relate to Pr_ObjectID in tblProjects Ms_Ck_ObjectID Number relate to Ck_ContractID in tblContracts MileStones... tblContract will use/share the milestone enter during registeri... 3 14.09.2006 04:01:44 Help with Code I need to add to the end of the below link after the = [stPro] In the below example the [stPro] shows up as =# and the ProNumber I need it to be = [pronumber] with the "[ ]" brackets. Any ideas? Current Code>>>>> Dim stPro As String Dim stHyp As String stPro = Me.ProNumber stHyp = " http://www.myyellow.com/dynamic/services/servlet?CONTROLLER=com.yell.ec.inter.yf ... 4 14.09.2006 02:02:06 Forms I have a data entry form in a database after i enter the data, i want to hit a button and go to a phone log form that i created and have the record that i just entered in the data entry form to be the record that shows up in the phone log form. any suggestions? ... 2 14.09.2006 01:01:41 Finding a record number based on a primary key Hello, I have a form and I would like one of the controls in the form to link back to a specific record in a table. The form itself is based on the search results from a previous form. The controls in the form are "Case Number", "Citation", and "Parties-Appellant." In the first search form a user will type in the name of a particular "Parties-Appellan", say "John Smith", then click a ... 2 13.09.2006 22:04:01 Concatenate 2 Fields In a Query Hello All! Ok, we have field "A" and field "B". If field "B" not null then concatenate in query results, seperated by a space, within field "A". Happy to provide additional information. As always thanks a million! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1 ... 4 13.09.2006 22:02:43 Populate Textbox with Command Button I have a form that has 6 textboxes and under each textbox is a command button. I also have a product listbox on the form. I select a product from the list box and then click the command button under the textbox that I want the product id to be entered into. I have created a function handle running edit checks and puts the product id into the box. How do I pass the object name of the ... 4 13.09.2006 21:35:02 Filter of Datasheet (disconnected ADO recordset) error Hi All, Using: A2K3 - WinXP Pro - Oracle 9i I have a form that displays a full listing of an Oracle table in datasheet view using a disconnected ADO recordset. This works as expected - I can see and traverse all of the data, and I can update / edit / delete records just fine (and see the changes in the Oracle back-end). Now when I try to use the built in filtering (right-click - 'fil... 3 13.09.2006 21:29:49 Insert Records Warning Yes/No Hi, I have a command button that inserts my selections on values in txt fields, combo boxes and list boxes into different tables... What I would like to do is before inserts a done, I would like a customised warning saying that you are trying to insert the selected values into the database and should give me an option of saying YES or NO. If yes is clicked, it should insert, if No is cli... 6 13.09.2006 21:28:02 Dynamically update value list - without a macro I am trying to dynamically update a value list, based on the results from a previous combo box choice - I want all the code to be in the 'afterupdate' expression section of the initial combo box and so far have: =if([ComboBoxName]="option1"),[FormName].[ListBoxName].RowSource="option1, option2" and I get the error "invalid syntax" any ideas? thanks ... 3 13.09.2006 20:47:33 Basing criteria on a variable when opening a subform I have a table that has an field for unique IDs, one for building, one for categories of potential problems, and one for a description. The category field is a combo box that can be good/bad and if it is "bad" a subform pops up asking for the description of why it is bad. It uses the unique ID to keep the description specifict to its building --- I think I have it up to this point --- t... 1 13.09.2006 20:47:01 Dialog Form for Date Variables Won't Close Hello: I created a simple dialog form that accepts a Start and End Date for a report. So far it seems to be working very well, however, the dialog form doesn't close, it remains open on the screen. Where and how do I close the dialog form? Is it done from the Report? Form Name: dfrmWhatDates Form Fields: vStartDate and vEndDate Here is the code behind the cmdRpt box. Private S... 8 13.09.2006 20:44:01 form combo box displayed record I have a form that I'm working on and it's almost complete except for a problem I'm encounering with a combo box. The form's record source is a SQL statement passed through open args from another form. All data shows except the combo box and I'm assuming that is because it's row source contains concatenated data. How can I get this thing to display the correct data on form load? Here... 12 13.09.2006 20:41:01 call sub from other module If I have a private sub in form1: Private Sub cmdOK_click() End sub And I want to run this from within form2's module - is that possible? Or must I make it public as: Public Sub cmdOK_click() End sub Or should I just put the content of it in a public sub and run that from where ever I need it? Public sub myOKcode() End sub Thanks, Jesper ... 4 13.09.2006 19:48:36 363 Pages: <<  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  31  32  >>