Search results

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.

You shouldn’t need to press the ctrl key, just the shift.

Your best bet might be to Remote Desktop into a Windows computer like described in this article

I think this is what you want: DLookUp("[CID]","[InvoicePayments]","[CID]=forms!Invoicing![CID] and [your field] is null") It isn’t clear where you are using this expression but there might be a better expression.

Your first sql statement could be used by replacing the subquery with DLookup(). Depending on the number of records, this might not be very efficient.

You need to provide a query with columns for every value you want to display in your report. It should be a totals query that is grouped by the date, as well as the fields you expect to see on the left side of the page. There should be one column that totals the numeric value.