Search results for query: *

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...

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

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...

excel program when run second time from MS Access - fails giving object failed or method global row failed etc different error each time while stepping through code... I think the cause is because of instance of excel is still seen in task manager process section. Not able to figure out - what...

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

I have a query that groups by 2 fieds application type and outcome. There are only 2 application type = "Access" and "Return" Where as the Outcomes are many.( Prevention, mediation, Attysecured, Withdrawn, Unfounded ) For a given date range lists entries to display the total and categorize...

Hi I have a small database with 4 tables that I am using for the current problem. The tables are call, parents, mailman, orders. Call and parents are related by the call ID (a primary key in the Call table.). Mailman and orders are related by a Unique Id (a primary key in the mailman table.)...

Hi, I have two tables tblsub and tblun they have a common field name 'filename'. I am trying to delte records in tblsub, if a record with filename is not found in tblun. Tried different ways but still getting error. Thanks in advance

I am trying to compare two records from two tables. Tblu and tblsub and create a table tblunion with matched records. Both the tables have a common field 'filename'. Can some one give me the example of the code. Thanks alot.

I have a question I have a table1 and table2 . Table1 has the field 'trandate', right now table2 is empty without any data in it. I am trying to read and loop through all the records in recordset and then transfer it to table2. Here is my code. I am missing something. Please help me very...

Hi, I have this function in a module and use the command button of a form to call the function. Though I hard coded the DSN to the database belonging the SQL Sever, still prompts me for a user to select the DSN, how could I avoid it. I am breaking my heads. Please any advice. The DSN already...

How can I tell how many times the database has been opened.Does any one has idea how to do this. Thanks in advance.

Hi, I am looking for a method that i can hard code a program to refresh the links to their appropriate DSN the backend being the SQL server. Instead of going to the users desktops each time when a change is made to the database and then refreshing the links through tools and then add-ins and...

I have a 'Company' table The primary key of company table is 'CIK" Company table has fields 'Type_Org' 'Sec_region' 'state_code' They should be first grouped by region, and then by state and number of records should be calculated from each state and withing the state they may belong to...

I have a form which has a command button 'send email' and contains the code needed to send email with report as an attachment (rtf format), to a list of chosen people by the database user. the process goes on this way. First the user chooses the list of users the email has to be sent, the list...