Search results

Hi Arnelgp Thanks for the reply and pointing that out. The data is pulling in but as before it is pulling in the entire record source and not the filtered data. How do I go about that?

Hi all, I have a form, with subform as datasheet. I have successfully exported filtered data on the subform to excel. Ultimately I want to export the filtered data into a mail merge and selecting a template stored somewhere on a network drive. But first I am trying to perform a simple task...

OK I have this working but I cannot see why my previous delete method was not working. I created a Delete query on tblMain with criteria under the ID field [Forms]![frmDistributionAddEdit]![ID] Behind a command button on my edit form, I called the query DoCmd.OpenQuery...

Hi all, I am weary using the cascade delete and update options in a relationship, but I had tried it earlier and it made no difference. I have come across this issue before if I deleted a record from a table on the "One" side, in that particular case I deleted the from the table on the...

Good morning all, I have a form which allows me to delete some records from it but not all of them, with the latter producing an error 3200 The Record Cannot Be Deleted or Changed because table "tblMain' includes related records. My database structure consists of 3 tables, with tblMain on...

Ripped and modified from another site but stick this behind a button on your main form. Ensure you have Microsoft Excel (x) Object Library added in the VBA (Tools) References Dim rs As Recordset Dim intCount As Integer ' Create the Excel object Set ExcelSheet = New...

Well that can go out the window with my brain!

Thanks for the replies! Ranman, copy and past works, but it is not ideal as the formatting is all over the shop where as a direct export has them neat. I'd like to refer back to your qsqry1. I never heard of that before. Is qsqry1 a control on the form that is built as I filter...

Good afternoon all, I have built a DB with a series of forms and I am looking to output data to excel. I have a main form containing some buttons and a subform which is a datasheet. I can filter the datasheet using the datasheet filtering properties. However when exporting that...

Thanks Spike, your reference to my text property twigged it. I removed the setfocus lines from behind the lstbox afterupdate event and referenced the text box .value properties rather then .text property. Cheers

Hi RanMan. If I click debug on the error it highlights the row where I fill the text box txtAcode.text = sPopulate or txtISIN.text = sPopulate The text box is populating with the required data selection but the error appears after that. Should I give the focus back to the...

Hi all, I have created user input form and to help with ease of input, I have decided to pull records in to a list box, user selects an item and the item updates to the bound text box field. The textbox populates but produces an error and I cannot continue unless I clear the text box. run...

UPDATE: The above code does not cater for my "AND" statement if I am dealing with multi criteria For each combo item selected I have included AND - The criteria changes for each Combobox sRowAddition = sRowAddition & " AND ((tblMain.A_Code)=[Forms]![frmMain]![cboA])" Following...

I meant to ask, you said there was a sample db but I don't see it. Do you have a linky?

Good morning PBaldy, I have decided to loop through all comboboxes on my form and identify the name and if the value is not isnull. This works perfectly, but I still feel it is overkill, it is what the user wants, as an option I will also put in a textbox and loop through the recordset and show...

Hi Pbaldy, thanks for your reply I was thinking along those lines alright, using an If statement, but I should of mentioned I have 7 comboboxes on the form! That would be a lot of SQL combinations, based on true or false values across the 7 combos Is this what you meant? Cheers

Hi all, I have a listbox on my form which initially pulls in data using a query as it's rowsource. To help with filtering, I have put numerous comboboxes on the form. The comboboxes are populated using data in two other tables. Once a selection is made, using the SQL in my query mentioned...

sorry... Final check - generally speaking, as in final part of a process or procedure

Thanks for the help VBA. It is user preference that the final check cannot be set until other conditions are met. I have read a few forums with the exact same issue, and the recommendations is to use a text box with code behind the on click event. I'll post up how I get on Cheers!

just spotted the enable / disable button in CF..... that will work for your standard controls, however CF is not available for Checkboxes. I'll keep digging