Search results

You mean Rich Text (rtf)? LOL

Your declarations are wrong. Dim rstEmails As DAO.Recordset2, DBS As DAO.Database, rstFile As DAO.Recordset2 Should be Dim rstEmails As DAO.Recordset, DBS As DAO.Database, rstFile As DAO.Recordset2 The first one uses the Recordset object and the sub recordset uses Recordset2.

First and foremost, the first thing to look at with corruption is 1. Do you have the database split to a backend (tables only) and a frontend (everything else)? 2. If not, it needs to be done. If so, does EACH USER have a copy of the frontend on their machine. If not, it needs to be. You...

If a field is set to Rich Text in the table but the control to display the text on the form is set to PLAIN TEXT, then you will see the HTML of the Rich Text as well as the text. If you want to stop that from happening, set the text box on the form to be RICH TEXT instead of plain text.

What is the row source for your chart? It would need to have criteria which refers to the group.

And if it is in VBA "INSERT INTO TblProfiles ( [Employee ID], Barcode ) Values( [Forms]![FrmCreateNewProfile]![txtEmployeeID], Chr(34) & [Forms]![FrmCreateNewProfile]![txtBarcode] & Chr(34) & " );

INSERT INTO TblProfiles ( [Employee ID], Barcode ) Values( [forms]![FrmCreateNewProfile]![txtEmployeeID], [forms]![FrmCreateNewProfile]![txtBarcode] );

Duplicate thread. Original: http://www.access-programmers.co.uk/forums/showthread.php?t=248741

It isn't that his "OFFICE" setup in a trusted location. It is that a Trusted Location has been defined by the user from his Access application. In 2010, if you open a database file and enable code once, it assumes that you are trusting that file. If the file gets replaced or moved, then it no...

Looks like you need a space after the paren just before the word AND

Web forms are not the same as desktop forms. You can create a nice looking formatted report using web forms. It is totally possible.

You sound like you are trying to use the PDF instead of the original OpenOffice Spreadsheet. You would need to work in the original spreadsheet.

Can you clarify that statement? Reports can be built but they are web forms. But the statement makes it sound like, if you need a report, you can't do it. That is misleading.

Have you thought about using this existing tool that can enable auto updating quite quickly and easily and you wouldn't have to write anything? http://www.btabdevelopment.com/ts/freetools

According to the MS KB article - http://support.microsoft.com/kb/837148, it only applies to MDB files. And it does have a workaround if used in an MDB file. Create an INDEX (YES/ALLOW DUPLICATES) before any sorting is done.

Use the NUMBER datatype and use DECIMAL as the specific type. If you don't need decimal points just leave the Precision property's default to 18 and leave SCALE at 0. If you need 2 decimals then change the Precision default to 16 and SCALE at 2.

I do not believe that is possible. I believe you need to use VBA for that. One thing to note. Macros do not duplicate everything that VBA can do. Sometimes, if you want to do something, you have to use VBA.

try using the Before Update event instead and then also change to this: me.fieldname = replace(me.fieldname, Chr(44),Chr(46))

You need to go to the VBA Window, click DEBUG > COMPILE and then fix any issues that are identified first (keep doing it after fixing each until it compiles). Also, it could depend on if you have a form or report open in design view.

What version of SQL Server? You may not be using the correct driver (and that can be dependent upon which version of Windows you are using as well). The generic SQL Server driver should only be used if you have Windows XP -----> SQL Server 2000 Windows Vista ----> SQL Server 2000 or 2005...