Search results

Thanks Travis! I ended up using code from the following page that I found: http://www.mvps.org/access/api/api0002.htm After I captured the path from this module, I created a form with a textbox that the user can enter in a file name, then appended it to the value I received from the function...

Is there a way to launch a "Save As" window in Access that will allow the user to browse their computer and other network drives when saving a file? I'm running the following code: DoCmd.SetWarnings False DoCmd.OpenQuery "qryMailMerge1", acNormal, acReadOnly DoCmd.SetWarnings True...

Thanks for telling me what to seach for. Once I get the data they need out of Access, I want them to have it so that I don't have to deal with any of their label problems and questions.

I was wondering if anyone has an example or can point me to any example of exporting data from an Access query into a DBF file. My users would like to be able to generate a dbf file that they can use as a Mail Merge file in MS Word or use this file for other applications. What I'm working on...

Thanks for your help. I finally got the query to work. I'm use to typing my queries in the SQL view. If I had only used the design view to begin with, it would have been a whole lot easier to create this query. Thanks again!

I'm having problems writing a query and I was wondering if anyone could help. I'm not exactly sure how I need to do this. I have 3 tables - tblA, tblB, tblC. (* denotes primary key) tblA ---- *project_id project_name tblB ---- *company_id project_id company_name tblC ---- *contact_id...

I realized what I was doing wrong. I can't pass an array to a function BUT I can use a variant in the function which will allow the array to be returned back to me.

I don't work with functions very much and I was wondering if someone can help me with how I need to setup the beginning of my function. I want to pass a string to my function and I want the function to return a multidimensional array back to me. Here is what I'm trying to do: Public Function...

Thanks for the info!

I've gone through the VBA help, but I can't seem to find what I looking for. I know that it's in there. Can someone tell me what the name of the funciton that I need to use? Dim MyString as String Dim MyLetter as String MyString = "ABCDEFG" MyLetter = ???(3, MyString) 'What do I need to use...

Thanks for your help FoFa. I couldn't fine any type of Add property, but I did figure out that if I add another .RecTo for each additional email address, the message will be sent out to multiple addresses. crhodus

I'm using the following code that I found to create an email with GroupWise 6.5. I modified a few thing so it's a little different from the original I was wonder how I can send the message to multiple recipients when adding 2 or more email addresses in the txtTo textbox on my form. I thought...

I have a field on my form that allows the user to enter an email address. Is there a way to launch their email program and create an email with this address whenever the user clicks on a button? I tried changing the field to a hyperlink and using mailto:, but this didn't work. Also, we're...

Hi dcx693, I read your post right after I posted a message. I ended up figuring out something that was very similar to what you suggested. Thanks! crhodus

Here is the code I used. I probably don't have to have the WHILE statement in the code, since there will only be 1 record in this table, but I thought I'd put in in there just in case another record was added by accident. '------------------------------------------- Private Sub...

As soon as I post a message, I figure out how to get something to work. Anyway, here is the code I used (BTW I'm using Access 2000). Also, I had to check Microsoft DAO x.x Object Library under Tools --> References to get everything to compile. Dim MyDB As DAO.Database Dim MySet As...

I tried using the code you provided Late4Supper, but I am receiving a "method or datamember not found" for the following code: MySet.PropNum = PropNum Im am assuming PropNum is the field that I want to update. I tried changing the name to the field in my table but I'm still having problems.

I finally figured out how to get the value from the table. Now I'm stuck on how to write this new vale that I have increased by one back to table TrackIt. Any Suggestions? Dim varX As Double varX = DLookup("[TrackNumber]", "TrackIt", "[TrackID] = 1") varX = varX + 1 txtTNo = varx

I know this is a simple thing to do but I am having a complete brain freeze. I have a text box named txtTNo on my form. I also have a table named TrackIt that contains one field named TrackNumber. There is only one value in table TrackIt. When the user creates a new record, I want to get...

Thanks for the link Kodo. I have just one question. There have been times when I have used random numbers, but the number wasn't very random. The same number was returned back to me three or four times in a row. This is why I appended the date/time with a random number. Did this problem...