Search results for query: *

This code in SQL Developer will return via dbmc_output to screen . What I need is the return into a data result set so can display in tablix DECLARE max_length INTEGER; BEGIN -- loop through column names in all_tab_columns for a given table FOR t IN (SELECT table_name, data_type...

Is there a way to setup different security rights within Acrobat for fill in forms. Example: If password entered is xyz then users have rights to fill in fields 1-10 If password = abc then users have rights to edit fields 11-20 If password = jkm then user has rights to edit all fields

Thanks Thank will work fine

I have a report that page breaks by group In this example I have 3 groups Group 1 contains 9 records Group 2 contains 15 records Group 3 contains 20 records Each page can handle up to 40 records When page 1 prints for group 1 I need the report to print the 9 records and then also print another...

use convert(datetime, expression, 103)

I need to populate a 3rd column on a table for the 1st 2 columns I have the following dataset Date Percent 1/1/09 .065 1/1/10 .038 2/15/11 .0222 3/12/12 .068 In a header row in the table I have the starting value of 500.00 (reportitems!txtstartingvalue.value) The running total...

Works Great Thanks

I have a form with 2 combo boxes on it ComboBox1 hase 3 items: A, B & C ComboBox2 sourcequery should change based on the answer to ComboBox1 case ComboBox1 = A then ComboBox2 source = query1 4 columns case ComboBox1 = B then ComboBox2 source = query2 6 columns case ComboBox1 = C then...

I appear to have resolved this issue. Before the Save command add line "On Error Resume Next" 'Save Record On Error Resume Next DoCmd.RunCommand acCmdSave

I have a main form with 2 sub-forms A & B Both sub-forms display the contents of the same row in the same table juts with different layouts SubFormA shows fields 1-5 while SubFormB shows fields 6-10 Data in B is updated manually and automatically based on inputs in A. The problem occurs when...

Worked like a charm. Thanks

afterupdate 1st combobox setfocus to 2nd combobox docmd.2ndComboBoxName.requery

I have a main form with 2 sub-forms Contents of SubFormA are based on the MainForm Even though SubFormB is also on the MainForm I need it's contents to link to SubFormA not the MainForm i.e. MainForm SubFormA links up to MainForm SubFormB links up to SubFormA

UGHHHH!!!! I'm an idiot

I have a sub-form with 5 fields named A-E I have a combo box on the form named cmbSortBy with options for A-E Currently trying to use a case select for restablishing the sort order on afterupdate Select Case Me.cmbSortBy Case "A" Me.OrderBy = "A" Me.OrderBy = True...

I have exploered that avenue. Can't seem to get that option. Thanks for the suggestion though.

I have the follow example continous form Row Name Color Age 1 Bob Blue 18 2 Tom Green 20 3 Dave Orange 25 4 Cindy Blue 17 The goal is to lock the age field just on row 3 because the color = orange Private Sub txtColor_AfterUpdate() Age...