Search results

I'm not quite sure about what you mean. I have attached my example, could you help me take a look at it? thanks !

i managed to change the record source from those subforms where data that is from the table and it worked. But i have some forms where the subform is a query how do I change the record source of those?

Hi there, I have a form where the users can select and search for the date in the table and it will appear in the subform. I have set the start date selection to be the min date in the table and the end date to be the max date in the table. However, I am facing the problem of the subform not...

Hi There, I have an access userform that allows the users to import in their excel worksheet and it will append the data to the tables. However, now I am facing the problem of updating the table. In the case where the users have already uploaded the worksheets into access but suddenly finds an...

thanks JHB for explaining to me step by step I have another macro but there seem to be the same error of method Range of object global fail for this particular line. I have used the custom combo chart to create it I have highlighted the line in red My macro: Sub PrintingChart(xlApp) ' '...

it gives me the error of object required and it highlights the first line: ReferenceToExcel.Range("A1:D8").Select

Im not sure on how to set the reference I tried to Dim ActiveChart as chartobject and it did not work

the error that is highlighted: Range("A1:D8").Select The first line under macro

Hello, I would like to export my access data to excel which also creates a graph based on the exported data. I have recorded my macro in excel and added it to my export command button on my userform. The chart was able to be successfully created the first time i use the export command button...

Create two columns from one, based on two different WHERE clause Hello, I have created a split form where it allows the users to select the date range and it will show in the data in the table below. I need to create two new columns based on the field of Loading Quantity (kgs) Both columns...

The user form will import the excel work sheet data into the same table hence the worksheet and access table columns have to be the same. Therefore, the table would not match is the field names in the column heading. the case where in which the tables field name would not match is when a...

Hello, I need to import my excel worksheet to a specific access table. However, when a user accidentally select the wrong excel worksheet, the tables would not match. Hence, the error would prompt Run time error 2391 Field "PO" doesn't exist in destination table "Printing". which would lead the...

How do i create a command button to populate the combo box? Private Sub DyeingCommadButton_Click() Call DyeingComboBox End Sub I tried this but it did not work

Hi there, I have made a userform to allow users to import the excel file into the access table. So far i have made a combo box to select the worksheet in the workbook as well as to import it to a specific table "Dyeing". i would like the userform to prompt the user with a message box of the...

yup, i did set it to value list. But i managed to solve my question already by removing the line me.yourCombobox = "" in the code Thanks anyways :)

Hi, thanks for your code it was able to list the names of the worksheets in the combo box. However, when i click to select one of the worksheet and click on any area of the form, the selection will disappear. why is that so?

This is the code i have so far: Private Sub btnBrowse_Click() Dim diag As Office.FileDialog Dim item As Variant Set diag = Application.FileDialog(msoFileDialogFilePicker) diag.AllowMultiSelect = False diag.Title = "Please select an Excel Spreadsheet"...

Does the file dialog allow me to select which worksheet in the workbook i want to import into access? Because the current workbook that i have consist of worksheets which are the 31 days in the month on each sheet. I would like to be able to select the sheet of the day to import to access

But can the file dialog allow me to pick which worksheet i want to upload onto the workbook? Because the workbook that i have consist of worksheets that are the 31 days of the month on each sheet. i would like to be able to select the sheet of the day which i want to upload into access. This...

Hi everyone, I have created a user form to allow users to import the excel worksheet into a specific access table. However, the workbook contains multiple worksheets and i need to create a combo box to allow the users to select the specific worksheet they want to import. Is there a way for me...