Recent content by aregan1

Bob - Thanks for your response. You confirmed what I suspected. I agree that if I developed this database for the user, I would have created forms for them to use to edit tables and query results, and I could have controlled when updates actually happen. However, this is a case of a little...

Thanks to both of you for responding. Let me explain further: This is one of the select queries that my user is running: SELECT [section schedule].term, [section schedule].[course key], [section schedule].[instruction type], [section schedule].instructor, [times, unique].[meeting times]...

Hi everyone - I have a user who developed his own Access 2000 database. In general, he did a pretty good job. But he has a question that I haven't been able to answer. Here goes: This user has written many Select queries. He is using the resulting data grid from a select query to update...

Look up DCOUNT as a quick solution... other wise try a recordset for a better (but harder to code) solution... --James

I figured out what I was doing wrong. I didn't have the "Link Master Fields" and "Link Child Fields" values entered correctly. Now it works just fine...

Hi everyone - A requery command for a subform on my main form is not giving me any results. But it's also giving no error, so I'm not sure where to turn. Here's the details: I have a main form called "Tutor Hours", which contains an unbound combobox called "cboTutor", a...

Hi Randy - I definitely wanted to close the form after I opened the report, so I used a public variable in the report to hold the value that I needed. It worked great. Thanks... - Anita

Hi again Randy - I figured out what my problem was. In the code that called my report, the code looked like this: DoCmd.OpenReport "LD List by Partial Code", acPreview DoCmd.Close acForm, "Select LD Partial Code" I tried commenting out the docmd.close statement, and the...

Hi Randy - Thanks for replying. Yes, "Selected" was actually the name of the text box on my form. But just in case it was a reserved word or something, I changed the name of the form's text box to "Partial". I then changed the report page header text box to use the...

Hi everyone - I'm using Access 2000, and trying to print a field in my report page header that comes from a text box that the user enters into a form. The text box in the page header of my report is called "PartialCode". The control source for this text box is set to...

Thanks to both of you! It works just fine now... - Anita

That worked. Thanks for the help... - Anita

Hi everyone - I am trying to store a field in an Access 2000 table that is defined as a "Short Date". I started out with a nine digit number (called CourseDate, defined as "double") that looks like this: 103021603. I stripped off the first 3 digits using: DateNum =...

Hi everyone - I have a form that displays a datasheet. When I click on a specific row of the datasheet, I want to be able to reference (with VB code) a certain column in that row that I clicked on. How would I reference the field I want? Thanks for your help... - Anita

So it looks like this is a known problem with Access 2000! Since we don't use Outlook where I work, is any other option available to me if I want to send an email from Access 2000? I don't know of any other way than SendObject, and the posts I see in this forum seem to offer alternatives only...