Search results

The OP hasn’t posted enough times that would allow him to attach a file.

I always specify the target fields as suggested by (and works) arnelgp. You might find some additional clarification about using all fields at https://www.w3schools.com/sql/sql_insert.asp

If you want to "send" a value from the first form to a newly opening form, you can use OpenArgs in the DoCmd.Openform method. The sent value can be used in the new form's On Open event to set the value of a control. I'll leave it to you to search the web for OpenArgs. If you need to determine...

"thick" = "width"

You can use the Circle method of the report object. In the example below, I have a text box named Eggs with a numeric value. I want to draw a red circle around the value if it is less than 50. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) If Me.Eggs < 50 Then...

wrong thread?

Can you create a query with all of the information other than the days by week which would be a simple date field? Looking at your relationship diagram, I'm not sure where all the data comes from. Does the data have a value stored that identifies the order of the actions and challenges?

Congrats on getting the first question to work. I’m not sure why the bold but it would be interesting to know if this was bold in a printed or to PDF report. A possible cause is code or conditional formatting. I’m away from home/PC for a couple days so I can’t look at your new question.

Every user must have create, edit, and delete rights in the shared folder. Can they all create and then delete just a Notepad file in the folder? I trust your shared folder is not Sharepoint or similar.

MediocreD, Does your application code compile?

Are you using the same data on all computers? I would need to review your data to determine why there are duplicates. I think the duplicates is because the crosstab doesn't filter to a single user.

That’s why I stated not a simple solution. There might need to some compromise regarding format/layout. I would link the Access table/query into Excel where there are more options for slicing and dicing.

I am well aware of the Vertical but not sure the orientation matches the desired look. Stephen Lebans was a master at stuff like this. I searched and found a thread here.

If you go the Access report direction, you might want to review the example of generating a crosstab report with dynamic headings. I’m not sure you will find a simple solution to the vertical text in your column labels.

I always place a debug.print in my code for troubleshooting: sql5 = "SELECT * FROM DATA_CHECK_KLW_2024 where Year = " & _ Jaar & " And Number = '" & TankNummerSelect & _ "' And InvoerDatum = #" & Format(Z_Datum, "mm/dd/yyyy hh:nn") & "#;" debug.Print sql5 Set rs5 =...

I'm not sure all the quotes are necessary if the fields are numeric. I did some testing something like this should work: SalaryAnnual.DefaultValue = DLookup("SalaryAnnual", "tblSalary") SalaryBasicPay.DefaultValue = DLookup("SalaryBasic", "tblSalary")

You have limited functionality in this forum until you have 100 posts. You are currently at 68.

I had some issues simply running the report until I deleted a bunch of the text boxes in the header (using tempvars etc). The issue I had wasn't related the beef of the report, just the non-record data.

I would suggest you provide a screen shot of the tabs like the following (not my app)

There is a week 0 because the expression creating the column heading in the crosstab query calculates the number of weeks between the start date and the data date. You can easily add 1 so your start week becomes Week 1 but nobody sees the Week 0. Expr2: "W" &...