Search results

If you use my recommended solution, you can change the crosstab column expression to: Expr1: [Seq] & "-" & [CrosstabHeading] which will group the dates and owner columns together for each "event". To make it even better, change the value of Start Date in the crosstab heading table to Begin Date...

You could take my solution and add "Owner" as the third record. Then make sure the OWNER field is in qselSubSystems. Change the SQL of the crosstab to: TRANSFORM Min(Switch([CrosstabHeading]="Start Date",[STARTING_DATE],[CrosstabHeading]="End Date",[ENDING_DATE],1,[OWNER])) AS Expr2 SELECT...

You can get rid of the Column Headings property values. It was there as a hard limit and also sets the column order. I think the subform will display any number of columns up to Access limits.

You can create a crosstab with pairs of values (Start and End) by creating a headings table [tblCrosstabHeadings] and adding to values I use a ranking/sequence query [qseqSubststmes] to generate the 1,2,3,... SELECT tblLeoM.Subsystem, tblLeoM.STARTING_DATE, tblLeoM.ENDING_DATE...

I don’t believe you have ever stated where you are creating the file? From your permission screenshot, I would expect to see full control.

I would create normalized tables where each response to a question created a record in a table. An unbounded form would present the group of four questions to be answered. Add a command button that checks the math requirements and appends (or updates) the appropriate four records in the...

There is a reporting process in the Northwind Developers template that does the same.

I believe it is just a message stating the report is being run/saved. I’m not aware of a solution for hiding it. Are you concerned something is wrong?

There is sufficient complexity that I would create a small user defined function that has the three fields as arguments and returns a string. You can add comments and use the function anywhere that you would have used the complex expression.

I've seen that issue in addition to creating a function with the name of an existing function. I don't recall all the errors. That's why naming conventions rock. All my module names now begin with "mod". I have seen a naming convention for functions and subs but I haven't used them.

I tried the test and got this error message Once I changed the Private to Public, it worked as expected. I expect the OP would know if there was a user defined function with the name Split(). I've run into this mistake in the past.

An alternative to the Switch() function and a lookup table, you could create a small user defined function that accepts the field value and returns the appropriate value. All of your logic would be in one place where it can be commented and edited quite easily. Save the function in a module...

I would make sure every user can both create and delete files in the folder containing the database. I usually have users right click to create a text file and then delete it after saving. If they can’t accomplish this, their permissions need to be changed.

Sorry, my autocorrect wrote Current DH (my current initials) rather that CurrentDB.

"SharePoint list" doesn't fully answer my question regarding the field being in the report's record source. Can you confirm you see the column in the report's record source and tell us if it is left or right aligned? Left aligned would suggest the value is text and right, numeric.

The error message suggests there is no field in the report's record source named [days remaining]. It appears you might have calculated this value in the report and not the record source query. Can you confirm the calculation and where it exists?

The key is whether or not the [days remaining] field is numeric or short text. If numeric, plog has provided the solution. If it is text (not a good idea) then the code would be: Private Sub reportbtn_Click() DoCmd.OpenReport "itemcheck", acViewReport, , "Val([days remaining]) <= " &...

First, check the name of the shopping cart subform. I would do this a bit differently. Consider building an append SQL statement and then executing it. Then you ismply need to requery the subform. Dim strAppSQL as String strAppSQL = "INSERT INTO YourTable (FieldListHere) Values (" & … & ")"...

👍

If you actually want assistance, you should probably do as Pat suggests and either post the application file or at least provide more information Tay you have previously.