Search results

I am using =Environ("UserName") as the default value of a text box on a form and the value returned is saved in the table.

I checked the references again and they still look fine. There are none that show up as missing.

I have done this and am currently using this setup. Split your db into Front end and Back end. I placed both halves on the server and simply e-mailed a link around to whomever would be using the program. This makes any location changes easy to do as you simply have to e-mail another shortcut...

My error.... yes, Now() does correct the problem with the date. Thanks for pointing that out to me! Sometimes we cant see the forest for the trees as the saying goes. I will check the references again. Is there anything else that you can think of to look for?? I also need to correct a...

I have noted a problem on 2 computers using this. There are around 30 or so computers on our network that work fine with this as a value. The majority of the users are at Access 2000 but some have Access XP. The offending machines have Access 2000 One day a persons computer crashed. DP imaged...

That is it then. The combo I used was based on just one field. Glad it worked out for you. Cheers!!

What version of Access are you using? It's odd that it worked ok for me and not for you!!

Not that this is much help but, I just tried your code in the got focus event and also the mousemove event of a command button. It worked fine in Access 2000 even when I populated the combo and then deleted the contents. Initially I had the combo limited to list but I removed that thinking...

Works for me!

Try this: SELECT tblCustomers.First Name, tblCustomers.Surname FROM tblCustomers WHERE (((tblCustomers.Company Name=[Forms]![FrmSearchCriteria]![Company Name]Or [Forms]![FrmSearchCriteria]![Company Name] Is Null)=True));

You state that your table name is Main Setting but the query refers to [Main Settings] (plural) It would be best to eliminate the space between the words such as this: MainSettings or Main_Settings

How about just making them vanish and reappear using the .visible command?

Try this if OptionGroup1.value = 1 then Me.List1.RowSource = "SELECT [tblIngredients].[Ingredient]" "From tblIngredients "

Is it possible to change the background color on the Find and Replace dialog box that access provides? I open it with this code: DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

I knew it was something simple. Thanks for the tip... it worked just fine. Here is what I ended up with: If Forms("frmFilter").Listbox1.ListCount = 0 Then Thanks again!! :D

How do I determine what value my listbox has? Here is what generates the records from Form 2: If Not IsNull(Me.[StartDate]) And Not IsNull(Me.[EndDate]) Then strCriteria = strCriteria & "tblWO.Created Between #" & _ Format(Me.[StartDate], "m/d/yyyy") & "# And #" & _...

Have you tried: DoCmd.GoToControl "Footer"

I copied your code before you changed it to Not IsNull That was the problem. I think now its just a matter of tidying things up. Thanks a bunch!

Ok, I changed the date format in both the module and in your code to d/m/yyyy. It reflects the correct formatting now in the text box on the calendar form. Still though, there are no entries in the listbox. Initially the listbox is populated with all records. When clicking the button on the...

No errors are evident. What is happening though is the listbox winds up empty. This is due I think to the formatting of the date. My table has values like this - 5/24/05 where as the calendar I am working with fills in the field with 11-May-2005 I am trying to correct this now. Thanks for...