Microsoft Access / VBA Forum

I have an excel spreadsheet with 500 rows of information. I want to copy and paste that information into an access table that i'm using, column by column.... But access only lets me copy and paste cell by cell from excel to access. Of course i could do that or even use one of my forms i created but that only allows me to import the information...

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it then makes that (calling) Form visible again. This article is released as a companion to the VBA Class Basics one that focuses on opening Forms. ...

I am working with Access 2003 on a computer running XP. I am new at using Access. I have a Db with a date field stored as mm/dd/yyyy. I need a Query that will prompt for the month, ie. 6 for June, and will return all records in that month.

I have a list of texts and I need to find out the number of times each character shows up. Example in the text "76DC4-34" the character '4' shows up twice. Is there a query that for this instance if I provide the text and character I'm looking for it will give the number of occurences as a result or if there is no such query how do I go about...

In recent weeks Access 365 (and I believe earlier versions) has become unable in certain circumstances to create a backup (File>Save As>Back up database>Save As) or create a .accde file (File>Save As>Make ACCDE>Save As). The symptoms vary depending on whether the FE has a password or not, and whether you are making a backup or a compiled version,...

Hi I am trying to get the results of a query to show only unique student records (not duplicates). Is there a simple way to make the criteria field do this? I am not too familiar with SQL. I have a student_info table, a session_info table, and a services_to_students table. What I'd like to do is query the tables to get a list of all...

My Access 2007 file fails to open on a machine with the 2007 Access runtime version installed. It comes up with a Security alert message. Is there a security setting in the Access Database that needs to be enabled to run the code and macros?

Hi, I'm using the following code to open a form on a specific record. I have a form displaying records in a list which then allows users to click onto the record to open it up in a new form in a single view. DoCmd.OpenForm "FRMBookingDetails", , " = " & Me.BookingID The form opens only on the first record only and never the chosen...

Hello, In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolbar "Ribbon", acToolbarNo) or even the "View" part of the "Home" tab because users like being able to flip between Form View and Datasheet View in the forms. It turns out that on our...

Hello all I have a new problem with my application. I want users of my application be disable to entering in design view of a Form by right clicking on the forms and selecting Design View. If there is any way to disabling Mouse right click at Run time with VBA please aware me. Thanks in advanced

INTRODUCTION The Levenshtein Distance algorithm is an algorithm used to calculate the minimum number of edits required to transform one string into another string using addition, deletion, and substitution of characters. USES The most common use of the function is for approximate string matching. Since the function returns the minimum number...

All, I posted a question yesterday about automatically sending emails with VBA in Access 2002. That post was wonderfully answered by Mr. Doherty. Now I have a follow up question. Can anyone toss some sample code my way about how to query a ldap server to get email addresses? I have the ldap server name and a user's first and last name. ...

Hi, I have a access form on which there is a tab control with 2 tabs. each tab has a text box (lets say text1 & text2) each tab also has a command button (button1 & button2) What I am looking for is when the user presses the Enter key in a text box, then the button_click event to be called. (true in both the tabs)

I am new to databases and thus to Access. I have a situation where I am trying to figure out how to key some tables I am working with. Consider that I have a database of my own records which are invoices I work on. These invoices are from four companies with their own invoice numbers. So, I cannot key by invoice number because there is a...

Hi , can anyone tell me how to get the complete table schema including constraints, primary key ..etc. through sql Query in Ms access. We can get table information in MS SQL Server by means using sp_help.I want to know the equivalent sql command for ms-access. thanks in advance

The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In this month's session, Ramachandran (APR) Pillai will be leading a presentation called Streamline Form Module Code in the standalone Class Module. For...

I have a textbox on a form into which an alpha-numeric string of data is entered. I wish to force the casual user, who would sometimes use upper case, sometimes not and sometimes MIX the case - yes, believe it - to use UPPER case only. I tried running UCASE on the string entered during the textbox's BeforeUpdate event code. That did nothing...

Hello, I am tyring to combine several rows based on matching information..For example i have the following table. IOSC: FEATURE: 00029 LH 00029 SWFTERM 00029 WATS 00031 1PTY

Hello all, I have (hopefully) an easy question for you all. I'm running Access '03 and have created a pile of VBA code to create a form and some queries related to each control in the form. (Basically, it uses structured naming conventions to create a form with a bunch of combo boxes that allow the user to easily add and remove controls......

On several occasions, we've come across situations in which our Members have inherited secured, legacy Databases and were told to either eliminate the security mechanism on these Databases or restructure them. In these, and similar circumstances, it is very helpful to know you can 'unsecure' a 'secure' Access Database. These are the steps...

Dear reader, With the export command you can export a query to Excel. By activate this command a form pop's up with the following text:

I've got two fields in my database. There are date and time fields, but they are both type text. I need to concatenate these fields together and convert them to a date/time data type. I've tried a few things in my query, but am not having any luck. How should I go about doing this?

Debug stops at the 3rd line of this code (Set rs = db.openrecordset("IMPORT") why? Private Sub Command118_Click() Dim rs As DAO.Recordset Set rs = db.openrecordset("IMPORT") With rs .MoveFirst prev = !NOM_ACCOUNT

I have created a report in access. I had to add a text box to input a value for previous months balance. I have formatted to display with $ currency, and also with the " , " for thousand separator. I have not been able to get it to display correctly. It is just the numbers without the formatting. Please help !!! *** Sent via...

Hi, How to set Validation Rule? Example, my Textbox should not be empty. So, I set validation rule as "Not null". But it shows only at the end of record save. I must need to show when they leave from textbox itself. Not at the end of the record. And,I need to show my Own message Can anybody please suggest me?