Search results

Is there a way to convert a phone number in text format into a number and remove any dashs or parenthesis. What function can I use ? old format (951) 244-3011 new format 9512443011

Thanks Gina. I was able to research earlier MS access threads and find the information I needed. I appreciate your help. You have a great day !!

I want to add the following security features: (1) hide the toolbar that shows access objects (2) hide all access objects such as tables, queries, forms, macros. How do I do this ?

thanks, perfect

I have two separate fields that contain a date and time. Entrdate Timestamp 1/8/2014 10:12am 1/20/2014 8:33am How can I convert these two fields into a single field with normal long date format like 01/08/2014 10:12 AM ?

I greatly appreciate all your help with this. I discovered the issue. The Set Warnings No command interferes any query criteria that creates a prompt. I changed the Set Warnings action property to Yes before the query and the query works fine. Thanks again for all your help !!! Your...

I had already tried your suggesting. I believe your change was to take out the "DateValue". When I break down the macro into a series of macros with these prompt queries run separately, everything works fine. This means all the syntax is fine.

Keep in my that this all worked for over 5 years before the company migrated us to Windows 7.

Brokerage Production is a table. The criteria with a prompt reads the eff field of this table, which is in date/time format.

SELECT [Brokerage Production].Pol_idx, [Brokerage Production].Item, [Brokerage Production].Trans AS Trans2, [Brokerage Production].Eff INTO [Brokerage_Initial Policy List1] FROM [Brokerage Production] WHERE ((([Brokerage Production].Trans) In ("NEW","REN")) AND (([Brokerage...

I'm embarassed to admit that I've lost a lot of time on this issue. The database worked perfectly before we migrated to new operating system. All queries with a prompt fail if executed from a macro but work if executed individually outside of a macro.

Open Query DoCmd.OpenQuery "B1g Identify Initial Policies", acViewNormal, acReadOnly Criteria in Policy Effective Date Field >=DateValue([Enter Monthend Date MMDDYY])-90

My company recently upgraded our computers from Windows XP to Windows 7. After this upgrade, a very simple MS Access 2010 query would no longer run. The query, QUERY 10, simply prompts the user to enter a value in the policy effective date field with the following criteria: >=[Enter Monthend...

I'm using an import export spreadsheet macro command that uses a pre-defined specification to export a table from the database to a text file on my C:\ drive. The macro worked fine until our IT department migrated us from Windows XP to Windows 7. I receive an error message: The text file...

Thanks for your help !!!

1. If I mistakenly include a close window action in a macro to close a form that is not open, will this cause any issues such as unneccessarily opening the form simply to close it ? 2. If the close window action's save property is "prompt", will this cause the window to remain open until I...

If I run a macro with an action to open an update query, is there any need to include a close window action to close the update query. My testing shows that the update query will run and close itself if the warnings are set off, so I would not need the close window action. So the close update...

The input mask worked. Thanks everyone. :)

I created an input mask with the following syntax: "LLL0000000-00". When I tested it and typed in GLO9808091-00 I received an error message that the format was not appropriate. Is there something wrong with my syntax ?

Your recommendation makes perfect sense, however there is an issue with this. The database was already released into production about six months ago. Is there a way to create a validation rule with the existing 13 digit single field ?