Search results

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!

Cronk, sorry for my poor english. As i said, its not my mother tounge. I want to create a question (Q1) that shows all data from Table 1. If there is data in a field in Table 2 on a row with the same id i want that data to replace the data in Table1. Something similar to: if(table2.comment >...

Cronk: If nothing is in both fields... Lets say that i only have a value in the "id" field in Table 1 (and that that id doesnt exist in Table 2) the row with that id in Table1 and all the other (blank) fields (iddesc and comment) should appear in Q1. My SQL: SELECT Table1.iddesc, Table1.id...

I have identified the problem. If i use: IIF(Len(table2.comment & "") = 0, table1.comment, table2.comment) And both "table1.comment" and "table2.comment" are empty Q1 doesnt add this row.

Galaximon: I have an OUTER JOIN. Right now i only have 1 row in Table 2. In Table 1 i have 4906 rows. Q1 returns 2235 rows.

Hmm. actually, that returns just half of my the data in Table 1. Any idea why?