Recent content by damonc

That's good. Glad you got it worked out!

I think any browser should display the editor correctly. I only use Firefox, and everything works perfectly.

Do you mean posting code like this?: Your code goes here If you what to do that, simply highlight the text you want to appear in the box, and click the # button on the WYSIWYG toolbar. As for your Access problem, I can't help sorry!

Perfect! Thank you EMP

HI, I have a field that contains mainly numbers, but the data type is set to Text because there are a few records where the numbers have a letter suffix. Eg. Invoice numbers 100, 101, 102, 102A, 103 etc. These suffixes are a result of poor data entry when the data was stored in Excel. What I...

I would hardly call myself an Access expert, and I might be frowned upon by others in this forum for suggesting this, because the solution I'm going to suggest is far from ideal...but: Once you have created your table in design mode, you can easily copy and paste the information from Excel. As...

Hi Tony, I have tried to import your spreadsheet into a new dbase and also receive the error message. Don't quite know what's wrong, but I did notice some points about your data. You really should be using several tables to store your information, rather than just one. You should have...

This method will still work. Give it a try.

These directions are for A2000, but should work for A97. In the Forms windows, choose to "Create Form in Design View" In the properties window, under the Data tab, choose the appropriate table as your Record Source. Using the Toobox, create a new unbound Combo Box, the wizard should pop up...

RG, you're a superstar! thanks you very much for the speedy help. pasting this line gave a syntax error: "VALUES ('" & NewData & "', " & Me.cboagentID.Column(0)) & ";" But I changed it to: "VALUES ('" & NewData & "', " & Me.cboagentID.Column(0) & ");" Which is what you had originally in the...

RG, I have inserted your code and changed the names you guessed: Private Sub cbobranchID_NotInList(NewData As String, Response As Integer) On Error GoTo Err_cbobranchID_NotInList Dim strSQL As String If MsgBox("The " & Chr(34) & NewData & _ Chr(34) & " Branch is not currently...

RG, Thanks for your response. the code to add a branch is: Private Sub cbobranchID_NotInList(NewData As String, Response As Integer) intAnswer = MsgBox("The Branch " & Chr(34) & NewData & _ Chr(34) & " is not currently listed." & vbCrLf & _ "Would you like to add it to the list now?" _...

I have 2 Cascading Combo boxes setup and working correctly. cbo1 lists all agents and cbo2 lists the branches that relate to each agent. tbl_agents and tbl_branches are setup with a 1 to many relationship. I have used the code (explained here) that allows the user to add a new agent if they...

Probably because I only just updated my profile :) Correct, an agent can have many branches. But a branch that belongs to Agent A, will never belong to Agent B. Think of it like a bank: Every bank has multiple branches, but they don't share branches. Two banks can have a branch in the same...

I have a bad habbit of saving almost every email attachment I have ever received. There have been some beauties over the years. I think some of the funniest in recent times have been some stick figure drawings. There are quite a few, so I won't post them all, but you can view them on my...