Search results for query: *

Hi all - how do i reference the button and form location which opens a particular form? I have a form NameDataEntry which can be opened from 3 different places on my database. Depending on where it's opened from, I want to change certain characteristics of the form, mainly it's caption and...

Hi - I am doing a mailmerge from excel to word, and when I go to insert the merge fields, it doesn't show all the columns in my worksheet. I have cleared and reset the print area, rearranged the columns, copied the data in to a NEW workbook, and even renamed the area I wanted (and it didn't...

Hello all - I have a query I use to populate a subform. This subform lists all charges against a client, by case. Currently, if one case has multiple charges, it lists them each individually. What I would like it to do is this - if there is only one charge on the case, list the chargetype...

Hi, I have a data set with names and charges. Some names have many charges, some names have one charge. I need to send out a word document to each name listing their charges. Can anyone tell me how to do a merge and have it create one document per person, listing all of that person's charges...

Hi all - I have what should be a simple problem. I need three cells in a row to have the same reference - =BudgetStatus!G4 They were working fine until I had to go in and make changes. Now, if I go into any of them, when I exit the cell, instead of showing the value in =BudgetStatus!G4 they...

hi all, I need to auto number the records my users enter into a form. i've created it as a text field, but can change that if I need to. I need them to follow the following format YY = last 2 digits of the current year MM = two digit month nnnn = auto numbering starting at 0001 at the...

hi all - I have a form with a subform on it in datasheet view that lists the charges against a person. I need to open the ChargesDetail form based on what record is selected on the subform. This subform is on a tab. I have the button on the tab as well, just below the subform. When I click...

Hi all - I have a form I'm trying to filter. Seems simple, right? Here's my code: Private Sub Form_Load() Me.Filter = Not VENDOR_NUM = 0 Me.FilterOn = True End Sub and every time, it throws me an error. "one or more operators in the filter is invalid." *sigh* All I want is to show the...

Hi all - I have a form in an adp, based on a view (query). The form loads fine. The view pulls all records from my table where the status = 0, which are those records where the vendor number <1. On the form, the user will be entering a vendor number. When the user enters the vendor number...

Hi all - I have a form with a simple print button on it. I want the button to open my report only with the current record. here's my code: Private Sub PrintRecord_Click() On Error GoTo Err_PrintRecord_Click Dim stDocName As String stDocName = "VendorRequestReport"...

Hi all - this is so basic, and I know I knew how to do it at one time, I'm embarrassed to post it here, but here goes. I have a form with 3 fields I want to work together. Vendor_Num, Status, and Status2. When the user changes Vendor_Num from the default value of 0 to anything else, I want...

I have a report based on the following query: SELECT Tbl_suppl_main.reqType, Tbl_suppl_main.supplID, Rights.[Unit ID], Rights.Department, Rights.Division, Tbl_suppl_main.Fund, Tbl_suppl_main.Attachment, Tbl_suppl_main.CostCntr, Tbl_suppl_main.Originator, Tbl_suppl_main.Name_Request...

Hi guys - i have a user with a spreadsheet that is on a shared drive. She is the owner. When she opens the spreadsheet, it prompts her for a password. When anyone else opens it, it doesn't prompt them, and only opens Read-only. I didn't set this up for her, but she wants to do another one...

Hi all - I have to create a front end for an adp that links to a sql server db. When I create my access db, I try to do the usual File--> Get External Data --> Link tables, navigate to my adp, and try to link to the table I want. Access says I can only do that between access dbs. So, how...

Hi all -- I have an Excel Spreadsheet that creates a bunch of other spreadsheets and saves them off every month. This all happens with a button click. It works fabulously, thanks in large part to the help I've gotten here. I now have requests from end users to setup the document print...

Hi all - has anyone had success creating a report with the line numbering down the side that legal documents require? I'm working on a system for a law office that needs this. Thanks.

Hi all - I have a strange situation. I have a db that someone else built with a whole slew of queries in it. The user needed to add a text box to all of the reports (dozens) to indicate what period they cover. So she made a single record table where she inputs the period information into one...

I'm trying to paste my form fields from one form into another, and when I do, they always end up rotated 90 degrees - they're sideways on the page. The page has the same orientation as the original. Can anyone tell me why this is happening and how to fix it? I'm using acrobat 6.0 Pro. Thank...

Hi Everyone! Is there a way to insert a date field that updates automagically in a pagemaker document? I have a document that has a lot of dates at the top, in different formats. I'd like to automatically update the year in those dates to be last year (this is our annual report). I would do...

Hi all - I have a procedure that copies some workbooks into a new spreadsheet and saves that spreadsheet for me. When I then open the saved sheet, all of the sheets are selected. I'd like to unselect the sheets before the save executes. Should I just select sheet1 cell a1? Or is there...