Search results

This code shows current record number: =[CurrentRecord] This code shows total record number: =DCount("[Category]","tblCategory") How do I combine them in a textbox to say something like "8 of 10"?

My database has comboboxes to autopopulate fields. These comboboxes have parametered queries for row sources so that the user doesn't have to go through a long list of IDs and to make the database more efficient in case it has to hold hundreds of records. They work the first time round but not...

I have a main form with customer details, staff details, invoice details, and subform with invoice equipment details. The database is in it's final version, everything is working perfectly. There's ID comboboxes that autopopulate for these details. However when I try to create an invoice...

I like to learn about different cultures, traditions, religions, and philosophies and I stumbled across a philosophy referred to as the Stoic Philosophy and it really clicked with me. I find it is a great mindset to have in life due to its realism and benefits. It helps develop a good work...

I have an invoice query that has a lot of fields, I want to create a copy of the query that searches for the best paying customer. How would I add up all the costs per customer and find out which one is the most?

I want the user to be able to use a combo box to select a value but I don't want them to be able to manually enter data, is this possible?

Why can't I get this simple piece of code to work? Private Sub txtDateBack_AfterUpdate() ' updates loan status txtLoaned = 0 If txtDateBack = Null Then txtLoaned = 1 End Sub Private Sub txtDateBack_AfterUpdate() ' updates loan status txtLoaned = 0 If...

In my database when an item is currently being loaned the item's loaned field will have a 1 to indicate this. When the item is returned the value is 0. Only so many items are available and when I use the DCount function it is counting the 0s as 1s. How do I solve this issue?

I added a new field to one of my tables and query, but when I try to add a control for that field into my form it is not recognising it and the field isn't appearing in the sources for the form, even though the table is sourced to the form? Or am I going to have to do the usual and redo the...

How do I make a control invisible?

How do I make a column invisible in my subform when the main form loads?

I have a combo box in a sub form with three values, rate1, rate2, and rate3. I have another three fields in the sub form rate1, rate2, and rate3. The rates are dependent on the item. When I select the rate from the combo box I want a cost field to update on change to the relevant rate. I...

In my main form I have added a combobox and changed the source properties but the customer details aren't autopopulating when a customer id is selected. http://s000.tinyupload.com/?file_id=05702272457269833949

When setting up the relationships I know that if you want to have different rates you can have the rate as a foreign key but what if the rates are dependent on each item (each item has multiple rates)? How would I set something like this us up? Thanks.

Is there much of a difference between Access 2007 and the newer versions, except for the ribbon?

What would be the Access 2007 VBA code for checking for duplicate records?

I have two medium time date/time fields and when entering information into these fields a calender is available to the right of the field. Is there a way to remove the calender for these fields?

How do I create an expression field that calculates the difference between a start time and finish time in hours, e.g. display 1 as the difference between 10:00AM and 11:00AM. Thanks.

I have a number field in my subform that's autoupdated but I'd like it to display "weeks" beside the number without trying to store it, is this possible?

I have Trainee, Staff, Course, and Booking tables and forms. Everything is working fine but I want to limit the amount of bookings per course to 50, how would I go about doing this? Thanks.