Search results for query: *

I have a text box on a report that contains a social security number. I want to only display the last four digits and have the remainder show as some type of symbol. I can't get the formatting to work right. Any suggestions?

I have tried searching the forums, but either can't find what I need or I just don't understand the responses, so I'm asking for help. I just can't seem to get the right coding and I'm not real familiar with the whole recordset references I saw before. I have a continuous form based on a query...

I inherited a database with 128 forms and 200 queries in the front end. Is there a way, besides going through each one manually, to check and see what queries are and are not used? I'd like to remove the excess junk if they're not needed.

I inherited a database with 128 forms and 200 queries in the front end. Is there a way, besides going through each one manually, to check and see what queries are and are not used? I'd like to remove the excess junk if they're not needed.

Can't seem to get this right...so I turn to you guys and gals for help. I have a form with several tabbed pages on it. On each of the pages is a textbox that stores the location of a file. I have a command button on a popup form which I use to copy the location from the main form. I can copy...

I am trying to generate an invoice number using the following code. It gets the number just fine, but I want to check the number generated against the table to make sure there are no duplicates, and if there is I want the number to increase by 1. Private Function NextNumber() As String Dim...

OK, after reading through as many threads as I could, here's my problem: In my current report writing system, I use a bound form with a memo field. Problems arose if more than one person had accessed that form while it was still open by the original user, thus leading to write conflicts or...

I have several old Access 97 mdb's and looking to update to Office 2000. The conversion is no problem. The problem I am having I think is with Windows 2000 Professional. On my older WinNT/Win95 setup with Access 97, I was able to open up a form that had a picture(jpg) embedded and be able...

How do you check for keystrokes? I have a hidden form and am using Microsofts code for detecting idle time. My problem is that the time is not being reset when people work in a memo field. Other posts suggest checking for keystrokes. Where and what code would be inserted in the following...

OK, I am trying to input an age into a text box and convert that age to the first of the year that the person was born. ex- input 25, returns 1/1/77 This return would then be used as the criteria for a query to look up people born in that same year. To take it one step farther, I would like...

I am trying to open a report based on a subform, but I keep getting a parameter value box when the value is already on the subform. Any help would be appreciated!! Here's the code so far: Dim stDocName As String stDocName = "rptBookingReportOLD" DoCmd.OpenReport stDocName...