Search results

No problem, mate. I assume you went for the coded solution :)

Then you probably need to use the SQL INSERT INTO command only for the first instance, and then an SQL UPDATE command: UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value; (source: http://www.w3schools.com/sql/sql_update.asp) You will have to somehow reference...

Do you mean that a new record is created for each instance of the command, when you instead want the value to be modified in a single (new) record?

I think you can add images from remote paths with the report structure view (I am sure you can do that with forms, so don't take it for granted). In case you want to code it anyway you can: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.ImgPic.Picture =...

Why don't you just assign the path to the variable without checking with IsNull()? That way you can make sure it will always hold a value - I'm not too keen on reports, but I am under the impression you would not need to be adding images with code?

Change your routine as follows: Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(Me.ImagePath) Then Me.ImgPic.Picture = "O:\Bellingham\Intranet\Production\Labels\No Label.bmp" Else Debug.print Me.ImagePath 'Me.ImgPic.Picture =...

Does the image path lead to a network resource? Did you test Me.ImagePath's value ('debug.print Me.ImagePath' or by looking at the local variables window)?

I've spent several hours searching the internet but haven't found a proper solution yet. I have a few hundred access databases all with the same tables and structure, and want to import all the data in a 'mother' database (which i created with the same tables and structure). I am using a sub...

oh, glad you solved it then :)

Mh, then I'm curious as to what the settings in your table structure are, and if you're using special kind of fields.

Hello yourself, that assumption is painful. Access handles data differently, and you use ID's or other means to refer to field values. Some of the folks here should be able to address you to some decent readings in order to clear this up for you, I would advice you use a query to do this...

on form's OnChange or Change event, I don't remember precisely.

excel reports.. mhmmm. access does reports, but I guess this isn't for you to decide if you're exporting. Did you try the RunSQL method?

I do not think you can use SQL instructions in DAO recordsets, but I might be wrong. Either way, I'd use the DoCommand.RunSQL method to execute your update query. Additionally, I'm not even too sure about the syntax of your query, adding a debug.print updateproc before your rs.edit call to...

The only thing that crosses my mind is that the data sent to the printer has not been refreshed after a given event. Have you tried using a VBA sub to do the quick printing for you?

Why would you edit directly from the table? Can you edit anything in the data? Is the file read-only? Do update/append queries work instead?

to be honest if you don't store conditional information on tables, your conditions will only last for as long as the form is opened, so you do need to do it.

It would help to know what kind of format the program accepts. Most software packages can import data from XML files, .csv files, simple text or even excel tables, but you would have to look at the specifications first. This is the first google result, have you tried googling...

Why yes, you said you have a condition field (ApplicationScreeningResult), didn't you?

Right, so you only need to "move" the data, like this? INSERT INTO Lokacija ( x, y, z, EDM_num ) SELECT Edm2012.x, Edm2012.y, Edm2012.z, Edm2012.EDM_num FROM Edm2012