Search results

Hi Paul. Yes, I'd developed the solution before your post. Pat. The process is that the User selects the data that they want then pastes it into the table. It is then used and edited from there. This is a selection process. the data is imported from an excel file into Table1 it is filtered and...

I figured out a solution: I have a command button on my split form called append data. Once the User has filtered as required they press this comd button to append it to the new table (represented by FORM2 Private Sub Command483_Click() DoCmd.GoToControl "ID" DoCmd.RunCommand...

I have a Split Form (Yes yes I know !!) I want the User to be able to filter the data and to then press a command button to append that data into another table. At present they select all, copy, open new table and paste. How do I apply the Split Form's data into VBA? My initial thought was...

Hi Ridders That's not what I'm looking for. The field could be blank. My solution was to put my code into everyfield's lost focus. This is how people select the records (in the datasheet part of the split form). It works but a bit long winded.

I wish to make a field compulsory by using the lost focus (unless there is anothe solution of course) I open my Split Form to the first record. I also have a Tab field set to Tab Order 0. This takes the focus away from other fields. I have a few lost focus on certain fields which work fine...

Thanks Arnie I was hoping for an easier solution tbh. The ADO route is a little our of my leage. Thanks for the message though.

I have a datasheet sub Form. What I am trying to do is have a radio button that allows be to select certain records then press a button to append the selected records. There is no data field in the underlying (Query)Table. If I select a radio button then all of the records are selected...or...

My solution was to copy Form1 change the data source and rename. Must have just been a glitch !!!

I have two forms. Both are datasheets. Form1 is based on a Query. Form2 is based on a Grouped Query. Form1 has the following on load: Me.[Field1].ColumnWidth = -2 Me.[Field2].ColumnWidth = -2 Me.[Field3].ColumnWidth = -2 Me.[Field4].ColumnWidth = -2 Me.[Field5].ColumnWidth =...

Bugger !!! The thing that throws you is that it is consistently sorted in the same (as you confirm) way. That's like shuffling your cards and getting the same random result everytime Thanks Plog

How does a Report sort it's data in the absence of any report sorting (seeing as it disregards the underlying Query) ?

I think that the only way forward would be to implement an If statement somewhere!!! If Pat's solution is invoked then open the filtered/sorted Report however if Pat's solution isn't invoked then open a report that is pre filtered/sorted. Does Pat's coding give us the ability to flag the If...

Ridders this is great stuff. I appreciate your time and patience greatly. This isn't the solution that I wanted. I'm flabbergasted that there isn't a simple solution to this. What you see is what you get scenario. My solution has been to create two buttons. This is not ideal but works in the...

Ridders: I found this but can't make head nor tail of it. Is there a way we could incorporate this ? Bear in mind that the sorting is not just A-Z but could also incorporate numerical formula eg less than etc

Morning Pat (well it is here !!!) There is no save option once the user has viewed the report. They either print/save to file or close. I'm a little unsure how to implement the where argument in regard to opening the report. My current get around is to have two buttons: If no filters or...

FFS If Me.field1 = Me!Subform1.Form!Field2 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Need to reference a control that is on an unlinked subform. Cant get this right ! If Me.field1 = Me!Subform1.Form.Field2 Then Could you help please

Ridders: Im struggling to understand your solution. I tried this in the OnClose of the Report: Me.Filter = "" Me.FilterOn = False Me.OrderBy = "" Me.OrderByOn = False To no avail. Is there anyway to implement an If statement somewhere that defaults to the openArgs specified...

Hey Guys I had neglected to add the Me.Filter to Pat's code. The open report line in #13 should read: DoCmd.OpenReport "rptTESTsorting_Members", acViewPreview, ,Me.Filter , , vSort There is just one issue. When I close and reopen the database. If I do not select any filters or sorting and press...

Pat fantastic work. This works, however the ability to filter has now been lost !! It would appear that we can only either filter or sort !! (seeing as the vsort has replaced Me.filter within the open code) Any further suggestions