Search results

Found a solution. With a small adaptation to my existing SUB, the problem with the gray data display in Excel.xls was solved. Everything is nice and black! Sub 'Ausgabe PDF DoCmd.OpenReport strReport, acViewPreview, , strWhere, acHidden, strBez DoCmd.OutputTo acOutputReport, strReport...

I have a general query, which is then output to the individual reports with the where condition. my query: SELECT AgeAktuell(tblMitglieder.Geburtsdatum,tblMitglieder.Austritt) AS AktAlter, AgeLJahr(tblMitglieder.Geburtsdatum,tblMitglieder.Austritt) AS LJAlter...

I prepare the data using a report (with the appropriate WhereCondition), which I can then export either as a PDF or Excel.xls. I just had to change the acFormat (acFormatPDF or acFormatXLS). In the Excel file the fonts are displayed quite gray. Is there an explanation for this? Sub...

Many Thanks, works wonderfully :):):)

I want to increase the seconds display of a DateTime field by 30 seconds. I dont get any further. My update query is not working: "UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + (second(DateAct)+1) where IDMit = 2;" Where is the mistake? Thanks for help

Excuse, here is the code: Private Sub cmdCopy_Click() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("qryMitglieder", dbOpenDynaset) Dim strNeueMitNr As String Dim strNachname As String Dim strStrasse As String Dim strOrt As String strNeueMitNr =...

Thanks for the information. I found out for a recordset method and found the following code and adapted to my needs. A new data record is created, but the first is displayed when I close the form and open again. What is missing in the code? Please help!

No ribbon menu, I'm looking for something in VBA.

I created a small MySQL database for our club using Access 2021 via an ODBC connection, which also works well. I manage the members using a simple form. If I now create a new member and the following member has the same data. Only the date of birth and first name are different. I just want to...