Search results

I'm currently using a custom ribbon that gets a macro error when any of the buttons are clicked. It seems the issue is due to using 64 bit Office now. I've had help with the previous code so I have no idea what needs changed or how to fix the issue. Current Code: Private Const...

I'd like to be able to automatically send a report from Access through Outlook. Currently, I started with: DoCmd.SendObject acSendReport, "rpt30Warning", acFormatPDF, "myaddress@domain.com", , , "Expiratations in 30 days", "Please see attached PDF.", False I later found I can't use this...

I have a split form with a sum of totals in the form footer. The total shows as long as the fields are filled have data and as long the cursor is not moved in to the next bank field of a new record. How can I get the total to always show and calculate properly?

I'm looking for a way to change the custom ribbon by clicking a button on a ribbon and entering a password. Right now my database has two ribbons. One labeled developers and one labeled users. Basically, the users ribbon hides all the ribbons, but the one custom ribbon. I would like to click...

I'm trying to do a database for basketball that has two tables. One table is Teams and the other is Players. The Team table has a field "Team Name" and the players table has a field "This Year's Team". I'm trying to do a report based of a query. The query has five fields "Last Name", "First...

Monthly I have to import data from an Excel sheet. It takes a while to import so I would like to have a progress bar. There is a small progress bar native to Access at the bottom of the screen, but I would like one in the middle of the screen. Here is my current code to import the table. The...

I currently have a database that compares some data between two tables such as firstname, lastname, and dob to see if there is a match between two tables. The second table is created from a spreadsheet that is received monthly. In the past the DOB field has been a short date. Recently the...

I currently am working on a small inventory project. I have a table with the fields "Part Number" which is my primary key, "Description", "Cost", and "Sale Cost". I have a second table that I would like to use to keep track of purchase orders. It has the fields "Part Number", "Description"...

I can't figure out how to get my query to run from criteria based on a combobox from another table. I have a field "prac" that has entries such as JF, MG, PM, RJ etc. My query has the criteria for prac as [Forms]![PracReportPrint]![PracChoice]. PracChoice is the name of the combobox. if I...

I've currently come across the issue where an end user copied the database locally to their computer and has been using it for months and months. After fixing an issue in the database on the server and then finding that someone still had a database bug is how I figured this out. Anyway, what...

I've been trying to help my sister with a database query. I need the query to count the records of a field and display a number for the records of the field. For instance, one field is [Genre] and the other is [Show]. The query needs to list the Genres along with the number of shows for each...

I currently have a database that looks for record matches between two tables. It is looking for same FirstName, LastName, MidName, and DOB. Here is the query: SELECT [Beaver A&D Waiver].LASTNAME, [Beaver A&D Waiver].FIRSTNAME, [Beaver A&D Waiver].MIDNAME, [Beaver A&D Waiver].DOB, [Beaver A&D...

For some reason the location of my text changes in print preview. For example, the last word of one line may hop to the next line in print preview. This is a real pain because I have data that needs to fill in to the reports. For example, I have a sentence that says, "I agree to pay a pre-set...

I have a continuous form that I use for addresses. The form is mostly grayscale. When I open it using Access Runtime I get darker colors closer to tans and browns which makes it very hard to read. I went back over the form and chose standard colors from the most basic color picker and I still...

I have an issue where my reports don't print the same in Access Runtime. At first it was a font issue because the PC running the runtime didn't have the font so I added the font and that issue went away. However, I have noticed other prints that don't have the same spacing. My print will be...

I have a form with a checkbox for the field "active". By default the box is checked. I currently have code to prompt the user if they have added or removed the check and asks if they would like to undo the action however if you undo the action it doesn't undo anything. Here is my code...

I have a field for SSN that I would like a prompt to let the user know that hey haven't entered a SSN. This field isn't required, but can be very important. If I use validation text or requirements some users may get annoyed especially if they don't have the information. So, if the field is...

I currently have a report created in access 2007. It prints fine on my PC. I split the database and put it on another PC and ran it using Access Runtime 2007. One report has a list of items like 1. text paragraph 2. text paragraph etc. When I print this report on the other PC I get a character...

I've added an address book to my current database and I was wondering if there was a way to view the records tiled similar to that of Outlooks adderss book. So far the best solution I have come up with is to just use a continuouse form, but that still just gives me the records vertically. I...

I currently have a query that I use to search records by firstname, midname, lastname. The criteria is entered on another form. The query pulls the data from the form to fill the criteria. For example, the query has the field "Firstname" and the criteria is - Like "*" &...