Search results

Currently I manually export a query result to an Excel file. I would like to create a button that is clicked to generate an excel file with the query result. How could I start with?

Currently the starting director is c:\Documents. I would like to change to other one. Is there any variable of OpenDlg to set this parameter or elsewhere? :confused: Your advice is appreciated. Thanks! Private Sub cmdBrowse_Click() On Error GoTo Err_Handler Dim OpenDlg As New...

I would like to create an approval column in a spreadsheet that contains holiday applications. My initial idea is to have a locked column with password protected. However, it has more than one person to approve for different sections. Any idea to accomplish this requirement? Thanks!

I had upgraded my Samsung ATIV Smart PC Pro 700T to Windows 10 successfully and the touch pad on keyboard was working correctly. Yesterday, I reset the pc and the pointer was working briefly at the beginning and then the touch pad malfunctioned. Can someone advise me how to fix this issue. Thanks!

I need to export a query in Access to an Excel file but discovered that the number field became text field. All numbers are stored in text (General & wrap text). It causes further calculation incorrect. How can I prevent it from Access? Thanks!

I have a formula, =VLOOKUP("*"&TEXT($A5;"000000")&"*";Vlookup!$A$2:$O$1405;4;FALSE) and would like to drag the lower corner of the cell to the right columns. How can I make the "4" to automatically add 1 for next cell? Thanks!

I have two columns getting the values from other worksheet. On other column, I have a simple sum function, such as =sum(P3,Q3). When the P3 is 0.01600046 and Q3 is blank, the output is 0.00000. Can someone advise the possible error for this scenario. Thanks!

I have a table consisting multi items in two fields and looking for a way to break them into individual records. They look something like following example. Co A 123456, 234567 AM12345, BM12345 JB Co B 345678, 456789 CM45678, DM738738 KL Co C 567890...

Can the consolidate function be used with more than 2 columns. I would like to have the results with other relevant columns, not just the column to determine duplicates and other one with values to be summed up. If so, your guidance pls.

I have following calculated field in a query and returned with an error. I double checked the syntax and found nothing wrong. Did I overlook something? You help is appreciated.:confused: BattCheck: IIf([NoofBatt]<1 Or [R-NoofBatt] <1,"No","Yes") The expression you entered contains invalid...

I would like to remove the old duplicates leaving distinct list with the latest info. Can someone help advise the way to accomplish it. sample file is attached for reference. Thanks!

I have two spreadsheets: A sheet contains sku no, unit price and other details of each sku no and B sheet contains sku nos and order quantities of last month. I need to get the details of skus from sheet A into matching skus in sheet B for further analysis. Can someone advise me how to...

I have a validation rule in a control of form: between 1 and 999999. Now I need to have different criteria subject to the value of other control, say between 1 and 9999999 if the value of A company in company control. Is it beyond the capability of validation rule? If so, any other idea to...

I tried to check if all required fields have been filled before saving the record using the following code. Private Sub txtReportNo_BeforeUpdate(Cancel As Integer) If IsNull(Me.cboMainCat) Then Cancel = True MsgBox ("Please enter Data for Main Cat")...

Currently I am using a multiple select list box in a form to select the engineer names for a report. I am looking for some enhancement. Firstly when I do not select any name, there is no records displayed. I need to show all records if I do not select any name in the dropdown list. I...

I have a parameter query using a form to collect the data. I put LIKE and wildcard enclosing the parameter to bypass the criteria if the data box is empty. It works well. I have another parameter of date type that uses between two dates. How can I bypass the criteria if I leave the data...

I have a table of database containing all the model related information. The model field in the table may consist of one or more model nos (same product but with different brand and model no, such as: 123456 234567, 345678 456789, 567890, 234567 Now I received a list of orders that contains...

I would like to create a command button on the header of a form. The button should perform a toggle switch: click once to activate the task and click it again returning original state. I can create the command button to perform a task but do not know how to return to original state. The...

I have an unbound control in data input form requiring to input a 6-digit number. I have put a validation rule restricting more than 6 digits. Most users prefer to enter, say 123 and the system can help enter the 3 leading zero for them. Any idea to accomplish it? Thanks!

I would like to enter a couple of alphanumeric groups into a field on an input form. After I enter an alphanumeric group, I hit the enter and the data will add into the field and refresh to empty box ready for next entry. If I continue to enter another group and hit enter, the next group will...