Search results

Have a read of this: https://www.ntu.edu.sg/home/ehchua/programming/sql/relational_database_design.html

Yes, your function as a good example. I'd recommend names because the user will see them in the text they are editing. For users it is helpful if they are meaningful so they can write their paragraph naturally choosing the fields they want to use as they see fit. The user does not need to be...

Save your paragraph like this: TO WHOM THESE PRESENTS MAY COME: By virtue of the power in me vested by the Statute in which such case made and provided, I, [name1], District Court Judge for the 212th District of Missouri, do hereby appoint [name2] [task], during her tenure as, and by virtue...

Here's another way... sbfrm = Choose(Nz(Me.cboPermitType, 0), "subfrmHotWork", "subfrmLineBreak", "subfrmConfinedSpace") If IsNull(sbfrm) Then MsgBox "Please select a Permit Type" Else DoCmd.OpenForm sbfrm, , , , acFormAdd DoCmd.Close acForm, "frmPermitsearch", acSaveNo End If

Looks like you need to set strEMailMsg = "" when you create a new email object. Otherwise, the strEMailMsg string will keep growing regardless of the change of email address. But I agree with MarkK, it's much easier and clearer to do this with two loops. hth

If your main goal is learning how to build a database then I agree with NauticalGent that Access is a great tool to build your own. But if you goal is to get your stuff catalogued, then you might consider market products. The generic title of what you are looking for is Digital Asset...

In my version it's: View=>Toolbars=>Edit

The attached database shows how to add a list of tasks (from tblTasks) to a subform (based on tblClientTasks). If you try to add tasks to a client that already has the tasks, nothing will happen. If you try to add tasks to a client with no tasks e.g. client 3, the tasks will be added. I don't...

A combobox only stores one value. In you case I guess it is storing VendorID i.e. a value of 1. So regardless of which of the first three options selected, the value stored is still 1. And when it comes to display, it will choose the row in the list with the value 1 which in your case is...

I think I know where you are heading (?) Yes you could have a form/subform approach where the form links to the client table and the subform links to the client/tasks table. You will need a physical table for client/tasks like this: ClientID___TaskID____Status 001________1________N...

Just add one extra column for ClientID i.e. 3 columns.

I'm also confused. As I read it you want a tick list type thing? In which case instead of having the things to tick as the headers, put them in rows (in one colum) and the tick box in the second column - a bit more how you would expect a tick list to look. As to joining, you can always join...

As Minty said, you don't typically store the same data in two tables. The key is to use queries to show the data in the way you want to use it. So in your example you would create a query that shows the required columns form both tables in the same query. You would use this query wherever you...

Another thought... If you enter text with line feeds then your text could be input as more than one line with the actual text not visible. It's easy to check this by opening your table and increasing the row height to see if there is text further in the "cell".

I agree with this statement. You can build accomplished solutions without using VBA (to a point). It's actually quite impressive how much automation macros can add to a solution. However, I agree with everyone else, that you should focus on VBA. For simpler solutions, you can get some nice...

Syntax to me has quite a specific meaning i.e. the vocabulary of the database engine. You can't change it afaik. It's deeply embedded. So the notion of "custom" SQL syntax does seem very strange. All I can think of is if you were using another D/B engine other than the main one you were using...

Here's a fuller description of how to add calculated fields to queries http://www.fontstuff.com/access/acctut02.htm

You don't need VBA to do this. Your form will be based on a query or table. In the form's property sheet undert the "data" tab you will see the "record source". If you click the three dots at the end you will either be shown the query window or asked if you want to create a query (which you...

Well in the absence of any answers to the questions you've been asked, I'll just suggest one route at random: - Find a 3rd party hosting service that hosts mysql/php - Create database in mysql - Create some html pages with php scripts - write some php to do some fancy stuff. My reasons for...

If you answer the questions that Plog raised then, the path should be clearer. - What technologies are currently being used in your current environment? - What is your current experience? There's no point investing time up front on PHP/mySql if your business is on the path of SqlServer/ASP.net...