Search results

Hello, I was wondering if there is a way to generate a report (maybe through use of a macro or something) from the data you just entered in a form. So, there is an order form and the user fills out their details, saves the order, and then they can press a 'Generate Receipt' button, and a...

I've researched this (and apologise if it's a stupid question :confused:), but it seems that this error message: "You do not have exclusive access to the database at this time" should only appear if I have multiple users trying to change it. This is just a school assignment, and no one else...

Hi, I was wondering if there was a way to create a report on one record from a table only instead of the entire table. Should I make a query first, one that eliminates all the other options, and then generate a report from that?

I cannot change the value in one of my fields in my Customers table. Is there some function that locks tables that I am unaware of (I am unaware of a lot :P)

Is it possible to create a macro that makes a field? If so, how does one achieve this?

I've made an order form for my database based on the table 'Sales'. Four of the fields include: VIP? (Yes/No) After Discount (Currency Calculated) Taxable? (Yes/No) After GST (Currency Calculated) If the VIP box is checked, the After Discount field displays the Subtotal (another calculated...

I've made a query that is supposed to be fully disfunctional, I just want it to display data. But when I drag it into my form, it creates a sub-form (or form, I'm not sure) and places that there instead. All I want is data from another table to be viewed in my form for another table. :banghead...

I have a Yes/No field, called 'VIP?', and I would like it to automatically tick itself if: 1. The field 'Order Count' is equal to or greater than 10 and/or 2. The field 'Order Total' is equal to or greater than $1,000 Any ideas? Where would I put this expression into?

How do you insert an image into a table? I know you can make an 'OLE' field, but when I go back to datasheet view, right-click and say 'Insert Object' and choose my picture to use, all that comes up is the text 'package' in the field. Why isn't the picture showing? Is it possible to have a...

I have a table with the fields 'Weight (kg)', 'State/Territory', 'Cost per Kilogram' and 'Postage Cost'. It depends on which state they want to send their item to as to the cost per kilogram. I would like to make this table into a form where: 1. The user inputs the weight into a text box. 2. The...

I'm trying to make a postage calculator for my database. I have to make a table first (obviously), but ultimately I would like to create a form. The postage price depends on the state you are sending the item to, and the weight of the item. The item weight is stored in my other table 'Stock'...

How do I make a 'home page' for my data base? How do these work, how do you add buttons onto it, how do you link one to another navigation page?

I have three fields, 'Sub Total' (which is calculated by "[Quantity]*[Unit Cost]"), 'VIP Discount' (Yes/No data type) and 'After Discount'. The VIP Discount is for exclusive customers. It takes 5% off the Subtotal. I would like an expression to make up the 'After Discount' field. It should be...

Hi, I'm a newbie to Access, and I was wondering how to use the calculations data type. When I select it, a little box pops up and I have no idea how to use it. For example, I want my 'Sub Total' field to be the result of my 'Quantity' field x 'Unit Cost'. Then I later want a more difficult...

I'm a new user to Access, and I'm using 2010 (if that helps). I have three tables, one is called 'Customers', 'Sales' and 'Stock'. I made a form for each of them, and at the moment I'm working on my 'Sales' form. The fields I have in this form are: SaleID (the primary key, which is an...