Search results

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

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.

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

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

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

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

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

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

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

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

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

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.

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

Thanks Bob, I' give thsi a try..

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

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.

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

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.

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

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