Search results

For the purpose you are going to be using the list boxes for, you can just select the "remember for later use" option. You will be reading the information about the selected values later when you are ready to create the record in the linking table.

Use the "Where" parameter of the OpenForm method. If you are using VBA or a macro there is an option to add the criteria to open the form to a record meeting the criteria you provide.

Yes, it is possible to do exactly what you want to do but a sub-form is not required here. You first need a way to assign or link students to the courses they are signed up for, so you do need the table to hold a record for the Student record ID and the Course record ID for each course. This...

I had not really ever thought about this but I can see how it might be a challenge for some. I have no problem with typing in the complete name of the state (mine is Texas (TX). Here are a couple of links to help determine from the two character abbreviation which State it is...

If you have a "View" then it would be read only. If you need to change the data you would need to use an ODBC connection.

You can use a query and provide criteria in the query that will filter your list box. As for the VBA coding, try using Google and this forum and you should be able to find code that will help. I will admit that this can and will be the most difficult part for you if you do not know VBA...

After briefly looking at your database, I would suggest that you need to do some thinking about the design of your database. I have attached a modified version of your database. I have made changes to fields in your tables and even added a table. I have also create an example query that...

My first question is: What else do you see in the navigation area beside the disabled Next and Previous buttons? Do you see a record count? One possibility would be that you may have set the "Data Entry" property to Yes and left the "Allow Additions" property set to Yes. I would check the...

You could display the list of potential e-mail recipients to your users in a listbox and set the Multi-select property of that listbox to "Simple". This will allow the user to select any number of recipients. You would then just need to use VBA code to read each selected value and return the...

I am a little concerned about the [Text863] as the name of your combo box. Normally when you add a combo box to your Access form, Access will provide a name like "combo0" for the first combo box added. There are a couple of ways that you could have the name that you are refering to but my...

If you do not need to have the application share data between users, then you can simply put the backend file in the same folder as the frontend and use the Linked Table Manager to link the frontend to the backend. Hope this helps.

Although the solution that I am going to propose does not include Drag and Drop at this time, it does provide a very easy way for users to change the sort order of one or more lists used in an application. You did not indicate which version of Access you are currently using but I have attached...

Try using your code in the OnFormat event of the section where your controls are located.

Try using: > Format(DateAdd("d", vbSunday - Weekday(Date), Date) + 1, "yyyy-mm-dd") as your critieria.

Change the line where you are assigning the Criteria String to your variable to the following: strFilter = "MACorID = '" & Me!MACorID & "'" Notice the addition of the quotes, both single and double. This will make the criteria to work.

Here is a link that should help: http://www.access-programmers.co.uk/forums/showthread.php?t=178371

You might try this link: http://www.askdoctoraccess.com/DownloadPage.aspx and scroll down to locate the "DemoCascadeComboBoxes.zip" option. That small database has working cascading combo boxes. You can see exactly how it is done. Hope this helps.

Gald to help. Good luck with your project.

Here are couple of links that might help: http://www.techonthenet.com/access/modules/sequential_nbr3.php http://www.utteraccess.com/wiki/index.php/Sequential_Numbering

As you make changes to the FE you will need to distribute a new version out to all of your users. Here is a link to a very good solution to this issue. http://autofeupdater.com/ For this one, I am assuming that you are talking about when you have to make changes or modifications to the...