Forms
in [Access]
|
Using VBA to automatically add a new date to my table? I would like to have my table (perhaps through a form) automatically add a new record with the date, every 24 hours, starting at midnight, 24/7/365 How do I do that? Also, And how do I search my username VWP1, because I tried searching users, typed in my VWP1 username, and no records were found? VWP1 ... 5 Mar 2010 15:06
SQL Statement Hi Guys, I have this sql statement, it works but I want to display a message if the record is not found and continue if record is found, my question is how can I capture these events, I will really appreciate any help Thanks Set rs = db.OpenRecordset( _ "select JobName, DocketGenInfo " & _ ... 5 Mar 2010 13:58
asigning a help topic to a cmd button Good morning, I have a help menu [taps-help.chm] and it appears to work when I press {F1}. I set up the control Help File and left the Help context Id blank {0}. I went to the button {cmdHelp} and put the Help Context Id to number {30} which is a page number. When I pressed the button, nothing happens. When I pr... 5 Mar 2010 10:33
Date picker not updating text box in A2007 I have a simple date input form and am trying to use the date picker with an unbound text box. When I click on the required date it appears in the text box but does not fire the update event (or any other). I need it to transfer the chosen date to a TempVar, but no luck. The same happens whatever version of... 5 Mar 2010 07:14
DAO and Table Locking Greetings, I've written some code to create a relationship between table A and table B. The code looks something like this: Set rel = db.CreateRelation("A_B") rel.Table = "A" rel.ForeignTable = "B" Set fld = rel.CreateField("AID") fld.ForeignName = "BID" rel.Fields.Append fld db.Relations.Append rel Th... 6 Mar 2010 21:46
I am using VBA, how do you test for new record in a form What should I test my VBA code so that I know the User is working with record as New in a Form. I am using Access 2007 under Windows XP. I used PrimaryID as an auto generated number, therefore it is Null in the begining that is how I know the user is trying to add a new record and not editing an existing one.... 5 Mar 2010 01:49
Object dependencies in Access 2007 How can I get all the objects like tables, queries, macro dependendent on my form. I developed a form which has lot of sources and would like to export all these dependencies to another database. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1 ... 4 Mar 2010 14:41
SQL statement not working I have a login form that will login who is using the database and the date. It has the following code connected to the onClick event of an OK button: Dim rosterSQL As String Set rosterSQL = "Insert into tblLOGIN([rosterID], [loginDate]) Values ('" & Me.rosterID & "', Now() );" DoCmd.SetWarnings (0) DoCmd.RunS... 5 Mar 2010 15:06
Hyperlinks to pdfs and word documents are not working My Access database was recently upgraded to Access 2007. Now all of the hyperlinks I have to pdfs and word documents are not working. In browsing "external data" I see that I can link to text files and excel files, etc. Please explain why my links to pdfs and word documents no longer are working and how I ca... 4 Mar 2010 15:49
Date Picker issue Greets to the intelligent among us...... Hi All, I have an anomaly happening with the (date picker??) I load a form to edit a record in History table using among other code, the lines Me.txtFromDate = Me.cboHistEditLookup.Column(4) Me.txtToDate = Me.cboHistEditLookup.Column(5) Then "On Click" to run my upd... 4 Mar 2010 12:22 |