Search results for query: *

I have searched high and low for a solution to this problem with no luck, although it seems to be a common problem. I have installed Apache server 2.0.59 and then Cold Fusion 6.1. When I go to view any .cfm file in the browser I just get asked if I want to save the file, and yet .html files are...

I have an Excel spreadsheet linked via data source to an Access database. The problem is that I have to painstakingly adjust all the columns to a particular size every time I update the data. Setting it to autofit is no use as some of the columns would then be too wide, so they all have to be...

OK, I am officially stumped and have checked the search (using above criteria produces hundreds of previous posts, none of which address this problem). I have an Equipment table and a Certs table with a one-to-many relationship - each item is tested and certified at six monthly intervals. I...

OK, this one is doing my head in. I am sure there must be an answer out there as it seems so elementary but I cannot get my head round it. I have a VB app that accesses an Access database. I want to pick the last 10 records according to date/time. This requires me to set up a query using SQL...

OK, this one is doing my head in. I am sure there must be an answer out there as it seems so elementary but I cannot get my head round it. I have a VB app that accesses an Access database. I want to pick the last 10 records according to date/time. This requires me to set up a query using SQL...

Is there some way of trapping the event when someone clicks on a tab to change the view in a JTabbedPane. I want the data being shown in the tab that the user is going to to be updated at this point, based on data in the other tab that they are just coming from. Have fun! :o) Alex Middleton

I currently manage several databases in Microsoft Access and wish to migrate these to Visual Basic stand-alone applications. I wish to do this because there are currently compatibility problems between versions of Microsoft Access that we do not require to have in the future. I would prefer to...

This is a recurring problem, which occurs sometimes and not others, with no apparent reason why. I have an equipment table and a certs table, linked 1 to many, ie each item can have several certs. I need a query showing all the items with the LAST cert for each item. This could be done by...

I don't know if anyone has come across this. I am using Access 97. I have a menu option for users to compact databses, as they get very large during use. It has always worked flawlessly in the past, i.e. on clicking the menu item the database compacts and reopens. Now, when they click the menu...

Well, I have tried and tried and tried! I am trying to export objects to another database but this has always produced an general error that causes Access (97) to shutdown. This is a known problem and there is a fix in the Microsoft Knowledge Base (Article Q160875) that gives code to delete the...

I have secured databases that are used by many users with different levels of security. A few users need Admins permissions so that they can add other users. I do not, however, want even these users being able to modify the design of any objects in the database. To prevent this I have...

I am trying to get a subform to requery after having enetred data into a pop-up form. I need certain data to be entered only when 1 category out of a number of categories has been chosen. The pop-up appears to prompt users to enter the data required. I want the form to close and then requery the...

I am trying to get a subform to requery after having enetred data into a pop-up form. I need certain data to be entered only when 1 category out of a number of categories has been chosen. The pop-up appears to prompt users to enter the data required. I want the form to close and then requery the...

I am trying to get a subform to requery after having enetred data into a pop-up form. I need certain data to be entered only when 1 category out of a number of categories has been chosen. The pop-up appears to prompt users to enter the data required. I want the form to close and then requery the...

I am trying to get a subform to requery after having enetred data into a pop-up form. I need certain data to be entered only when 1 category out of a number of categories has been chosen. The pop-up appears to prompt users to enter the data required. I want the form to close and then requery the...

Every now and then I get a message saying "MS Access has created an error and will be shut down (not sure of the exact wording). An error log has been created." The only problem is, I can;t find the error log. Does anyone know where these are found? Alex Middleton

I am new to Crystal Reports. I am experienced with VB, VBA and MS Access and have programmed many Access databases. In these I use the Access reports to print out certificates etc. I am now in the process of writing a front end for my databases but I am having a lot of problems with Crystal...

i am just wondering if anyone knows how to do this, if it is possible. I have a datasheet with 4 columns, one of which is a combo box with categories that can be chosen. When certain categories are chosen I would like the datasheet to display some extra columns that must be filled in. I am not...

I have a database that accesses a system.mdw file for security purposes and at present, if you want to log off and then on again as another user, you have to exit MS Access. Is there any way of doing this without leaving Access? Users do not have any access to the database window or...

Ha sanyone come across this error when programming in VBA before? The specific situation is where I am opening a recordset, e.g. dbs = currentdb() set rst = dbs.openrecordset(<table/query name>, dbOpendynaset) This produces: &quot;Error 3061 - Too few parameters. Expected 1&quot;. I cannot...