Search results

thank you that work perfect love you

tnx i know but my head is to busy that i can't go over the dir function :banghead: need help writing the code

hi i have a db that take a snapshot to "c:\img" with extension of "jpg" there is only one file in the folder at a time the file saved each time with a different name how do i rename the file to "1.jpg"

id is the students id number or passport so its a short text field your sql Looks shorter and better anyway i'm already working on a new db i'll check your code when i'll have time What the heart desires time expire it sounds better in my language

tnx i got the point make sense i hope the post will help other people best regards:eshai

this code add a field formname the event procedure have to be on the field "on click" so it will be then it have to be which form to open on specific record so ok so you can do it this way and you can do it in my way any different?

ok this is the sql union code SELECT "tbl1" as tablename, [id], tbl1.[lastname], tbl1.[firstname] FROM tbl1 union SELECT "tbl2" as tablename, [id], tbl2.[lastname], tbl2.[firstname] FROM tbl2 Union SELECT "tbl3" as tablename, [id], tbl3.[lastname], tbl3.[firstname] FROM tbl3 Union SELECT "tbl4"...

you suggest to insert the form name to union query for tables? can you union forms and tables in union query in sql? (no) i will have to combine 2 union query that is to mass my code do the job perfect and i'm using it also for search record that is more quick for me instead of do loop

i cant add the form name to the query because i will need to do it manually this where the code do the job to apply which form to which table

if the union query is build from 6 table that have queries and 6 different forms how can you put docmd.openform in datasheet view or even in form view without if and else if. the code goes behind a field in a query that build based the union query. it open a form not a table

first this is my code If FieldName = "txtvalew" Then DoCmd.OpenForm "formname", acNormal, "", "[fieldname]=" & "'" & .FieldName & "'", , acNormal ElseIf FieldName = "txtvalew" Then DoCmd.OpenForm "formname", acNormal, "", "[fieldname]=" & "'" & .FieldName & "'", , acNormal...

hi: tanx you all i build this db when the other (schools) worked like stone age (the still do) so the send me students list in excel file to solved this problem i build a software that get the data from the network and insert it to my tables without losing my stricture i well past my code i...

no. every table have a unique structure and the gets there data by an excel file and some of them have unique codes and for the final there is another db that sanding data to this db. it's a very complected db that have 7 end users that dells with is department now for my Q' i build a form...

the table structure is fine tbl1 is main school other tables are sub schools each table have a unique fields the first reason i did union query is to find where is the record of the student instead of writing a loop code that well take a long time

hi: that why i build a form based on the quiry the commend in the field should be "on click event" and in the vba I thought to use "if" statement like "if table name = tbl1 then docmd.open form1 when form1[id]=me.id"

hi: i build an union query from 6 tables For that matter we call them' tbl1,tbl2 etc' the have fields called "table name" "id" "first name" "last name" and some other fields now what i need is to add a field Called open record that well open the record in the form of the table i made a form...

perfect work great i'm rebuilding a db the picture folder is 4gb so i can't change the structure thank you for your help best regards eshai

UPDATE test SET test.image = "C:\StudentsManager\data\Pictures\" & '" & lastname & "' & " " & '" & firstname & "' & " " & '" & city & "' & ".gif"; thank you

not working It puts the code into the field as is

you mean to put at in a query as expression on the image field?