Search results

If at all possible, can you please help me build a crosstab query? That would be the best solution to my issue...just not sure how to accomplish it. Thanks.

Thank you for your reply. What I am looking for is a "Status Page" for display of information only. I want this to be a dynamic page, so when a new Company is added, it automatically displays. Can you please throw a quick example of how you would go about this? I will tailor it to my...

I have run into similar instances in the past. In more than one of these instances, it was due to not compiling the code before the accdb->accde conversion. Just thought I would throw that out there.

I have a table that has multiple related tables. I am trying to display (in a from) the total record count of all related tables per record in the main table, but I do not know how to build the query...or if I should be using VBA. For example suppose: tblCompany -CompanyID (PK)...

I am running 2007. I was getting a user defined variable type error. I just set the vars as variant and it works fine now. Thanks for the help!!

@the_net_2.0 I just typed that all in and got an error. Then I saw the line that said VBA 5.3 or earlier needed. I am running 6.5. Any other ideas? @vbaInet The standard tool bar gives you the line you are on, not the total number of lines in the project including modules. Unless you know...

Anyone know how to see the total number of lines of code in an Access 2007 database? I have tried CountLines() and ContOfLines() (with and without a leading '?') in the immediate window, but it errors, "Compile error: Expected: =" Any ideas?

Bob- I know it has been a while since you posted the db above, but I am hoping you are still subscribed to this thread. I downloaded it, but when I try to open it I get an error, "Unrecognized file format." I am running Access 2007. Any ideas? Also, what is the benefit of storing/using...

And as usual, you have saved the day! Thank you for all of the help you give us on this forum!!

I am trying to refresh one form from another. I have a table (tblZ) and two forms, frmA and frmB. frmA has a command button (cmdA), an unbound list box (lstA) and a subform (sbfA). The AfterUpdate property of lstA refreshes sbfA. The OnClick property of cmdA opens frmB. frmB is a modal pop...

Unfortunately no...or I should say not yet.

I checked that. All users are set to full control. I am currently having some issues with then number of connections my computer will allow. The BE is on a external HDD on my computer and others are connecting to it. We are getting errors that say the maximum number of connections has been...

Bob- I am having the same issue. I have split my database. The BE resides on a network drive. I have it linked by the network path, not drive letter. The FE for users is an accde, while I maintain the only accdb FE. I have your Auto Updater installed (an excellent tool, by the way -- I use it...

Of course!

For those who are interested, here is the final fix to this issue: Dim db as DAO.Database Dim rst as DAO.Recordset Dim var as String Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * FROM tblSubReport WHERE tblSubReport.ReportID = " & [Forms]![frmReport].[ReportID] & ";" ...

You, sir, are a genius! Thank you so much for your help!!

You were right. It is an autonumber. It works now. Thank you! Now, any idea how I can get it to show in a text box on the main form?

Also, do you have any insight how I can get the results to show in a text box on the main form? I have the text box and it already fills with info from the main form...all of this is just to get the subreport results to append to what I alrady have.

I tried your suggestion, but I still get the same error, but telling me expected 1.

Bob- This thread has kind of bled into another I have open. Can you please have a look at the thread at: http://www.access-programmers.co.uk/forums/showthread.php?t=215091? Thank you, sir.