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...
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.
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...
in my form i have 2 bound fields OrderDate (Date Field) , and the reserved days (Integer field). now i want to make an unbound field where i can perform the check and show the remaining reserved days , comparing with the current date and reserved days. here is the example for better...
i have writen this code for On Delete event of my form, which is a child continous form, and this code suppose to delete the record when the del key is pressed.
well problem is when i press " NO " at the moment when the message appears and ask the confirmation for deletion then this...
Hi, i have a wroksheet and i want to export it in the text format file, with the fixed position and length in the
text file.
My worksheet contain. 2 parts of information. Clients and Inventory. every cleint have a unique number. and every product have a unique code.
In the text file i want to...
I have writen this code for the " child form " in my order main form, for on delete event , this code work fine,
problem is when choosing " No option " at the time of
execution then the delete process stops successfuly. but
other buttons on my main form stop...
we have windows 2000 professional server operating system, as a server, and users have different version of windows.
I have split my Access database b/w FrontEnd and Backend.
BackEnd database is on the server , and all the LAN users having the copy of the FrontEnd installed on there computers...
i have split my database b/w front and back ends.
back end is on server , and copy of the front end is
installed to all the users individually. now the problem,
i have created a shortcut to user desktop, and they can execute the front end which is linked to a backend on the server. and every...
I have create a function, in my module. and i'm Calling this function in a report by using a macro, in the menu which i have designed for my report.
now what this code is doing. when this code runs it change one of the field value to true in the table name as "order".
and then it...
Hi,
I want to delete records in my subform "which is bound to a table name as OrderDetails" using the Del key.
i have writen code for on delete event for my sub form where my code will check the product code and orderID in the table name as as "Reserved", if record found...
i try to explain my problem,
i have 4 tables , first two tables name as 1) InvoiceMaster
2) InvoiceDetail,
the other 2 name as 3) ReturnMaster 4) ReturnDetail
in first 2 tables i store the information about product sold from stock,
and in last 2 tables i store data about the products which...
I have a difficulties with Dlookup here is my syntax,
=DLookUp("[sellinHP]";"SellinHPFinder";"([ProductID]= Reports!SellInReport!ProductID)")
Note: SellinHp is the field i'm looking in the SellinHPfinder query, Product ID is the key to match the record...
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.