(0.012 seconds) Articles (1670) /84 Next>> Last >| Access 2000 to 2003, get error 438 3 1573 (6/3/2010 3:59:01 AM) Utf Hello, We have a Access 2000 program which is running fine on old PC. After we changed to new PC(Win7 with Office 2003), we can't get it work correctly anyway. When running the fuction, we always got "... Updating .nsf lotus notes server file - from access 2 1236 (6/4/2010 8:22:33 AM) Utf Hi, Using the below code i can fetch data from the .nsf file kept in the server. Dim LotusWizard As DAO.Recordset Dim session As Object Dim notesdb As Object Dim notesView As Object ... Checking for Null & Select Case 14 1395 (6/4/2010 8:54:19 PM) lmcc I have a form called fSearchforCompany with two unbound fields. After selecting a field from lstQuickSearch (list box) and tabbing to txtSearchBox to enter data, the correct form should open with the text fr... Allen Browne's Calendar97.mdb 4 1573 (6/5/2010 12:57:20 PM) Mark This may be asking too much, but does anyone know how to use the calendar (frmCalendar) from Allen Browne's Calendar97.mdb as a subform on a main form, rather than as a modal popup? I would like to use the... If this correct use of Select 3 1131 (6/5/2010 2:29:32 AM) Utf Hi there I want to use the following statement in the RowSource for a report but am unsure of whether it's correct: SELECT *, * FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] =... "item not found in this collection" 5 1533 (6/4/2010 3:35:55 PM) Utf I try to send mass emails in my VBA codes, but I got the above error message. Can you help me to debug it. Here are the codes. Dim email1 As String email1 = "a@hotmail.com" + ";" + "b@yahoo.com" + ";" + "c@... Conditional updating - 98561 0 1279 (6/6/2010 1:21:35 PM) samotek I have the following working updating function which is ok: CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72" I want to add on a condition depending on the field “code” in the same... Sendkeys "{ESC}" 1 1929 (6/6/2010 10:12:36 AM) Utf Hi untill now I used the Sendkeys "{ESC}"/Cancel in the event BeforeUpdate, but occassionaly I had some problems. From now on I follow the instructions of some users in the duscussion Groep and I replaced ... VBA Reference Libraries-Access 2003 vs 2007 6 2587 (6/4/2010 2:00:19 PM) Utf I'm in the process of converting from Access 2003 to Access 2007. When I converted my 2003 db to 2007 the VBA code would not run. I changed the Reference libraries in 2007 to match what I had in 2003 and th... Select Case question - Comparing strings 1 1054 (6/5/2010 8:11:36 PM) JDB I am passing variables into a subroutine, and comparing these to some parameters in a array. If all 4 of the variables passed in are equal to 4 values in the array, I run a a loop adding values to the array.... OLE, INK and Reports 0 1280 (6/5/2010 9:19:35 PM) Utf Hello everyone, here is my problem. In my app I have 7 spots where a signature can be required. They are all OLE controls that when they get the focus they are scaled in size, 4 x, when you double click... run query message 2 1157 (6/4/2010 8:26:06 PM) Utf Every time a SQL statement is ran the "run query" message is display in the status bar, is there a way to prevent this so a useful message could be displayed? Thanks Jim ... quantifying overlapping time spans 1 1192 (6/4/2010 11:46:56 PM) EHobs Hi all, I am trying to write a query to calculate the amount of time that any two individuals overlap in their use of a location. My table currently looks like this: Date Time IndividualID Arrival... "%" character 1 1013 (6/4/2010 11:42:21 PM) Utf I am using the following code: Val(strValue) where strValue = "0.1%" I am getting a type mismatch error.. what does the "%" character do to a string? ... Calendar control conversion issue 3 1167 (6/4/2010 9:29:12 PM) Mark Hi all, I still do most of my development at home using Access97. At work, I convert the FE to the default 2000 format on a computer running Access 2002(or maybe it's 2003, I'm not sure which). I can then ... Why does code Loop 2 1164 (5/25/2010 10:00:01 PM) Utf When I click on a command button to show a report I have a break point on the command_click. Upon clicking the command button it opens a report. DoCmd.OpenReport stDocName, acPreview As I step thro... Form Name as Variable 1 2154 (6/4/2010 9:36:02 PM) Utf Hi, I have the following subroutine: Public Sub SetMeterBasic(p As Single) ' This subprocedure is used to update the progress meter bar With Forms![FormA] .shpMeterBar.Width = p * .lblMeter.Width ... Public variable 1 1359 (6/4/2010 4:28:19 PM) Utf I am calling a public sub from a form, and I am trying to get the sub to be able to access a variable from the form. I declared the variable as public in the forms code, but it isn't available to the subro... create a form that collects parameters 1 1634 (6/4/2010 11:35:14 AM) Utf Hi, i need a form where we search for a detail and the result should be published in the bottom, based on the result the user will decide what to do next in acess 2007. i refered the link below http://... populate a text box with multiple records based on combo box selec 2 1167 (6/4/2010 4:20:54 AM) Utf Hi, I have made one form with a combo box (dropped down) , a search button and a Text box. when a user selects a value (ie. Project No.) and click on search button the text box should display all the rec...