Recent content by Jason

Perhaps there is a control that somebody knows that would allow me to do this?

I have a list box that presents around 200 lines of information. However my application dictates that it would be far easier for the user to scroll horizontally than vertically. I want to have the list wrap from column to column with a set height. That way the list would grow horizontally, (with...

Nope, no luck yet... :-( Anybody else hae any ideas??

Thanks David, Cool Site! However the file (soa900.dll) is the same version that I have already and that is the one with the problem in it, (installed with Office). I have mailed Microsoft to get the Patch for this particular issue in A2K so we will see what they come back with, (I should hear...

Hi All I am having problems with the export to excel function within Access. It is truncating my memo fields to 127 characters. There is a Microsoft Article about this but it does not offer a definitive answer apart from asking me to contact a MS representative, (for a fee). I know that I need...

M2J Fornation was right, the date gets exported as a system date. All that you need to do is select your entire column in Excel and then set the format of the cells to date. Unless you do it in code, (opening an instance of Excel from within VBA in Access and then doing the formatting behind...

Thanks a lot... I will distribute the mdw file with the FE and make sure that the combination of the two contains the correct groups and users (mdw) and permissions (FE). I suppose that I could leave the mdw as shared on the network and just make sure that the FE permissions are up to date. At...

Hi I have set up a reasonably complex DB with the BE residing on a NT server and the FE on each clients computer. I have implemented full security and have several user groups and around 40 users. My workgroup file is on the server and everybody has a shortcut from thier workstation which...

I found the solution... http://support.microsoft.com/default.aspx?scid=kb;en-us;Q302411 Jason

I have worked the problem back through the queries and have found that the Data Access Page will not display calculated information when the query, (or one that the current query is based on) has used a LIKE criteria expression, (something like "LIKE "*JOHN*"") to filter the data. I dont know...

I am assuming that Quick Doc is a Access DB with both the Front and Back end in one DB File residing on the Server, with users opening that file concurrently. I have found similar problems in that type of environment. There are a couple of ways around it. 1: Go around to each computer and make...

llkhoutx Thanks for the input, I could do this if I was scrolling through the records one by one on the Data Access Page. However I am trying to represent the information in a table type layout, (more like a continuous form) for viewing and copying purposes, (I want users to be able to access...

Hi there All I am trying to display the results of a query on a DAP. The page seems to display all fields that are taken directly off the table with no problem, (things like Categories, etc, however whenever there is a calculated field, (IE InField: [AllOut]-[AllIn]) then it seems to replace...

Thanks a lot, I will take a look. Jason

Hi all Does anyone have a decent sample database or some code that utilises the TreeView control?. My data is higherarchial in nature but I am having only limited success with the TreeView control although I know that this is the best way to go. I specifically need to be able to dynamically add...