Threads Replies Last Post 363 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  >>   Determine when Data in Table was last edited Hi, Is there a way to determine when the data in a table was last edited, via VBA? Thanks, Sean... 4 15.09.2006 21:20:30 create new row/record using existing row as source Occasionally, my users need to create a new record in the database using the values of an existing record (in the same databvaase) as the source. The primary key to the table is an "autonumber" field. Ultimately, I'd like to be able to have the user specif y the source record, have the system create a new record using some (not all) field values of the source record; open the "edit" fo... 5 15.09.2006 19:51:23 Read all open objects I'd like to create an autokey that when pressed, will close whatever query is opened. How do I read which objects are open? Crystal... 7 15.09.2006 19:51:02 schoolyear Hi, I need a field on my form that contains current schoolyear... Now we are in the schoolyear 2006-2007. Over here a schoolyear runs from september to june of the following year so, when the current date is sept 02 2007 the entryfield should change into 2007-2008... Hope I explain it correctly Thanks JP... 4 15.09.2006 19:21:51 Deleting records in a master-detail form In a form with two folder objects I show master-detail relation. On the detail folder I have code on the Current event that should not execute if the user has pressed "Delete" on the master record. How can I test if the master record has been deleted. I need to do this from the Current Event on the child folder. (The actual deletion of the child record is taken care of with a cascading ... 1 15.09.2006 17:25:02 Auto type test in form? I'm very new to Access, so I'll be having lots of questions in the near future, I'm sure. So thanks in advance! I am creating a personnel database, and have a form which has everyone's name and some additional information on it. Can I make it so that if you're looking for a specific individual you can begin typing their name and it will automatically "figure out" who you're looking for aft... 2 15.09.2006 17:18:38 Creating a table in Basic I have a form that runs when the DB is opened. When the DB is opened, i want it to search a table for dates that are 30 days or older. each of these records must be deleted. A Delete query would sufice there. however, each record is associated with a table. i would like this table to be moved to an archive database (but right now, i'm just setting it to a backup table in the current... 13 15.09.2006 17:15:02 Passing OpenArgs to a subform Hi, I would like to pass openargs to a subform using Child1.SourceObject = <A Form>. Is there any syntax or way to include Openargs with the sourceobject property of a subform?... 3 15.09.2006 16:18:02 Difference between two times How to calculate difference between two times (same date)? Example: First time = 6.30 Second time = 9.00 Difference must be: 2.30 Btw. can I copy time value from one textbox to second in Default Value property, how? Thanks!... 2 15.09.2006 15:56:59 warning of possible duplicate record I have a 'text' field for the account number. How can I set up a "warning message" to the user when a new record could be a duplicate. For example: existing account number N-5189 New account number N5189 or 5189-N I'd like to give the user the option of: 1) See the existing account (in a new window to find out if it is the same) 2) Ignore the warning and go ahead... 2 15.09.2006 15:53:44 Cancantenate Date to Output File Hello All! I am attempting to cancantenate the present date to the end of a file within a macro's output file field. It is presently not working, and this is how it looks... F:/NewPeople/XGCardRonLetter"& Format(Date(),"mmddyyyy") & ".xls" Thank you!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1 ... 4 15.09.2006 15:46:35 Update field Value I have a form with a subform. This subform has datasheet view and the fields, product quantity and value. At the footer of the subform I have a calculated field (total amount) summing Quantity*Price. On the main form I have a calculated field wich data source is Subform’s total ammount. The subform total amount is not visible. I need the total amount field to be updated when the quantati... 2 15.09.2006 15:23:34 Filling list box I have a table with two fields: CourseNum (text) and time (text) in a table called tblCourses. The course numbers are like this: 1001, 1002, 1003, 1101, 1102, 1103, 1201, 1202, 1203, etc. The first three numbers denote the course and the last number the identifier of that course. The first form I am using allows the user to select the course number. After the user selects this I want th... 4 15.09.2006 15:15:03 Run-time_error_‘-2147217904’ Hello, The rst.Open command in the following code generates the error: "Run-time error ‘-2147217904’ Too few parameters. Expected 11." Dim cnn As New ADODB.Connection, rst As New ADODB.Recordset Dim strSQL As String strSQL = "Select * from qryUOFQueryUnique" Set cnn = CurrentProject.Connection rst.Open strSQL, cnn, adOpenKeyset, adLockOptimistic, adCmdTableDirec... 3 15.09.2006 14:55:02 writing to table from form I am using Office 2003 on WinXP My database has this table TblMain 2 Columns in table, Name and Location The form has a cboName and cboLocation Choices in cboLocation are determined by value in cboName When the choice I want is not in cboName, I want to be able to put it in the cbobox and have it write to the table, and then do same in cboLocation. I have property 'LimitToList' s... 2 15.09.2006 14:55:01 Trying something but not working, please help! Hey all, As opposed to typing... If Not IsNull(txt1Label) Then .txt1Label.Locked = True Else .txt1Label.Locked = False End If 9 times I tried to have it loop thru the text fields and lock the ones containing text but it's not working. It only locks the first one and forgets about the other 8. Do I have to do it the long way and forget about my idea? Thanks to all wh... 4 15.09.2006 14:31:01 tristate check box I have a tristate check box.The default behavour of tristate check box in windows is that, the grayed check box will become unchecked after click on grayed check box. But i want , the grayed check box will become checked after click on grayed check box in VC++ .Pls help me its urgent. ... 1 15.09.2006 14:10:00 passing info from for to form record set locked I'm passing info via open args from a search form I created to a form built to edit a selected record. All the data shows up fine but if I want to change the event that I pass it says the record set is locked. How can I fix this?... 3 15.09.2006 14:00:02 Form Title Bar Hi, I have a database that is used to enter orders. I would like to add the current order that is being worked to the form Title Bar. I am hope that someone will be able to help.. Thanks in advance... 3 15.09.2006 13:29:02 Stop writing in a field Hi I have thsi counting system there count Lines and Characters in a field when a user come to 0 characters left i want to make it so the user cant write anymore, i have dome it with setfocus on another field but then if the user have 0 characters left and want to change something in the field, the user can't that because it allways go to the other field. Can someone help me here? Alvi... 6 15.09.2006 11:55:55 Scripting conditional list box I am trying to populate a drop box with time in increments of 15 min. However, I want to be able to block (or delete) that time if it has already been assigned to a worker on an assigned day. ie: Worker A tries to sign in on 5/2/06 at 7:15. If there is already an appointment for 7:15, I want that time to NOT be a drop box option. As I am new to this, I will need in depth direction. Will th... 14 15.09.2006 11:41:01 apostrophe in textbox errors An unbound cboBox has this After_Update code behind it. Private Sub cboNameLookup_AfterUpdate() Me.Filter = "LstName = '" & Me.cboNameLookup & "'" Me.FilterOn = True If Me.RecordsetClone.RecordCount = 0 Then Me.FilterOn = False MsgBox " Name not found." End If End Sub If the user types an apostrophe into it, I get the following runtime error: Run time error '2448': You... 3 15.09.2006 11:37:24 Center Form on Screen I want a form to always center on the screen no matter the size of monitor, etc. Auto center does not work. Thanks for any help. ... 3 15.09.2006 06:35:02 How to Dim Array I get an "expected array" error when running my code. This code runs fine in ASP, but I don't know how to dim an array in Access. The code splits a date time string called dtTargetDateStamp into a date and time variable. Can someone explain how to properly Dim the dateArray1 variable below? CODE *********************** Dim FSO As New FileSystemObject D... 6 15.09.2006 04:02:36 Totals Ok, I hope I can explain this. I have a table which holds PO information. I then created a form from a query of the table. So for example this PO has 3 line items, in the table I would show quantity ordered, and Unit price. In the query I created a new field call "LineTotal" which multiplies qty*Unit Price. This gives me the total for each line. Which I then display on the form. ... 2 15.09.2006 01:42:30 363 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  >>