thx PHV
=Me!listbox1.Column(1, 0) ' didn't work out.
at this point i like to be in details. actually i wanted to get the value from the listbox using VB Code but i never succeed so i decided to drop this idea and get the value out from the listbox and store it to text box and then use it for...
Thx Remou for your reply, you are right, but i still didn't get the value. as i understand untill the list box is not selected or not get focused, i'll not get the value in my text box field automaticaly, i'm still looking for the solution.
Hi,
I have an unbound Listbox based on a calculated query as row source, i can see the data in my listbox but when i try to get this data to one of my unbound text box field i get null value. here is the example.
List box data:
Customer_ID Balance
1100 -4993,22
now i want to have...
i have applied the following code to solve my task but i didn't get the results. my problem is that i'm trying to print information of Group footer right after the Detail section but in one condition that if the group footer size is more then the size left in page right after the Detail section...
Thanks Smuckers for your detail explanation i really appreciate it, today i'm going to work with your solution and let you know the results.
Once again thank you very much for spending your crucial time on my question and i'm sure that your explanation will going to put me on right track...
Please help me to solve the error in my code i have a problem with initializing the loop. please give me some advise thanks in advance.
My problem is, that i want to export data from Access into my Excel worksheet.
where first 3 columns in my Worksheet will contain the Product No, Product Code...
Please check this code i have a problem with initializing the loop in my code. please give me some advise thanks in advance.
My problem is, that i want to export data from Access into my Excel worksheet using organized format, where Product Code and Name Of product will be trasfered vertically...
Hi,
My problem is related with the RecordSet.
i want to retrieve data from my table for specified period using some parameters, like
1) stock number
2) product number,
3) and between some user define period.
At the starting part of my code every veriable is defined.
R - is a Recordset...
my problems is that now when i receive my email using Outlook Express i found attachments with my emails are disable, but if i use microsoft outlook i can see these attachments enable and can easily open these files. i have been using Outlook Express since last 6 months and every thing was...
Is it possible to automatically insert some information in the subject field of the e-mail from the report.
I'm sending the report and i want to show the order number and the client name automatically inserted to the subject of my e-mail from the report,
i'm sending this report using macro...
I have windows 2000 server, every thing was wroking fine but today our server is working very slow, and i check the task manager, and found that the file Inetinfo.exe is taking 98% of CPU process, our network is working very slow.
how to solve this problem.
Give name to your subforms like child1 , child2 ...
suppose you have main form were client ID field is the same as client ID field in child1, you can easily linked both of them now if u want to link your child1 form with the child2, then in the child2 form properties you need to mention the...
Hi WildHare , well i like both of your suggestions, i guess that you have been experienced with the basball advise, and got a gun shoot in return and luckily you are alive my congratulation. but i'm not brave enough like u to go for your first suggestion, but i do prefer the second one by...
my problem is that, if One copy of my Front-end database is running then how to deny another copy to be opened and show message that program is already running.
some time user working on the Front-end database, they open another copy of the same front-end to work on different functions of my...
Hi,
Has anyone tried to use MS Access as Front end on SQL server BackEnd Database? I would like to know more about it.
Can any one redirect me to some usefull links or give me
some advice about whether this is a good idea ore not.
i have started seriously thinking to convert my Access Backend...
Hi friends i have solved my task by doing the following.
i have declare the variable in the "On Current" event of my form, and perform the check. here is the code.
note: tmleft is the variable to hold the value which i have declare in my "On Current" event.
tmleft =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.