Search results

Yes, that is exactly what I have. Here is the SQL SELECT tSpecCode.tSpcCodeID, tSpecCode.tSpcCode, tSpecCode.tSpcCodeDesc FROM tSpecCode ORDER BY tSpecCode.tSpcCode;

I have several list boxes that allow a user to input a value and it then filters the form accordingly. However, one of the fields is a lookup box and it shows the actual value, but hidden behind that is the record ID. How can I modify the following code to read the content of the box and...

Here is the solution to the Date issue. Private Sub luDate_AfterUpdate() '= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = ' By Ken Gooch last updated 02/15/2020 '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 'Filter by Date [Forms]![fAccList].Filter =...

7/14/2020 is the format for a simple date. I will check it.

I want to filter a form by a specific date. I have created an unbound text box that filters records by several different fields by whatever text string I type in to a text box. I then execute the filter with a Command Button. I have tried to use this same concept with a date field but it...

Thanks so much everyone... I will try the AfterUpdate and look into the Video! Thanks for the Coupon Code!

Thanks for the thought, but Conditional Formatting doesn't work with a check box

I have a form with a check box named [tConcur] If the user clicks the checkbox on, I want the label of the check box to change to Green. this is what I tried, but it doesn't work. Private Sub tConcur_BeforeUpdate(Cancel As Integer) If (tConcur = -1) Then Me!LConc.BackColor = vbGreen Else...

That's actually exactly what I was looking for!! You guys are the best!!

Can the setvalue function find and replace characters?

I saw that as a possibility, but for some reason I'm not sure how to link a form field to a query, or perhaps I should have just written it into the underlying query upon which the form is built... I guess I just haven't thought it through. My first thought is usually VBA then Macros...

So, we use the Database to track info from our Medical Records system, that doesn't have a way to track this particular issue. We block and copy the name from the MRS to the Database and it put's a comma with no space between the lastname,firstname. For the ProperCase function to work there...

I need a Macro command so I can check a form field for "," and replace it with ", " Thanks in advance for your help!

We are supposed to get rid of all of our paper Accession logs. So access was already on our computers and since it allows multiple users to access the data, unlike excel, it makes a good tool for a log book.

Wow! thanks so much for the Quick response!!! So where does the block of code go that you provided? It looks like VBA code rather than a single line of code that could be entered in the "Default Value" field of the tAccLog table under tAccNum? I was trying to accomplish this in the table...

I have a database that has a separate index ID so that each Accession has a unique number. I need to track the Accession numbers by the Prefix "S" and then the last two digits of the year ie 2019 would be "S19". So the system tracks Accession numbers by the Year "S19" and then in a numeric...

Hi, Ken Gooch, Management Program Analyst VAMC Martinsburg