Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jazminecat23
  • Content: Threads
  • Order by date
  1. jazminecat23

    Change Form Caption based on where it's opened from

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

    Mail Merge Word to Excel missing columns?

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

    use IF in qry when count is >1

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

    Merge Excel --> word. Multiple records

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

    Excel Cell References not working

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

    Custom input mask?

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

    open form to selected record on subform

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

    Filter form

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

    query conflict - throws error on update form

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

    Print current record only

    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"...
  11. jazminecat23

    Change values on change in text box

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

    Textbox based on IIF

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

    Excel - password prompt on open

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

    Link Access Front end to adp?

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

    Run Page setup in Excel and close setup window

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

    Create Legal Document w/ line numbers

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

    Join type makes query fail

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

    Paste fields end up sideways!?

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

    Insert automatic date?

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

    Unselect copied sheets before close

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

Part and Inventory Search

Back
Top