I am looking at creating a master database for our church information, i would like each person to have their own entry, but then I would also like a form...

I have a form with a button that executes some code which amongst other things includes: MsgBox varNewID strSQL = "Update AVAILABILITY " & _ "Set...

My update isn't updating the table. Why? Code is: strSQL = "Update AVAILABILITY " & _ "Set AVAILABILITY. = " & varNewID & _ " WHERE AVAILABILITY.BookingDate=...

I'm having a problem with the following code. I'm trying to create a recordset using a query. I run the query earlier in the code and it returns multiple...

Hi I run a query from code but don't want the results displayed to the user. How do I hide the result table? I looked under tools/options but couldn't spot...

I need help with a report that needs to be in Excel. I found some code that I use to manipulate the headers and footers; however, I need to know how to...

When a table or query is emailed in txt format, it produces a format that I cannot duplicate using the export wizard or macros. Is there a way to use code...

When I define a form based upon a table then I get this feature on the bottom of the form that allows a user to scroll through the records. Can I suppress this...

Relating to my earlier post on suppressing record scrolling on a form how do you decide whether to base a form on a table or not? If I have a form where a...

If I run a select query that may return no records how do I test that there are no records? I need to do this in code, i.e.code a select statement followed by...

Is there anyway to set a field to multivalue in a form? If not, does one have to create a look-up field in a table to be allowed the multivalue option? Is...

I have created a form to display my data in a simple name and address table. I have created buttons to navigate through the records but want to create a...

I want to duplicate a record on a form because only two fields are changing value from record to record.I have created a duplicate record button. When I click...

Hi. Sorry for the newbie question - I'm quite the novice with Access. I'm trying to develop an information input/storage type of database for medical use. I...

Newbie question - sorry. I have an Access 2000 database on an old computer and I want to transfer the database and all the records to a new computer. I don't...

Hi, I have an HP laptop with XP Professional and Office Professional 2003 SP3 (including Access 2003 of course) I want to install Access 97 from my...

Private Sub cbxProjectID_AfterUpdate() Hi, I'm trying to filter one combo box in a subform based on another in the main form using Access97. I got this...

Hi, I am attempting to limit the contents of a combo box in a subform based on the selection made in a combo box on the main form. I've been trying to...

Hello, I have a main form "frmDailyRecords" and a subform "dailyRecordDetails"(in datasheet view). When I enter or change anything in the subform, the...