Search results

Open form to a specific Record, but show all records? Hi, I have 2 forms, which are showing me my client information. the form Client List shows me only few information in a list, the form Client Details shows me detailed information for a specific client. when clicking the ClientID field of...

Hi! I have a problem with a relationship between 3 tables. I am using the tables clients (with all my clients), products (with my 6 products) and investments (of each client for each (!) product) to keep track of the activities of a small investment company. Since every client has bought a...

Hey, I am running in a strange error since using a 2003 database under 2007. When I am trying to send an email, which will pulls the body from a table and then replaces certain keywords with specific data, I get an error the used ReplaceVariable() function is not defined. I use it under 2003...

OK, I used the search engine of the forum and found several related threads, but since I am not using any macros or anything special, it all does not really apply to me. I am using a query to pull data from totally 3 tables (which are all related amongst each other), but now find that when I...

Hello everyone! to make it short and simple, my total working experience with Access comes down to 3 days now, in which i successfully imported tables, designed forms, made queries, etc., so actually am quite successful, but now definitely am at the end of my knowledge. I am currently working...

Hi, i run into a type missmatch error while I am trying to import data from a closed xls workbook (with success), but get the error while trying to replace content of a memo field in the newly imported table. Sub GetDataFromClosedWorkbook() Dim xlApplication As Excel.Application Dim...

Hi! I am trying to import a specific excel spreadsheet which is to be defined in an inputbox prior import. however, when the code should select the prior defined sheet, it returns the error message that this action would not be support. Surprisingly, the code used to work before... :confused: I...

Hello! I have data in a memo field which is originally imported from my companies management system. However, during the export from this system, all line breaks of this text based data are delete and replaced with *-symbols. Now I am looking for a way to replace all * symbols in the table...

Hi! I am a little experienced with VBA from an excel point of view, however, am a complete newbie to access. In that relation, I am running into a probably minor problem: I wrote a piece of vba which lets me create an email with data from the entry currently shown on the form. However, since I...

Hi! Here my code for generating an email out of my database: Private Sub SendEmail2_Click() Dim EmailApp, NameSpace, EmailSend As Object Dim strTitle, strFn, strLN, strBody As String Set EmailApp = CreateObject("Outlook.Application") If EmailApp Is Nothing Then Set EmailApp =...

Hello! I am using the following code to import data from a closed XL spreadsheet and import it into a table in my database. Sub GetDataFromClosedWorkbook() Dim wb As Workbook Dim ws As Worksheet Dim db As Database, rec As Recordset Dim Filename As Object Dim Selection As String Set db =...

Hello, i have no clue what I am doing :) ...alright, since I read that at the "How to talk to a programmer" thread, I think it is a necessary thing to point out right at the beginning. I honestly just started with Access 2 days ago and built a rather easy database, but I ran into a small...