Search results
-
M
Issue with opening one database from another
Hello, I have two databases and I'd like a button in one to be able to open the other. I've written this code: Call Shell ("""C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE"" ""C:Users\me\myfilename.accdb") This works like a charm to actually open the database but with one issue -... -
M
Button to copy data from one record to the next
Hello All, I am in the process of creating a database to cover the purchases of various people within a group. I have two tables - one for orders (vendor, date, order number, person who ordered, some shipping info) and one for the items and their costs ordered within each order - the tables... -
M
Include a fillable option in a calculated field?
Hello, I am creating a table which, in part, associates costs with certain items. So I built an expression to generate costs: IIf([Unit]="Unit A", 15,0) & IIf([Unit]="Unit B", 17,0) To make Unit A come up as $15.00 and Unit B come up as $17.00 and so on. It works well for all the items I... -
M
Using DMax to create invoice numbers with letters in them
Hello, I am creating a form that contains a series of invoices. I have created a command button that inserts the next number in a series as the invoice number - this is the code I used as "On Click" If Me.NewRecord = True Then Me.Invoice = Nz(DMax("Invoice", "Invoices"), 0) + 1 End If... -
M
How to open a form at the correct entry
Hello All, I have an Access database with two forms - both these forms contain some of the same information (basically an identifying number and a persons name), but one is much more detailed than the other. Essentially I'd like the user to be able to enter the basic info, and then if they... -
M
Generate reports for a series of specific groups
Hi, I am still a real newbie to Access but I had so much luck with my last question here I am back for more! I have created a database of members who are sorted into specific groups and I want to be able to create a report for each of these groups. Eg, for each person I have: Name DOB... -
M
Concatenate a name with a yes/no field
Hello, I am relatively new to Access and just figuring out a lot of this. I am using a query to concatenate first and last names for a group of people. I have had no trouble doing this, but now I’d like to add a title to some people’s names if they possess that title. I have a yes/no field...