Recent content by troutusa

I just tried using the Ribbon to open the Preview and Print the report. The report opened and printed without delay. The problem is trying to control the report from VBA. I use a command button and the following code: Private Sub btnPrint_Click() DoCmd.RunCommand acCmdPrintPreview End Sub...

There is some code in the report, but I added "debug.print 'Begin/End [section name]' & Now()" to any code. The timestamps in the immediate window indicated that all code was executed in less than a second. What I did try was to use the Ribbon commands to open the Print Preview, and to Print...

The print preview page displays instantly. I can scroll page one, but I can not go to page 2, close the print preview, or print the report. (I use a command button on the report that runs the following: Private Sub btnPrint_Click() DoCmd.RunCommand acCmdPrintPreview End Sub I just tried...

38 records in data source query. Query runs immediately. There are 2 unbound controls with calculated data. The data is the full path name, and the version. (I added debug.print to the code with a time stamp for retrieving this data. The data is pulled in immediately according to the start and...

I have a report in access that when I open it up, it opens quickly as expected. When I try to print preview or print to a printer, the report takes way too long to print. (20 minutes or more before the report prints and access responds to mouse clicks.) I am wondering if there is a way to find...

@mike60smart I've tried to add in Effects form. I'm working sfrmSongEffects. I want to include a NotInList procedure to the cboPreset control. The form does what I want but gets stuck in this endless loop of adding the new Preset. (The NotInList keeps getting triggered because the list is not...

Thank you for that clear explanation. I see what you mean. I am sure my problems with the forms are due to my table structures. If I normalize the data properly, the forms will just be bull work. My biggest problem is that I need the brand and VST details for each track, but they are dependent...

This look really good except for assigning the tblPType_Name in the sfrmPreset. I tried to change it to a combobox and add tblPType_ID to the subform's query. Access would not allow me to use a combobox to make a selection. I think I know a way around this. (Add an unbound combobox under the...

But I need the supporting data to help find the Preset, I also need to save the VST_ID with the Preset_ID as Preset_Names can be duplicates.

@mike60smart Unfortunately, it still presents the same problem. The form is trying to update records that should be read only and, in the end, creates a record with duplicate PKs that prevent a record from being saved or changed. I'm thinking I just connect sfrmTrackDetails with frmSong for...

Yes. I can filter out "Effects" presets for sfrmTrackDetails and exclude any presets that are not "Effects" for sfrmTrackEffects and sfrmSongEffects. I only need the details from tblTrack displayed here, but each track includes at least one Preset. (The join table tblTrackPreset takes care of...

@GaP42: Current Progress I added forms to add the supporting data and created a Splash screen. The supporting data forms still need plenty of work, but they were sufficient to enter a great deal of supporting data. I thought a few days away from frmSong might give me some new perspective. My...

My goal is to store the settings only. I need to know the presets and the track information. I can back up the midi events digitally. I've experienced loss of information in the past where I don't know the preset for a track, or all the presets for a song. Having this documentation helps me...

Track has: 1. Order Number 2. Name 3. A Type (Instrument, Controller, Sound Clip) 4. A Preset 5. 1 or more Effects Preset has: 1. Name 2. VST (the program that generates the sound, or sample collection name.) 3. Brand (The creator/seller of the VST) Note: It is important to know the VST and...

I have not been able to link the Presets with the Tracks. I have a number of presets, VST's and Brands loaded into my DB project. I also have songs and tracks. I just can't link the tracks and presets together. I have posted a sample of the DB so far. See SongDB v82.zip attachment in previous...