Search results

I design the Access 2010 database for a friend of mine who owns a business. 2 weeks ago he changed his computer to Windows 10 and since then, about every other day this happens: The only way to fix it is to open the corrupted DB, where a message appears that there is a problem and Access...

There was a phantom record in the main table that could not be deleted. It was a strange one because the primary key field was the same as another record somehow. Anyways, I ended up making a temporary backup table with a make table query, then I deleted the original table, created a new...

Hi all, When a user tries to delete a record in a particular form, I want to be able to look at what is in one of the fields in that form first. However, by the time the event fires, the record has already been pulled from the form pending confirmation from the user, and the next record is...

Hello, I am not sure how to accomplish this. I am exporting a query to XLS, and this works by itself, however, the user selects the criteria from a list box in the form, so the query's criteria would be like: In ("APPLES", "ORANGES", "BANANAS", "GRAPES") Since there is no "WHERE" option for...

I am using VBA to create an HTML email in Outlook. This works just fine for me when I use it at home. However, when the guy I designed this function for uses it, the emails are in RTF I believe. He sent one to me and the table size is wrong and the hyperlinks within are plain text. He said...

Hello again.... The guy I design the database for is suddenly having an issue with a totals box not displaying its contents. This text box is in the form footer of a subform. Here is a side-by-side screen shot of when it displays and when it does not. Notice how when the contents of the...

I miss the old database window format of Access 2000 with the tabs for tables, queries, forms, reports, etc. In 2010 I have to scroll top to bottom when I am switching between queries, reports, etc. and it's time consuming and hard to find my place because there are so many of each. Is there...

Hey all, I am having a bit of trouble figuring out how to do a specific type of report. I want it to show totals (count of records) from most to least, broken down by month, like this: January ------- Apples 20 (20 records exist for apples in January, etc.) Oranges 18 Bananas 12 Grapes 10...

This should be pretty simple but I can't get it to work. I have a report that lists events in order by date. I want to use a group header or footer to create a space in the report anytime the month changes, so each month's dates are grouped together. If I group by month and then sort by date...

We recently converted to Access 2010 after using 2000. This problem has suddenly appeared. It doesn't happen on every report but there is one in particular right now and I can't figure it out. The first page of the report is complete but it prints a second page containing only the page header...

I would like to create a command button that saves a report as a PDF. Currently I am using the built in "PDF or XPS" button but it always opens Adobe reader at the end and also a dialog with the option to save export steps. I want nothing other than a simple save dialog like I can do with a...

Since converting to Access 2010, when I use the "PDF or XPS" button to create a PDF from a report, after the save dialog it opens the PDF in Adobe reader, and then after I close it there is another dialog with the option to save the export steps. Is there any way to just be able to save the PDF...

Just switched from Access 2000 to 2010 and now on many forms and reports where dates are displayed, you see ###### instead. I realize that widening the field fixes this but there are a lot of forms and reports in this database to go through and change all of them. Is there a setting somewhere...

Hey all, please see the attached Access 2010 database. Notice how in the form, the 4 rectangles are a border width of hairline, 1pt, 2pt and 3pt respectively, but the first 3 look identical and the borders almost look gray even though black is the color. However, when drawing lines, you can...

Hey all, Just converted over to Access 2010 and there are a few things that I can't figure out. I use dual monitors for design and the 2nd monitor is for the code window and properties panel. I can't figure out how to get it to use the 2nd monitor. I can resize the program window all the way...

Well, I made the move and am using Access 2010 now and I am running into a couple issues. First off, I want to get rid of this menu on startup: Not sure what it's called (ribbon, menu bar, etc). I am able to hide it using DoCmd.RunCommand acCmdWindowHide DoCmd.ShowToolbar "Ribbon"...

This is a strange one. Initially this code worked, and then it gave me the error, and then it worked, and now I am getting the error again. I have a text field in a table that will either be blank (null) or contain a date in the format mm/dd/yyyy. In my query I am trying to get all records...

I guess it's time to get with the times here. I have been using an Access 2000 DB for many years and the owner of the company wants to upgrade to 2010. Is it correct that I can run it as is (MDB) in Access 2010 without a problem or would it be advisable to convert it to ACCDB? This DB has a...

I maintain an Access DB for a friend who runs a business. The problem I am having is that the auto-number value on his machine is different than on mine so anytime I try to add data in testing, it tries to create a primary key value that already exists in the table. Can I set the auto-number...

I have a report that was created on my computer. When this report is opened on other computers (2 that I've tried) the text alignment is way off. Originally I thought it had to do with printer margins dictating something but that is not the case as the margins remain identical on all...