Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 101
Search took 0.63 seconds.
Search: Posts Made By: vagues0ul
Forum: Forms 12-19-2018, 09:30 PM
Replies: 1
Views: 374
Posted By vagues0ul
Combo Box Not filtering Results

i have a combobox on the form and it has multiple values. But when i enter some text which is already in combo box, it does not fiter the result and display error instead.

The text you entered...
Forum: Forms 12-18-2018, 05:41 AM
Replies: 2
Views: 213
Posted By vagues0ul
Re: Change Linked Fields String/s

sub cboBox_Afterupdate()
txtBox = cboBox.column(1) 'actually col 2
end sub
[/QUOTE]

Thanks for your answer. I dont want the textbox to be filled based on a combo. The student tables is linked...
Forum: Forms 12-17-2018, 06:50 AM
Replies: 2
Views: 213
Posted By vagues0ul
Change Linked Fields String/s

I have a form that is based on a query which is taking data from three forms. I need a button on the form that that change the value of a field depending on the value of a dropdown box on the form....
Forum: Forms 10-31-2018, 09:01 AM
Replies: 2
Views: 397
Posted By vagues0ul
Re: One To many Record Update

that are a lot of changes :banghead::p
Forum: Forms 10-31-2018, 08:31 AM
Replies: 2
Views: 397
Posted By vagues0ul
One To many Record Update

I have a db in which i want to apply a fee module to specific class. The task i am trying to achieve is to add fee to a class and all the students in that class will have that fee in their account. ...
Forum: Forms 10-30-2018, 12:03 AM
Replies: 2
Views: 469
Posted By vagues0ul
SMS Module In Access

I want to have a form in access which detects the GSM phone attached to the pc and send sps to selected entry in the databse. I dont want to use any sms sending website as the sms will be sent...
Forum: Forms 10-29-2018, 09:00 AM
Replies: 10
Views: 616
Posted By vagues0ul
Re: save data from two forms into one table

yes batchid has number datatype. currently i am interested in saving the record in another form. kindly guide the process to save data from these fields to another form. thanks
Forum: Forms 10-29-2018, 08:26 AM
Replies: 10
Views: 616
Posted By vagues0ul
Forum: Forms 10-29-2018, 07:47 AM
Replies: 10
Views: 616
Posted By vagues0ul
Re: save data from two forms into one table

yes the tables are linked and they are on a form. i want the save button to submit the data into table3 with the values present on the form (that is created by inserting values of table1 and table2)
Forum: Forms 10-29-2018, 06:54 AM
Replies: 10
Views: 616
Posted By vagues0ul
save data from two forms into one table

I have two tables TABLE1 & TABLE2. Each have different elements. I have created a from with values from these two forms and want to store the data into another form. How to achieve it ?

Table1 =...
Forum: Forms 10-27-2018, 08:31 AM
Replies: 1
Views: 546
Posted By vagues0ul
Multiply Value To Number of Days

I want to achieve a task of multiplying a number to specific number of days based on criteria.

If the current date is more than required date. then multiply a specific value to those number of...
Forum: Forms 10-27-2018, 08:18 AM
Replies: 11
Views: 281
Posted By vagues0ul
Re: Adding Data To Subform With Same ID

yes i did notice but can you explain why cliednt it is needed there instead of agent id ?:confused:
Forum: Forms 10-22-2018, 02:12 AM
Replies: 11
Views: 281
Posted By vagues0ul
Re: Adding Data To Subform With Same ID

THANKS A LOT :) :) you are a life saver as always
Forum: Forms 10-21-2018, 05:49 PM
Replies: 11
Views: 281
Posted By vagues0ul
Re: Adding Data To Subform With Same ID

1: The Agent table store agent related data.
2: Passenger_Details table is storing passengers data that are related to specific agent
3: One agent can have many passengers but they need to be on...
Forum: Forms 10-21-2018, 09:27 AM
Replies: 11
Views: 281
Posted By vagues0ul
Adding Data To Subform With Same ID

i want to add record to a subform through another popup form but the id should remain same. I am attaching the db along with the post in which the agent and client tables are in relationship and i...
Forum: Forms 10-21-2018, 06:15 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

the records only contain single non duplicate value. so it will work for me . thanks for suggestion.
Forum: Forms 10-20-2018, 10:18 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

thanks to all senior membes who also helped me. i have also learned about using the vb in code and found two vb codes to make app better.. Thanks you ALL
Forum: Forms 10-20-2018, 10:16 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

worked like a charm :) :) :) your comment is a life save .. had to ammed a bit but it worked. THanks a million <3
attaching the ammended macro pic
Forum: Forms 10-19-2018, 09:36 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

i have attached the db so you can have better idea. the form AGENT is where i have subform and search button.
Forum: Forms 10-19-2018, 09:00 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

MsgBox "Your Subformvalue is :" & Me.cntPassDetails.Form!sect
SECT is on main form not on subform..
Forum: Forms 10-19-2018, 08:44 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

still the same error. here is the updated code
="Passenger_Name = '" & [Forms]![Agent]![cntPassDetails].[Form]![sect] & "'"


am i doing it wrong somewhere?
Forum: Forms 10-19-2018, 08:24 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

Before trying the cuddly monster i have given a try to macro and now getting type mismatch error

="[CGS] = '" & [Forms]![Agent]![Passenger_Details].[Form]![sect] & "'"


CGS is of type text...
Forum: Forms 10-19-2018, 08:17 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

no doubt :) lucky me
Forum: Forms 10-19-2018, 07:56 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

i tried a trick with combobox and changed the subform master field to combobox name. now the records are filtering.

but i need them to filter through textbox. so is there any trick like the...
Forum: Forms 10-19-2018, 07:54 AM
Replies: 28
Views: 985
Posted By vagues0ul
Re: Search Record In A Subform

its only referring to controls on forms. how to use these when searching through textbox and button on main form :/ the monster (vb) is biting me :P
Showing results 1 to 25 of 101

 
Forum Jump



All times are GMT -8. The time now is 02:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World