Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   ComboBox Question... Hi, I have two combo box on a form and I was trying to use the top combo box to determine the content of the 2nd combo box. i.e if the top combo box content is Car and Truck. If the user select Car, then the content of the second combo box will be list of Cars type in table and if the user selects Truck the content of the second combo box will be Truck in table. But the problem is... 3 03.03.2006 12:24:35 Dynamic picture loading to report Hello codders, i need to load any type of picture (but not bitmap only!!!) to a report. I made this work in forms by using .picture property on a picture object. Using the code at report causes an object doesn't support this property or method. Any help? Thanks a lot, (buddy*)__lukas__ ... 8 02.03.2006 18:06:56 mde grows on close This is a multi-part message in MIME format. ------=_NextPart_000_0024_01C63CA3.6F0B86C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Anyone have any idea why my .mde file grows on close? I've read all about database bloat and fixed many issues by closing all = recordsets, querysets, and current databases, also setting everything to = nu... 3 02.03.2006 12:30:13 French language currency routine required / date routine offered In the VBA Developer's Handbook, Getz and Gilbert offer the routine dhNumToStr. It takes a number and converts it into text for writing checks. For example, 24.95 gets converted to Twenty-Four and 95/100. I need an equivalent routine in French. Has anyone attempted this? I offer my own routine for converting a date into French text. Please let me know if there is a system function to a... 11 01.03.2006 18:57:14 Email Sending Message "From" Account I would like to specifically send a message from a Group account, of which a logged-in user can have the message sent from the Group MS Exchange account, as opposed to their actual Windows Log in account. What special coding is required for this ? Many thanks !... 2 28.02.2006 14:23:06 Generating passwords automatically I've created a Password function that creates a random password Function Password(passlength) As String Dim i As Integer, tmp As String, tmpChar As String, arrChars(61) As String, j As Integer For i = 0 To 9 arrChars(j) = i j = j + 1 Next For i = 65 To 90 arrChars(j) = Chr(i) j = j + 1 Next For i = 97 To 122 arrChars(j... 4 26.02.2006 22:23:20 Are DLLs the way to go I write a lot of utility programs and database front ends using Access 2000-2003. Most of my functions are in the modules and I use a lot of the same functions in most of my projects. Lately I have been finding that I am not updating all of the common functions in all of the projects and they are falling out of sync (what a suprize!) I have never created a DLL but I was wondering if t... 7 26.02.2006 02:21:15 ImageClass HelpMe Compliments for the good gym of study to S. Lebans but my lower part level of knowledge of the VBA has been put k.o.. 1. How can I do to PCX to load images? 2. As I can do to the image to make Negative 3. How can I do to cut out the image for then to resize it, in dynamic way in another control Image? example: to cut out a portion of the image, to make to become her/it a new image to unhide... 2 25.02.2006 14:35:26 Combo Box? Hi, I have two combo box on a form and I was wondering if there is a way for me to use the top combo box to determine the content of the 2nd combo box. i.e if the top combo box content is TVand Radio. If the user select TV, then the content of the second combo box will be list of TV stations and if the user selects Radio the content of the second combo box will be Radio stations. ... 3 25.02.2006 03:46:55 How to avoid : error 3052 file sharing lock count exceeded Rather than keep increasing the registry value as my clients grow and grown their databases, I'd like to change my code to repair this problem. We are using Access 2003 on a Windows XP system using a Windows 2003 server. For some reason recset.lockedits tend to suggest that we are using pessimistic locking (which in itself seems odd to me). Now with pessimistic locking I'd expect each r... 1 24.02.2006 16:21:19 Help with this code Dim oApp As outlook.Application Dim oMsg As outlook.MailItem Set oApp = New outlook.MailItem Set oMsg = CreateItem(oMailItem) With oMsg .To = "ssamnang@yahoo.com" .Subject = "cmd Buttom Testing..." .Body = "Hey delete me now" .Send End With at the very first line, I got the following error: Compile Error: User-Defined type not defined SF ... 4 23.02.2006 15:29:51 I need your feedback My boss may have me implement the following subprocedure to automate the correction of the ItemID of the records... If you understand how to read my code, will you give your input if you think it's the best way to do it or not? Sub ChangeID() Dim db As Database Dim rsI As Recordset, rsSI As Recordset, rsSSI As Recordset 'The three tables Dim ITEM_ID_txt As String 'The ... 3 21.02.2006 20:14:30 Access Email through Outlook. Hi, I embed the code below in my button click, so that when the button is click an email will be send but....How do I get rid of the pop up message from outlook "Microsoft Office Outlook: A Program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should chose 'No'". Dim olApp As Outlook.Application Di... 3 20.02.2006 15:23:55 Adding a column to a table using a VBA function Hi I have an access Db where I need to create an extra column in a table the default value would be the current date I need to create this in a vba function. Any help greatly appreciated Subs ... 14 17.02.2006 05:05:42 textbox to field? Hi, I have 2 unbound textboxes, that I want the user to input text, and I want this text in a field in the table, so that every time they input some text it comes into the same field in table it will just keep overwrite the old text in the field of the table every time they input text. How do I do this... Thanks Tiger ... 4 16.02.2006 16:33:55 accessing controls by tab index Hi, I was wondering if anyone could let me know if it is possible to access a control by its tab index? Reason why, is that in a user form, if a certain entry is made, the next 'n' controls need to be disabled... best way to do this, appears to be by using the tab index. Any help will be greatly appreciated, thanks:)... 4 16.02.2006 15:27:04 acc 2003 2 form instances trying to generate 2 active instances of same form at run time with: 'Module Declarations section: Public FM1() As New Form_fmCompany 'Module Code section: Sub OpenFM1(Comp_ID As Long) ReDim FM1(0) FM1(0).RecordSource = "SELECT ......" FM1(0).Visible = True FM1(0).Tag = "FM1" 'this tells running code that the instance being tested is this one End Sub Problem is: All... 5 15.02.2006 17:28:26 ms access VB and MS Outlook contacts hello, i need to find out which components to use to be able import and export ms outlook contact item into an ms access database using them ms access VB. i'm using the ms access 2003. thanks for any help. happy coddin' (buddy*)__lukas__ ... 2 15.02.2006 10:14:24 Help with module code At the bottom of this code is "Function Removable" I am only able to call up the A:\ drive, but I need it to also call up the C:\ drive or another removable drive such as a flash stick. I believe it has something to do with "Case Removable Media": Can anyone revise this so I can call up at least the C:\ drive...Thank you, Randy Option Compare Database '************ Code Start *... 6 15.02.2006 01:38:35 Search Via combo box On my main switchboard forms I have a few combo boxes where the user can select a coordinator name to view all the contracts that coordinator is handling I created another combo box to do the same thing but search for a single contract that they select from the drop down list. I just copied the code from the coordinator combo box and changed the field names. For some reason it doesn't... 5 14.02.2006 21:38:32 Access report to Word then to Publisher This is a multi-part message in MIME format. ------=_NextPart_000_002E_01C630B1.8B0FC910 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need help getting started. I have an access report that needs to be printed in booklet format. = Publisher does this real nice. Today I create the report in Access, publish it to Word, format it in = ... 2 14.02.2006 07:11:17 Find & Replace (behind the scenes) I was once faced with finding and replacing through over 40,000 large records and because the database was so large (over 500MB) i kept having problems on my machine, until I was given some nice code to do this through a module. First, my current problem, then the code: Now I am trying to find/replace " " (tab) with "" (nothing) and also, """ (quotation mark) with "'" (apostrophe). I ... 4 13.02.2006 15:01:47 Find all calls to a user defined function. Can anyone tell me how to find all the places where a particular subroutine/function is used in a MDB? ... 9 10.02.2006 21:07:16 Linked tables path Can I change the path of the linked tables by code ? I would like the link to be the same as the front end (fe with forms and be with tables are in the same directory). In VB6 you can use something as application.path.... -- Filip http://users.skynet.be/101airborne Official Site of the 101st Airborne - 463rd PFA ---------------------------------------------------------------------- ... 3 10.02.2006 07:38:07 Setting the margin width of a report by code Hi, we have set the margin width of a report to the minimum possible on PC "A" (in the page properties) and then we sometimes copy the mdb to a different computer "B", to change that report design, then after copying the mdb back to "A" the margin settings are gone (we get a lot of white labels again). In the page properties we have to apply the 'minimum' settings again. Can I avoid t... 3 08.02.2006 14:06:34 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17