Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 111
Search took 0.01 seconds.
Search: Posts Made By: gsrajan
Forum: Forms 09-18-2019, 05:26 AM
Replies: 2
Views: 84
Posted By gsrajan
Forum: Forms 09-18-2019, 04:57 AM
Replies: 2
Views: 84
Posted By gsrajan
Populate combo box with the data from an excel column

Is it possible to get populate access combo box with the data from an excel column? Please let me know how to do that if possible. Thanks for your help.
Forum: Forms 09-04-2015, 08:54 AM
Replies: 10
Views: 650
Posted By gsrajan
Re: Auto emails from Access form

Thank you very much to all. I will try this one. I do not know how to do what pbaldy said. Please let me know when time permits.

Have a good weekend to you all.
Forum: Forms 09-04-2015, 07:49 AM
Replies: 10
Views: 650
Posted By gsrajan
Re: Auto emails from Access form

Thank you. It can be 16:00:30 or even 16:01:30 ?. Yes I will sending an attachment. A query.
Forum: Forms 09-04-2015, 06:27 AM
Replies: 10
Views: 650
Posted By gsrajan
Re: Auto emails from Access form

Yes, Minty. Access will be running.

pbaldy: I do not want this to run from Scheduled Tasks.

Thanks for your replies.
Forum: Forms 09-04-2015, 06:10 AM
Replies: 10
Views: 650
Posted By gsrajan
Auto emails from Access form

Can access send an auto email from the database at a specific day (Thursday ) and time ( 4 PM )? I have to send this email from the specific computer - without user intervention.

Thanks for...
Forum: Forms 08-26-2015, 05:13 AM
Replies: 2
Views: 443
Posted By gsrajan
Sending email when a field data is changed

I have to send an email when the data is changed in a specific field ( for example, a field data is changed from "Pending" to "Paid".

Please let me know how to do this.

Thanks for your help.
Forum: Forms 05-18-2015, 01:14 PM
Replies: 3
Views: 942
Posted By gsrajan
Re: Input Mask Starting with Specific Letter

I checked there but I do not find a solution to Start with a specific letter ( in my case A or T). Thanks for your reply.
Forum: Forms 05-18-2015, 12:54 PM
Replies: 3
Views: 942
Posted By gsrajan
Input Mask Starting with Specific Letter

Hi,

I have to add an Input Mask or force the user to enter in a specified format in a text field. The condition is, text should start with "A" or "T". The complete format is A-12345-67890...
Forum: Reports 05-01-2015, 08:13 AM
Replies: 6
Views: 656
Posted By gsrajan
Re: Page Footer in Access Report

The user wants to avoid the extra step - saving and then opening.

Thanks for the answer. I will go with this.
Forum: Reports 04-30-2015, 11:39 AM
Replies: 6
Views: 656
Posted By gsrajan
Report in PDF format

Thank you, I figured out that I need to use sub report. I have another issue. Is there any way to open an access report in pdf format? I do not want to save and then open the report.

Thank you.
Forum: Reports 04-29-2015, 05:39 AM
Replies: 6
Views: 656
Posted By gsrajan
Re: Page Footer in Access Report

Any help?

Thank you.
Forum: Reports 04-28-2015, 08:56 AM
Replies: 6
Views: 656
Posted By gsrajan
Page Footer in Access Report

Pease help me. I was able to create only 3 pages in access report. I am not able to go beyond 3 pages since the page footer is not moving down, means I am not able to drag it down.

Am I doing...
Forum: Forms 02-12-2015, 09:14 AM
Replies: 4
Views: 365
Posted By gsrajan
Re: Product Available and sold.

Thank you for your replies

Table: TblStock
Fields: ProductCode, ProductAvaiable, ProductDescription

Table: TblSales
Fields: ProductCode, Customer, SaleDate

Form: SalesForm with...
Forum: Forms 02-12-2015, 07:58 AM
Replies: 4
Views: 365
Posted By gsrajan
Product Available and sold.

I have
TblStock with fields ProductCode (String) and ProdAvailable (Number).

I have another table
TblSales with ProductCode (String).

I wish to check the record count of...
Forum: Reports 02-05-2015, 12:08 PM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

Thanks for trying. There is no error message, and not working.
Forum: Reports 02-05-2015, 11:27 AM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

debug.print rst!PatientNumber show me the patient number "AS45362"

Thank you
Forum: Reports 02-05-2015, 09:21 AM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

Thanks, I moved my code to the details section format event, not working.
Forum: Reports 02-05-2015, 09:08 AM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

Sorry, please read as they are not locked.
Forum: Reports 02-05-2015, 09:02 AM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

No they are locked pbaldy. they are not locked. allow edits is set to true. But the report's control source is another query. Is that a problem? My company wont allow me to send the DB. Sorry for...
Forum: Reports 02-05-2015, 08:02 AM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

Thank you. No, they do not have control sources with = signs.

Thanks for your help
Forum: Reports 02-05-2015, 07:54 AM
Replies: 15
Views: 826
Posted By gsrajan
Re: Unbound Text Boxes in Report

No, all 10 text boxes are unbound.
Forum: Reports 02-05-2015, 06:37 AM
Replies: 15
Views: 826
Posted By gsrajan
Unbound Text Boxes in Report

Dear Sir,

I have 10 unbound textboxes with the Tag Name "LoopID" in my report. I have to display the "PatientNumbers" field from the table tblPatient in those text boxes. Below is my code....
Forum: Reports 01-23-2015, 05:43 AM
Replies: 11
Views: 927
Posted By gsrajan
Re: Displaying data Horizontally

Thank you,

I tried. Still it shows fields from top to bottom, not left to right. I changed number of columns to 4, row spacing 1", Column spacing 0.25", Column size 1", layout Across, then...
Forum: Reports 01-22-2015, 02:19 PM
Replies: 11
Views: 927
Posted By gsrajan
Displaying data Horizontally

Hello,

My problem may be quite simple for you. I have only one bound text field in my report. By default, it shows the results (150 records ) vertically. I wish to show them horizontally, 5...
Showing results 1 to 25 of 111

 
Forum Jump



All times are GMT -8. The time now is 02:47 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