Search results

Thanks again, there seems to be a minor bug whereby if I click ID15, it will also highlight ID5, ID14 will highlight ID4 etc. If I wanted to populate the ID field based to a different Form based on the click event - will I reference the txtlist textbox? I am clearly not too advanced in Access!

Many thanks for your time. Have a great weekend.

Hi All, Apologies for the rushed database yesterday. I've made some small amendments to the database which hopefully makes my question clearer. In Form1 (that is populated from Query1) you will see checkboxes populated. If I click any checkbox, it clicks all checkboxes, my question which...

Apologies, the sample was rushed and obviously didn't do the job. I figured out the issue. thanks for replying.

Hi DBGuy, thanks for taking the time to reply. this is a very rough sample! In Form1 - I want the detail section to be populated based on query1 - I want a checkbox populated for each record returned in query1. The goal is, if someone clicks on the checkbox on a specific record, this will...

Hi All, I have what is hopefully a very quick question. I have a form where the detail section is populated based on a query. There are two fields that can have variable number of records returned. I was wondering would it be possible to add a checkbox for each record that is returned without...

Thanks all for the time taking to reply and for sharing your knowledge! It’s people like you that make these forums an excellent place to come.

Thanks for the reply. I just have one follow on question if I may. Why do we put the index to null. Does the index only search for null values then? Any idea how I would index a checkbox (only return false values) to speed up the index? thanks again

My back end is not an SQL server, the main form has a record source that’s a query with some calculated fields in the query that display on the form. The controls on the form are bound to a table so when users make updates they are saved etc. thanks again

Thanks all for the replies. I would welcome any suggestions. The problem i have is that, there are 200,000 records in the database table. My solution was to split the table in two (current records and archived records). Once the current records where of no longer use, I would copy them to the...

Everyone has their own front end. It’s a continuous form with bound controls. The data is only needed for a short time and will be of no use after a certain period. It’s for this reason it’s deleted (and to keep the database running fast). if you go into the back end and delete the record you’re...

Thanks for this, is “ID” a name of a field in my table? Sorry I’m not an advanced programmer by any stretch. I set it to the primary key on the table on which the form operates and added this code to the on current event. It still doesn’t work. Thanks Rasta

Hi all I have a database that multiple users use simultaneously (front end and back end). Within this database the main form is a continuous form. The problem I have is when one user deletes a record, other users of the database see the #deleted and get an error “record is deleted” when they...

Guys, I would like to personally thank both of you for your help. This is a great website for learning and you guys are awesome for helping. Cat

Thank you for the reply! It's still not working, I'm getting a Syntax error. May I ask, can you please send back the database I sent today with the proposed updates so that I can have a look at what it is directly. I must be making some error along the way... Thank you Cat

Thanks for taking the time to reply. That didn't quite work. Are you suggesting I change the Row Source type in Filter 1? I've changed it to a query and also left it as the value list and neither work as intended. Sorry for my lack of knowledge but you may have to spell it out for me. Cat

Hi I have attached the database Customers 3 - this will be my final question on it! I need to include the 'Total' from the 'Qry_Customers' as a filter in CboFilter2. I'm also getting an error when filtering for null values I get problems with the recordset updating the label on occasion i.e...

Hi I have one final question that I hope you can spare the time to help with. In the select statement you provide you selected all the records. Is it possible to select a field that is not in the table? For example: In an access query, I have Addnumbers (Num1, Num2) as Total (where...

honestly appreciate the time taken, have a great day.

sorry once again for wasting your time.