Microsoft Access / VBA Forum

Hello, Do some of you know some pretty good books or web tutorials on building databases, if any? By that I mean, when looking at a business, the sound way of choosing the proper fields and the proper way to group these fields to construct the tables that make up a database, while anticipating database growth. I have learned quite a bit...

Hi, I am having trouble using the following code: RetVal = Shell("C:\Program Files\Microsoft Office\Office" & tussen & "\excel.exe " & thispath, 1) Don't mind tussen, this is to switch between Office 2000 and 2002

Hi, Everytime i try and import a txt file into my ADP i get a " . . . is not a valid table". if i open the table i am trying to import into i can not modify any of the data that is in there (yes, i have all the correct permissions on the SQL Server side). This error only seems to happen in some tables, not all of them. Any help or guidance...

To all, A tall order, but any help on any segment of this would be appreciated: I have a table that needs to be populated with information contained in an email attachment. 1. Is it possible for Outlook to "notify" Access that an email has been received?

There must be some way that tabs are set in module windows. A lot of the code I've used from the Access Web and other sites have indents that I can't possibly imitate. Is there a way to do this? I'm in A97. TIA -- Tim - http://www.ucs.mun.ca/~tmarshal/ ^o<

I manually split my database - in a blank database, I copied all the forms, reports, etc. and linked to the tables in my original database. The front end has grown to 12,818kb and the back end, where my tables are, is only 6,472kb. How can this be? Does the front end need to be compressed? I thought if the data is actually being stored...

Environment: Access 2k, win2k Business Problem: I have to display returns on investments made over a period of years, and show the amount of return earned on each investment by year. For example, if you placed some money in 2001, you'd want to see the returns on that for 2002, 2003, 2004 etc. (These are long-term investments, so it's...

I'm using Access 97 and need some assistance in sorting out a proper DSum expression. It relates to a subform (sfrmCost) from which I'm wanting to extract the grand total of any and all data rows that have the same primary IDReference, and have it post as an accumulative sum in one text box (TotalCost) on the main form (frmMain). There are...

How do I place a Command Button on one of my forms that when pressed will open up a find/replace window that I can specify two criterias for search and then have the items I searched for show up on the form? Wow, any help is greatly appreciated!!

Has anybody seen one? Or care to offer (a brief) one? Yes, I've done some searching of the archives. Anybody who's read my posts over the past couple of years (and there must be at least one or two of you!) will know my only real experience is with Access/Jet. But it's becoming clear to me that for career's sake I've got to expand my skill...

Hi, I've managed to create a form with various components on to create an sql query within vba. So I can create the query, and a recordset of the results, but how can I then go about showing this to the user? Ideally I would like the query (which is address details) to display as mailing labels in a specified format, but I would...

/* Make two tables, then find that a left join between them works, unless you add a view on top of one table -- if you add a view and use it, the left join fails -- rather, it acts as an inner join */ aaTable1 myid, Number typeid, Number 1,11 1,13

This property is only available only when the control has the focus... Error #2185 I get the above error when code running in FormA is trying to set the value of a hidden textbox on FormB to a string. Here's the code I'm running. How can I accomplish what I'm trying to do? Forms!FormB!MyTextBox.Text = "Hello"

Hi I am using the Internet Transfer Control as follows; strData = "Some data" strHeaders = "Content-Type: application/x-www-form-urlencoded" & vbCrLf objInet.Execute strURL, "POST", strData, strHeaders I would like to keep the internet connection alive. What would be the syntax

Currently I am using this statement to translate 3 fields in my db thru Visual Basic. I import the data from one table to another then call the IFF statements and the NewDate to translate the fields. Can this be done in an Access db? I am trying to learn how to do these things in Access vs Visual Dim strIIF As String Dim sstrIIF As String...

2nd post: Does anyone know how to set the height of a form passed the inbuilt limit? I want to set the height of a form so that it will fill a portrait page when printing. When the screen resolution is <= 1024x800, the fm.InsideHeight is capped by Access so that the height is reduced.

Howdy, all. Appreciate your help. Have a one to many relation between a client and visit table. In the visit subform, I have a visittype and counselor field which are comboboxes. If I set either field to drop down via Me.dropdown in the GotFocus event for the field, each time the client record changes the visittype or counselor field...

I would like to know if the following is possible: I have a form and a subform. In the subform, there are records summarized. (For ex, instead of showing all 19 fields, I only show 3 to save space.) I would like the user to be able to select a record in the subform datasheet, and click a button, or double click, to bring up the ENTIRE...

In Access 2000. Microsoft Word 9.0 Object Library reference is set. I got the following two pieces of code from Help from the Object Browser. Both of them are giving me the same error: "Run Time Error '429' ActiveX Component Can't Create Object" Code # 1: Documents.Open FileName:="blah.doc", ReadOnly:=True

I have an export specification created to export the result of a query to a text file. My issue is that it is adding decimal places to my numbers (For instance, 1 becomes 1.00). Does anyone know how to prevent this from happening? Thanks!

Hi, I'm looking for an editor for an Access Database. I've used UTE in the past, and looked a few others, but now I need a slightly more powerful editor that will let me add and delete complete tables and fields rather than just the records therein. Preferably, a web-based, ASP app. Any ideas? Links? Thanks.

I am not sure why this is not working. This is the code that I am using in my form for this button but I am still not getting the option to sort it when I run it. I would really appreciate any help I can get. Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim stDocName As String

Set strFoundCt = ("SELECT COUNT(*) FROM (SELECT DISTINCT Entity_ID FROM qrySearch" & strPxSx) This doesn't work, but hopefully describes what I'm trying to do. I have several different queries (e.g. qrySearch29) that are run based on user selection criteria. User criteria is saved in the strPxSx variable. The problem is getting a count...

(Access 2000) I have: Set eWB = e.Workbooks.Open("Book1.xls") Where e is DIM'd as an Excel.Application and eWB as an Excel.Workbook. This file opens fine.

Struggling a bit here & would be grateful for any help. I have a table which has a list of people in it. Each person has a unique ID automatically allocated by Access but also belongs to one of 5 Groups - call them A to E. I'd like to generate a further automatic reference number based on something like Group/Unique ID so when I create a...