Search results

Check your "Access Settings" - "Trust Center Settings" - "Macro Settings" to make sure that Access is not on the highest settings (Disable all macros without notification)

If you need to keep all within VBA then the following link explains how to use the Shell command to perform single line commands. http://www.mombu.com/programming/programming/t-move-command-using-shell-in-access-vba-646041.html

You also could create a command file (.cmd) to copy the files if you have known extensions. copy C:\DirectoryName\*.pol C:\DestinationDirectoryName\*.txt (add as many lines as you need to cover other extensions) (to make this work without using variables try not to have spaces in you directory...

You will need to open the back-end exclusively, no one else can be in or actively linked to the back-end. If you can get everyone else out of the database, open access, goto open, and when the browse window comes up, select the file. The open button will have a down arrow beside it. Click on the...

Go into the linked table manager (through the F.E.) and check the location that the B.E. is located. Also, if the mapped drive is not the same on the other computers accessing the DB, you will want to use the server location (\\server\database) for the location.

This page should help http://www.access-programmers.co.uk/forums/archive/index.php/t-128280.html

Are you doing this for all of the files in a particular directory? attrib <directory>\*.* -r or If there is something common about all of the file names that you want to change attrib <directory>\*this*.* -r This will change any file with the word this contained in the file name or if an...

If you open up windows explorer (or My Computer) goto Tools goto Folder Options goto View (tab) Uncheck "Hide file extensions for known file types" This will show you the extentions on your files. A txt extension is probably not the only one that can be read by notepad. Hope this helps.

Make sure there is at least one record to show. Hope this helps?

Try: DoCmd.OpenReport "rpt_PDP_data", acViewPreview, , "[Name]= '" & Me.CboName.Column(0) & "'" The Column number is the column of the info that you want to use. (Columns start from 0, not 1) Sorry, I missed that that solution was already used

Your main form might be trying to filter your subform?

You might also want to add an error handler so that you can set the confirmation back to true if there is an unexpected error.

I would suggest using Combo Boxes instead of List Boxes.

The Dlookup funtion should work for you. If Project is Text: Me.[Project Description] = DLookup("[Project Description]" , "Programs", "[Project] = " & Me.Project & """) If Project is Numeric: Me.[Project Description] = DLookup("[Project Description]" , "Programs", "[Project] = " & Me.Project)

I am assuming that your combo box includes both Project & Project Description. In the On Change event (of the combo box) you can use: Me.[Project Description] = Me.[YourComboboxName].Column(1)

This error may be because you have a linked picture or document that cannot be found. Or may be caused by Norton Antivirus. http://support.microsoft.com/kb/q295824/

I'm at the limit of what I can suggest without knowing more about the setup of the form and what info you are trying to return. You can try setting break points in your code to find out what is being returned to your fields (FieldA, FieldB & FieldC). Or maybe someone else may have some...

I am assuming your subform is a continuous form. It may be easier to to create a pop-up form to insert your comments.

Take the line out of the query: [FieldA]=[Forms]![FormName]![ComboBoxName] Or [Forms]![FormName]![ComboBoxName] Is Null= True and try it in the Form Load event (or Form Open). You may have to play with the syntax or use an If statement. That line is trying to get information before the form is...

Ideally, you should split your DB into Front-end and Back-end. But to answer your question, under options, the default open mode needs to be shared.