Search results for query: *

Setting the value to 'Yes' or 'No' worked. Thanks

Using VBA in MS Access trying to prefill a pdf form...stumped on how to programmatically fill a check box..Question: Using VBA in MS Access trying to prefill a pdf form... I have the following code to prefill if it is text box, stuck on how to check or uncheck a check box based on a field...

Using VBA in MS Access trying to prefill a pdf form... I have the following code to prefill if it is text box, stuck on how to check or uncheck a check box based on a field value. Dim AcroApp As Acrobat.CAcroApp Dim pdDoc As Acrobat.CAcroPDDoc Dim fcount As Long Dim sFieldName As String Dim...

Sorry for the confusion, a) I need to design a survey form, part of it will have fields being populated from the access database, other part will have fields that user will manually enter then will need to be read into the database again. I am not sure I am going in the right approach, would...

In word form, how to copy the field name labels and bookmarks to various child records.. I have a word form eg with a Supplier information and different products the supplier supplied A supplier might supply one or more products. Rather than having #1, #2, #3, #4 sections for different...

to be able to use some of adobe plugins and library.. like aforaut 2.0 library and acrobat.tlb from acrobat 6 My program is referencing both the files mentioned in vba - so would the user need to have professional or is standard version enough to be able to use that vba program. Please suggest

Thanks.

have a text controls on adobe form to capture time entry with format 'h:MM tt' Getting the 'value entered does not match the format of the field' error while entering - eg '08' How to be able to enter time like 08:05 AM or 12:45 PM etc. What format the text box needs to be.

our form is created in adobe acrobat 9 professional. This form will be sent to couple of users who need to fill and information needs to be saved. Later the information from the form will be read into a file - that is the ultimate task. But what steps are needed after the form creation for...

is there a way to open a same word document generated from template and update it..Question: is there a way to open a same word document generated from template and update it.. That is to open a word template with some auto populated information from the database and some of the information...

Yes, that was it. Thank you.

Thanks! yes, that was it.

...columns tblOngoing_casemgr and tblActive_casemgr The above mentioned columns are covered in below line. 'xlWks.Cells(1, iCol) Like "tblOngoing*" Or xlWks.Cells(1, iCol) Like "tblActive*" Dim iCol As Integer For iCol = 1 To xlWkb.ActiveSheet.UsedRange.Columns.count If...

...is what I have Dim iCol As Integer For iCol = 1 To xlWkb.ActiveSheet.UsedRange.Columns.count If xlWks.Cells(1, iCol) Like "tblOngoing*" Or xlWks.Cells(1, iCol) Like "tblActive*" Or xlWks.Cells(1, iCol) = "New" Or xlWks.Cells(1, iCol) = "Active" Or xlWks.Cells(1, iCol) = "Ongoing"...

...Dim cell As range, DeleteRange As range For Each cell In Intersect(ActiveSheet.Rows(1), ActiveSheet.UsedRange) If cell Like "tblOngoing*" Or cell Like "tblActive*" Or cell = "New" Or cell = "Active" Or cell = "Ongoing" Then If DeleteRange Is Nothing Then...

...manager process section. Not able to figure out - what is wrong letting the excel still hang and not completely close out. here is the code. ******** Public Sub Format_Report(whichquery As String) Dim oapp As Object Dim xlWkb As Object Dim xlWks As Object Dim iLastRow As Integer Dim...

This is regarding a program that displays important dates from access db in monthly outlook calendar format. I have some important date deadlines and descriptive items of those that should be displayed in the month calendar format. (grid). I have my table with the data to be displayed that has...

parse a string with years month and days.... -------------------------------------------------------------------------------- Solution to parse the strings below and get number of months 1) 10 years 5 months 5 days - Should give 5 2) 6 years 10 months 22 days - Should give 10

That is the requirement, the user wants to see the other categories(all the selections even if zero). Thanks Any advices on this.

...a given date range lists entries to display the total and categorize them into various application types and Outcomes Current report style lists ********** eg if it list 40 as total count. Access - 35 Outcomes Prevention 20 Mediation 15 sub total - 35 Return - 5 Prevention - 5 sub total -...