Search results

Hello all, I have a database with five forms, named A to E. I want to display custom shortcut menu 1 in forms A, B and C and shortcut menu 2 in forms D and E. I was wondering where should I define the menus, in the "On load" event of each form or somewhere else? Cheers PS: I am asking this...

Thanks. I am still having trouble to format the Excel once it is created. Do you know how can I adapt this code that you shared to modify my Excel?

Works great now, thanks!

This is the code I have at the moment: Private Sub ExportOverview_Click() On Error GoTo SubError DoCmd.OutputTo acOutputReport, "EventSummary", acFormatXLS, "\\path\Events archive\" & [Event] & ".xls" MsgBox "File exported succesfully", vbInformation + vbOKOnly, "Export success"...

Hello all, I am getting started with exports using VBA and I am having trouble finding documentation "for beginners" where it explains step by step how to export a report to Excel and how to format it, as the default Export that Access offers does not fit the needs of my project. More...

I have tried these but the problem is that the data I import is already structured into the 3 columns PersonID, PersonName and JobName -and cannot be done in any other way-, so I don't see how to "convert" the list of JobNames to a table with the correct properties that you list above. That's...

Hello all, I have created a table called PersonTable with 3 fields: PersonID (primary key), PersonName and JobName. I have set the JobName field to indexed (duplicates OK) and now I need to enable the user to write, through a Form, attributes for each JobName. These attributes are Industry and...

So if I manage to have the data that will be updated in another Access file or SQL Server instead of Excel, I should be able to query it and work with it in my database?

So then what use case is the "linked table" import option intended for? Thanks

Apologies :)

Hi, this would be it :)

Yes sorry, just saw it. I am not entirely sure it is what I am trying... Let me show you an example because maybe I didn't explain it correctly or I didn't understand what you explain in the link. This is my imported from Excel table - it is a linked table so it has no primary key: ID Name...

So it is not possible to show each item with the 6 attributes in the same form? It is important because the user needs to see the imported information in order to fill the new attributes. Thanks again

Hi Pbaldy, I get an error message saying the file has been permanently moved

Hello, I am very new to Access and I am not sure if this makes any sense but I am just going to explain it to see if you can help me. I have to import an Excel sheet to Access. As this sheet is continuously modified, I imported it using the "Linked tables" option. This table contains items that...