Search results

Hi, The combobox can have many columns, therefore you can set the row source for the combobox to display the foreign key in the first column, and the text you want to display in the 2nd, 3rd 4th columns as you want. E.g. SELECT ForeignKeyFieldName, DisplayTextFieldName FROM TableName This...

Hi, First you have to use setfocus to select the form (as you have done), then you can use it again to select the control on the form. Try this: Private Sub cmdAddNewReocrd_Click() Me.SF_AccountsSub.SetFocus DoCmd.GoToRecord , , acNewRec Me!SF_AccountsSub.Form!eDate.SetFocus End Sub

Hi, I have removed the Exclusions table from the database. There is potentially a single exclusion for each student, therefore you would have a 1:1 relationship between your students table and the exclusions table. I think this will potentially make the application slower, particularly when...

Hi Kenny, On the left hand side of the main database window you will see several objects. Click on "Forms" and you will be shown all the forms in the database. At the top of the database window click New. The Form Wizard is the second option on the list. The same is true for reports -...

That's ok, I have started helping on this forum because I quite enjoy Access, and it is a good way to learn myself! I'll take a look tonight. It shouldn't be too hard to select the data you want to export, both for multiple email addresses, and students that don't need to be included. I...

Hi, This should achieve what you want, just change the number 60 to the number of days you want to group by, and change the field and table names to match your data. SELECT Int(([DateFieldName]-DMin("DateFieldName","TableName"))/60) AS DateGroup FROM TableName GROUP BY...

Hi, Take a look at this site, one of the answers explains how to work with the context menu, and gives a specific example of deleting records. http://stackoverflow.com/questions/770425/how-to-add-a-menu-item-to-the-default-right-click-context-menu

Thanks to everyone who has replied, the information is very helpful. It sounds daft, but I had never really thought about why communications over a network become slow. Reducing the amount of data that needs to be transferred by careful selection of records, and further optimisation of code...

Thanks, I will take a closer look at stored procedures - I am very new to this so don't know all the jargon yet! It seems like they are broader and much more flexible in terms of what they can do. Interestingly I have just read that caching of the execution plan (or not) only really causes...

Hi, In addition to the advice above it is worth taking a look at DoEvents. A word of warning though is to be careful about how many times you call DoEvents. It can be useful to prevent the application from hanging. But if it is called many times then it can cause the computer to hang, or cause...

The force is strong with you too my young Padawan.

Hi, Should be as simple as changing: Docmd.OpenReport strReport to Docmd.OpenReport strReport, , , "employeeID=" & rs!employeeID

Hi Pat, Yes, if you look at post #7 it reads "I would like to be able to select multiple courses from the available 70". I hadn't appreciated this at first which is why I initially suggested a ComboBox, rather than ListBox. Good advice about the clear button. It is also worth using a command...

For most of my forms and reports I already retrieve a limited recordset, so I can't see any major difficulties. I can't think of any instances where I have included any custom functions in the criteria of my queries, but it is useful to know to avoid these as a general principle. I can think of...

I think I understand your set up now. So you have a relationships set up with the reg_number in table1 linked to the reg_number in tables 2-4. For the relationships is "enforce relational integrity" checked or not? You will need to do this before cascade updates will work.

Hi, It sounds like the issue is almost resolved, but I thought I'd pass this on in case it helps. I have been looking to do a similar thing recently, and stumbled across an application written by a fellow poster on this forum, Bob Larson, called FRONT-END AUTO-UPDATE ENABLING TOOL. This is...

Hi, Given the complexity of your query, perhaps the best thing to do is pass the parameter to the query. As you are using DAO you might as well stick with that. What I think you need to do is use a querydef object. You can then supply the parameters before the recordset is opened. I'm a little...

Thank you Pat for taking your time to write such a detailed and clear explanation of how to make the transition. It is difficult sometimes to form a coherent view of the advantages and disadvantages of various options when there is so much conflicting information out there. Lots of people have...

I guess the answer to your question depends on what the reports contain. If you want different formatting for each report then you will need a different report for each format. If you want the same format, but select different data, then it is best to filter the results shown on a single...

The example you have given will open up a report called Attendance and then the value from the "max" field, for each record in your query. You will therefore open the report as many times as the number of records in the query. Is this what you intend to do? If so I can explain how to pass...