Search results

How about using the network path in your table links rather than your mapped drive letter? So \\servername\foldername rather than its mapped letter... Never a good idea to have multiple back ends, unless one of them is a backup of course :)

Thanks for looking everyone - Bob's is definitely the more logical way to go, over mine, obviously.... I did have a bit of a brainwave about making Dir pick up where it left off, by calling it again into another variable, then when I returned to the original instance of the routine, comparing...

Does anyone know if it's possible to move the 'pointer' when using Dir() so that it skips the first n files it's supposed to return?

Ah that one just declares the array so I can use it in another routine

Afternoon all!! Hoping you can point me in the right direction here.... So - I've got this bit of code. It's supposed to read the paths of folders and subfolders into an array, which I'm then going to cycle through with another Dir command to find MDBs and compact them. The process is: Call...

Good point spikepl :)

OK then - probably the best thing to do is read up on the Dir command in VBA, have the user enter the path of the DB and loop through the contents of the folder, adding MDB files to an array, which you can then use as the rowsource of the listbox: Public Sub ListBox_Files(Userpath As String...

You can repeat the UNIOS statement as many times as you like, I think... Your second question talks about parameters but "Between [begdate] and [enddate]" sound like criteria... just put this in the SQL statement after the FROM line in each query, as inWHERE tablename.[posted date] between...

As in post 2 above :)

I don't really understand your post but I'm assuming that's something to do with primary key violations in your table. Can you upload the database so we can have a look?

That would make the combo box blank, not display all the countries.

OK, so what you need to do there is create a field in your activities table for the comments, and have a text box bound to that.

OK. Firstly, add the descriptions to your activities table, that the listbox is looking at. That should sort that out. When you're storing a record of what the activity is and how long it took, you should only really be storing the activity number, start/stop time and duration, rather than...

Couple of questions about structure before we start on the importing business - how come there are so many databases? Does the data in them change regularly? The reason I ask is that I immediately thought of having the tables themselves stored centrally and having links to the tables in your...

I think what I'd do there is have the option group update the combo box's row source, i.e. change the query. What you'll need to do is Set the option group up so that "a" is 0, "b" is 1, etc. Put this in the group's on click:Dim Letter_ASCII as integer, Where_String as string Letter_ASCII=...

Could you upload a stripped out DB so we can have a look?

The Shell command allows you to run programs in VBA, maybe you could use that to run SeeIt before printing starts?

So there's a users table in the database? Has that got thr right permissions, as well as the form?

I usually use a for loop in VBA to do this kind of thing, although I suspect there will be a more efficient way:Sub Append_Questions() Dim LONumber as integer docmd.runsql "DELETE * From Questions;" For LONumber = 1 to dmax("[LO Number]", "Questions") docmd.runsql [insert sql from append...

Do you mean that you want to have a text box to show what's selected in your listbox? I think you just have to create the text box, and in its control source put =listboxname.column(x)where x is the column number starting from 0. So in this case x would probably be 1.