Microsoft Access / VBA Forum

I need to create different recordsets based on queries that use data from unbound fields in a form. I've discovered that I can't do this, and instead need to save the data in question (usually a text string) to a table. I'm thinking the best way to do this is to use a Make Table query -- that way the table stays small -- one row -- and...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

Hello all, I just discovered something (stop me if you've heard this before....) that was causing me a significant performance hit when opening a form with subforms. To speed up loading the form, I set the rowsources of its, and its subforms', combo boxes in the "Enter" events of the combo boxes. That's the standard trick for not...

TEST ONLY 10/4/03

I'm attending track1. If you'd like to connect there and compare notes and impressions , send me an e-mail. I'm thinking that this version may be a big upgrade and I'm interested in seeing the capabilities.

I am currently trying to design a vb.net application using a MS-Access database that will keep track of my home files. I want this application to assign a folder number to each new file based on the category. So if I had categories like "Home", "Insurance", ...ect. and in the "Home" category I would have "Furnace Info", "Water Heater...

I have a continuous form that lists records from a query. One of the columns is an amount field, In the footer of the form I place a text box that displays the total (sum) of the amount. The data in the form is linked from a one-to-many table relationship. In this instance, I really can't sum the value from the one's table since if there...

(cross posted - comp.databases.ms-access, microsoft.public.access) Hello folks - this is my first post here, after a short lurk. I have written an application in Access2002 for a friend's business which allows him to take orders, arrange deliveries and trace deliveries back in the event of subsequent complaints. It uses a handful of...

Form FrmRestock's recordsource is QryFrmRestock. The TransactionDate field's criteria is set ats: Forms!FrmRestock!LastXDays. LastXDays on the form is a combobox where the selections are 30, 60 and 90. The default is set at 30. Question1: When the form opens, there are no records displayed although there are many records that fit the...

Hi, I am making some alterations to my Database. I have a table called projects and a table called Work_Types. Projects currently contains the name of the work type (Work_Type) but now I want to change this so it contains the Work_Type_ID, is it possible to update Projects with one query? Thanks for your help

Hi every body I've a little problem with my query, I can't figure it out. I've three tables: Table A (EmployeNr, Date, Code) Table B (EmployeNr, Date, Code) Which is an historic of Table A Table C (BegD, EndD) I can have all the records in table A that doesn't match in table B but not from the other side.

Hi every body I've got a little problem with my form ("frm_Company"). It is divided in two parts: - first one is filled with some text fields over the company. - second one is filled with a tab control and give informations about contact persons. On this tab control there is also a form ("frm_ContactPerson") which contains some text...

I created and access application that sends e-mails automaticaly to our clients, over 1.500 e-mails daily. I am using the MS Outlook components to create the e-mail with HTML code. All works fine if the MS Outlook is open, but if the MS Outlook is closed, the program is unable to send more than 4 or 5 e-mails. I wish to add a...

I have tried both methods of using DSum and creating a Function to address summing some number columns, but to no avail. Since this has been a popular topic over the years, I'm sure I'll receive some guidance. This is related to Access 97 and involves my redoing a miscellaneous purchase and sales form. A main form (frmMain) is used that...

Thank you in advance for any and all assistance. I'm running Queries for updating my forms and I want to turn off the Internal Warnings that access gives. How do I do that? Michael

I've just removed a reference to Word OLB as I'm using late binding now. I've got a reference to OLE Automation. What's that for then? Embedding Excel objects in Access, Word objects in Access reports and such like? I just removed the reference and everything worked. Not that I've got any embedded objects. But my Word automation was fine,...

I have Office 2000 and Office Developer and I want to upgrade to Office XP. Will my copy of Office Developer work with Access XP?

Hi Folks, Does anyone have a line on some well written black box code that will handle SMTP mailing sessions and can be integrated into a VBA app? Thanks.

The Windows XP specification says that Franklin Gothic should be used for titles at certain point levels. So I am thinking to use this font for report titles. It seems that this font family is installed only with Windows XP (though for some reason it's on my Win2000 machine). Can I legally distribute this font with by Access97 App since...

Hi Folks, Does anyone have a line on some well written black box code that will handle SMTP mailing sessions and can be integrated into a VBA app? Thanks.

Are you overworked? Do you need a paper typed? Do you need transcription services? Do you need a professional resume? Is your secretary always sick or on vacation?

We recently converted our department wide shared Access97 database to Access2K. We used to be able to open various reports in design mode and make changes to the design (or create new reports) even while other users in this shared database might be using other, unrelated reports. Now, in Access2k, it appears that whenever you do not have...

The letter or symbol " ì " appears in the memo field of my Access database. I tried to use search and replace to delete it, but even though I can see it the search and replace feature can not find it. It appears that the " ì " is a line feed symbol because when I paste a passage into Microsoft Word it appears at the end of a line before...

I'm trying to create an email mailing list for Outlook. Here's the part of the sub that puts the email address in the Bcc (or To) field: With objNewMail .BCC = strEmail .Display End With

I have a combobox bound to a field in a sub-sub-form which remains blank as I traverse through the records in the parent form. It works fine when I have a simple rowsource query but remains blank when I add more critera for the search. I also have to requery it everytime I change the parent record. Is there an easy/better way to display...