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  >>   Baloon Tool Tips i've downloaded a tooltip database from http://www.lebans.com/ which creates baloon type tooltips, from KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;119991. Ive got it all working but i just need to know how to get the icons onto the baloons. this is a section from the code but i just cant make sense of it, ive tried adding the code TTM_SETTITLE=2 but knowing h... 8 29.09.2006 11:22:14 Audit Trail - Syntax Error I have inherited a database into which I want to add Allan Browne's audit trail. All has been going well until I tested an edit on the first form to which I have added the code. On exiting the form I get the message "Syntax Error (Missing Operator) in query expression '(My Table.Primary ID = 13)'. The names of the table and the primary id have spaces - a cardinal sin, I know. Co... 5 29.09.2006 08:18:02 copy and paste Hi, I copy words from a word document, Eng 97, which include double-quotation mark and paste it to a Access 97 form which field type is memo in Eng Win Xp. After this, when I press the backspace key, chinese character will appear in the place of double quotation mark and when I print, Chinese appears as well. Can you please help? Thanks. ... 4 29.09.2006 06:38:03 Generate Date when any changes made in a Form I have a field in a Form that requires the user to enter a date when they make any changes to any fields in the Form. What I would like is for the field to automatically generate the current date when any changes are made. Thanks for any help ... 2 29.09.2006 05:47:07 Could not find installable ISAM -2147467259 I have written some vba code that connects to the current db and inserts new records into several tables via SQL inserts. It worked, I debugged it and then went on and built some other new forms and added to the tables. Now the original vba code I wrote is giving me errors. First, it said 'Invalid password", so I removed the db password. Now it says, could not find installable ISAM -2147... 2 29.09.2006 03:19:02 msoe.dll - SendMailWithOE checking www.deja.com I found this thread from June of 2005. http://groups.google.com/group/microsoft.public.access.formscoding/browse_thread/thread/fb774e3d9fbd5290/0d9448fdd6501af7?lnk=st&q=msoe.dll+SendMailWithOE&rnum=2#0d9448fdd6501af7 It's the exact same issue I'm faced with right now. The thread ends and no solution is given but the two people talking seemed real close. Does anyone... 8 28.09.2006 20:50:09 Unable to keep subform from closing Hi All, I have a subform "Frm_Exp_Detail" (which is one of several detail forms) that is opened via a select case statement on the main form "Frm_Exp". both of these forms are based on the same table. I didn't do a seaprate details table because there is only 1 detail for each record. The reason for the details form is that my users insist on having the main form in a datasheet vie... 2 28.09.2006 20:11:48 Open a new form based on current form and append new record query I am creating a questionaire for Human Resources. I have created a form from the [Associates] table for the user to select their info, update or add if needed, then click a command button named CreateSession. This command button runs an append query that INSERTS the EmpID field INTO the [Session] table thereby creating a new Session record. I would like in this Assoicate Form to add ... 2 28.09.2006 20:03:27 Combo Box filter I have a form where there are a number of preloaded buildings and also their respective rooms. I want to be able to select, from a combo box, the building number and instead of entering that as data on the table, it will actually filter for all the records of that building. After that, I want only the rooms that correspond to that particular building show up in the room drop down. Fin... 8 28.09.2006 20:00:52 Field Backcolor Changes I have some forms with a large number of data entry fields. I'm using the technique below to visually highlight where the user is on the form. This highlights the label for the field and the data entry field. This is tedious to code the On Enter and On Exit to turn on and off the highlighting for every field. Is there a way to do this "globally" for the form? I'm using default gray d... 4 28.09.2006 19:58:23 for KLATUU I got the Option Group with two Option Buttons (one for 'Yes' the other one for 'No'). I am not sure where to put the piece of code you gave me: If Me.opgYesNo = True Then > 'Do the Yes Stuff > Else > 'Do the No Stuff > End If > Also, who do I link the option group or the yes and no option buttons to the querry? I have a field in the querry that the data is eit... 2 28.09.2006 19:43:02 Emailing From Access I have a few buttons on my form that run some VB code that create an email in outlook. all the emails are created in plain text and not html. Is there a way to change this automatical. also i have to select which account to send the email from can this be selected automaticall Thanks Simon ... 2 28.09.2006 19:19:27 If-Then Help! Seems simple This question is hard to explain so i will show you an example: dim strng as string Set find = CurrentDb.OpenRecordset("Name", dbOpenDynaset) find.MoveFirst If chkJob.value = -1 Then If Len(strng) = 0 Then strng = "find!title = " & cboJobtitle Else strng = strng & " AND find!title = " & cboJobtitle End If End If If chkyears.value = -1 Then If Len(str... 4 28.09.2006 19:19:15 Colored datasheet ... Hello: I have a form that displays the records in datasheet. What I could really use is to color records based on criteria in the columns. If I have a field called STATUS, all records that have "1" display the records as blue, all those that have "2" display the record as red and etc. This would very well look like a rainbow of records. Is something like this possible. Regards... 3 28.09.2006 19:14:41 Opening a form When i open a form how do i make the button open a blank form and not a form with data in it Thanks ... 4 28.09.2006 18:55:24 Emailing From Access I have a few buttons on my form that run some VB code that create an email in outlook. all the emails are created in plain text and not html. Is there a way to change this automatical. also i have to select which account to send the email from can this be selected automaticall Thanks Simon ... 2 28.09.2006 17:55:02 can't add new records I am creating a database questionaire for human resources. I have found AccessMonster to be the most helpful for any "issues" as they occur, following many of the links to obtain examples. After a couple hours of research, I haven't yet found a solution for my current dilemma. I have six tables - Departments, Associates, Questions, QuestCharc, Response, Session. I can add records to D... 5 28.09.2006 17:53:10 dlookup In the following code; meterFind = DCount("meterID", "tblRunningMeter", "unitID=" & Forms!frm_units! UnitID) meterFind will always be the first meter it finds (meter 1). Can this be coded to increment (like a loop) in order to find all meters? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1 ... 5 28.09.2006 17:31:46 in design view ....in design view, is there a way to display the (for example) text box's "name" rather than its label, caption... I've inherited a project where none of the controls were re-labeled; and following tex123, and label 456 are driving me crazy (eventually i'll give them standard lables, but for now...) thanks in advance ... 4 28.09.2006 17:07:38 Writing a Sub with arguments Hi. I need a routine which can make 3 controls invisible. To do this, I have written a Public Sub which takes three arguments. I placed the Public Sub in a seperate module. When that didnt work, I put it in the Form_load event, to no avail. it is now back in the module. The code is: Sub MakeInvisible(Visiblee1 as object, Visiblee2 as object, Visiblee3 as object) Screen.ActiveForm... 2 28.09.2006 16:35:02 Error 2107 when setting the forms recordsource ? Hello everyone ! I have this weird problem with an Adress Form I cannot figure out. The function of the form is to display a list of adress names in a listbox (left part of the form) which will synchronise the field textboxes of the selected record (right part of the form). So when you go through the listbox on the left you see the fields change on the right. When the form opens: 1) ... 4 28.09.2006 16:24:28 Emailing From Access I have a few buttons on my form that run some VB code that create an email in outlook. all the emails are created in plain text and not html. Is there a way to change this automatical. also i have to select which account to send the email from can this be selected automaticall Thanks Simon ... 2 28.09.2006 16:21:09 syntax for textbox value into query criteria Have a query criteria to find all employees that have a hire-date anniversary based on the month selected. Obviously there are various hire days and years....which isn't important...just trying to find everyone's anniversary by the month. In the table the hire dates are stored 1/1/2005 etc. I can manually put in criteria of: Like "3/*/*" and it correctly returns all employees wit... 3 28.09.2006 16:06:02 Report doesn´t recognize text.caption I want to extract the info from a textbox in the open report event but I don´t have the caption option there. This textbox is in the header of a section. How could I extract thise info? Thanks ... 6 28.09.2006 15:55:49 Changing Tab Page using Combo box I am trying to change the active Tab Page depending on the item selected from a Combo Box. Background:- I have a main form called frmAddEvaluationStock. On this form is a Combo Box control called AssetCategoryID which lists such things as Laptop, PC and Printer. Also on the main form I have a Tab Control with 3 pages (Laptop_Specs, PC_Specs and Printer_Specs). On each of these t... 3 28.09.2006 15:33:21 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  >>