Search results

Search the forum, or look in the Sample Databases section, for security and passwords. You will need a login screen, which is the start-up screen of the database and then depending on the login details they enter, you can only gove them access to certain forms via a switchboard menu screen.

Tramp, Delete the CategoryID fields from TblItems and TblParts. Access will probably tell you that you will have to delete the relationships first. Then create TblCategories and go back to TblItems and TblParts and insert CategoryID as a FK. Might not be so easy to sort the relationship out...

You don't need to use a query for this. You can use the DLookup function instead. Search the forum, or Access help, for DLookup and you'll get plenty of answers. Also search the forum for database security/password. There are lots of threads with people asking how to password protect a database...

Use a form, which has 2 option buttons. One, which allows the user to enter 2 dates and the other, which just has one textbox for the date. Have a cmd button on the form, which runs a query to display the results. I've attached a rough and ready example to show you what I mean.

I've changed the structure of the database a bit, but it the cascading combo boxes are working.

Hi Have a look at http://www.candace-tripp.com/_pages/access_downloads.asp Download the 'Picture in Database' example and this will show you how to store the filepath of the image. Also have a look at the 'Windows Common Dialogs' example as you will be able to use this to allow users to...

Delete TblRoute, you don't need it. Just use the other 2 tables. TblRides will be the main form with TblWayPoints as the subform. Forgot to add that IDRide will be the foreign key in TblWayPoints.

Attach the database and I'll have a look.

Have a look at the following link http://www.candace-tripp.com/_pages/access_downloads.asp Specifically the 'Picture in Database' example.

You need to use a main form and a subform. On the subform you can have the start and end dates and everything else can go on the main form. There will also need to be 2 tables. One, which the main form is based on and the other, which the subform is based on.

Have a field in the table which stores the filepath location of the image.

Try using the following code instead of the macro; Checkbox_AfterUpdate If Me.NameofCheckbox = true Then Me.NameofTextBox = Date() End If I can't see any reason why you should get the 1800's date from the macro, but see if the code makes any difference.

Thanks Rich, I'll give it a try and see which the users prefer.

Sorry, I should have mentioned that the subform needs to be in the detail section, as it will be different for each record.

Thanks for the reply, but whenever I try to change the form's properties back to continuous, Access displays an error message telling me that subforms cannot be placed on continuous forms.

If I understand what you want - you want the user to select a record from the listbox on FrmMain and then that record will open up on SubfrmTest. To do this, just remove the following line from your code DoCmd.Requery "List15"

I have a subform, which allows users to select several offices that they want to send a task to (the task details are on the main form). I then have a continuous form, which displays the outstanding tasks and the offices, which are associated with the tasks. Unfortunately, Access will not allow...

mbertoul, I've attached the database (in 2000 format) with the changes I suggested. The selected record is displayed whether the user uses frmsubtest or frmmain. Let me know if this is what you wanted. Dave

Have a look at the following link: http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb This should give you a start.

Depending upon which operating sytem (OS) you are using, you can check the available system resources by right-clicking on the 'My Computer' icon on your desktop and selecting properties. Under one of the tabs it will display the percentage of system resources, which are free. Every programme...