Referring to a Table in a with statement VBA

[dellehurley]

I know this is very simple but I cannot find the answer anywhere.
How do I refer to a table when declaring a with statement (eg below)
Form_frmFileName works for a form however neither Table_tblFileName or simply tblFileName work.

With Table_tblFileName
            .txtFileName.Value = FileName
            .txtFileNo.Value = FileNo
End with

Thanks in advance.
Dannielle

 

[dellehurley]

Sorry I copied this from another piece of code writing to a form, obviously the textbox info is incorrect.
I have just recently moved over from Excel to Access and I'm still using training wheels...
but I would still like to know if it is possible to use the with statement after
DoCmd.OpenTable "tblFileName", acViewNormal, acAdd
or/and how do I refer to the table and field line by line (without the with statement)?

I know this is very simple but I cannot find the answer anywhere.
How do I refer to a table when declaring a with statement (eg below)
Form_frmFileName works for a form however neither Table_tblFileName or simply tblFileName work.

With Table_tblFileName
            .txtFileName.Value = FileName
            .txtFileNo.Value = FileNo
End with

Thanks in advance.
Dannielle

 

[welshgasman]

I have never edited a table directly except via queries or manually?
Normally a form is recommended, with that table as it's source.

 

[Micron]

Agree. Even if there is an answer to how it is not something you want to be doing. Might be better if you explained what the process or end goal is.

 

[dellehurley]

Oh that is interesting .This is what I am trying to do...
I have a main form which has several joined forms. The first step on the main form is a command button which opens a browser to select a file, the vba checks whether the file is named using the correct protocol and whether it is in the correct file location. As this is a process I started in excel some files are already named correctly. I thought if they were named correctly that I would bypass the form, reverse engineer the file name, add the required info to the table and continue from there. I suppose the reason that I spent all day yesterday not being able to get this to work is because it isn't something that is done!

 

[Micron]

As this is a process I started in excel

All of the aforementioned objects (table/form/etc.) are in Access? Not sure I understand what comes after that part of your post. Seems like you're using a file dialog (what you call a browser) so why not just append to a table whatever you need from what the dialog returns? If you're using code for this, you could either use Docmd.RunSql or .Execute method of Database.

 

[dellehurley]

All of the aforementioned objects (table/form/etc.) are in Access? Not sure I understand what comes after that part of your post. Seems like you're using a file dialog (what you call a browser) so why not just append to a table whatever you need from what the dialog returns? If you're using code for this, you could either use Docmd.RunSql or .Execute method of Database.

The file name is auto generated by the info supplied on the filename form. The file is selected, renamed, moved to the correct location and if the file is an image the exif or metadata is updated too. As for the "either use Docmd.RunSql or .Execute method of" I will take the advice and look into it. I appreciate you taking the time to reply.
Dannielle

 

[welshgasman]

Well you could use a recordset to do what you now appear to be attempting.?
That would pretty much emulate what you wish to do in your explanation.