Search results

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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] = " &...

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

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

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

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