Recent content by kapaw

  1. K

    How to Export a query to Excel if Access file is read only(located on SharePoint)

    Yup, QBF2 is working fine. My only issue is exporting report since the access program should be in Read-only mode. I tried the code below(I added a title:Filtered Results) but I get the "Read Only Error". With db Set qdfTemp = .CreateQueryDef("Filtered Results", "SELECT QBF2.Vendor, QBF2.MPN...
  2. K

    How to Export a query to Excel if Access file is read only(located on SharePoint)

    Hi, I have an access program that is stored on a SharePoint site. I want to be able to export report to the computer even if I just open the access program as read only. Here's my code: Private Sub btnExport_Click() On Error GoTo btnExport_Click_Err Dim db As DAO.Database Dim strSQL As...
  3. K

    DoCmd.OutputTo: Store path location selected by user to a string

    What about the directory on which the user will store it? I want to be able to store that in a string too including the filename
  4. K

    DoCmd.OutputTo: Store path location selected by user to a string

    I am using this code with the OutputFile set to "" so the user can select the directory on where they want to store the exported template. My issue is I'm trying to figure out if I could get the file path and the file name and store it on a string so I could use it for something else.
  5. K

    VB Access Loop Problem: exits loop prematurely even if conditions are met

    Thanks spikepl! What's weird is I'm using the same format for my other listboxes and they were all working fine. X = 500 For i = 500 To intHighest If X <= intHighest Then lstIrated.AddItem (X) X = X + 250 End If Next
  6. K

    VB Access Loop Problem: exits loop prematurely even if conditions are met

    I am filling up a listbox and I have this code which exits prematurely even if conditions are met. Starting value is 0.1 dblHighest = rs.Fields(0).Value 'dblHighest = 3.06 dblDCR = 0.1 For j = 0.1 To dblHighest If dblDCR <= dblHighest Then lstDCR.AddItem...
  7. K

    VB Code: Replace Main Row if a part is Unapproved or Obsolete

    Help Please -> VB Code: Replace Main Row if a part is Unapproved or Obsolete I have an access table that I download from a specific site that looks like the one that I attached. The problem is the format of the table. I want to write a code that will replace the main row of the PART NUMBER if...
  8. K

    Track Changes made by Update query

    Is there a way to show all rows that was updated by an update query? I have a tblMCN where the data comes from a temp table. If the MCN is new it goes from temp table to tblLogs to tblMCN(using append query) then just updates the tblMCN using update query. My dilemma now is to show the users...
  9. K

    Highlight Items in a Listbox using a '>=' or '<=' button?

    Greater thatn or equal to a selected item on the listbox. Ex: If a user selected 1.02 and click '>=', 0.37 to 1.02 will be highlighted.
  10. K

    Highlight Items in a Listbox using a '>=' or '<=' button?

    I have a listbox that have a list of numbers: lstDCR: 0.37 0.45 0.56 1.02 2.05 5.67 I'm trying to create a code that will highlight numbers greater than or equal to when a '>=' is clicked(same thing with less than). Is there a command that will do this: lstDCR.Highlight?
  11. K

    Track changes using query

    This is perfect! Thanks a lot Ozturk!! I just changed and TimeStamp=a.TimeStamp to and TimeStamp<>a.TimeStamp
  12. K

    Track changes using query

    Sample: Board_____Part no____Timestamp______Description____Status abc_______123_______7/1/2011_______description____Approved abc________123_______6/1/2011______...ROHS______Approved def_______456_______7/1/2011_______...ROHS_____Unapproved def________456_______6/1/2011______...ROHS_____Approved...
  13. K

    Track Changes in a Table?

    I've been trying to figure out a way to do this one. I have a table where the first 2 columns can be the same on any rows provided that the timestamps are different. ex: Board_____Part no____Timestamp______Description____Status abc_______123_______7/1/2011_______description____Approved...
  14. K

    Track changes using query

    The date stamp and also the Approved/Unapproved column. Did I answer your question? I'm still a newbie with access.
Top Bottom