Search results

Thanks Tiro, I never thought about creating an Excel link to the dbf....this looks like it will work great. Appreciate the help!! Steve

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...

Thanks Mile and Marie, I will check out the help file. I did try compacting and zipping but to no avail. For future reference is there a better way to open/export a query from a form using the selected record other than the ApplyFilter command? Steve

Thanks Mile, My field was numeric so I made the changes and it worked great. I did have to remove the " at the end. As I am still learning this VB stuff, could you or some else explain to me why my first code example works and why I needed to make the changes to second example which only uses...

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...

Thanks IgorB...simple solution...my head must be in the clouds.

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

Rich and Fornation...I appreciate the help :) . Rich....that worked like a charm. Don't know why I couldn't figure that one out? Guess I should stick with the old saying "K.I.S.S." (kkep it simple stuuuupid!!!)

Fornation - Thanks. I gave it a try but keep getting a "Run-time error 438" Object doesn't support this property or method. Vb debug doesn't seem to like the pink line. Any suggestions as to my inability here (lack of skill not withstanding)? Here is what I used: zSurvInOut = main report...

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...

Len, your a life saver. Worked like a charm. I have been struggling over this for some time now trying to get the code right. This was much simpler. Thanks again, Steve

Still no go! I have been working on this some more and digging through the VB help but can't figure out what I am doing wrong with the code. I get a VB Error message saying "Run-time error '438' Object doesn't support this property or method" The code i am using is: Private Sub...

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...

Ahhhhh....now I see the error of my ways. That appears to have fixed the problem and everything seems to be working. Chewie and Shadez....thanks for providing this "novice" with a little help. Learn something new everyday!

Here is what I have placed in the OnClick Event: Private Sub Command58_Click() Function fCopyFile(Image1.eps As String, Image2.eps As String) Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFile Image1.eps, Image2.eps, True End Function End Sub Thanks, Steve

I know it has been a while since I put this forward this but I got pulled away on some more "important" projects. I am still having problems getting this to work. Chewy....when I place this on the OnClick event I get an error that the VB is looking for an expectant EndSub. Additionally will...

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...

I changed the code to the following: Private Sub Command58_Click() Dim fs As Variant Set fs = CreateObject("Scripting.FileSystemObject") fs.CopyFile Source, destination, [overwrite] End Sub This got rid of the syntax error but now when I run the code I get another Run Time Error 2465 saying...

When I set this code for the OnClick event I get a "compile error: syntax error" for the following "fs.CopyFile source, destination[, overwrite]" I don't know enough about this to figure out what I am doing wrong.:confused: