Search results

I am trying to delete a file Text.txt, if the file is open it will return an error and skip the delete command. My error trapping is set to 'Break on unhandled errors'. x="C:\Text.txt" On Error Resume Next Kill x On Error Goto 0 I am boggled at why this doesnt work. Any ideas?

Hi all, I searched the old threads and found this from 2009. I am trying to change the source connection of a linked table through vba. This one is currently set up for an ODBC connection, but the whole tdf.connect part to change which MDB database to use on a network is right over my head...

Hi All, Im trying to convert a value like 8/31/2012 2:36:14pm into just seconds. Any suggestions? Most what I find in google only tells me how to convert the hours and not the date as well. Thanks

Hi all, back again. I'm trying to get a small sub to show all the currently open workbooks. I copied this excel code I found through google, is there a quick way to modify it to run with access, or maybe there is a snippet I couldn't find buried on this forum using the search function...

Just found out about FSO while looking for ways to import files names from folders/subfolders into access. and I wanted to know if it is possible to change the Debug.Print fl.Name to populate a table with the results instead of populating the immediate window. (I did add the required Microsoft...

The sheet number 2 is constantly made with different names and I was wondering if the transferspreadsheet command would be able to pick out data by the sheet number instead of the sheet name. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Tbl_EXCELDATA", "MyFile.xls", True...

I am trying to get a query to show all records if Field1 in Form1 is blank. However the results are either: I will get proper filtered results when Field1 is not blank (ok good) OR when it is blank I recieve everything except records with null values (@#$%). Am I missing something? Thanks for...

I am using a button to retire a product. I am trying to make it so that the SQL will retire the product depending on which one the user is looking at on the form using the autonumber as the primary key. I recieve a data type mismatch error when I attempt to run it. Any suggestions on what I...

What would the report equivalent to : Forms!Frm_Qry_Tbl_AcessTable!Field01.Caption = "New Caption" I have tried something like: Reports!Rpt_Qry_Tbl_AcessTable!Field01.Caption = "New Caption" on an open report, but can't seem to get the label caption to change. Majority of code...

I have been using this line of code to dynamically update label captions for my database. Forms(strFormID).Controls(strLabelID).Properties("Caption").Value = strlabelcaption And I was curious if the same could be done for reports as well. I figured one way to est would to use the code below...

I'm using an integer to store specific record number I was my code to jump around to when analyzing data in access. I am changing and storing the value for the record number in 'intCounter'. However access does not seem to like this. Is there a different tecnique I should use to ge this to...

Rather than make a seperate query to have a combo box dynamically show results, I figured I would give it a try to just put the SQL code into the combo box itself. SELECT Qry_Tbl_Measurements.[Referance] FROM Qry_Tbl_Measurements WHERE (((Qry_Tbl_Measurements.ProductID) Like...

Now I know you cant directly change the data-type for the BE table from the FE sections. However is it possible to use the FE to open the BE DB, access the BE Table with the field type I want to change, and then change it? Even if I were to have some code in the BE that I would send data to...

Im trying to get a parameter for my query to show all data in a query if a combo box is selectd with 'All', however if any other value is selected (numerical) I want it to show the data that is only between that selected value +- 30 each way (threshold tolerance). Any idea on how I can fix...

I am using: Forms(strFormName).Controls(strFieldLabelName).Properties("Caption").Value = Me.New_Field_Label_Caption To change the caption of some labels. The code works fine so if I run it then open the form, the label has the proper new caption, however if I close and reopen the database...

strTableName = Me.Database_Table strFieldName = Me.Table_Field [Forms]![" & strTableName & "]![" & strFieldName & "].Visible = Me.Visible How do I get these string to work in this setting? I feel like I'm missing something real simple.

I have an adobe file that I constantly 'print' from access so that the most resent data from a report is available. This file stays open all the time (to be displayed on a projector) until it has to be reprinted. I would like to be able to put this on a timer so that the file will close...

Here is my issue. Attached image is a mock example of what I am working with. A user will select a product to review (Example is product F-12). The subform will fill with all of the pieces that were used to make this process. Now if the user wants to review all pieces in say Step B they will...