Search results

  1. A

    I don't undertstand why top works bottom don't

    Hi Bob: Now that the query works as it should. I plan on putting a button on the the work order form to allow mechanics to check on the fly, the work order history of the unit they are about to work on. The main reason for this is to limit the duplication of recently done work. With four...
  2. A

    I don't undertstand why top works bottom don't

    Nice! My knees get a little weak, but I am not afrad. I'll have to share that in the next staff meeting I am in. John.
  3. A

    I don't undertstand why top works bottom don't

    Hi David: You really know how to ask the right questions. The query works exactly right now. I guess my only answer is that when want to make something work and don't know why it wont, I look at something that does and then try to make a working copy by modeling something that works withe the...
  4. A

    I don't undertstand why top works bottom don't

    Hi David: Y'all the man. Your suggestion worked. Just one thing, Now I get a prompt for RadioUnit, another prompt for Enter Radio Unit then the date prompts. Just wondering how to remove the 1st prompt. It workd but double prompts might confuse me mechanics.. Again, thanks 2U, its alive..
  5. A

    I don't undertstand why top works bottom don't

    Thanks Bob: I'll make the change. John.
  6. A

    I don't undertstand why top works bottom don't

    Thanks David, I'll give it a try.. John.
  7. A

    I don't undertstand why top works bottom don't

    Can anyone help me understand and fix? works right, prompts for vendor number then prompts for start date and end date PARAMETERS [Vendor#] IEEEDouble; SELECT VENDORS.[VENDOR#], VENDORS.[COMPANY NAME], [t_PO-actions].ActionDate, [t_PO-actions].Desc, [t_PO-actions].Amt, [t_PO-actions].[Posted...
  8. A

    The things I don't know, Newbie question

    Thanks Dave I went looking and then remembered add I did. It seems to work. Could it be causing the problem or does it look ok? Private Sub Command64_Click() DoCmd.OpenReport "r_vendor", acViewPreview, , "[id] = " & Me.ID End Sub Private Sub Form_BeforeUpdate(Cancel As Integer)...
  9. A

    The things I don't know, Newbie question

    I am using Access 2007, I split the data base on 09/15/10, I am not sure when i noticed the problem the first time. But I've seen it enough to know that the data is actually updating. I think the message could be from spliting the data. I've been using the DB full speed for about 3 months. the...
  10. A

    The things I don't know, Newbie question

    I have a DB with tables which get updated from a form. I have been getting a message (since I split the data base, I think) When updating/ exiting the form. "You cant't save this record at this time" coe100710fe may have encountered an error while trying to save this record. If you close this...
  11. A

    Emailing report in Access 2007

    A date range prompt is used in my reports that are sent to print preview screen where I can save them as pdf files that can be emailed. The report I email the most is the closed workorders for police and fire vehicles. When I save the current vehicle workorder I am asked if I want to Overwrite...
  12. A

    Help access newbie

    I am so simple. I guess if I want to see records then the date range should include data from the range after the Y/n date field started being populated. New guy can make some really simple mistakes. pardon my tunnel vision, it's wider than I thought.
  13. A

    Help access newbie

    Weel Bob: Thanks.. 1st time it didn't work so I looke at page layout again all margins were .25 t,b,l,r I dragged to 10" page now prints without error message. In my tunnel vision i didn't notice that the posted date does,t show. I con't understand. both dates are in the subtable po...
  14. A

    Help access newbie

    Thanks Bob, I' give thsi a try..
  15. A

    Help access newbie

    Must be I am learning something I knew the answer to this one. Now for one I am struggling with. "The section width is greater than the page width and there are no iterms in the additional space, so some pages may be blank." I have gone into the design view of the report, I have limited the...
  16. A

    Question Split data base

    Thanks for the detail Bob. I changed to text box then changed field type to text and put default value in place and as soon as replaced the - with a . the data I need populates the field Now if I can get the address to to work this will be a done deal.. John.
  17. A

    Question Split data base

    Thanks Bob: I read the link you sent for the 1st time. I guess I still have a lot to learn. Access must be a good program. Even though I do things the wrong way the program still works pretty well. I'll try and make any future projects free of any table level, look up fields. Any Idea's on...
  18. A

    Acess 2010 - outlook for consulting

    Companies like to keep current, but I think that means opening a 2003 db in 2007. Adjusting to the "NEW" and then saving as 2007 and the cycle repeats it's self.
  19. A

    Question Split data base

    I was learning how to use A2007 and I wanted to limit mechanic's typing requirments. They don't want to do it, They aren"t very good at it and many confuse sounds like with spelled like. I was building the system like I wanted to be used and I did define the table field(s) as look-ups. It...
  20. A

    Question Split data base

    I have just split my 2007DB. I also just noticed that AGST (Above Ground Storage Tank) table/form has lost some functionallity. before the split a lookup field let you select the tank registration number. (Multipul locations have different numbers) Since the split this stopped working. I...
Back
Top Bottom