Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 98
Search took 0.44 seconds.
Search: Posts Made By: vagues0ul
Forum: Forms 10-31-2018, 09:01 AM
Replies: 2
Views: 295
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: 295
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: 351
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: 430
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: 430
Posted By vagues0ul
Forum: Forms 10-29-2018, 07:47 AM
Replies: 10
Views: 430
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: 430
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: 369
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: 273
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: 273
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: 273
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: 273
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: 748
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: 748
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: 748
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: 748
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: 748
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: 748
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: 748
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: 748
Posted By vagues0ul
Re: Search Record In A Subform

no doubt :) lucky me
Forum: Forms 10-19-2018, 07:56 AM
Replies: 28
Views: 748
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: 748
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
Forum: Forms 10-19-2018, 07:51 AM
Replies: 28
Views: 748
Posted By vagues0ul
Re: Search Record In A Subform

thanks .. going to give it a try:)
Forum: Forms 10-19-2018, 07:42 AM
Replies: 28
Views: 748
Posted By vagues0ul
Re: Search Record In A Subform

is there any alternative way rather than VBA? like query etc?
Forum: Forms 10-19-2018, 07:38 AM
Replies: 28
Views: 748
Posted By vagues0ul
Re: Search Record In A Subform

the vb code is :banghead: for me :P can you suggest if any macro code that will do the trick ?
Showing results 1 to 25 of 98

 
Forum Jump



All times are GMT -8. The time now is 11:55 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World