Search results

Hi! I want to get the link adress to an image in a report using VBA. I use the following code: Dim strPath As String strPath = [CurrentProject].[Path] & "\bilder\" & FirstImage If Not Right(strPath, 7) = "bilder\" Then Me.huvudbild.Picture = strPath Else Me.huvudbild.Picture =...

Background I have a query (Q1) that retrives data from a table (Table 1). One of the fields in Table (F1) contains both text and numeric data (ie: 24 eggs). I want to separate these values in Q1. Questions How can i in Q1 retrive only numeric data from F1 and display that data i a field? How...

Background: I have a table (Table 1) with a field (F1) that has a numeric value. The data in this table is imported trough an excel and is going to be updated regularly. F1 consists of a four digit number (1234) but if the first one, two or three numbers are a zero (ie. 0033) Access only...

I am new to access and english is not my mother tounge, so i apologize if something is not clear in my description. Background I have one query (lets call i Q1) and I have two tables with identical structure. Table 1: - id - iddesc - comment Table 2 - id - iddesc - comment Table 1...

First of all, i am a real newbie on Access and English is not my mother tounge so i apologize if something is unclear. Background: I have a form where you can edit the content of a table. This form has a onchange macro connected to it. The macro adds a value to a column in the table (if...

Hi! I have a database with the following tables: - data - datamodifications - mergeddata The "data" table is imported from a large excel file (about 5000 rows and 40 columns) and needs to be updated about once a year. The idea is to use the "datamodifications" table to store all...