Search results for query: *

Hi, I would have to sort a large excel sheet by 4 criteria . Using the VBA recorder below is the code, but only for 3 criteria - if I add a fourth, I get an error message... is it not possible to have 4 criteria?? Thanks in advance for any indication you can provide. KaW Dim i As Integer...

Hi, I am trying to find a template for an idea: Situation: I have a contacts database tblcontacts and a companies database, tblcompanies. When I enter a new name in the contact database (frmContacts), I would like to allocate a company (and the address and web site, etc details that goes with...

Hi all, I am wondering. In the following Design view of a query, how do I change the date tblDescription.EndDate to be only the first three letters of the month and the full year?? Description: [tblCurrencies.Currency] & " " & [tblDescription.EndDate] Thank you so much in advance!! Kysteratwork

Hi all, I have a table tblCountry. The user should be able to enter a new country in a pop-up (alerady created) which contains CountryID (autonumber), Country and Region (dropdown to tblRegion). After the user enters Country, I want to force him to chose a region, too from the dropdown. So...

Hi all, I have problem: 4 tables: tblCompanies (with BusinessCity and BusinessCountry - both IDs linked to tblCities and tblCountries) tblCities (with Country (an ID, linked to tblCountries)) tblCountries (with RegionID linked to tblRegions) tblRegions I would like to have in a form the...

Hi All, I have a very important and sensitive question: I have many tables linked together in all kind of ways and changing one information in one table will influence many other tables. Now my question: If I reset the autonumber in one table (that is linked to numerous other ones) will the...

Hi all, I would like to print a report upon clicking button in a form. The code I have so far is: Private Sub PrintReport_Click() On Error GoTo Err_PrintReport_Click Dim stDocName As String Dim MyReport As Report stDocName = "RptMeetings2005" Set MyReport =...

Hi all, Is it possible to create a calculated field in a table that contains part of another field: i.e.: Fields are: FirstName and LastName and I want to create another field which is the first letter of the FirstName, followed by a '.' How would I do that? Do have have to create a query...

Hi all, I found this fantastic code online (unfortunately I forgot where) which lets the user add a new record to a dropdown (ice cream flavours in this case), if the record is not in the list. Private Sub Combo111_NotInList(NewData As String, Response As Integer) Dim rstFlavors As...

Hi All, I have a subfrm (continuous form) where I would like to create a command button that sorts the entire subform by the text field txtCompany... sounds easy enough, but I don't know how to do that. Is it at all possible in a form? Thank you in advance for any indication. Kysteratwork

Hi All, I have a pop-up form that serves as a search tool to enter data. For some reason, though, the form always remains the same size (square), regardless of how small I make the layout in design mode. What must I do to adapt to the size I make it in design mode? (And it ought to appear on...

Hi all, I have a question with regards to this code I use in a form to display time and date: Private Sub Form_Timer() Me!lblClock.Caption = Format(Now, "dddd, mmm d yyyy, hh:mm AMPM") End Sub Private Sub cmdClockStart_Click() Me.TimerInterval = 1000 End Sub Private Sub cmdClockEnd_Click()...

Hi All, I have a serious question: What code do I have to put for a command button, in order send an email to the address located in the textfield EmailAddress (via Outlook?) I can't make the EmailAddress Field Clickable, since I wouldn't be able to add a new record without the code wanting...

He all, I have a rather frustrating problem: 1. I have two tables, one with event details (tblEvent) and another one with contact names and the respective contact details (tblContacts) 2. I have created a junction table (tblJunction), so that I can have a many-to-many relationship (i.e. one...