Search results

Scratch that last part, we went over that, i forgot an earlier XLSX, I fixed. Only the first part I have a problem with:)

Finally had a chance to get back to you. I am still unsure how to make the Continous look like a Datasheet (which is important, seeing as you have to be able to easily sort data etc), and the other problem I have, is the error I get when opening the exported Excel sheet. Excel cannot open the...

Hmm how would I go about formatting it properly? As you can see it has to look like a datasheet otherwise it will get very...messy!

I have tried both the zip and raw, no luck. I have added it to dropbox however. Not sure, but do I need your email or does this clipboard link work? https://www.dropbox.com/s/eh8gtggb2f6p2sb/Database.accdb

Hmm i'm getting a Your submission could not be processed because a security token was missing. If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error. The dummy is around 46k KB in compressed state, and im not sure...

Sure, ill see if I can get one uploaded quickly before I leave from work.

Can't get it to show up if I do it this way, since I can't put it in the 'detail' section of the design view. If I try to put it under Form Header or Form footer, it just refuses to show up, not sure if it's being hidden behind the form or what. If it's confusing I can link some screenshots of...

You are a genius, thank you! Now I just need to figure out how to create an individual button for the subforms... If I create a button in design view for one of the sub_forms, it replicates this button for all the other sub_forms under the main navigation form. If it makes sense?

A compact and repair fixed the crash issue, but not the validation / corruption issue. Here is the code (it is Excel 2010) Option Compare Database Private Sub Command508_Click() DoCmd.OutputTo acOutputForm, "Products", acFormatXLS, "J:\Backup\toTheDocument.xlsx" End Sub

Silly question, now that i've created the button and attempt to click it, my database seems to crash every time (Not responding). The excel is imported to the specified folder, but is corrupted (probably because of the crash to Access I would assume?) Is this merely because of a slow CPU you...

I am merely going to the navigation form which I want to export and Export to Excel Spreadsheet, as I would do in any other table. However when used via the navigation forms, this does not work.

I have decided to move away from Switchboard in Access 2010, to what I find to be more user-friendly; the Navigation Forms. However, when I attempt to export any of the data from my navigation forms, the result is a blank Excel sheet. I can easily go into the forms themselves on the left...

Forgive me being confused. This is what I have done: Option Compare Database Private Sub Form_Resize() NavigationButton120.Width = InsideWidth - NavigationButton120.Left - 60 NavigationButton120.Height = InsideHeight - NavigationButton120.Top - 60 End Sub Under the sub-form control code...

Sorry for the long answering time, I was on vacation:) Yes, my navigation control consists of a number of buttons, some which have sub-buttons. Some do not. I want to change all of this for, f.ex. a navigation button called 'Archives', which dates back several years, where you would need to...

If you mean the original form, that will show up in the navigation control, then it will not show up as a datasheet in the navigation control, which is kind of problematic, as it does not give a very good view of things at all.

Sorry for the long time answering, I was on vacation. Where would I do this boblarson? This is a navigation control form, not a normal form, and there is no default view as if it was a normal form?

I am not completely sure what you mean pr2-eugin. I mean what sort of sub form would I place in the original form that would sort it out?

Just an update, I assume I was wrong in doing it this way. As I just received runtime error 2100. Does this mean I managed to change the width, heigh of the Navigation buttons themselves and not the subforms in the navigation form?

Option Compare Database Private Sub Form_Resize() NavigationButton116.Width = InsideWidth - NavigationButton116.Left - 60 NavigationButton116.Height = InsideHeight - NavigationButton116.Top - 60 NavigationButton112.Width = InsideWidth - NavigationButton112.Left - 60...

Alright I just read your reply and I will try this. Same code name but repeated for every subform name I assume.