Search results

If you view the datasheet of the form’s recordsource, all date and numeric fields/data should be right aligned. If they are left aligned, there is some expression that is converting them to text.

The field could be in the Order Grouping.

I like NauticalGent’s code since it can be used with any delimiter as well as beginning and ending characters. I would not hard code the #.

I think it’s safe to say that no long time Access developer would store the gift type as opposed to the ID. Can you provide a justification for storing the text?

I had used MapMyRide years ago but switched to Strava. Strava data can be pulled into VelowViewer which is data paradise. All data can then be exported easily to CSV.

George, maybe for someone who walked regularly and stored all of these excursions in a database for several years. This could provide a great overview graph 😁

This generic function is my go to. Are the items always in alpha order and any subtractions be adjacent values?

If you are building a dynamic object such as a form, I expect all the information required would be contained in a save as text file. The same could be said for the results of the database documenter. If I wanted to build a dynamic application with the definitions saved in a system table, I...

Would it be fair to compare this entire system as an equivalent to Access’ saveastext and LoadFromText?

#5 try your latest delete query in a test or copy.

Admins should move this thread to “Forms” since it has nothing to do with reports.

I don’t believe a query with Group By will ever allow editing.

It doesn't sound like the application has been changed but I would expect something like this if a user defined function or module was named Nz. This would also suggest If txtApproval & "" = "" Then would not be a problem.

"choosing number" is a matter of using a control such as Pat Hartman suggested. Set the strOpenArgs to the value of the control. This is a form with a combo box to select a value for the OpenArgs and a text box to enter a filtering value. The code in the form which provides the control names...

In addition to Gasman's suggestion, you could temporarily try: If txtApproval & "" = "" Then

Your code doesn’t match mine. I didn’t have an “=“ or "strOpenArgs" (in quotes) in my OpenReport code.

The simple way to display openargs is with a text box with a control source of: =[OpenArgs] Private Sub cmdOpenReport_Click() Dim strOpenArgs As String strOpenArgs = "Open Args Value" DoCmd.OpenReport "rptTestOpenArgs", acViewPreview, , , , strOpenArgs End Sub

Imb, It would have made sense to start with a very basic description of the high level steps/processes when a form is opened. There have been over 80 posts in this thread and we still haven’t seen any table structures or a relationship window screenshot or even if the data is stored in standard...

This is the Report forum but you mention only Form in your question. Can you please share more specific details or requirements?

I expect I was confusing posts with urls vs attachments.