Search results

hi, Currently i know how to extract info from 1 table in MS Access into an excel spreadsheet. However, when i do that, Ms excel will create a new spreadsheet(page) for that table. This is a good way to differentiate tables but for me i need a different method. How do i extract the info i...

I would like to prompt the user whenever he adds a new record in my form. This form has a listbox which users must make a selection.It also has other fields that the user must enter. However, i would like to implement a prompt in the form whereby in the next Add record if the user makes the...

I have this selection form whereby users will select a specific record and open another form based on that record. However, that form has a header that contents fields that i would always "hide" . So it results in this big empty space in the header. How do i set the form size of my HEADER using...

How do i compare a value for a input field against a value in a column in a listbox. This is my code but currently nothing happens. I want to make sure drawdownamt does not exceed the listbox column 3 amount. Private Sub DrawdownAmt_BeforeUpdate(Cancel As Integer) If Me.DrawdownAmt >...

How do i blank out records in a listbox that are not selected. For example, i have selected a particular row in the listbox that has 5 rows. Access will then hide the rest of the rows while only showing the selected row?

How do i change the highlight colour of the listbox? Whenever i did some testing with printing, the selected row would always be printed in total black(however the words would be white in my computer screen). I am able to change the background colours of the listbox but currently im not sure how...

Here is my code, please ignore the first line of the code( the btnUndocommit) Private Sub Form_Current() Me!btnUndoCommit.Enabled = False If Me.OpenArgs = "Edit" Then Me.Label49.Caption = "something" End Sub I want to add in more....statements. For example: If Me.OpenArgs =...

I have a form called addcommitmentdetail which comprises of three parts; main form,subform,subsubform. The mainform is just to select a foreign key value from a listbox(which is still stored as a value in the record), while the subform and subsubform are to add records that will be related to...

Hi, I have a problem with access that i hope you can solve. Whenever i type a number with a decimal(1.20) or enter a number less than 1, access always rounds up the number and does not allow any decimals. How do i solve this problem? (i already tried configuring the decimal places in the...

hi, I have a textbox that has a control source of my listbox. My listbox has two columns: Lender Id and Lender name and my bound column is 1. The control source is LENDERIDFK and its datatype is number so if i set the bound column to 2 it will give an error.So now do i display the...

Hi, How do i requery a listbox that is contained inside a subform? Listfacility is a listbox in main form while the listlender is a listbox in subform. This is my current code: [Forms]! [ListFacility].[Form]! [ListLender].Requery

Hi, Is there anyway i can set a code in order to allow users to expand columns in a listbox?

Hi, Currently i have a listbox that has 9 columns. I want to cut it down so im intending to have two listboxes. First list box displays BorrowerID and then after making a selection the second listbox will display the child records that borrower has, which are the contact parties. Borrower...

Ok, so here is my code for the validation of my form : Private Sub AvailablePeriodEnd_BeforeUpdate(Cancel As Integer) If [AvailablePeriodStart] > [AvailablePeriodEnd] Then MsgBox ("You have entered a date wrongly") Me!AvailablePeriodEnd = "" End If End Sub However the code in red gives me an...

Hi, I currently have a select form where users select a record based on BorrowerTitle, FacilityName,CommitmentID using a single listbox and then clicking a button to open the selected record in edit mode. This has caused a problem as BorrowerTitle and TitleAgreement can have many...

Hi, I have a edit section in my database that has a listbox that displays records by clicking on a button. I use the following code to excecute the command: DoCmd.OpenForm "Formname", , , _ "[tblname].[fieldname]=" & "'" & Me.typelistnamehere.Column(0) & "'" 'Close the dialog box DoCmd.Close...

Hi, So my form has three combo boxes named TypeSecurity,Location,ProjectType. I want to disable projectype in the form unless the user selects two specific values in the other combo boxes which are "Property" in TypeSecurity and "Local" in Location. Only if they select these options then the...

Hi, How do i put a PrimaryKey Value i selected in a listbox(Listbox contains records in form 1) in form 2 and put it in a field in a form 2? I have two tables : addnewborrower(One) and documents(Many) and they have a one to many relationship. I arldy established the relationship in the...

Hi, I am having trouble opening a form and editing a record based on the record i selected from my listbox. I have tried two codes and both failed..ill just state the codes here: 1st code: DoCmd.OpenForm "AddNewBorrower", , , _ "[tblBorrowerDetails.BorrowerSerialNo]=" &...

Hi, What is the best code to use in order to save the record and quit the form? I have a main menu so i will save,quit this form and go to main form I have this code: Private Sub testingsaveok_Click() If Me.Dirty Then Me.Dirty = False DoCmd.OpenForm "BorrowerSection", acNormal DoCmd.Close...