Search results

@Gasman already told you how. I don't usually export reports to Excel; but when I did, I don't remember not seeing the header also exported. Do you have a complicated header? Does it have images?

The launch Excel bit is not necessary, because the OutputTo method has an argument to automatically open the new file after it is created; just set that argument to True. DoCmd.OutputTo acOutputReport, strReportName, acFormatXLS, strFilePath, True

Hi. Welcome to AWF!

@DHookom had the same idea (re: minimal height). Glad we could assist. Good luck with your project!

Have you tried the opposite? Make the subforms really small/narrow and set Can Grow to Yes.

It's hard to say if you should use a bound form in this case or not. Typically, you should use a bound form when you can if the data on that form are stored in a table. If you didn't want the user to edit the data, you could make the form read only. As you already know, to use an unbound form...

Glad to hear you got it sorted out. Good luck with your project.

=DateSerial(Year(Date()),1,1) =Date()

Based on the title of your thread, are you trying to do this using CF? If so, the answer would be "it depends." What is setting the colour of control B? If it's another set of CF, then you can try to use the same conditions on control A.

You can use a script or third party app to set the trusted location in the registry.

That's unfortunate. But to determine the actual cause of the problem, the first part of my question was to verify if SSMA works with regular (not converted) ACCDB files first. Otherwise, I don't think we can be certain if the problem is your MDB file or your install of SSMA. Luckily, even if you...

Just a guess but does the wizard work with ACCDBs? If so, maybe try converting the MDB to ACCDB first.

Welcome back!

Hi. Welcome to AWF!

Please let us know how it goes. Good luck!

No, I meant one of the four (4) queries you said you would have to constantly update if the ID didn't start with 1.

If you don't mind, can you show us the SQL statement for one of those queries that has the ID field value that needs to stay at 1? Thanks!

Depending on what you're actually doing, I think the main idea is: if the C&R doesn't require you to reestablish table relationships, then wouldn't it be a simpler approach than the reset query? In other words, compare the following two approaches: Reset Query Steps Delete Table Relationship...

Hi. Did you try the last file I posted? If so, you'll see I didn't use that code. And as I also said in my last post, I don't think that code approach may not always work in some cases. For example, I deleted some records, and the code didn't work as expected anymore.

As @MajP was trying to say, the Autonumber field should restart at 1 if you empty the table and do a C&R before appending the new records.