Recent content by VelvetVoice

Here is a copy of the query design, report design and the macro. As you can see, it is referencing the Activity table when it doesn't need to. These blank forms do not need to be dated. I'm not sure why the designer put that in there.

I posted a snapshot of the table. The table in question has a list of items, and there are little plus signs where the primary key designation usually is. Like when you look at Windows Explorer, and clicking on those little plus signs opens the folder to show what is in them. It shows the...

What is the function of subtables? I tried looking for definitions in the help portion of Access, but it is not there. Is there some kind of manual where I can find the definitions? How are they created? Incidentally, I added the cost center numbers to one of the other tables for another...

Hello! I'm having some trouble recreating forms and reports. I have an Access database that was built 15 years ago, and I was trying to copy and paste tables from the test environment to production. However, one of the key tables has subtables, and the subtables will not copy over. There are...

Thanks! Will do.

Got it. Here's my solution: SELECT IIf([MSysObjects].[Type]=1,'TABLE', IIf([MSysObjects].[Type]=5,'QUERY', IIf([MSysObjects].[Type]=-32768,'FORM', IIf([MSysObjects].[Type]=-32764,'REPORT', IIf([MSysObjects].[Type]=-32766,'MACRO', IIf([MSysObjects].[Type]=-32761,'MODULE'...

Hi! How do I print a list of tables, reports, forms, modules? I was looking at another forum and it gave me an SQL of how to do it, but I wasn't sure where to put it.

Great! That worked! Thanks a million. I'm going to keep this link in my Favorites box so I have a reference. This stuff will all come back to me soon, just getting a kick or two.

Option Compare Database 'Use database order for string comparisons Option Explicit Private Sub cmdexit_Click() On Error Resume Next DoCmd.Close A_FORM, "Report: Par List" If Err <> 0 Then Call errorhandler(4, "Report: Par List.cmdexit_click", "Report: Par List") End If End Sub Private Sub...

When I press the Run button, it automatically prints the report. I'd like to just see the results and not print. I have a copy of the database, so I can try different things without breaking the original.

Hi, I'm new here. I just got a job, and I am trying to recall Access knowledge from 20 years ago. I need to impress the resident systems guru, so try to help me out. Thanks!

This database was designed about 15 years ago, and we just converted it to Access 2007. There are embedded Print Report directions in here, but I don't know how to get to them. I already tried following backwards on the autoprint thread, but it didn't work. :confused: Can anyone help me?