Search results

  1. Joe8915

    Question change the default on the find and replace

    Don't think that will help. I have only three options: 1. Fast Search 2.General Search 3.Start of field Search What I was looking for was default to Any Part of the field. It would be great, that some where ms 2010 would give you that option. Thanks guys anyway
  2. Joe8915

    Question change the default on the find and replace

    Has anyone come up on how to change the default from "whole field" to "any part of field"
  3. Joe8915

    Question 2010 Access Database HELP! Pretty Please and Thank You!

    DoctorPDR, this is one of the best or if not the best forums on the internet. I think you got off on a bad note. Big Booty is right, take a look at all the help that has been offered here. Do a search and see if you can find your answer. If not some one will help you out. Listen I have been...
  4. Joe8915

    Question Use a date Range in a Crosstab Query

    Yes, that was the problem. I made some adjustments, and re thought what I wanted and came up with solution. Thanks so much
  5. Joe8915

    Question Use a date Range in a Crosstab Query

    I would like to use a date range in a crosstab query. I have tried to use "IS not null and between [BeginningDate] and [EndingDate]" Any ideas? Thanks
  6. Joe8915

    Modal Welcome Message Access 2007 - VBA code not working

    I just retype the ElseIf and now it works without any error. You mean I fix something on my own................. wow
  7. Joe8915

    Modal Welcome Message Access 2007 - VBA code not working

    What a great idea, I just copied and pasted the following code: Private Sub Form_Load() If Time() < 0.5 Then [LblMorning].Visible = True [lblAfternoon].Visible = False [LblEvening].Visible = False ElseIf Time() > 0.5 And Time() < 0.75 Then [LblMorning].Visible = False [lblAfternoon].Visible =...
  8. Joe8915

    Setting Specific Printer via VBA

    Thanks for the quick reply. We are having a problem printing one of our forms. I can print the form if I manually select the printer. If I close the form and return to the form I cannot print the document. If I keep the form open I have no problem printing the document. Strange
  9. Joe8915

    Setting Specific Printer via VBA

    Will this work if your printers are hook up on network?
  10. Joe8915

    Viewing a graph different computer with different results

    GinaWhipp, thanks for the reply. I think it has to do with the Screen resolution. I have some running on XP and others running on windows 7. Trying to get the windows 7 users to 1280 x 1024 or smaller.
  11. Joe8915

    Viewing a graph different computer with different results

    I have a db which is split. Running MS 2010. On my computer I can see all the information listed. When I view it on separate computer I don't see all the information. At first I thought it might be a different resolution, changed to same resolution as I seen it on my computer and still the...
  12. Joe8915

    Populate additional fields

    pbaldy, first of all I would like to thank many times over. After a good night sleep and reviewed your replies. The magic word kept comming up row source, and that is where some how it was slipping thru my smal brain. As you would thought, that is where my mistake was comming from. I didn't...
  13. Joe8915

    Populate additional fields

    pbaldy, I have over 1500 different contractor names. The word "none" comes up on every record. Why was the first one so easy to do with the DUNNS? I have 1500 different Contractor Names and 1500 different DUNNS numbers. When I select the particular Contractor the Dunns number that is...
  14. Joe8915

    Populate additional fields

    Well guys, I think I spoke to soon. If I type the word none in that Column it show on the form. So its pulling from Column (2), now I just have to pull what ever it loaded in that Column. Pbaldy, the db is 176 kb, so I don't think its possible to post the db and its government owned. At one...
  15. Joe8915

    Populate additional fields

    pbaldy, I pasted the code in the correct place and it work: Private Sub Contractor_Name_AfterUpdate() Me.Dunns = Me.Contractor_Name.Column(1) Me.TaskOrder = Nz(Me.Contractor_Name.Column(2), "None") Doc Man thanks for chimming in as well End Sub
  16. Joe8915

    Populate additional fields

    pbaldy, I will post the entire code this might give you better idea of what is going on. Once again thanks for the quick reply Option Compare Database Option Explicit Sub Combo107_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[ID] = " &...
  17. Joe8915

    Populate additional fields

    Thanks pbaldy for the quick reply. I guess I should mention that I have SQL running as my BE When I try to enter the following: Private Sub Contractor_Name_AfterUpdate() Me.Dunns = Me.Contractor_Name.Column(1) Me.TaskOrder = Me.Contractor_Name.Column(2) I received error msg Run-time error...
  18. Joe8915

    Populate additional fields

    I have one table Name TblProclog the other is called Contractor Name. I have it now working., if they select a contractor it will populate a field called DUNNS. Private Sub Contractor_Name_AfterUpdate() Me.Dunns = Me.Contractor_Name.Column(1) End Sub Now I would like to add another...
  19. Joe8915

    Question combo bx error msg

    I have got it this far and it works but I would like to it select the name one time only but not twice. Private Sub FullName_BeforeUpdate(Cancel As Integer) If DCount("FullName", "qryFullName", "name_ID = '" & Me.name_id & "'") > 0 Then Cancel = True MsgBox "cannot save...
  20. Joe8915

    Question combo bx error msg

    Here is the bottom line. What I am trying to accomplish is not having duplicate enteries in a combo box. I think I am close now. Here is what I have so far: 1. Main Form called FrmBatch2b 2. Subform Called TblName subform Link Master field is ID Link Child field is Name_ID...
Back
Top Bottom