Search results

FIXED! I completely forgot about registering the control. Thank you very much for your help! -Joshua

I developed a database on another machine that utlized the calendar control (Access 97). When I run it on another machine, it doesn't recognize the calendar control. fine. I go to the VB Editor, go to References, browse to mscal.ocx and install that sucker. It shows up on the list with a...

I changed lines 2 and 3 so that they now say dim rst as object set rst=.....Recordset.Clone And now it works. Many more problems after this, I'm sure you'll be hearing about a few of them. -Joshua

I feel like this should be a simple problem but it's just not working. I have a combo box that picks a record and I want to go to a corresponding record on a subform. Here's how I'm doing it: (Acess 2000) Private Sub firstmonthgoto_AfterUpdate() Dim rst As Recordset Set rst = Me.[objectives...

Boy, do I feel dumb. I was so worried about trying to find how to use a string as a control name that I missed the whole control variable business. oops. public datedestination as Control and set datedestination = blah blah blah works like a charm

How do I pass a control location around in a variable? Specifically, I have a form with the calendar control. I want to be able to double click on a control on another form and have that form tell the calendar where to stick its value once the user is happy with it. I made a public variable...

Perhaps this is too simplistic, or doesn't do exactly what you want. When I wanted to create new records that had the same values as the record on my screen, I just made a command button and used the wizard to make it a "copy record" button. That creates a new record and copies all the values...

I guess I could be reading this wrong, but if he wants to get the result of the query into the recordset shouldn't he use the SQL statement as the parameter for the openrecordset? Set CustObj = dbs.OpenRecordset("SELECT Customer.ID FROM Customer WHERE Customer.ID ='" & Me!txtID & "'"...

see the posting in Queries

The client does their catalog by printing reports directly to Adobe. They sell trucks with a lot of different sorts of accessories, each being listed in a report. The reports are all dissimilar enough that you couldn't combine them. There is a lot of wasted space, though, as some of the...

I don't know if you can accomplish this with a single combo box, but I have done it with multiple combo/list boxes. Have the first box list all the different subjects from a query that lists each subject once. The second box gets its rowsource from a query that reads the value of the first...

I'm assuming that the data being sent to the report is a simple query or straight from a table where each record is like this: field1: activity field2: name and then your report groups on activity. The problem with trying to list activities with no name is that the report wouldn't know about...

That's what I do, but it just attaches dailyreport.rtf to the email, it doesn't actually put the report into the email.

Is it possible to send a report as an e-mail, not just attached to an e-mail? We use Outlook which is set up to use Word as the e-mail editor, so I imagine it's somehow possible.

Is this form based on a query or on a table?

The other alternative would be to get your hands on a copy of the Office Developer's Edition. This includes a copy of the MSAccess runtime library that you can distribute royalty-free so that users don't need MSAccess to use your database. I don't know about Access2000, but I've seen it around...

OK I figured it out. I put a button on my form with this behind it: Private Sub getnames_Click() Dim myfolder As String Dim myext As String Dim mypath As String Dim myfile As String myext = Me![extension] myfolder = Me![path] mypath = myfolder & "\" & "*." & myext myfile = Dir(mypath...

wow, that'd be really great. Even when not inserting the picture directly into the database problems exist. I tried just using the file name in a field and changing the source picture of an image box to the current file name. It'd still just be a blank in the frame where the picture should go...

alright, let me be very specific about what I'm trying to figure out how to do. There will be two directories, 'Pics' and 'NewPics.' These will store pictures brought in from a digital camera. NewPics will house the pictures just brought in and not entered into the database yet and Pics will...

The problem seems to be that Internet Explorer has taken over all my picture types except for .bmp Now I guess I just have to figure out how to associate everything with the Microsoft Photo Editor or something else. Thanks a lot for your help