Search results

Hi all, I am sure that this has been covered before but I have searched the old posts and have been unable to find a solution. I am trying to link a dbf table to my database. The error that I receive is that "The Microsoft Jet database engine could not find the object...

Hi all....... I am having a problem that I am guessing has a simple solution. I am using some simple vb code on the "OnClick" event of a button to export a query to excel. Works great. Now I created a crosstab query based on the original query to summarize some info and want to export that...

Quick question -When I open a certain table two columns appear to be missing but if I create a query based on that table all columns appear correctly. I checked the table/column properties in design view but can't find the problem. Any suggestons. Thanks....Steve

I have a report that has numerous subreports. These subreports are based on different tables that may or may not have data depending on the type of survey. So for any given report, certain subreports are empty with just a header page. I would like to have a text box (txtNoData) become visible...

I ma having problems using the ActiveX controls in Access. When I click on the toolbox icon to access the controls I get a message saying Access has generated errors and needs to shut down. The tools work fine is Excel, Word and Powerpoint. I tried reinstalling just the Access portion but no...

I have been struggling with this for a while. On my form I have a text field that upon change sets (setvalue) the hyperlink for a file which worked great (or so I thought) but I couldn't figure out why the links weren't operating correctly. A search of this site revealed the error of my...

I originally posted this under the Forms discussion but feel that this may be more appropriate I have a database on map plots that users access from a network drive. Users have an option of adding a new plot record and I would like to have button that allows the user to select and then copy the...

Hi all, I have searched the archives for this but can't find exactly what I need. I have a database on map plots that users access from a network drive. Users have an option of adding a new plot record and I would like to have button that allows the user to copy the file from their local...

Hi all, I am having a problem with a lookup table in my query. I have table added that contains 20 columns with code values. I am trying to link those column values to a lookup table to return the real value for a report. The problem I am having is that in order to get the correct values to...

I have a question that I hope someone can help me with. I have a database of lake vegetation survey data. The surveys date back to the 40's and always methods for recording and logging the data changes. The current table format has a single record for each sample station (total number varies...