Search results

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...

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...

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...

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...

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...

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...

Access Version: 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 researching this issue for two days straight, and while I've read some posts that were...

Hi, I'm using Access 2010, though am also familiar with Access 2007. I have a listbox populated with a query (concatenated last and first names with a bound ID field that's invisible). One of my users asked if it would be possible to search the listbox by more than the first letter of the...

Hi, The version of Access I'm using is Access 2010. I've been trying to work with the "Collect Data" tab to email a survey to 800 people and have the results be populated in the database. I know that's possible with the "Create Email" feature, but I want to take it a step futher. My survey...

Hi, I've built an educational program database in Access 2010 and housed it on a shared network folder. Now I've been asked if I could possibly make it so our program's remote users could enter data in the database. They do not have access to the shared network folder where the database...

Hi, I’m building a form for one of my program databases (Access 2010). The business rules I’d like to set up are: A student can be enrolled in a program, exit the program and return at a later date, i.e.: Name --------- EntryDate----- ExitDate John Smith ---9/1/2010 -----8/31/2011 John...

Hi Everyone, This question concerns an Access 2010 database I’m creating for one of my programs at work. I’m having an issue trying to get a nested loop to work. I am very new at loops, and at working with recordsets in vba. Here’s what I’m trying to accomplish: The user clicks a button, and...

Hi, This question pertains to Access 2010, though I'm familiar with 2007 as well. I'm trying to set up validation rules in one of my forms so that the combination of two fields is not duplicated. More specifically, I want to avoid the following scenario: Student Program Subject EntryDate...

Hi, I am using Access 2010 for this particular project, though I am familiar with Access 2007. In my database I have a form that acts like a subform but is not embedded in my main form. I have a command button on my main form that opens the quasi-subform, which I'll call qs from now on, to...

Hi All, I'm running Access 2010, though I'm very familiar with 2007 as well. At my job I've been tasked with creating an Employer Database. The database is supposed to provide the name and address of the employer, as well as accomodate multiple supervisors tied to each employer. I think I've...

Hi, I'm working with Access 2010, though I'm sure advice from Access 2007 would be applicable. Basically, I have three tables: tblStudent tblService tblStudentService (junction table between tblStudent and tblStudentService) My tblService has almost 3,000 records. Most of these records...

Hi, I'm trying to set up a simple filter button in an access report. For example, my report might have 2000 services, and I don't want my users to have to go through them all to find the one they want. I wanted them to be able to narrow the results down by the first letter of the service. I...

Hi, This question is in regards to Access 2007, but I'm sure advice would be applicable for all versions. I hope so anyway :). I have three main tables I'm working with: Student, Service, and StudentService (which is a junction table for Student and Service). Here is the structure: Student...

Hi, I'm running Access 2007. My database has four main tables: tblStudent tblAPR tblService tblStudentService tblStudentService is a junction table between tblStudent and tblService. It has tblStudentServiceID as a PK and StudentID(pk of tblStudent) and ServiceID (pk of tblService) as...

Hi, I'm working on an educational program database using Access 2007. I'm currently designing Version 2. I made Version 1 when I didn't know much about database structure, and it's currently in production. A problem I'm having with Version 1 is that students have multiple entry and exit...