Search results

Hi, I'm trying to have a button on a form that would delete a record from a table only if there are no child records linked to it. If there are child records for the selected record, the button would be disabled. Is there a simple way of doing this? TIA.

Hi, I'm trying to reference a control in a subform from a module but I keep getting errors! Here's what I've tried.. and what error I've been getting: First try: GetCboEntries = Forms.frmMain!frmSub.Form![cboEntries].Column(1) (where frmSub is the name of the actual form in the subform...

Hi, I tried creating comboboxes already but ran into a certain problem - that is, the first combobox doesn't allow you to "select" entries with the same ID - it lets you select the first one, but no other (yet it'll still show the other item with the same id in the combobox)... This was using a...

Hi, In a form, I am using two comboboxes per record (i.e. when you add a new record, two more comboboxes for that record appear). My goal is to have the second combobox show entries specific to what the first combobox was, with certain caveats (see below). My current approach is using three...

Hi, I currently have a form that creates a report based on a query that takes in a start date and an end date. What I would like to do is to create comboboxes that will let the user choose a month and year for the report. Is there a simple way to choose an entire month in access? I've tried...

How would you check if the value's already entered in the recordset?

Many thanks for the reply. I'll give those methods a shot and see how it goes.

Hi, I'm wondering how to do the following: I have two combo boxes that exist on a form record (i.e. two combo boxes for every record on the continuous form): mainCategory and subCategory. Currently, I can choose a mainCategory and depending on the mainCategory, I have certain values available...

Hi, Is there a way to get blank fields to sort to the bottom rather than the top when sorting alphabetically in access? TIA!

It is indeed the "navigation button bar". When I set navigation buttons to "Yes", the buttons appear on the bar. As for setting the border to "None", where could I find this? I only see a "Border Style" property for the subform. Setting this to none does not do anything to the navigation button...

Hi, Is there a way to totally remove the navigation button bar? Even though setting form navigation buttons to "No" removes the buttons, the "bar that held the buttons" remains in it's default gray colour. I'm trying to make a subform blend in with the main form but this is posing to be a...

Scratch that- figured it out. Thanks for all the help!

Hi, Thanks for the sample. I want the users to be able to change to previous date entries. Is it possible to have it display today's date by default but have it be a combo box where the user can select any of the "previous" dates that data was entered?

Many thanks for all of your input. You've all been of great help. Wayne - the SQL statements you posted in the other topic worked great. Thanks!

Hi, I was wondering how difficult it would be to do the following: 1. A user opens up a form. 2. The user uses a combo box to select his/her name. 3. There is a date combo box on the form and by default, it is set to today's date. So when the user selects his/her name, the records for today...

Hi, Sorry.. I'm not sure what you mean.. It orders alphabetically when I use the "mmm yyyy" format. What I'd like to do is get the combo box to order by date. I'm using a SQL statement in the Row Source property of the combo box. When I try to use a "SORT BY" at the end of the current SQL...

Is this possible, if using the following: SELECT DISTINCT (Format([Month],"mmm yyyy")) FROM Table; Adding a ORDER BY [Month]; gives a "distinct and order by" conflict... Is there any way to alleviate this? I want to display a "mmm yyyy" formatted combobox in order (i.e. Jan 2005, Feb 2005...

Hi, Thanks for the reply. How would I get this to work with the combo box? I tried using the row source as "Query2" but to no avail. I was originally wondering if there was some way to manipulate the Year() and Month() functions from VBA into SQL to get this to work...

Hi, I was wondering how to delete records that have been checked (through a checkbox) in a form... Also, I want to add a record after the record that has been checked. I only want this ability to add records available if only one record is checked. Otherwise, if more than one record is...

Thanks very much for your help! I had a row source for the combo box but I didn't bind the control source to a field.