Search results

Might me easier if you did everything from either VB or Access. Depending on your code you could either convert your VB code to VBA or create a form in VB linked to your database. However, I'm not sure about Access but in VB it is possible to open the database file and then your database can...

Not that I know of unless there is a property in vba which I don't know about, I got around it by having a colour scheme for my database that goes with grey

It depends on how it would work. I have worked on a database where it is on the internet but also there was secure information in it ..... Of course I took out the confidential stuff and made a new design ... but if it could be guaranteed to be 'safe' AND it could restrict users looking at the...

to answer my own question you perform a union query for each column name. However, if like me you want to update a table with fixed columns relating to a query where the columns can be dynamic I still can't figure out a solution.

Does anyone know how you would go about this: In a table1 I have two variables, variable1 and variable2 which relate to a row (variable1) and colum (variable2) in another table. I want to be able to use the two variables in table1 to crossreference table2 to find the value in position...

I am writing a database which reads in data from a series of delimited text files. What I would like to do is show the user the files that are to be imported. I am using the file search property and I can get all my files and put them in my database but when I do a "For i = 1 To...