Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Problem with "Me(textfield).Value =" still displaying blank Thanks. It's not currently writing anything in the cells. I believe the problem is in the " Do Until rst.EOF" loop, as I'm getting blank cells at the end, although I've gone back and forth over that loop and its neighbors and I can't for the life of me see why the cells would all be blank at the end. The initial " 'clear all values in cells" loop in ClockImage_Click() works well, ... 1 13.02.2006 22:50:36 Firing event on both KeyDown AND Click? I know how to do a CommandButton_Click() event and I have a CommandButton_KeyDown() event which checks to see if Ctrl was held down: Private Sub Note_Toggle_KeyDown(KeyCode As Integer, Shift As Integer) If (Shift And acCtrlMask) > 0 Then Call TheLocker("[Notes Subform]", "[Note Toggle]", "[Text_EditNotes]") End If End Sub The problem is that the Click and the KeyDown a... 4 15.02.2006 02:00:04 Real calendar with Access calendar control Anyone ever created a calendar with the calendar control in Access? Me.CalendarName.Value gives the date that the user is clicking on and is normally used in putting dates into a "meeting" schedule or whatever, opening the Calendar so that a user can click on it. I'd like to create a real calendar. If I can't figure out how to get text into the Calendar boxes, perhaps I'll simply circl... 1 11.02.2006 00:56:28 #error with null date field using isNull or isDate I have attempted to write a function in Access 2000 to calculate the days between two dates. In my Access 2000 the end date can and does contain nulls. Using Access queries, I have no problem using IS NULL to evaluate the field, but in my function if isNull is true or isDate is false, it returns #error. If isNull is false or isDate is true the function returns what I wanted it to. I could... 3 09.02.2006 22:03:59 Mouse Click and Ctrl to activate Command Button From http://support.microsoft.com/?kbid=209984 Private Sub ExitMicrosoftAccess_MouseDown(Button As Integer, Shift _ As Integer, X As Single, Y As Single) If Shift And acCtrlMask Then DoCmd.Close End If End Sub What's this "If Shift"? Where's this Shift come from and how does the Sub get the acCtrlMask variable?... 2 09.02.2006 21:34:18 Reading data from linked Excel "tables" I have data in Excel, which is linked to my Access 2003 frontend. I simply need to read the data (record by record) and can't get "Currentdb.openrecordset" to work. If I use the code on a linked Access table, it works - but then if it's a linked Excel file, it doesn't work (There is a $ after the table name and says it's not a valid name). Thanks in advance!... 2 09.02.2006 18:17:30 Form.next event? What's the event that I can reference when a form goes to the next (or previous) record? How do I make some VB code trigger whenever the user goes to the next (or previous) record?... 2 07.02.2006 19:46:34 Changing Toggle Button picture I'd like a toggle button to show one picture when depressed and one picture when not depressed. But the darn toggle button keeps loading the regular picture, but showing that it's depressed. Even calling the function that changes the picture from Form_OnLoad isnt' changing the picture until you go and do something like click on the button. Here's the function that I use to switch the ... 2 07.02.2006 19:21:30 I'm in "DAO Hell"; Please Help I recently installed an ATI All-In-Wonder Pro 9800 Video Card which I believe installed something called "DAO". A failed driver update corrupted the DAO (Data Access Objects?) so that it cannot be uninstalled from Add/Remove Programs. This led to a secondary problem in Roxio Easy Media Creator 8 so that I can no longer burn CD/DVD discs. It appears "DAO" also stands for "Disc at Once"... 6 07.02.2006 06:24:40 I need help every time I send and receive this error message comes up. It says incorrect password or account nameCheck the username/password or security settings. And it doesn't let me get my mail. can somebody help? my address is eli.barr@providenceday.org ... 1 07.02.2006 02:06:14 How to create a recordset in memory Currently I'm using a SELECT...INTO statement to create a new table upon which a second query is run in order to return some rows to be used to populate a bunch of textboxes. Afterwards I DELETE the new table I just made. I would like to skip the steps of creating and deleting this table. I could do that by using the second query to populate an array but I would rather work with a record... 7 04.02.2006 23:05:45 Animals in China mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sales@lpi-hk.com ... 1 04.02.2006 10:03:56 Animals in China mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sales@lpi-hk.com ... 1 04.02.2006 10:03:47 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:06:25 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:06:24 What's the name of a subform object? I have a toggle box next to a subform. When the toggle is clicked, the subform should allow deletions/additions/edits. When the toggle is clicked again, the subform should not allow such. I've tried the caption name for the subform but that doesn't seem to be working. What's the name of a subform? Edit: In the following sub [code]Private Sub Name_Toggle_Click() If [Name Toggle]... 2 03.02.2006 21:54:28 How to create a RTF doc and append to it using Visual Basic inside MSACCESS I have a calculation for with some values linked to a table in MS Access 2003 and would like to create a report in RTF format. Can anyone help me with the VB code to perform the task of creating the file, formatting some text and to append to the file? -- mmsPosted from - http://www.officehelp.in ... 2 03.02.2006 20:44:48 Formatting table in VBA Hi, I am populating a table with VBA. I need to format a field like this If the value is less than 100000 than add 30000000 to the value if the value is more than 100000 then add 400000000 to the value What would be the easiest way to do this? Thanks Michael Clavien Unit 1, 1 Gordon St CAMPERDOWN NSW 2050 Australia Ph: +61 2 9519 6650 Power Electronics & Industrial Con... 3 02.02.2006 06:16:04 Can't use Byte datatype for Recordset Index? The following code won't run for me in an Access module apparently because J is dimmed As Byte. The code runs fine with J As Integer or As Variant. Just curious but is this right? Sub RecordsetTest() Dim J As Byte Dim rs As adodb.recordset Dim cnn As adodb.Connection Set rs = New adodb.recordset Set cnn = CurrentProject.Connection rs.Open "tblWhatever",... 4 01.02.2006 22:11:02 ie.Document.Frames data into Access DB When extracting data from a web page, how can I tell when the page is finished processing? I have VBA that scans the data from a page and loads an Access table but sometimes it starts before the page has been completely processed and thus gives an error. I'm using ADODB. Thanks.... ... 1 01.02.2006 05:03:17 Images in and from mdb-files Hi, I have a program for storing recipes with photos in an mdb-file. Over the last 5 years I put about 400 bmp, gif and jpg images into the database. Unfortunately I did not care about the size so the database grew to 1 Gb. I don't have access to MS-Access, therefore I tried to replace the images with smaller copies by using Excel VBA. Putting together some code with the help of Microsof... 1 30.01.2006 14:35:39 Corrupted MDB (seems to be code related) Hi All! I have a serious problem, please help, if you can. In a multi-user environment I have a back-end mdb for data, front-end mdes for GUI and an mdb for development. I was just writing code for a form in my develpment mdb when Access 2002 shut down and tried to send an error report... Now I am informed that the file is corrupted and can't run compress and repair. I found out th... 3 27.01.2006 15:42:02 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 27.01.2006 01:23:38 Maximize Screen hi, the database is built and it looks ok but the docmd.maximize still left the access bar at the top even though ive disable all of the items in start up. The problem was resolved by setting Popup and modal to Yes. but ive got quite a few forms and it will take time to set the properties of each one. Is there a way that this can be done for all forms in the database as ive got se... 5 24.01.2006 23:06:58 MaxLocksPerFile exceeded error - how to correct Hi, I'm opening a table and deleting all the records (about 120.000 rows) using the following: Dim db As DAO.Database, mytable As DAO.Recordset Set db = CurrentDb() Set mytable = db.OpenRecordset("Trent Sickness", DB_OPEN_DYNASET) Do Until mytable.EOF mytable.Delete mytable.MoveNext Loop I get the error messa... 2 24.01.2006 12:15:15 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13