Search results

I have a query that I have created for a table that will sort text data, including values that look like numbers into a proper sort, i.e., 300, 385 427, 3085,, etc. rather than the default sort. I have two questions about creating a report using this query. 1. I created a report that has a...

This seems like it should be simple, but I can't figure out how to do it. I have a database with a table that contains Id numbers of threads and the inventory on hand of each thread. I want to create a form that allows me to enter an id number and have it look up and display the inventory...

I am using Access 2016, Window 10. Is there a way to get a list of all the queries in the database? Also, is there a way to find out where each query is used and print a report? Thanks, Judy

I have created a query which sorts a field that is a combination of text values and numbers (from double digits to four digits). The purpose of the query is to sort the values so the text fields are at the top and the remainder of the numbers are in true numerical order (rather than the default...

I have created a main form and a related form that I call with the click of a command button. I am trying to pass the value in the linking field to the called form, and it just isn't working. The called form "knows" it's being filtered but doesn't have the value I passed it in the correct field...

I have an MS Excel file in which I have keep purchases, i.e., inventory. I want to import this file into Access and split it into two tables. I want one table to have a description of the item and where purchased. I want the related (linked) table to have purchase date, cost , etc. That way I...

I have a main form where I enter membership information. I then click on a command button to go to another form to enter the actual member detail. When I exit the member detail form, it works fine IF the record was previously existing in the membership info database. If it's a new record in the...

This seems really silly, but I can't figure it out. I created a database in Access 2003 and Hid the tables, queries, etc. It was really easy to view them when I wanted to work on the database. How do I few the list of tables, queries, reports in a database in Access 2007? :o Thanks, Judy

I am using Access 2003 coding as Access 2000. I have a report with a subreport. The report has vendor information (name, address, etc), and the subreport has order details from the vendor. This particular line has 4 detail lines on the subreport section. The underlying data source is a...