Search results

The WindowStyle details are exactly what I was looking for, thank you!

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 -...

This is intriguing... This is almost certainly a stupid question, but can you tell me which of those terms I need to replace with my own?

Yeah I understand where you're coming from and I definitely respect the opinion. Part of the problem is I'm moving an old Excel spreadsheet system over to this and it's already been done that way in the past, with comments made on the spreadsheet to that effect. If possible, I'd like to retain...

Unfortunately I don't think copying the whole order would work. I thought about adding a column in the items table but annoyingly there are sometimes orders with, say, 20 items, and most or all are for one person, so having to add that in when you're filling in items would be a bit time consuming.

Hmmm. Sorry, I'm not sure what you mean.

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...

You mean like adding an 'additional comments' section or something like that? I thought about that but I'd like to use the cost to move forward with other queries, etc. It may well be the only solution though.

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...

Ah, you're a genius!

I was thinking of this but I'm actually not sure how to format it so the letters show up. Right now, in the 'invoice' field on the form there is only a number. What would I insert to make this show the letters too?

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...

Ah, thank you! Works like a charm!

Thanks for the reply Paul. I’m still pretty much a newby and I guess what I don’t understand is where I’m putting that code. I have a button to open the second form that I just created with the button wizard. How do I edit what is there now? Do I need to make a macro? I apologize if these...

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...

I found that when I put it in the OpenReport it prompted twice to enter the info no matter what I tried. Putting it in the report it only prompts once. I understand that it's likely not ideal.

Not quite. In the design view of the report itself I added a condition which then brought up a prompt for the user to enter the group number. I’m learning slowly, there’s a lot more I’d like to do with this program. Hopefully I can overcome the hump of figuring it out.

Thank you all, I read everything you so kindly suggested and in the end I ended up adding a condition to the report rather than trying to do it with a macro. So glad I finally figured it out, although I’m quite sure there are more exciting adventures to come! I’m finding the learning curve in...

Okay, I got the report to format using the sorting and grouping options you mentioned, and I've even successfully created a macro to generate that report. However, despite reading the site June linked I'm still a little flummoxed. I'm assuming I should set up the macro with the where...

Thanks for the replies. It does really help to even know what this function is called (I was googling with no luck as I was using silly search terms).