Search results

Hello again access experts! I have a search form that I want to be able to use on any current form (See attached). It has the combo button for the field names but I just don't know the code to automatically fill in the field name combo box with field names of the called form. This is a piece...

Thank You spikepl I believe that is just what I am looking for! I'm going to try and play with it and let you know. - Charles Williams

Thanks Pbaldy I totally missed that! That though is my idea for the code.

Sorry guys I should have said from the beginning that I am using Access 2007. This is the test I did make sure the code works: Private Sub RecordID_GotFocus() Call SetBorderColor End Sub Private Sub RecordID_LostFocus() Call ResetBorderColor End Sub With the modules: Function...

Hello Access Experts, I need help with a little coding please. I have a form (see attached) and every time someone goes to a different field I would like to change the border to red and when they leave that field to change the border back to the default color. I know I can put the code in for...

Hello Access Experts, I'm going to ask an easy question. How to get the last Thursday of previous month? For 5 particular queries I need to pull the date range starting at the last Thursday of the previous month forward. Any help would be greatly appreciated. - Charles Williams

PaulO - Yes 80,000+ records. You are correct running an update field would do the trick. If you where to see the whole db it would make you scream. :eek: I was rushed to create the db and my boss didn't really care about normalization. JHB - That was exactly what I was looking for. Thanks! ;)

PaulO, Thanks for the response. It is fed through a query. I will try to use the calendar and set it up with a left inner join. I will also change the time in the table (good catch) Also, the database I attached is a part of a much larger database (80,00+ records). It would be too tedious to...

Hello Access Experts, I have a report that is grouped by the day and lists the salesman across the top and times down the left side. What I would like is to have all the times from 9am-9pm down the left side for each date weather there is a lead assigned or not for that salesman. I cannot get...

Thanks bunches Trevor, I'll give it a try. Happy New Year!

OK Trevor, Here's how I changed the code: Sub PageSetupArraySheets() Dim wsH As Worksheet 'Loop through each sheet 'Adjust Page Setup For Each wsH In ActiveWorkbook.Worksheets With wsH.PageSetup .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Zoom = 100...

Trevor, I should have prefaced my original message with i'm not familiar with VBA in Excel. So in saying that... I created a macro to insert the Header (left and right) as needed. The only problem with this solution (if you want to call it that) is that you have to run it on each sheet. I'm...

Hello Excel Experts, I'm wondering if theere is any way to do something... I have a spreadsheet (Attached) where, when I print a paticular month, I would like to... A) Show the salesman's name from the workbook name (Flinstone) in the left header. B) Show the month from the spreadsheet's tab...

Hello DB Experts, I have attached a db (Access 2K) that suites most of my needs for salesman scheduling. There is a few items I would like to do with it and am having trouble with: # 1 - Change times across the top (where it says 12 with a 0 underneath) to 12:00 PM. # 2 – Set times across the...

I think I might have that file. Give me a few to dig it up for you.

Access Guy It doesn't quite do what I want. If you move the password box you can see the data under it. Can you make it so the spreadsheet cannot be seen until the password is entered? - Charles

Thank You Access Guy. I'll try it tomorrow in work. I would try it now but my computer only came with Excel starter version.:( - Charles

JanR, Thanks for the quick response. sorry, I should have made myself a little clearer. I would like it so when the person clicks on the tab for sheet1 in the workbook it prompts you for a password before it opens it. Is that a little clearer? - Charles

Does anyone know of any way you can password protect a sheet in a workbook? The Excel version is Excel 2007. I'm not looking to password protect a whole workbook with a password. I'm visioning VBA code for this. Thanks for any help you can provide.

Thanks A Million. This can also be done in Powerpoint?? Interesting.