Search results

Gasman, why would you suggest hour argument to add a day? Oleynek, how does your non-VBA solution create 6 records with various date/time values? Why would you need triple #?

Yes, VBA using a loop to save the number of desired records. Want to provide database for analysis? Follow instructions at bottom of my post. Would make it easier to provide code specific to your db. Tricky part is determining what times of day to use for the frequency of daily doses. How is...

Did you mean "unsatisfactory"? You want to screenshot that limited area of the game board? Programmatically taking a screenshot of Windows frame is complicated enough (search topic "Access VBA screenshot"). Grabbing a segment of window would be maddeningly complicated. Agree with Doc, open...

Why use Recordset? Why not just set RowSource with SQL statement?

If Isladog's SQL works, then some of those 4 fields have Null and some have empty string. Again, don't need fields in the DELETE clause, don't even need *, just: DELETE FROM myTable WHERE...

No need to list fields because entire record is deleted, although shouldn't hurt. DELETE FROM mytable WHERE ... If you want to provide db for analysis, follow instructions at bottom of my post. I don't allow empty string in fields so don't have to deal with. A blank field would be Null or...

Sorry, don't know how I managed to post one of my bad attempts. I have edited the post to correct.

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.