Search results

I think I will go for the continuous form. I was trying to make a query tool where the user could select the columns they wanted. There are about 50 total, and the datasheet is the only view flexible enough to display them all at once. But the user choosing all the fields at any given time is...

I gave that a try and now I'm unable to scroll at all. Unless I'm missing something?

Hi, I'm having the following problem with my form (Access 2010): I need the flexibility of datasheet view, but also need to be able to put command buttons on my form. I went with the solution of using a main form for the command buttons and the datasheet as subform. This isn't too bad of a...

Just wanted to come back and say thank you for the help. This strategy worked perfectly and I was able to apply it to multiple tools in my database.

Thank you mh for replying as well. I think JHB's suggestion is the best one as well. I'm just trying to figure out the best way to do it. In the past I didn't care much about efficiency or the best way to design things. In one instance I wrote 18 different stored queries to grab max values when...

A workaround could be to create a query on the fly, (using VBA code), only containing the required fields the user had selected. Thank you so much for taking the time to respond. I like the idea of creating a query on the fly. I think that's a better way to go than simply hiding the fields...

Hi, I have a query tool that allows users to create their own custom queries. Basically, it's a form that allows the user to check boxes for the fields they want to see. The code behind it simply hides the fields in the query for which the user has not checked the box. That works very well...

I just wanted to come back and thank everyone for their advice. For the longest time, I've been strictly working within the UI that access gives me. Now, I'm getting more of a sense of what code can do, and I'm very excited to learn more and try more things. The members of this forum have helped...

Hi, I'd call myself an advanced beginner with vba. I have limited skills, but can do a fair bit of stuff with them. I'm now at the stage where I'm trying to figure out how to do things in a better, more efficent way. I would like to make clickable labels on my form, so if the user has any...

I just wanted to say thank you again for responding and for your help. I looked at the information in the links you sent, and that seems the best way to go. I appreciate you taking the time to help me.

Would leaving the texts alone and creating combos just create an extra step to achieve the same goal, or are there additional benefits to doing it that way? Thank you for taking the time to answer my question. I really appreciate it.

Hi, I'm just curious whether there is a way to convert multiple text boxes to combo boxes all at once, rather than right clicking on them one at a time, and selecting Change to. I have a form with about 50 fields and most of them need to be converted to combo boxes. I'd always done it...

I just wanted to come back and say thank you to Mihail and David for your advice. You gave me some good tools to work with that I will apply to solve the problem. Thank you for taking the time to help me.

Hmm, not sure. Is that something I'd be able to check for if I was at the computer? Would that be something my colleague would be able to correct, or would I have to have IT get involved? It's a private office computer, and my colleague is the only user, but we're on a system wide network...

Thank you very much for responding. I just have a couple of follow up questions: 1) Check if the worksheet is in a write protected folder. Does this have something to do with the trust center, or is it something different? 2) Check the references. Would you be able to point me in the...

Access version 2010 Excel version 2010 Hi, I added a command button to get one of my access reports to export to excel. The process works perfectly on my computer, but when my colleague runs the report on a different computer and tries to use the button, an error comes up that says "can't...

I've been fooling around with the subreport, and it looks like the solution is going to work for me. I just wanted to come back and thank you for your help.

The calculations are different for each field. For numeric fields such as credits and gpa, I have min, max, and average. For demographics I have counts and percentages. To hold all of these calculations, I have about 100 text boxes. That's why I chose to do the calculations at the report level...

Hi CJ, Thank you very much for responding! I had to rule out using a datasheet because I have a lot of calculations in the report footer that I wouldn't be able to recreate at the query level. Does that make sense?

Access Version: Access 2010 Experience Level: Beginning/Intermediate-Comfortable with basic vba coding, but need a bit more guidance with anything advanced, though I'm good at following examples. Hi, I've been working on a custom report tool, in which the user would be able to click...