Search results

You can use MkDir("C:\" & Format(Date,"dd") & Format(Date,"mm") & Format(Date,"yy") & "filename and extension") to get the result you need. JonH.

Hitching a ride on this thread. JonH.

Try this Ewan, MkDir ("C:\New Directory") JonH.

It sounds as if the problem lies with your email software. Maybe you need to amend the default profile or set up a default profile that your email software will use automatically. JonH.

Here are at two ways of doing this. You can use the Timer event in Access to check the system time and run the code at midnight each night, after running the code you can close the database with DoCmd.Close but you'd need to open it up the next day to run that night. Likewise use a Timer to...

Don't know any but thought I'd hitch a ride on this thread incase someone knows of any. JonH.

Do you have and mde file or an mdb file? If you have an mde file then you need to obtain the mdb that created the mde as I don't think there is a way to amend forms in an mde. JonH.

The ldb file shows the host name of the workstations that have logged in during the current ldb session. If you have a map or a list of where all your machines are or who sits at each machine then you can ring around the users who are listed. Note that just because a machine is listed in the ldb...

Do you get this error if you log on at a PC other than your own or is it just other users who get this error? JonH

No doubt you've already checked this but is there a folder on C: called 'Document Set'. JonH.

It sounds as if you've set the default database folder to your Y drive. To change this open Access, select Options from Tools at the menu bar. select the General TAB and change the default database folder to a valid drive. JonH.

I'd use a VB frontend with an Access backend. Also don't use Data Controls but use DAO/ADO instead you get far greater control over the connections to the backend and therefore are only using the Access backend when you have to. Jon.

Try removing the semi colon fom the end of the SQL string. Jon.

Using SQL you can access another mdb e.g. Dim dbs As Database Dim rst As Recordset Set Db = OpenDatabase("U:\My_Database.mdb") Set rst = Db.OpenRecordset("SELECT * FROM tblPost") This puts the query results into rst I don't know of a way other than this I'm sorry. Jon.

I have a set up like you describe and performance isn't affected at all. One of the major benefits I have found is that the VB frontend leaves a much smaller footprint on your worstation using only 1% of the CPU rather than the 95% Access used. Jon.

You can set the links on the mde file at any time. It will save the link setting even as an mde which you can then distribute. Jon.

Are you querying via SQL or using queries direct from an mde?

I've read 255 users but I've also read 16 users. I think basically the more users you have the less stable Access becomes. We ran a db in work with 20 users satisfactorily and when the unit was increased to 50 users saw performance and locking errors increase dramatically. Jon.

You should be able to use the Change event which runs each time the control changes - Private Sub TextBox0_Change Call NotInList End Sub Jon.

OnOpen will work but only once. If you set a Timer event and then an If.... Then statement that checks the System Time and runs the required code/query if the If statement is satisfied. It will run at the set time every time. But with the stability of Access I wish you luck. Jon.