Search results

I am still getting this runtime error 424. This is how my code looks : Option Compare Database Private Sub Form_Resize() NavigationButton116.Width = InsideWidth - NavigationButton116.Left - 60 NavigationButton116.Height = InsideHeight - NavigationButton116.Top - 60 End Sub I...

I am still getting the runtime error 424 - object required. I have put the options compare database in and it looks like this now: Option Compare Database Private Sub Form_Resize() Markets.Width = InsideWidth - Markets.Left - 60 Markets.Height = InsideHeight - Markets.Top - 60...

I get a runtime error 424 when attempting to use this code :( Here is my code for my forms (this is for one). Private Sub Form_Resize() Markets.Width = InsideWidth - Markets.Left - 60 Markets.Height = InsideHeight - Markets.Top - 60 End Sub Does it make a different I have not...

There will be alot of users using this database, so the screen sizes will vary alot. The display works ok on my computer on the original form itself, but in the navigation form (the subform of the original form), the subform is too wide and there the scrollbar is too far on the right.

Would I not need to open the form in Form view and not datasheet view, if that was to sort it out? If I place the button in the Form header and view it in datasheet mode, it does not show up, but it does in Form view. I need it to show up in datasheet view however.

Should the code look like this then? Option Compare Database Private Sub Form_Resize() yoursubformname.Width = InsideWidth - yoursubformname.Left - 60 yoursubformname.Height = InsideHeight - yoursubformname.Top - 60 End Sub

Makes perfect sense. However much I try it though, it does not show up on Form View (the button that is). I can try and link a picture to show you what I mean.

I can't seem to find the form resize. Is this under the properties of the original form or under the navigation tab?

As to the second question, I would like to be able to have a button for each tab, so that I can separately export the forms, not all the forms at the same time. That is what I meant.

I am working in Access 2010, and in my original forms, the vertical scroll bar works as intended. However when I use the navigation tabs, the user has to use the horizontal scroll bar to scroll over to find the vertical scroll bar, which can seem confusing. I have attempted to find a fix in...

I finally managed to get (part of it) working, thank you! The export part now works, however I have a small question. Using the innate export button, there is the option of getting the document to open after the operation is complete automatically. Is it possible to code this in? My second...

Here is a very, very dummy version of the database, let me know if it will do.

There is nothing in the folder. And yes it's possible, but it seems like it is too big to upload (maximum is only 2 MB)? (pretty sure even a zipped version would be too big) How do I create a dummy version?

Wow this is frustrating. I have added the filename to the code, and nothing happens, still. In regards to the button appearing in all tabs, I have selected the Products tab before creating the button (under design view). Yet it still shows up on the other tabs. Am I creating the button...

I am probably making a mess of something, but I cannot seem to see what...

Private Sub exportBtn_Click() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Products", "J:\Backup\" End Sub This is what my "test code" on my button looks like. However when I click it under my navigation form, nothing happens, whatsoever. Should I put it under the...

I apologize for struggling with something that should probably be very simple. I have not made any queries in my database, only forms. I have now created the exportBtn button, and added the code behind it you pasted. When you post the table or query name, is it the name of the Form i should...

Bear over with me and consider me an access rookie :) Would I create a button running a query? The link you sent me to is fairly confusing to me.

Hi pr2-eugin, as mentioned I am pretty new to databases and Access and most of what I do is trial and error and Google :) How do I go about exporting the Query rather than the Form? As it seems the navigation Form can't be exported. (This is me attempting to make exporting for the users of the...

Thank you anyways, I hope someone else will come along. And yes, I believe they are something that have been added to 2010. I just havent found a solution online for it. I used to run a switchboard in 2007 where you could macro around it, but with navigation forms I don't know.