Search results for query: *

I have created a text box so a user can enter in the number of a project, then click a cmd button that opens a form and displays that project. I would like to place the same code on the txt box so that the user could alternatively just enter the number and hit the enter key and launch the code...

I am trying to update a textbox on a report with data from a table that is not part of record source for the report. I am trying to get the sum of the field "admin_amount" from the table "tblAdminAllowance", then pass the result to a text box "txtAdminSum" on the...

I am trying to create a record in a many table from a form. user creates a new record in the one table via a form, then I want them to be able to open a new form so they can enter the details for that table. problem is that I need to create a record in the many table before I send them to...

I am doing a vlook up, but the formula is displayed not the result??? Everything is formatted as text, save the file as a 97/2000/2002 excel file. I am working in 2002 I have other formulas on the same sheet that work fine. What's up? Thanks, Ron

I am trying to sum two different fields and then add them to a table. the form has a one, and a sub, many side I want to take the value of textbox1 from the main form, and sum it with the value from textbox2 on the subform, then have an event that updates textbox3 on the main form, thus...

Access xp report Is there a way to set the detail section as landscape, and the group header section as portrait? Or is it all one or the other? I am trying to combine a portrait formatted letter (correspondence) and a couple of sub reports that need to be formatted as landscape. thanks, ron

I need to send approximately 600 letters with 1 to 6 detail sheets per letter. Question is: Is it possible to bring the letter into the report that prints the detail sheets below a page break and then group so that the print job will print the letter, then the detail sheets for that letter...

Okay, ere it goes, I have 3 Access XP database applications that serve a section of the company. They all contain and have information about and from, the companies main database which is a Sysbase product. I have set my applications with normalized tables, unfortunately, the main database...

Access 2000, I am trying to record the users name and date when they make a change to a memo field. The rub is that the memo field may contain many instances of changes, and I want to keep all of them for a running record. So what I think I need to do is first save the users entry, then...

www.straxx.com provides an xla file that you load into add ins (Excel) that removes exisiting passwords. Works well. Usually takes it about 30 seconds to remove the password. I can't seem to get it to work on shared workbooks though. Ron

access 2002, tblAddBook (1) To tblContacts (many) add_id Primary key add_id foreign key referential integrity with cascade I have a main form (frmAssignContactToProject) that allows users to enter a new person, then on the subform (datasource is tblContacts) they can add many...

I am a vba newbie, I currently have an access 2000 database. A form displays about 3000 records, in an effort to provide a user with smaller views of the data, I have a option group tied to a macro that applys filters. The filters are queries. In an effort to make it faster and simpler, I...

I am trying to create a moving funding line, if the amount in column N6:N387 is greater than $737,844,644 I want the row to be underlined. First I am getting a mismatch error, I think due to the currency, secondly, how do I get this to loop down the column and keep evaluating till the...

I have a form with a subform, the user creates a new record on the main form, How can I evaluate if they have made a selection from the subform so if they fail to make the subform selection, I can prevent the save, and prompt user to make the selection with a msgbox? I just need a nudge in...

VBA newbie, using Access 2000, Trying to tie a cmdbutton to a list box, the user selects which report they want to run from a list box, then clicks a cmnd button to launch the report, OR they will click another cmd button to launch a pdf. I keep getting an error when the if is true...

when entering any formula into a cell, press enter, and the cell displays the formula as if it were text, it does not calculate. I went to options and everything looks correct, auto calculate, no protection set, etc. anyone have any experience with this? excel 2000 Ron

I have a transaction table with an average of 5 rows per unique project. I would like to find the most recent date for all projects. The result needs to return one row for each unique project, with that row being the last entry of the set. Help, Ron

I would like to diable all shortcut menus from an application so the user can't get in through a back door. I have worked out how to disable the main menu, but not the shortcuts. Does anyone know what the shortcut menu object name is or of any way to disable this menu from an application...

Excell 2000 Is there a way to remove the main menu from Excel?

I searched, but could not find mention of this problem, (I remember it was discussed previously) I have the tab order correct on my form, but when a user scrolls down the form and selects a subform which is on a tab control, the form jumps on the screen. (Not so that the selected area is out of...