Search results

Hello, I have a table (OwnershipT) that has a list of ProductID and OwnerID among other fields. Both ProductID and OwnerID are foreign keys to the tables with their details. A product can be owned by different Owners and vice versa, but each pair OwnerID-ProductID is unique - no duplicates...

Hello all, I have a giant procedure that exports a set of queries from access to excel and formats the excel sheet. A lot of code parts are repeated several times throughout the code and I would like to know if someone could explain how to take these bits out and call them somehow like if they...

Hello all, I have a table where I register the configuration of different elements for various events. The fields of this table are: "ElementName", "Configuration" and "Event". Field "Event" is a lookup to a table where I also have a date field. I have a form where I show the user the Event and...

Hello all, I was wondering if someone could help me with this one: I am exporting some queries to Excel using CopyFromRecordset and as I need them to be one under the other, I would like to know if there is a way to keep count of the row number, maybe with a loop or something similar. I cannot...

Hello, I have a report with few columns but plenty of rows and I would like to display it in two columns. When I choose the format in "Page setup" it applies it only to the printable view, but I would like to know if it is possible to have it always displayed in two columns (in report view or...

Hello, I am trying to compare the value of a set of cells (rows 85 to 200 of column 5), so that if they have the same value the cells get merged. I have tried this code but it doesn't work. This is part of a code that exports some queries using CopyFromRecordest, so this loop is inside the...

Hello, I was wondering if someone could give me a hint on this one. I have created a sample db to exemplify my doubt better. So I have a table "Clothes" and a table "Materials" and a third table where it is specified what materials compose each garment. I wanted to know if there is a way to...

Hi, I wanted to ask if there is a way that I could export this crosstab query (Thread on crosstab query) to Excel using VBA along with some attributes of each index and depending on the Event (using a parameter). Thanks

Hello everyone, I have created a query in the sample database that I would like to look like the table in the picture. Taking index 135 in Event A as an example, in the query there are two lines for this combination, one with a cross in type "Welcome" and one in type "Wedding". Is there any...

Hello, I am getting started with Ribbon XML because I would like to create a custom one for one of the frontend files of my Access 2016 app. I would like to show only certain commands (so it really isn't creating the ribbon from scratch), but I can't use the default hide/show options because...

Hello everyone, I designed a database with plenty of forms and reports and when it was finished, I decided to split it. At first I did all of this in my computer but then I decided to move both the backend file (that contains only tables) and the frontend to a shared folder in the network. I...

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...

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...

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...

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...