Search results

Really should provide sample data as text tables or attached file, not image. Can't copy/paste data from image. Records in tblCrosstabHeading: CrosstabHeading BeginDate EndDate AOwner SELECT tblLeoM.Subsystem, tblLeoM.Owner, tblLeoM.STARTING_DATE, tblLeoM.ENDING_DATE...

Why not use DHookum's suggestion as expanded in post 13? Although, I would use underscore instead of hyphen. Also, prefix Owner with something that would alphabetically precede Begin (1_AOwner) or allow it to follow the date columns. If you need more guidance on CROSSTAB, review...

For your subforms, review https://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp

Even a CROSSTAB query is limited to 255 fields in output. If you could have more than that, will need a more creative and elaborate procedure in Access or possibly export data to Excel.

I upgraded from 2010 to 2021 last year. I bought Office 2021 Pro Plus from a 3rd party for $20. I don't quite remember how the install went with regard to Outlook but afterward I apparently had option to run New Outlook or revert to Old Outlook. Both show as available apps. My existing code for...

AFAIK, New Outlook cannot be automated. Is New Outlook your default email? I don't use New Outlook at all.

Why does keyboard need to be changed - again - what happened? By broken monitor, you mean it no longer displays anything? Replacement display in USD starts at $51.95, add cost of battery/keyboard (first and second time around) and SSD upgrade - at some point cost of maintenance exceeds cost of...

Strongly advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.

Wouldn't need to do that if you upgraded Access. OutputTo method can create PDF. Upgrading can be cheap. I bought Office Pro Plus 2021 for $20. Do you really need to stay with 2003?

Yes, Doc meant multi-value field.

You say an employee will only ever have one training. Linking Questions to TrainingTypeID instead of TrainingID is not conventional and source of difficulty for data entry. Employees link to Trainings but their Responses are linked to TrainingType. You want to enter data for each Training but...

If you retain punctuation/special characters just keep in mind that MUST use brackets around names in queries and many code situations. I agree that the form/subform arrangement makes no sense.

As noted by Gasman, controls used to enter search criteria must be UNBOUND - otherwise you change data in record.

Switchboard form is opened ReadOnly - combobox (or listbox) won't work because this is "data entry" even if not BOUND. Same as not able to type into textbox, form is locked. I tested with my form.

I have never used combobox Click event, I use AfterUpdate. However, likely that won't make a difference. Have you step debugged? Is event triggered? Is combobox Value getting selected item? Could provide db for analysis - follow instructions at bottom of my post.

The_Doc_Man, I have no problem opening form and table at same time.

Why does subform "jump around" - what code is behind control where you type check number? Is this an UNBOUND control?

So txtPayment and txtReceipt are controls (textboxes) NOT fields.

Then what are you referencing with frm.Payment and frm.Receipt? Select Case shouldn't be needed. Pass -1 or 1 as an argument and multiply. Pull field name from passed control name or pass field name as argument.

Need quote marks? - "txtPayment" Also: Case "txtPayment" Since function RetAmt is not actually returning anything, why not make this a Sub instead? Why pass control and not just control name as text since you don't actually manipulate control, just using its name?