Search results

There are alot of posts regarding images on the forum. Storing images in access 'bloats' the db size. The best method is linking your images and as Ally says just storing the path name to your image in a table. Search the forum for some examples.

Shay, Thanks for your reply. The query is triggered through code. I will give your suggestion a go. Thanks again

I have a query which exports data as a .txt file. Is there a way of stopping the export if no data is returned from the query, something similar to the report On NoData event ???

Dim Response Response = MsgBox "This entry has been marked complete. Are you sure you want to send an email?", vbYesNo If Response = vbNo Then Exit Sub End If

You can try creating a command button and on the OnClick event put the Me.Requery line.

Are you sure the DLookup formula is correct?

Sorry, my mistake. Put the Me.Requery on the after change event of your combobox

In the properties of your textbox add Me.Requery to the after Update event

There are quite a few posts about this. Ghudson seems to have it covered. Try this thread. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=35471&highlight=Disable+shift+key

Great Idea, Maybe we should use some of the popular questions that are posted, and build a sort of reference db for all to use and abuse? Or Is that a lame idea???

Either send me an email or post your email address and I will send you the .ocx file you need and a program for registering the file.

What is the name of the library which is missing. In the VB Window Tool>References.

Try putting this after the Set db = CurrentDb Set rs = db.OpenRecordset("TableName",dbOpenTable) Also remeber to set db & rs to Nothing at the end of your code otherwise you will run into problems later. ie Set db = Nothing Set rs = Nothing

You could split the database keeping the back end on the server and then customising 5 front ends for the reps which would sit on their pc. The only problem with front ends on the reps pc is when you want to make any changes or updates. If you would need to make regular updates then it would...

Forms![yoursubform]![yourfieldname].Visible = False

What is the pupose for each rep needing their own database? If each rep only want access to their records then just filter the form based on the rep Id.

Your MoveFirst needs to be outside of your loop otherwise it will just keep returning to the first record. rs.MoveFirst Do While Not rs.EOF

Use this code behind a button on your form. You will need to modify it to reference your fields though. Private Sub Command1_Click() On Error GoTo ErrProc Dim TaskNS As Outlook.NameSpace Dim TaskItem As Outlook.TaskItem Dim TaskApp As Object Dim Db As DAO.Database Dim Rst As DAO.Recordset...

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34755

Auteng, Cool site!!