Search results
-
H
When Exporting a table to a Sharepoint list, all primary keys are converted to autonr
Hi, I'm attempting to move all the data (Tables) in sharepoint for team colaboration and data centralization. Everytime I'm attempting to export a table, sharepoint automatically resets the primary key to AutoNumber. Because I already have a ton of data in these tables, I certanly need the... -
H
search for records based on multiple criteria from multipe search boxes
I am trying to create a form that allows you to return results based on multiple criteria. I have FirstName field, LastName field, and State Field. I also have text boxes named searchFirst, searchLast, searchState where users can input criteria. How do I build the filter so that it takes the... -
H
When Filtering Form and no results are returned. Handle the search box gracefully
Cannot believe how many hours I spent on this. I have a form that displays some data. I have a textbox that filters the form data after each key press. It seems like VBA just cannot gracefully move on with its life if the Me.Filter returns 0 results. This error happens because this form is... -
H
Matrix Crosstab query based on checkboxes with multiple values
I searched online but I'm not sure if I need to create 3 separate cosstab queries and then somehow join them. I'm trying to achieve a report that will show a percentage of 3 criteria (checkboxes) based on month. I'm following some tutorials but I'm unable to add 3 values in one crosstab query... -
H
Autogenerate incremented number based on number of records and add a prefix
I'd like to improve the data entry for a form so that fewer mistakes are made when entering this number. I have two tables. One is Projects the other is ProjectActivites One Project can have multiple activities. I have a form that shows a Project and in that form I have a subform that shows...