Microsoft Access / VBA Forum

Hi, Happy new year to all(: I have a Microsoft Access Database which stores comments. Comments are 'Memo' typed. Thus they can be very very long. However i need to export the comments into excel monthly but the 255 character limit refrains me from exporting the entire comments stores in the Access database. I have tried to find solutions...

I am trying to recover a database in Access 2007. I do not have a viable backup. The error message is: "The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should...

Does someone know an (fast) example of reading files in VBA, Byte per Byte ? I need to be able to take action on every single byte Thx

I'm trying to calculate a standard deviation for each record in a database...the record has 12 fields which contain consumption for each month of the year. I want to calculate the standard deviation of those 12 fields but it seems like access is wanting to calculate only on one field... Is there any way around this or am I just not understanding...

My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary Access-tables. I have tried this: conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database...

Hi guru's, I m unable to find how to Insert a primary key which is also an autonumber field into Table. My query is as below.It is inserting record if i m hardcoding the ID Field. It is VBA Access Insert into TableName(ID,LoginName,FirstName,LastName) Values(AutoNumber??,'Sam','Sam','Don') Insert into...

I have produced an Excel (2007) worksheet, with which I want to create a Pivot Table. This would all be done from a module run on an Access 2007 database. Please can anyone supply some simple code for this? Many thanks for any help received.

We have set up an Access database with tables x,y, & z where we would like to have multiple people entering data into a table x. Each person has an identical copy of the database on their PC's. When the person is done entering the data into table x, we want them to e-mail their database to one person who will combine the data from table x...

I need to create a Form that has a button and when you click the button it opens a box that lets you navigate through the computer's files and select a Excel spreadsheet to import that data to specified tables. Note: I need to do this for 2 seperate Excel spreadsheets and 1 Excel Workbook (which contains 2 spreadsheets I need to import). and...

I would like to run an MS-DOS command from Access (VBA) in order to read a directory tree (into an external file). The command works OK from the command (DOS) window (in XP) but I can't seem to get it to work from MS-Access (2003). I tried a simplified command, DIR, but also this wouldn't work. I have been using the following syntax: ...

Main form is named Add Products and Sub-Form is named Add Products SubForm On Open I want the focus to go to the sub-form and then go to control Product Name on the sub-form. How Can I Do This ? Thanks in Advance...

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...

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...

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).

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 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...

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 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?

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 to remove dashes from 111-22-5555. I am importing text file and some of the numbers have dashes and some don't Thanks

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...

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.

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...

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...