Recent content by aanders

Thank you Galaxiom!

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

Thanks pr2-eugin.

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

RainLover Thank you. I will try the recommended solution.

RainLover Ok, i will give it a go - but i will come back to haunt you if something goes wrong;) (Just kidding - thanks for your help!)

Once you set up your table in Access it never changes. And there will not be any problem when i import new data to this table? How many records are you going to import. It is in the range of 10 000+. Originally you wanted 0001 to display instead of 1. Do you want a number or text? I want to...

RainLover Thanks for the reply! I really don't want to edit the input data field. It is MASSIVE and if i start to edit it, i will have do remember to edit it many, many times a year since i get a similiar input file 8 - 12 times a year. Is there no other way around this?

RainLover: No idea. Can field have different properties in Excel?

missinglinq The field appears to be defined as text. And i do not want to change this since i will have to import a LARGE excel-file quite often to Table 1, so it's default import settings should be used. Is there any way to solve this?

pr2-eugin Tried to, but for some reason my browser dies when i try to attach an image... But my properties for the F1 field looks exactly like the properties in your post.

Yes, that is correct.

missinglinq and James Dudden That didn't work :( (The format field appears to be a drop down where i can choose "euro", "date", "true/false" and some other options). F1 appears the same (in the case i loked at, it is "6" instead of "0006".

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

Cronk! That did it! Thank you!