Search results

My company is converting from Access 2010 to 2013. My database is in Access 2007 - 2010 format. Will I have to convert it to Access 2013 for it to work in 2013?

That worked. Thanks!!! I was thinking that there was a much easier way to do it.

Thanks, but no, not really. Now I have a query that shows me in the same column the number of wins and the number of losses for each runner, but I don't know how to get it to show me the percentage of time each runner won.

I would like to create a query that groups records and then tells me what percentage of the time a boolean field is true for each grouped field. So in my table, there are multiple entries for each person. I want to find out what percentage of time each person won. The table is called Races...

This seems to be working. Thanks so much!!!

I will try that. Thank you very much.

Thanks, but unfortunately, that didn't help with my specific question.

I have read a lot about this, but I'm very new to Access 2007 and custom ribbons and am having a really hard time figuring this out. I want to be able change the default ribbon depending on certain things. So I started by creating a UsysRibbons table. The table has two records. One with a...

I figured it out. It turned out to be simple. I think I was making it harder than it needed to be. Here's what I put in the OnLoad event of the second form: DoCmd.MoveSize Forms!NameOfCallingForm.Form.WindowLeft, Forms!NameOfCallingForm.Form.WindowTop + Forms!NameOfCallingForm.Form.WindowHeight

Any ideas?

I have a form on which there is a command button to open a second form. I want the second form to open just underneath the first form. I thought I had it figured out using the MoveSize method, but it turns out that the second form won't be positioned properly when the resolution of the user's...

Thanks for your reply, but the fields are not the same. Here's the deal. I have a table called tblCourt. For each group of records that have the same tblCourt.ID_Number, I need a query to show me the tblCourt.ID_Number and the Max of the tblCourt.ActionDate where tblCourt.CourtActionsID = 1...

Sorry, no that's not what I meant. I want to create a single SQL statement that does what all three queries do. In other words, I don't want to have three saved queries. I want one.

I have three queries that I would like to make into one query, but I'm having trouble. How do I combine the three queries into one? The three queries are below. The qryGetMaxChapter3 is the one that I will use, i.e. it is built on qryGetMaxChapter2, and qryGetMaxChapter2 is built on...

Thanks! This isn't exactly what I was looking for, but I'll give it a try.

I have a form with a combo box on it. The combo is bound to the first column which is FacilityID. The combo displays the second column which is FacilityName. I am creating a search form, and I want the user to be able to search on FacilityName. I've looked around here and found where someone...

I have a main form with several subforms. What I would like the user to be able to do is basically build a search string with as many fields from the Main Form and Subforms as he/she wants and then display the results. I can't decide what would be the best way to do this. Here are the...

Thanks very much. So I take it VBA is the language that we are using in Access, not Visual Basic.

If I'm creating a resume and trying to list my skills, I'm not sure what to say. I believe that I would be classified as an expert in MS Access. So I know I would put down MS Access as a skill. But do I put down Visual Basic as a skill? Or would being able to code in MS Access be called...

Thank you very much. I figured I would have to use two separate forms. I was just hoping there was some way around that. Yes, I really do need both views -- I'm not just trying to open another form when the user selects a particular record.