Thirdworld
Last Activity: Nov 4 '08, 07:07 PM
Joined: Sep 24 '07
Location:
-
Building a spreadsheet with VBA.
I'm trying to learn VBA to get some special features into a spreadsheet I am creating using Excel 2007. I'm trying to use condition formatting where, by selecting "Open" from a drop down list the entire row becomes formatted. How can I do this and for multiple rows? -
Like you, I did google InDesign forums before posting here. I was really looking for user recommended forums. Thanks for the suggestion. -
Is there an easy way to produce XSLT?
I've been trying to develop a method by which I can import XML data into Indesign CS3 with it being already formatted. Indesign does support the use of XSLT stylesheets when importing xml. The problem is, I'm new to xml and have no clue how I can achieve what I want to do with the data. Is there an easy way that I can use XSTL to do what I want? The project that I'm working on has a time limit so I'm trying to get this done in the quickest way p... -
Good InDesign CS3 forums
Anyone know of any good InDesign CS3 forums? I'm pretty new to it and I'm looking for a place were I can communicate with experienced InDesign users. -
Line breaks for xml (using InDesign)
I know that xml focuses on data and not the format but I have to ask, how are line breaks done? I'm trying to import some data into InDesign using the xml import function but the data simply flows from one tag to the other or uses weird spacing when the white space is considered. -
My apologies for posting in the wrong forum.
I do know a bit of HTML but I am look to improve my database development skills with the possibility of creating some desktop applications.Leave a comment:
-
I want to learn vb, where do I start?
Hey guys, gals.
After this site opened my eyes to the wonders of database development, my next objective is to learn VB so i can become more competent. The problem is, where do I start? Anyone have any books or sites that a beginner should use to learn VB on his own? Suggestions or anything that you find useful is also welcome. -
Thanks for the code, it worked. Using this code stops a more serious error that occurs when the user attempts to enter information that does not exist in the table which is linked to the dropdown box. So I'll take the user doing a little extra work any day....Leave a comment:
-
I had that option set to 'Yes' already but it still allows me to type in data.Leave a comment:
-
How to stop inputs in a dropdown box?
I'm creating a form that uses a lot of dropdown boxes that takes information from other forms. Is it possible to prevent the user from inputting information that is not found in the dropdown box? i.e. only the information found in the dropdown list is selectable. -
I still got the error. :(Leave a comment:
-
I tried the code again with the changes and got "Compile error: Method or data not found." The cursor stands on line 5.
Here's the code I used.
...Code:Private Sub delete_indep_Click() On Error GoTo Err_delete_indep_Click If MsgBox("Sure you want to delete this record?", vbYesNo) = vbYes Then CurrentDb.Execute ("delete * from Project_Contact_Record where Contact_ID="Leave a comment:
-
I tried the code with your suggestions and got a syntax error. Here is what I did:
...Code:Private Sub delete_indep_Click() On Error GoTo Err_delete_indep_Click If MsgBox("Sure you want to delete this record?", vbYesNo) = vbYes Then Me.Requery currentdb.execute ("delete *from Project_Contact_Record where Contact_ID=" & Me.ID End If Exit_delete_indep_Click:Leave a comment:
-
Ok, I went to insert the code for the delete button and found this:
...Code:Private Sub delete_indep_Click() On Error GoTo Err_delete_indep_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_delete_indep_Click: Exit Sub Err_delete_indep_Click: MsgBox Err.DescriptionLeave a comment:
-
Custom delete messages
I've created a form and used the wizard to create a delete button. Upon testing, I noticed that the warning message would be very confusing for some users. How can I create a custom, user friendly warning message that comes up once the button is pressed? -
Forgot to say thanks for this.Leave a comment:
-
Exactly what I wanted. Thanks man.You have no idea how much you've helped me with your posts.Leave a comment:
-
I tried the code and got this error:
Run-time error '2465':
System can't find the field 'I' referred to in your expression.
How can I fix this?Leave a comment:
-
How do I create a hyperlink button on a form?
I'm trying to create a hyperlink button on a form that does the following:
1. User clicks on button
2. The default 'insert hyperlink' window appears
3. User selects the desired file
4. User clicks ok
5. Path of the file comes in the textbox
A button is needed for each textbox that requires a hyperlink. Is this possible? (Note: I'm a beginner with no programming experience and this is my first... -
Where and how do I place the code? I tried using the wizard to create both buttons but the same problem occurred.Leave a comment:
No activity results to display
Leave a comment: