Search results for query: *

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...

Hi everyone - I'm working with Access 2000 and Netscape Communicator 4.77 as my email tool. I was trying to generate an email message using SendObject, and I was occasionally getting the following error: Error # 2958 , Description: "Reserved Error" Through a lot of trial and...

James, your last bit of advice worked! I changed the code to read: strMessage = &quot;Media Services acknowledges your request for the following resources: <br><br>&quot; & &quot;Event: &quot; & Me!EventTitle.Value DoCmd.SendObject , , acFormatHTML, strEmail, , , &quot;Media Services...

Hi James and Dan - I tried the suggestion of putting all the strMessage code on one line, but the results were the same. Then I tried changing the outputformat to acFormatTXT, and that also didn't change anything. Then I tried changing the outputformat to acFormatHTML. I also changed the...

Hi everyone - I'm currently running Access 2000, and using Netscape Communicator 4.77 to send email messages. I'm trying to format an email message to include carriage returns, but haven't been successful. I have tried all the options you see below in the code, and all of them give me the...

Hi Paul - Here's the code I have now in the groupfooter_format event. Note: I designed the group footer controls with a row set up for each of the possible 5 tasks. I set the &quot;can shrink&quot; property to yes for all the controls in these rows. Based on the data in the record, I make...