Search results

Hey all simple question: is there any way to apply a different filter to a subform each time it appears on the main form? I have a subform that would be awesome on multiple tabs of a large form, and Id like to apply a different filter on each tab.... Thanx in advance! mike

Hi all I have a form that has twenty True/False items. Rather than display all of them for each record in the DB, how can I show only the ones that are True? Do I need VB for this? I hope not, but it seems that we can either put the value on the report or not, regardless of true/false...

Hi all In my VB code I need to create a row in a table that has an autonumber field as the primary key. How does one specify that in SQL. I have the following as my sql -- I dont know what should go in the [autonumber] spot "INSERT INTO [WindowCondition](ID, RoomID, UnitNumber, RoomType)" _...

Hi all I am creating an apartment unit inspection DB. Each unit has a number of rooms, and each room has a number of condition. So I am thinking of Table design such as: Apartment Unit <-- Kitchen ^--------- Bedroom ^--------- Bathroom...

Hi all I was wondering how I can pass parameters to an append query. I have the query set up to enter rows into a table, but I need to be able to pass it parameters. Thoe code below executes when an apartmentunit is created. Basically I am attaching a Kitchen, Bathroom, some other rooms...

I have a query on two tables with a one to many relationship. I would like to write a query that limits the results based on fields in both tables, AND that only returns one row, regardless of how many rows are in the "many" table of the 1-many relationship. This is not an inner join or an...

hi all Im using a form to display all the units in a table with a combobox. When the user selects a unit and clicks the delete button, that unit gets deleted. The question is, how do I update the combo box after the delete? Right now a "#deleted" string takes the place of the deleted unit...

So Ive defined a bunch of tables that have a one to one relationship. When I view these tables in Datasheet view, at the far left of every row is a + that when clicked, expands out into the sort of root table, showing multiple entries. How can this be? There should be only one row in all the...

Hi I open a form from another form when the user selects an item to edit. How do you prevent the mouse's scroller from changing records?

Hi everyone So I developed an application with a backend containing tables and a front end with forms, queries, and reports. This is so I can give my employer some basic functionality and then add more reports/functionality to the front end over time. My questions are: 1) If I change the...

Hi all Im using OpenReport to open a report based on a table, not a query. This report is not opened from a form or anything, just straight up by clicking on the form in the Reports section. I hope OpenReport is appropriate. Private Sub Report_Open(Cancel As Integer) DoCmd.OpenReport...

hi all i recently seperated my DB into two mdb files so I could update the front end and preserve the data my client was entering. Now when i open the data mdb file, it complains that the "form name Switchboard is mispelled" -- I dont want a switchboard at all, but there does not seem to be...

Hi all Im embarrassed to even be asking, but I left my Access book at home -- Ive inherited a DB that uses a table as the basis for a report. The report right now does not filter the results. I need to filter by a Yes/No field that is in the table. I tried putting "where Active=true" in the...

Howdy all can anyone tell me how to enable a form field based on whether another field has a value? I have a "Is OK?" check box, and a "Comments" box for comments it whatever isnt OK. How do I make the text box enabled when someone unchecks the OK (checked is default). Or even better, how do...

Hey all Ive made a form with a drop down menu and a button -- the user selects a record and then clicks the button to delete. I created the button and a wizard appeared, so I selected the delete record option. Whenever I try to delete a record, I get a beep, and nothing happens. No confirm...

Hey all Lets say 2 people are each using a copy of an access application. Two people means data entry goes faster. Is it possible, when data entry is complete, to combine the results? To do this, would one user import the other's database? Also, is this conception of linking correct?: If...

Hi I deleted a field from a table. The field was automatically removed from underlying queries. I removed the field from a form. Whenever I try to open that form, a dialogue box pops up and asks for the field value. How do I stop this? Also, anyone know how to set the default value for...

Hey all Im trying to use a button to open a form for data entry/modification. The button is on a seperate form used simply to select the object for modification. When I placed the button on the form, a wizard came up that helped me create the button, so I assume it works. I created an...

I cannot set a one-one relationship ... Ive defined relationships, but when I bring up the edit box it always says one to many...how do I change relationships between table to be one to one?

This is sort of a continuation of my dynamic row post -- basically I have apartment units in one table with either 0, 1, or 2 bedroom table entries attached to each unit. (Meaning I have a Bedroom and Unit Tables, where multiple rows in Bedroom are related to one row in Unit). The question is...