Recent content by Butch

Hi, I have developed a small database with 3 or 4 forms which works ok on most PC's. But when I put it on a certain PC, it almost works properly except for one form which is very slow accessing the table! Eg. It could take 2 minutes to use a combobox. All PC's have Access 2000. Would there be...

could be up tom 50 but not all concurrently!

Hi, I'm have a database and I'm going to split the database so I can have multiusers. But how many users can access this database? Is there a set amount of users that can access the database at one time? Thanks in advance

Hi, I am incrementing my autonumber with vba because it is part string and part integer. eg.ABC001 And this works fine. But now I have to change the lettering of the string part of the autonumber. I'm using the DMax function. But once I change the letters in the string part, everytime I add a...

I developing a crosstab query. But the query,(query A), it's pulling the information from has criteria under the 'date' field. The criteria is: >=[forms]![frmDateRange]![txtStartDate] And <=[forms]![frmDateRange]![txtEndDate] and this works ok in 'query A'. but when I design a crosstab query...

I developed a database with access 2000 on windows xp. But the company I developed it for is having a one problem with it when running it on windows 98. I have a function that calls the 'windows file browser'. This function works ok with windows 2000 upwards but with windows 98 it comes up with...

That worked perfectly. Thanks for your help!

I tried that sql code with the extra space and CDATE function but still having my original problem??

I never use the 'QueryDef' function. Could you please give me an example?!

I'm having a problem with my code. I'm looking for dates on a table and open a form after, so I use this SQL statement to extract the dates. DoCmd.openForm "frmJan" With Forms!frmJan strSQL = "SELECT * FROM [tblKevin]" & _ "WHERE ([entryDate] = # " &...

MS Outlook Express is set as my default. I'm trying to link my database to it but it keeps looking for Ms Outlook instead. Is there a way of linking to Ms outlook Express???

I'm using the 'Richtext' control to format my data in an access db before sending it as an e-mail, but when the data goes into to Outlook it look like this .... {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}} {\*\generator Riched20...

When I open a Treeview on another Pc it has the nodes placed all over the treeview. When click on they works ok but they are gone crazy!! is there a reason for this?

I'm not sure which MDAC to use?!

There are no IT people in these places! How are these logon scripts written or where can I get information for this? Thanks