Search results

This database constrains a calendar control example. http://www.myaccesstips.com/UI/Reports.html

Another way is to use DMax: Me!Recordnumber = Nz(DMax("[RecordNumber]", "[Your Table]"), 0) + 1

Check out:http://www.mvps.org/access/api/api0018.htm

You can prevent users from accessing design of objects by creating an mde file.http://office.microsoft.com/en-us/access/HP052393021033.aspx About digital signatures http://office.microsoft.com/en-us/access/HP010397921033.aspx?pid=CH010411421033

I would disconnect all USB storage devices and reboot the PC. Then reinitialize each device by attaching them 1 by 1.

I suggest testing the removable media on another PC to determine if the issue is the PC or the Media. If it is the media, you may need to reformat it (this will erase any data). When you disconnect the USB devices, are you using the “Safely Remove Hardware” icon on the Taskbar (near the...

You are welcome – good luck on your project.

You are welcome – good luck.

You should design Materials as a sub form of WIP (Main Form). http://office.microsoft.com/en-us/access/HA100986741033.aspx?pid=CH100645661033

Here is one - Link.

You are missing the Me object. Dim stGunlib As String Dim stGunlib2 As String stGunlib2 = Me![Stock number] stGunlib = "#http://www.shooting.uk.com/Gunlibrary/" + stGunlib2 + ".jpg#" Me![Link] = stGunlib Me![Picture] = stGunlib

Is [Picture] a hyperlink data type field in the table?

Try: stGunlib = "#http://www.shooting.uk.com/Gunlibrary/" + stGunlib2 + ".jpg#"

Create a new table for the grouping. Structure tblYearGroup -Year (PK) -YearGroup Data Year | YearGroup 1990 | 1990-1994 1991 | 1990-1994 1992 | 1990-1994 1993 | 1990-1994 1994 | 1990-1994 1998 | 1998 Then create a query - add the 2 tables, join them by the year field, add YearGroup to the...

I think Excel would work as a better medium than Access, for what you want to accomplish.

To prevent deletions, set the AllowDeletions property of the form to No. If you want to restrict based on the user you will need to have a process in place that captures the user name and stores it in the record. http://www.databasedev.co.uk/filter_current_user.html

Use the Toolbar, Menu bar, and shortcut menu property of Form and Report objects to assign your custom ones. Then disable toolbar changes in the Tools > Startup options. Crate an MDE file to lock down the application so users cannot make design changes...

You can also use a simple batch file to update the FE and launch the db. http://www.myaccesstips.com/deploy/deploy.html

Here is a function to FTP. http://www.myaccesstips.com/Functionality/ftp.html