Search results

I would like a printout of all the object dependencies in my database. I can see them by going to Database Tools>Object Dependencies, but that only shows one object at a time, and I need a list of all of them. Does anyone know of a way to do that?

I would like to create a database model diagram from an existing Access database. Several years ago, I did this using Microsoft Visio, and Visio automatically created it. Now, I can't get that to work. The versions I have are Access for Microsoft 365 and Visio Plan 2. Does anyone know how to...

I have an Access database (I'm using Office 365 on Windows 10) stored on a network server. No matter what I do, I can't make my database trusted. I have gone into Trusted Locations in the Trust Center, and added the network location where the database resides being sure that the Allow Trusted...

What are the major differences between Microsoft Access and Oracle databases? I have an Access database that I designed and have used for many years. In addition to the tables and queries, it has numerous forms and reports, and a lot of VBA code. It can also generate emails and Microsoft Word...

Apparently, the LIKE operator does not work in the Where clause of an access web app macro. Does anyone know an alternative? The following statement does work: [debtor name] = [txtDebtorName] but if I change the clause as follows, I get an error message: [debtor name] LIKE [txtDebtorName]...

I have a relatively complicated fillable form that someone else created in Acrobat. I would like to be able to fill it out using data from Access tables. So basically, I would like to do a mail merge with data from Access and an Acrobat pdf form. Is that even possible?

My company just got Access 2013 and SharePoint, so I am just looking into things, so please go easy on me. :) I have a desktop Access database that I would like to link to a SharePoint web app. I would like certain users to be able to use the full version of the database with forms, reports...

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?

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

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

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

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

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

I have a subform that has its Default View set to Continuous. In one of the events in the subform, I'd like to add code that will switch the view of the subform to Single. I tried Me.DefaultView = 0, but I get an error message saying, "To set this property, open the form or report in design...

I know this has got to be a simple reference problem, but I just can't figure it out. I am trying to pass a nested subform to a procedure, but I keep getting a type mismatch error. Here's an example: Call MyProcedure(Forms!MainForm.Form!Subform1.Form!Subform2) Public Sub MyProcedure(frm as...

I'm thinking about trying to do some freelance work in Access. I know a while ago, I ran across a couple of websites where people post database jobs they want done and then others bid to try to get the job, but now I can't find any. Does anyone know of any of these sites? Has anyone used them...

Can anyone tell me how to suppress the little message called "Printing" that says something like "Now Printing..."? I have tried the following, and it didn't work. The little message still pops up. DoCmd.SetWarnings False DoCmd.OutputTo acReport, "rptCommentsPrevValue"...

I have some tables that are set up as follows (these are not the actual names of the tables and fields, I'm using generic names so that I don't get a bunch of questions about the setup to begin with; I believe they are set up in the best possible way): Table1 has a one to many relationship with...