Search results

Hello AJE, I was able to get in contact with Lister. I attached a sample of my db in a new thread if you want to check it out. Thanks alot for all the help on this. brsawvel http://www.access-programmers.co.uk/forums/showthread.php?t=137205

Hello All, I appreciate the help on this. I've been asking a lot of you for help on this and some have asked that I attach a sample of my db to display what I'm dealing with. Just a basic explanation of the db. frmListedAM contains two listboxes (overlapped) and a cmd button...

I tried sending this message to Lister, but it's too long....

can you create commands in access that will send records to a pre-designed .rpt file?

I stole it from "the scripts" website. That part works for my application, but what I ended up doing for the issue of changing from none to multiselect is I created a hidden listbox with all the same columns. So when I click the command button, it will draw from the hidden listbox and put it...

Hello, Easy question. If I'm gathering records through a query rather than directly from a table, is all my code going to read [qry1].[fld1] instead of [tbl1].[fld1]?

Ok, so I was able to find a code that selects all fields in a listbox - For i = 0 To Listbox.Listcount = -1 Me.Listbox.Selected(i) = True Next i But, in order for that to work, the MultiSelect has to be in Extended or Simple. I have the default of the listbox MultiSelect set to None, and would...

ahhhhh..... is the code you show the needed addition? brsawvel <-----New at Access, VB, and SQL

I've seen that example before, but it isn't quite what I'm looking for. It's close though. Lister has his(her?) set up to generate a report based on selections made from a listbox. Mine isn't a "multiple selection" type. I'm looking for mine to generate a report based on what appears on the...

you're right. I don't have an actual "query" that I draw from. Sorry about being vague. I have a few buttons where, when one of them is clicked, the listbox records change because I've written an "On click" command that overrides the original rowsource. (example): Me.listbox.rowsource = SELECT...

Hello, I have a listbox that displays records drawn from a query (so the records aren't always the same, although the table drawn from is). Is there a code to cause a "Create Report" button to send the records displayed in the listbox to a report for emailing or printing?

I figured it out. I have to have the subform visible first before I can click on one of the fields in the listbox.

I tried setting up a mirrored "After Update" but got the following Error (91) on my database - Object variable or With block variable not set. I used this code: Private Sub List55_AfterUpdate() Dim rs As Object Set rs - Forms!frmAM!subfrmDetail.Form.Recordset.Clone rs.FindFirst "[AssetID] = '"...

HC!!!! Thanks Alot! That was it. I really need to find a class where I can learn SQL and VB.

I'm assuming the failure on the last command I showed is in the "ORDER BY [tblam].[fldLocation]" because when I copy and paste the original rowsource into the button's "onclick" event, it looks as if it requery's rapidly (flicker) and the table comes back the same.

PBaldy, I really appreciate you helping me on this. It is driving me crazy. I attempted the Debug.print on the code, but I'm not sure if that was supposed to send a report but nothing happened on click except what has been happening (listbox goes blank) This is the original rowsource...

Hello Epic, I attempted your first code above on my listbox using a command button above the listbox, but when I click the command button, the listbox goes blank. Would you happen to know why? brsawvel

I know it isn't right since I got an error, but I wrote the following: private sub command7_click() DoCmd.RunSQL (OrderBy(tbl1.fld2)) End Sub Am I close? This is to order a field I designate in the statement (not necessarily the pk) in a listbox. Edit ************** I also tried using this...

Hello, Is there a way to create a Me.OrderBy command for a field displayed in a listbox?

I like what you came up with OldSoftBoss, but now my next question is, is there a way, when you select a record from the list box (when it is a subform within a form) that it would open the data in a second subform? frm1 - contains subfrm1 & subfrm2 subfrm1 - listbox subfrm2 - detailed box