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 Chriss Miller 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: *

  1. ptpaton

    Access 2007 runtime being blocked?

    Great. So they provide a product that works on only simple databases, and if any complexity is present in the code at all, it crashes. Way to go, Microsoft. Should have known better than to believe MS would put out a "free product". -Patrick Nine times out of ten, the simplest solution is...
  2. ptpaton

    Access 2007 runtime being blocked?

    I'm having the same problem. I've determined so far that as soon as any VBA code runs, the error appears. Error trapping doesn't help at all, either. I'm researching the problem also. -Patrick Nine times out of ten, the simplest solution is the best one.
  3. ptpaton

    DoCmd ?

    Kermit, you are a trouble maker! j/k :) -Patrick Nine times out of ten, the simplest solution is the best one.
  4. ptpaton

    DoCmd ?

    Glad to help Kermit! -Patrick Nine times out of ten, the simplest solution is the best one.
  5. ptpaton

    DoCmd ?

    Try Me.[tblCoilTracking subform].Form!CTDate Also, make sure that CTDate and DRDate are the actual field names? If the text boxes and the field names are the same, you can also run into problems. Name the fields one thing, and add txt to the start of the name for the control names. So CTDate...
  6. ptpaton

    ComboBox to update subform.

    Aximboy, You can run queries to maniuplate data on the subform, and then perform requeries, but it's really better to get into VBA to starting updating subforms. What specifically are you looking to do? -Patrick Nine times out of ten, the simplest solution is the best one.
  7. ptpaton

    DoCmd ?

    Kermit, In design view of the mail form, select View>Code. Make sure the only code you've entered is OnUpdate of the date field on the mail form. Then, make sure there's no code running on the sub form by designing the sub form and selecting view code. If that's not it, try formatting the...
  8. ptpaton

    Combo box

    Ahhhh. I see, then lupin is correct. If you want to see the other field, add another text box bound to that field? Otherwise you have to combine the fields in the builder as lupin suggested. -Patrick Nine times out of ten, the simplest solution is the best one.
  9. ptpaton

    DoCmd ?

    I've been developing for 10 years now, and here's how it breaks down: 90% is self taught from experimenting, trial and error, resolving error codes, and digging through MS help. 5% is from google and awesome boards like this one. 5% is outright theviery from you good people. Thank goodness...
  10. ptpaton

    Combo box

    Whoa...hang on Brogrim. ZmrAbdulla is correct, you can have as many columns in the combo box visible as you'd like, once you drop down on it. Make sure you have 2 or 3 in the number of columns, the column widths are appropriately wide enough, and the size of list is big enough to accomodate...
  11. ptpaton

    Saving form recordset data to text file.

    Kraeg, What I would do is put a command button on the form. OnClick of the button, you can do a couple of things. 1. You can create a simple select query that's limited to your form's recordset and export it using the DoCmd.TransferText command or 2. You can create a recordset, set it to...
  12. ptpaton

    Combo Box_Opening Subform

    A subform is usually imbedded in a main form, and opens with the main form, so I'm not really sure what you're trying to do, but you could open the form as a dialog or normal form with any of the action properties of the combo box. Have you thought about something like DoCmd.OpenForm on the...
  13. ptpaton

    Appending to New Record, Not to Same Record

    StarScream I think there are two issues you need to think about: 1. If you want multiple records to appear on one form you need either continuous forms or you can base a list box on a table, and set the record source equal to tblYourTabl!Note That will give you a list of all the notes. 2. To...
  14. ptpaton

    Access date formats

    If possible, always save data in a table unformatted. It's best to format only where the end user sees the data. In a blank column in your query, type this into the field box. Date: Format([DateField],"mm/dd/yy") This will format your datefield to short date. -Patrick Nine times out of...
  15. ptpaton

    Access date formats

    Format(DateField,"mm/dd/yyyy") -Patrick Nine times out of ten, the simplest solution is the best one.
  16. ptpaton

    Updating data in a subform

    Randy, It sounds like you might want to take a look at your table structure. Typically, if you're using a main form / sub form, you have two tables. The main for is based on the master table, and the subform is based on the second table. The main table has one instace of ListID, and the...
  17. ptpaton

    Move to a record on a continuous form based on a value of a column

    BSMan, PHV's code shoud work perfectly. Here's almost the exact same code I use to perform exactly what you're talking about. I have buttons on my form for first, next, and prev. All you have to do is change the .FindFirst statement below to either .FindNext or .FindPrev Also, pay close...
  18. ptpaton

    Automation between Word and Access

    dkellygb, Another option you could consider is inserting database fields into your Word templates, with the bookmark name something memorable. You may then refer to those bookmarks through VBA with the FormFields() property: Where objWordDocument is set as the active document...
  19. ptpaton

    Access 2000 - Calculation on a report

    Are you doing this calculation on a form or report? If it's a report, you can use sorting and grouping to separate company employees from non-employees. That way, you can get totals for each group as well as the total attendees. Also, if it is a report, you may want to repost in the Access...
  20. ptpaton

    How can i search two or third feilds in the same table with a querry

    You can use a union query to combine the two fields into one. Then, in a second select query, join on the merged fields and search it. Union queries have to be written in SQL...you can't use the query builder for it. Lookup help on SQL specific queries in Access Help...it should be able to...

Part and Inventory Search

Back
Top