Saving pathsettings in a form

  • Thread starter Thread starter Nicollo Machiaveli
  • Start date Start date
N

Nicollo Machiaveli

Hello everyone,

Could someone help me with my question. I want to use a opendialog code
where i save the path. I don't want to hardcode it in vba because i want it
to be flexible.
How can i achieve this.

Greetings Mach
 
Your form is a way of viewing data stored in a table. It doesnt store any
data by itself. So if you want to store pathnames ( or anything else ),
create a table to store the data, then set the form recordsource to point to
that table. ( or to a query combining and sorting several tables, if you
need more flexibility )

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
-----Original Message-----
Your form is a way of viewing data stored in a table. It doesnt store any
data by itself. So if you want to store pathnames ( or anything else ),
create a table to store the data, then set the form recordsource to point to
that table. ( or to a query combining and sorting several tables, if you
need more flexibility )

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control



.
Hi Adrian,
Click to expand...

Thanks for the tip. But how about if i use an access adp
project, the tables aren't available. Should i also use a
table but then from sql server.

Greetings,

Mach
 
Sorry, I know nothing about ADP, but yes, put the pathnames in a table, just
like any other data.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top