Search results

Hi, I have a form where user can choose products and bills generated. The "Billing" table contains information of individual bill i.e Bill ID 101 contains 3 products. I want when user choose the items and click update , the information from Billing table go to inventory table (i.e billno...

Hi, I downloaded this (attached)from internet and working which allowing to connect to backend but issue is that I have backend file open password. I want that I supply backend file password too using VBA and it connect. password is: "unix" I want where is connect to backend so also supply the...

Hi Pros, I have already written some sub-routines and in my each sub-routine there are two common piece of code. 1. Checking for curtains sheets from which I don't want to take data. 2. The sheet from which I want to take data should be empty of its its B2 cell. For Each ws In...

Hi, I would like to take out the second date from the excel cell as shown below in bold: 3/10/2022 Listing removed $1,225$1/sqft Source: Zillow Rental Network Premium Reporta problem 2/15/2022 Listed for rent $1,225 (+23.1%)$1/sqft Source: Zillow Rental Network Premium Reporta problem 8/13/2019...

I have excel with images in cells. When send the file to other it shows broken links as I just imbedded the excel sheet. So I have more than 150 pictures as I want any vba solution if images are linked then embed.

Hi, I am playing with ms access forms. So I created a form using Form Wizard and my form fields are bounded. So I have two buttons 1- Save 2- Cancel. I want to save the record to table is Save button is presses and don't save the record (either user entered data into the fields) if Cancel...

Hi, I have a spreadsheet and I would like to show result based on keyword matched. So I have list of all keywords in columns (column Heading will be the result if keyword matched with string). So I have about 10 keywords columns and String in a range upto 50. I would like to see the result in E...

Hi, I trying to add report to subform/subreport based on user choice and button click. The issue I am facing that the text field doesn't grow according to the data in a field. Please suggest how to set Form field grow (not report) automatically. thanks

Hi, I am wondering If I could get solution that how to show all rows where keywords are matching in 2 or more columns of a table. I am using this for one field and working well but don't know how to use for two columns. Expr1: InStr(1,[CountryName],[Forms]![Main]![txtSearch]) thanks

I am trying to delete record but getting error while clicking on cell . Code added on Sheet2: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(ActiveCell, Range("q:q")) Is Nothing Then If ActiveCell.Value = "Add to Orders List" Then rowNum =...

Hi, I am wondering about a small issue which I am facing to get the ID from a table using Function call. It is working perfectly on my other MS Access program but not on the currently attached. If you open frm_Customers and hit show button you will see it giving error Object required. Can any...

Hi, Please have a look on the attached image. I have a table which contains Already Saved Styles. I would like to update the new table with already saved Styles where by considering form1 parameters. Style Type field always blank in new table so Style will be added to new table field using...

Hi, I am trying to add the query to update Table 2 using Table 1 data but it is not working UPDATE [Table 2] SET [Table 2].Name_ = [Table1].[Name_], [Table 2].Result = [Table1].[Result] WHERE ((([Table 2].[roll no])=[Forms]![Form1]![cboRoll])); I would like to update the Table 2 fields where...

Hi, I am trying to save the reports on disk using Query records. the program works well for all records but giving error when I type parameter in query design. The below code working well for all records in query but not working when I set parameter in a query design for a field which linked...

Hi all, My access program printing the reports in pdf on local drive well. But when computer on network then some time it saves the pdf on desktop but most of the time the error occurs which is 2501. Private Sub cmdPrint_Click() Me.Form.Refresh ' my code DoCmd.SetWarnings False Dim strUserName...

Hi, I have main form with subform. I would like to show relevant record after choosing value from combo-box. The matching field type is text.

Hi, I have changed the data type of field "EmpID" from number to text and the query not working now. Any suggestion?

Hello, I have a statement written and getting problem in working when I changed the Field "EmpID" from number to Text. strSql = "SELECT *, Format(Date(),'yyyy')-Format([DoB],'yyyy') AS Age FROM tblRecallSheetStatus WHERE EmpID=" & emp_no & " ;" Set qdf =...

Hi, I would like to get your suggestion regarding the requirements as: 1. A form will be shown with all Tests required. 2. User will click on check-box to include/exclude the test in report So how can I show a form with all tests and how can I get dynamic report based on user choice? So if...

hi, is there any software to convert the .db file to excel format or access?