Search results

Do you have a table of each unique data values? If so, this could be accomplished with one simple query. For instance a table [Datas] Data 105674 130351 14398 14421 17816 17817 17818 19183 19184 19303 19894 21092 3692 You could create a query with SQL of: SELECT SKUs.SKU, Datas.Data FROM SKUs...

Wouldn't a move of a single record, be a single triangle?

Those are Navigation buttons and there are lots of options. Search the web for “ms access custom navigation buttons”

Thanks for the more digestible SQL. Having the first and last names the same shouldn’t be an issue when including the ID field. I doubt performance will be an issue with this application but it is good to understand the advantages of the subquery method.

Using a subquery seems overly complex when a simpler SQL statement should meet the stated requirements.

If I was going to create a solution for this, I would probably create a generic function that would accept a date, a time period like week or month, an offset of periods (positive or negative), and the day of week. The returned date would be a specific day of the week, x number of weeks or...

To get the most recent payment for each payer your query would be a totals query grouping on FkDemoID and returning the Max of the GiftDate. This can be combined with the demographics table if you need additional data.

Is there any code/VBA in the form? Are there any unique types of controls? Is the recordsource a table or plain vanilla query?

2/23/2025 isn't a Saturday. Did you try the query? It seemed to work for me with all the dates in the Northwind Orders. Open the immediate window and enter: ?DateAdd("d",-Weekday(#2/18/2025#-2),#2/18/2025#) and ?DateAdd("d",-Weekday(#2/18/2025#-2),#2/18/2025#)+5 You should return the requested...

I'm at a loss trying to understand your application.

If the date is a Monday, do you want the previous Monday to be the entered date or a week prior? Using the Orders table in Northwinds, this query should provide the OrderDate and the previous Monday - Saturday SELECT Orders.OrderDate, DateAdd("d",-Weekday([OrderDate]-2),[OrderDate]) AS...

I would use VBA to export the query results to a CSV file and then open the Word document. The Word document will use the CSV file.

It would be easy to remove the parameter and test. I usually export a query to a text/delimited file from Access and then open the Word document.

You could have the subform be invisible until the CustomerName is entered/selected on the main form. You would probably want to make the subform visible in the On Current if the CustomerName wasn't blank.

What did you try when presented with the Login form? Did you try click on the OK button or Cancel? What happened?

Have the user enter “s” for space and then handle it in you code.

It looks like the crosstab is doing what you asked it to do. Can you provide a screen shot or other of what you expect/want?

I would use the Microsoft print to PDF.

You now mention “importing”. What do you mean by this?

Sounds like an issue with margins. Are you suggesting there is a significant difference between the print preview and the pdf? Can you explain “shrinks the pages”?