Search results for query: *

I've been given a spreadsheet that looks like this: Id[tab]Type1Name[tab]Type1Amount[tab]Type2Name[tab]Type2Amount[tab]Type3Name[tab]Type3Amount 1[tab][tab][tab]A[tab][tab][tab][tab]1000[tab][tab][tab][tab][tab]B[tab][tab][tab][tab][tab]2000[tab][tab][tab][tab]C[tab][tab][tab][tab]500...

ok, i have a report with three group headers and footers(grants, loans, other). the detail shows the type of programs that fall under these catagories. what i am trying to do is underline the last record in each group. i tried to put a counter in the detail section(this worked) and then choose...

is it possible to have the legend be dynamic? jerry.

what i am trying to do is change the field name(column header name) in a select query. instead of something like this: [COLOR=red] Sum(qrySource.PreviousAmount)AS SumOfPreviousAmount [/red] i would like "SumOfPreviousAmount" to be a specific string stored in "qrySource". is...

does anyone know how to change the legend through code. i found one thread that makes reference to the Legend property but i can't seem to get it to work. not to mention that the microsoft help sucks. jerry.

perhaps i am thick in the skull but i can't figure out how to do this. in a query, i want to take a number like 037012 and replace the first two characters (03) with two other characters. help! jerry.

Here is the set up: Table 1: [p]AccountsId - AutoNumber AccountTitle - Text AccountNumber - Long Integer BeginningBalance - Currency Income - Currency Expenses - Currency Balance - Currency Table 2: [p]FamsId - Autonumber [f]AccountsId - Long Integer FamsNumber - Long Integer The two tables...

i have two tables that are joined with a One-Many relationship. with referential integrity on(Cascade Update), is it possible to delete the record on the One side and NOT delete the matching record on the Many side. jerry.

the way i have things set up has to be wrong. here's the lowdown. I have a database that manages the accounting of scholarships. The main table is set up like so: tblAccounts [p]AccountsId AccountNumber FamsNumber Account Title BeginningBalance Income Expenses Balance...

I have a data entry form and on this form there is a combo box for Yes or No. The problem is that when the combo box get the focus it displays -1 instead of Yes and 0 instead of No. Is there any way that it will only display the words "Yes" or "No"? thanks! post script...

Here's the rumpus: Two Tables: tblBudgetCode - [p]BudgetCodeId BudgetCode BudgetCodeDescription tblAccountInformation - [p]AccountId [f]BudgetCodeId AccountNumber AccountDescription Each Account has a Budget Code assigned to it. What i am trying to do is: 1...

is there a way to allow the user to add ONLY ONE record on a form based on a table. i don't want the user to see previous records or edit them. any ideas? thank! jerry.

i found this code in a thread: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Dim ShiftDown, AltDown, CtrlDown, Txt ShiftDown = (Shift And vbShiftMask) > 0 AltDown = (Shift And vbAltMask) > 0 CtrlDown = (Shift And vbCtrlMask) > 0 If CtrlDown Then Select Case KeyCode...

i have a data entry form with a sub form (single form view) based on a table. on the form i have buttons to add, save, cancel and delete records. i already have it so the navigation buttons are disabled when in "edit" mode but the user can still change records (i.e. page up/page...

i have a form that archives old records and it prompts the user to enter the dates which to archive. the records are added to a seperate table with an append query. the criteria i use in the query is: Between [Forms]![frmAuditArchive]![txtBeginningDate] And...

i have a continuous sub form with three fields per record based on a table and i would like to have the background color of the entire record change of the when it's is selected. i set the background color of each of the controls to the highlight color and then set the back style to transparent...

i have a continuous sub form with three fields per record based on a table and i would like to have the background color of the entire record change of the when it's is selected. i set the background color of each of the controls to the highlight color and then set the back style to transparent...

i am trying to make an update query that will remove a negative sign(-) from in front of a string if it is present and add a negative sign(-) to the front of the string if there is not one present. thanks. jerry.

i have an form to send email in access 2000. i am trying to populate a combo box with the reports in the database and and use it to send them as attachements. the problem is that i think the combo box is just displaying the name of the report and not referencing the report itself. if that...

i have an form to send email in access 2000. what i am trying to do is populate a list box on a pop up form with the names of the reports in my database; select a report from that list box and then move the report to a text box on the main form which is the control for sending attachements. as...