Microsoft Access / VBA Forum

I have an excel spreadsheet that I imported into Access, and there is a Name field in the format of last name, first name. I'd like to break this into 2 separate fields. How can I do this? TIA!

Hi There.. What is the Macro or Code Builder Event, For Copying And Pasting. i.e: I need to click on a field in a textbox, and it must be copied jus by clicking on it. Then I want to click on an empty textbox, and the field I copied must get pasted... How do I go About doing this? XL

I'm trying to see if I can use DLookup instead of a Recordset to find a specific record. To find this record I think I only need one criteria. The problem is that this record must be the record with the oldest date amongst all the records with this criteria. DLookup("Bottom 1 EndDate", "TBTasks", " = " & Me.ProjectID) The expression...

Generally, the number of Arguments in a Procedure Call must be the same as in the Procedure Specification. If a Procedure requires 3 Arguments in its Specification, when calling the Procedure you must pass exactly 3 Arguments which should be of the specific Data Type and in the correct order as defined by the Procedure itself. A simple case will...

Hi, I need to rack and stack some data using a pivottable. I'd like to do it in excel. I have the query in Access 2007 finished but it is 800,000+ records. How can I get it to Excel 2007....it keeps giving me errors related to 65K line limit. Super frustrated....and not highly skilled at Access but on a deadline. Thanks

Goal: Have multiple text files, each of various lengths, be concatenated together into one final consolidated text file. Problem: Since the names of the files to be concatenated can change from day to day, I need to be able to dynamically generate a batch file to concatenate these files. So far, I have looked at using...

Hello everyone, I have a bond form that a user uses to enter data. One of my fields, is PolicyNumber. I added some code on the Before Update event of txtPolicyNumber that checks to see if that policy number is in the system when entering a new record. If it is, I want it to display a message and go back to the policy number field. ...

Please help on how to show a busy message like "Please wait" or a "analytical animated watch" in ms access when a process in running.

I have been working on a database containing the verses from the Bible and the figures of speech that apply to the verses. All but one of the fields are text fields. There is one memo field that contains the passage because I was not able to use a text field because some passages exceed 254 characters. The database was prepared using...

Hi all, I have a table with two columns, labeled Year and Loss. In the Year field, I have the numbers 1 to 10,000, each which can or cannot repeat. In the Loss column, i have numbers corresponding to the Years...for example: Year, Loss 1, 568 1, 621

Is it possible to obtain the IP address of my desktop using a Visual Basic command?

A while back, I started boning up on Software Engineering best practices and learning about Agile programming. In the process, I've become much more committed to removing duplication in code at a much finer level. As such, it's very frustrating to be working in VBA which lacks inheritance, one of the more powerful tools for eliminating...

This error has been driving me a little bit nuts, I have 2 reports going off the same query, the query pulls in data from a crosstab query. One of the reports is working just fine, but whenever I try to run the fourth one I get the error (the microsoft office access database engine does not recognize " as a valid field name or expression). The...

Hello again ! Is it possible to have custom Column Heads in a ListBox (ComboBox) ? I have a ListBox bounded to a table (if necessary I can bound it to a query). One field (or ListBox column) is for prices. This prices (all of them) can be either in European money (Euro) either in Romanian money (Lei). If the prices use Euro or Lei, is the...

Hello, I need to know what is the maximum number of records Access can hold? I need approx. 6 million records, do you know if Access can hold this amount? Thank you everyone.

I have two reports I want printed with Cute PDF Writer. Right now, the user has to select this printer, but I want it bound to the reports. I used this technique with Access 97 - I set the printer as part of the Design mode and this particular printer becomes the default for the report. Access 2003 doesn't seem to work the same way. How can I...

I would to remove dashes from 111-22-5555. I am importing text file and some of the numbers have dashes and some don't Thanks

Newbie question must of been asked before but: How do I count the number of tables in a database? Without VB, prefer to use SQL or the Access GUI somehow. Thanks. Lee g.

I would like to run a query from VBA. The query will be one with parameters. Is there a way to run the query and have Access prompt for the values like it does if I where to execute it through the database window?

I'm going over an application written by somebody else and have encountered what looks to me like nested "With"s. Is this something new with MS Access 2003 or am I losing it? Seems to me that when I tried nesting "With" clauses in MS Access 2000 it was a no-no. Some sample code - in which it looks like they're creating/populating a...

I saw previous solutions to convert a month number (1) to a month name (January). I have a database with 200+ dates. In a query, I use the "Part" function DatePart("m",), to extract the month (number) and all month extracts worked correctly (they returned the correct numerical month). However, when I attempted adding a field in the query to...

Brendan Reynolds posted the following function a while back ago: Public Function HoursMinutes( _ dtmStart As Date, _ dtmEnd As Date _ ) As String Dim intHours As Integer Dim intMinutes As Integer

I want to compare two text fields and return records where they differ. But I need to ignore the last 15 characters of the first string. Is there an equivalent to this function in Access SUBSTRING(field1,-1,15).

I have a VBA program that creates and emails a series of reports to a mailing list. These reports are queried off tables that are linked over the internet to a web server. Occasionally, the ODBC connection is dropped on one of the large reports (perhaps do to high traffic over the web). When this does happen, I would like to error trap this...

In a report I have 3 sub-reports. Each Sub-Report has it's own Page Header. When I run the sub-reports individually, the page headers print correctly ... but ... when I run the main report the subreport page headers do not print (they are simply invisible). The Sub-Reports' Report Header Band does get printed though. Any idea why the...