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...

Hi, i have tried the code and i have encountered error '3464'....i have check the expressions and i cant find any error in the spelling...here is your code modified with my tables: Private Sub ListBorrowerRD_BeforeUpdate(Cancel As Integer) Dim Resp As Integer If DCount("BorrowerSerialNoFK"...

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...

Because the user wants to see the header section of the form when in ADD mode...but does not want to see the header in EDIT mode .

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...

Sorry i meant 4th column....not 3rd column. But i still cant find a solution...my 4th column is a number but it still doesnt work.

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 >...

Yea but i think for me its better to use the listbox. However your second example is quite confusing....is there any other method? I cant seem to find the solution yet

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 =...

sorry but speakers86 do you have any solutions?

yes sry for the late reply the form that is the edit form is called SelectEditCommitment

Alright. But i havent figured out how do it yet. Its in the add commitment edit section under the button " edit commitment". What i want to do is display some of the facilitysubform and lendersubsubform fields (not all fields) in datasheet view. I tried created a new show record button that...

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...

Edit: Thanks it works. Also, i have another problem that i hope you can solve. There are two textboxes that refer to the same listbox in order to calculate interest rate. Textbox1 calculate listboxvalue+lenderate. Textbox2 calculate listboxvalue+screenrate. How do i like.....enable 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...

Thx it worked its just that the nameofsubformcontrol or something related to control always confuses me.

Hi, My code still does not work. I dont really need to refer to any control so i just eliminated that part. Please help! The code is: Forms!DrawdownLenderCommitmentsubform.Form.ListLender.Requery