Search results

you may not have your tables correctly normalised. I would ensure that each document record has the person's ID as a foreign key, then all you search for is all documents with a particular foreign key. If the document is linked to more than one person then an extra table will be required to...

Concatenation is the name of game PartNumber = partnumber & "1" & is the concatenation symbol

your order table would be similar to this tblOrders orderID - primary Key SchoolsID - Foreign Key orderDate tblOrderDetail OrderDetailID - Primary Key OrderID - Foreign Key OrderDetails - could be a foreign key to a product OrderCost

here is the refresh code I use Private Sub RefreshLinks() ' DAO Data Library Dim tblDefs As TableDefs Dim tblDef As TableDef Dim strConnection As String Set tblDefs = CurrentDb.TableDefs ' LIVE Production Database Link strConnection =...

why not use a union query to always append a blank recordset to your main query.

you will not be able to email a report as the message body, nor as an attachment. You would have to save the report in RTF format first then attach it. Otherwise you would have to build up the message body as a text string.

I would use a query for the record source of the subform and place filter criteria on the date referring to the value on your form. =Forms!YourFormname!YourControlname

I would create 3 tables. Here are the minimum data sets I would start off with. tblWard WardID autonumber Wardname string tblStreet StreetID Autonumber StreetName StreetPostCode (many roads/streets run through post code boundaries) WardID tblSchool SchoolID Autonumber SchoolName...

its called soundex. here is an example and a helper function Function Soundex(LastName As String) Dim i As Integer, j As Integer, Str_Len As Integer Dim SCode As String, PrevCode As String, strResult As String, CharTemp As String * 1 If LastName = "" Then Soundex = ""...

to hide the first column (containing the primary key) just set the width to zero.

A progress bar needs to be initialised with the min and max values, then it needs to be updated periodically. So cannot be used the way you want to use it, as you cannot break into a query to determine how much work has been done to update the progress bar. However queries do use the progress...

try exporting the speadsheet, then importing it into Access. Or you could open the spreadsheet within Access and read the cells, to see if the problem with the Excel function persists

yes, search the forum for workgroup security

yes, search the forum for security or workgroup

Split your db into Front/back End, and store the link to the document not the document itself.

The Auto Correct feature is buggy (as you have found out to your cost) , turn it off. you now have 2 options, either as HiTech pointed out, revert to last backup or recreate your form.

I can't help you with Excel as this is the Access Forum

if you are referring to an auto id, either ignore it, or go into table design and delete it. In my opinion all M$ software does too much second guessing especially when it comes to indexing and auto numbers. When you created the table it will have prompted you to have M$ Access automaticcally...

I strongly advise you to remove combo boxes from tables. Place your combo box on a data entry form instead. Always try and keep tables as simple as possible, with minimal index's, one on Your primary key and one on any Foreign keys in your table.

you can prevent empty text boxes being printed by setting the can shrink property to yes/true