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

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

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

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

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.

This question might start a fire storm but here goes... In your opinion who was/is the best and worst president?

If anyone can help it would be greatly appreciated. I am trying to get the form to pull a report by 1 salesman in the salesman combobox or if nothing is selected all salesman. I've tried using a union query with no success and tried different criteria in the VBA and query. I also want it to be...

Hello Access experts I've attached a database example and screenshots of what I am trying to do. I hope I can properly explain it. 1. What I want to do is filter down all the records (Screenshot 1) to exclude the sold records (Screenshot 2). 2. Then I want to filter down the records to...

I am having a problem sorting the attached spreadsheet. I use ASAP utilities to fill L2:M21 with random numbers. After doing that I try to sort the standings by 1rst sort-pct. desending and 2nd sort- +/- desending. I go to data-sort to sort the data and it does not sort at all. Any Ideas? BTW...

I thought this would be a neat post. I am interested to see some names people have.

I’m not sure if this post should be in the forms or reports forum. Sorry. This is my problem; I have a form that has a button with the following code: ====================================== Private Sub Command4_Click() On Error GoTo Err_Command4_Click Dim stDocName As String stDocName =...

re: Games In Excel, Word And Access Here's one I tripped upon one night. I play this in work at lunch sometimes. I am not the creator of it. It was created by Lena Wood (lenawood@qwest.net). - Charles Williams Edit: It is for MS Access 2000

Is the Access section being updated anymore ????? It seems like a long time since I seen updates in the Access section.

Hello Excel Experts, I was wondering if someone can help me with this. In the attached spreadsheet I would like to be able to put some kind of data into range B3:B1002 and have it automatically add it to the range G3:G1002 if it is not already there. It would then do the calculations in columns...

Hello Everyone, Someone must have put a stupid pill in my coffee this morning. :eek: Here's the problem. I put the zip code in and it is suppose to autofill the city and state but it doesn't work. :mad: Can someone look at the attached file and tell me what I might be doing wrong? I've...

I am trying to get a total count of the source for 2 different items in the report footer and cannot seem to figure out the correct code. Please see the attached file to see what I am asking. Any help would be greatly appreciated. - Charles Williams

Hello To All, Has anyone seen the message in the attached file? I got this when I was trying to update the row source on the field after I had a problem with data in a report coming up inaccurate. I've been developing in MS Access for about 7 years now and have never seen this. Any explination...