Search results

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

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

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

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.

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

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

Please help :(

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

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

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.

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?

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

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

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

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

That table is just a sample, :). It can also be just one line for the result, but highlight the filed that was changed. The Log table comes from multiple spreadsheets which is updated every week. So I need a query the will tell me if col A and B has any changes on their col C or D. Here's a...

Hi, I am stuck with this tracking problem, here is an example: Log Table A B C D E Apple W.Apple Approved Not Approved 7/19/2011 Apple W.Apple Approved Approved 7/4/2011 Apple G.Apple...

Hi, I have this code that's been working perfectly (DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, strCmbBOM, strFullPath & strFileName & ".xls", False). I'm just curious if I could add a feature that will be able to export a filtered table/query to an excel spreadsheet. I tried...

Oh wow, I didn't think it would be simple as that. I need a lot of common sense :D. Thanks!!!

Hi, I've been having a hard time figuring out why my query always shows up a parameter dialogue box with this query design: Build Date______ Weeks Left: DateDiff("w",Now(),[Build Date]) ______ Priority: IIf([Weeks Left]>7,"Low",IIf([Weeks Left]>3,"Medium","High"))...