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

    Query looking for certain word in a field

    Your awesome, thanks.
  2. demax182

    Query looking for certain word in a field

    I'm not familiar with SQL yet, but if I need to learn it to get this done I'll have no choice. I have a table that is in horrible shape, there's no uniformity whatsoever, but it's what I have to work with, so please don't slam me for having a bad database design. I didn't create it, it's an...
  3. demax182

    Relationships after the fact

    I'm not trying to make a many to many relationship actually. For example, A1, A2, A3, A4, etc... B1, B2, B3, B4 etc... "A" is the contract number and "1" is the Task Order. Just want to make sure that the person does not input a duplicate task order for the same contract number. Damn, I'm...
  4. demax182

    Relationships after the fact

    Sorry, made it a bit confusing, let me use the real names of the tables. We have contracts here called IDIQ contracts usually with a number in this type of format: N62836-11235. Now IDIQ contracts have task orders. N62836-00001 can have Task Orders 1,2,3,4,5,6,etc... Now N62836-00002 can...
  5. demax182

    Relationships after the fact

    Hi, A little problem, I made a table (TblKid) that has a field Contract# and a field TaskOrder#. For each Contract#, there are many TaskOrder#'s. So now I want to create a new table (TblDad) with a field Contract# with additional info such as Contractor, Point of Contact, Phone Number...
  6. demax182

    Multiple entries in a field

    PHV, Thank you for the reply, but I don't know what you mean by foreign keys. Here's a more detailed explanation of my situation, any help with designing my database is greatly appreciated. I have tblBuilding which contains building data (Building#, Size, Age, etc...). I have tblContract...
  7. demax182

    Multiple entries in a field

    HELLO motivated ACCESS programmers! I'm not sure if this can be done, but can multiple entries be entered in a single field. Here's the scenario, a table/form that keeps track of roofing contracts. However, while many contracts correspond to fixing only the roof on one building, there are...
  8. demax182

    Calculations in reports

    Thanks lupins46! Your suggestion worked, why didn't I think of that? Now I can rest in peace.
  9. demax182

    Calculations in reports

    Hi, I've been at this problem for too long and I've tried just about everything. Here's my problem, I have a report based on a table. I have several fields in my table, but I will point out just two that I've been having problems with. One field is to record the cost (in yen currency) and the...
  10. demax182

    Multiple Page Reports

    I'm trying to create a new report, but I'm running into a problem. The "Details" section of my report can only hold about 3 pages. I'm not looking to split up my pages using sorting and grouping, as it won't work that way. I have a page 1, page 2, page 3, page 4, and so on. Thank you for...
  11. demax182

    Report in Microsoft Word Format

    Is there any way of putting all the data that you have in tables and putting in a Microsoft Word Document? I already have a report template, but it's a word document. I usually copy the word document and paste it into the report (design view) then move around the fields so that they fit in the...
  12. demax182

    Unique records based on 2 fields

    Ok, maybe I'm confusing myself with my wording. What you said in the latter is what I want to do. If there's an A1, then a B1, C1, D1, etc... would be feasible still. And if there's an A1, then A2, A3, A4, and etc... would be feasible as well. If there's only one letter to a number, that...
  13. demax182

    Unique records based on 2 fields

    Forgive my lack of knowledge, but how do I go about doing that?
  14. demax182

    Unique records based on 2 fields

    This may be simple or this may not be possible to do. Here's an example: I have a field called [Letter] and a field called [Number] in one table. I want to ensure that for every [Letter], there's only one [Number] and vice versa. The user may do [Letter] = A and [Number] = 1 for one record...
  15. demax182

    Positioning a label based on an "if" statement

    Hi, What is the code to position an object in a report. For example, if field1 = false then label1's left position = 5" and top position = 4". If true then the label will be positioned in another location. Is there a way of doing this? Thanks in advance.
  16. demax182

    Excel Format Reports

    Not sure if I should post this message under forms forum or report forum. Is there a way to get the data you have inputted into Access into an Excel spreadsheet? Generate a report in Excel format (I don't mean saving the report in Excel format)? For example, Field 1 gets inputted into cell...
  17. demax182

    Required Field in Subform

    I have a main form and a subform. I have a field that is required to have a value in the subform. However, when I want to create a new record on a new form, I get an error message saying that the required field in the subform cannot be null. I think the problem is, when I try to create a...
  18. demax182

    Unbound Controls for Calculation

    I have an unbound control in my form that calculates the subtotal for items (quantity * price = subtotal) for an order #. I'm trying to make another unbound control that calculates the entire cost of that order# (sum of subtotal = grandtotal). Is it possible to have calculations on one unbound...
  19. demax182

    input mask help

    Thanks! Anyway of setting a prefix before the number?
  20. demax182

    input mask help

    Presently, I have no data, I'm still building. It would be nice if the system does generate the next number. Makes my database that much more user friendly. Thanks.

Part and Inventory Search

Back
Top