Search results for query: *

Hi, everyone, I got a problem in the C++ programming when reading data file. The codes are attached below. In the for loop, the data file can only be opened once. When j=2, it does not open the file. I don't understand why. Is there anyone can give me a hand? I've been struggling for a while...

Hi, I have some date fileds on several forms and I want to pass the date from calendar control to them once any of them is in focus. The calendar will be created on a separate form. Date fileds are on several different forms. I hope once one click the date field and then pick the date from the...

Is there an event that we can use when Access is closing, like windows is saving settings after one hit turn off computer? I want to write out some infomation when Access is closing. Thanks, SwingXH

When I use Time(), it gave me 1899-12-30-06:42:14. The hour is correct. How to get the correct system time including dates? Also, I want to write an output file with append property, how to write the right code? Thanks a lot! SwingXH

I have a form, mainform, to be used as input form. Assume I have fileds ID and Name to control the data record on another form, form1. I used codes like this stLinkCriteria = "[ID] = " & Me.ID.Value And "Name = " & Me("ComboName").Value DoCmd.OpenForm stDocName, , , stLinkCriteria But got...

Is there a way to get certain field name based on the field value using a query? For example, I have a form based on the table below ID Name Age Height 1 John 34 5.6 2 Ken 55 6.6 I want to make a combo box, when Height>5.5, Height becomes rowsource of the combo box list. If...

Id like to create a log file with the following informaton: 1,user Name 2,Last Log in Time 3,IP address 4,Hard drive ID Also, I want the file to be deleted once a week. within a week, these infomation should be appended. Thanks, SwingXH

I want a Access program to run only under certain location to prevent copying it to anywhere else. I am thinking of making a file location track and return to the program as the password. But don't know how to get the location? Anybody can help on this or any other ideas? Thanks a lot! SwingXH

I have a table with fields like AYesNo, BYesNo, CYesNO. And these field names are the source of a combo box. My objective is that if AYesNo=Yes and other two are NO, then the list of combox box is AYesNo only. If they are all Yes, then list them all. Is that possible? Thanks, SwingXH

How to make a pop up form on top of all other opened windows? Thanks, SwingXH

I would like to put a subform on a main form to show the records. And the records on the subform should be controled by a comboBox on the main form,values of which the user can change. I knew how to display the records on a separate form. The codes look like DoCmd.OpenForm...

I would like to count the records number according to the two dates that specified on the form. The following codes are used, but it returned me the number for all the records. MyDate is in the format of mm/dd/yyyy Me.TxtTotalRec.Value = DCount("MyDate", "MyTable", "'MyDate<=...

I have a sub to open a table using ADO (part of the codes are shown below), but I got error "Object required". I added microdoft activex data recordset 2.5 library and microsoft activex data object 2.1 library. But could not find the control on the menu like other standard controls. Is that the...

I have some images in a report which are linked by text input in a form. I have code like this [Reports]![ReportName]![ImagePathName].Picture = ImageName ImageName includes the path and name and it is a user input. The problem is that i have to open the report in design view first then the...

When I use Date(),got an error : can't find project or library. In fact, it worked fine last week. Very strange. Please help. Thanks, SwingXH

I have a form using tab controls. But the event that I created for switching from one page to another did not work well. For example tab click event, I have to click the form below the tab to active the event. But I want it to be actived once I click the tab. Any idea? Thanks. SwingXH

I have a form uses tab control. An excel figure was copied and pasted on one of the pages. When I directly open this form by double clicking this form, everything is fine. While when I made another main menu and set a open command to open this form, the figure did not show up. Does anybody have...

I have a table named tblIdea. A form has been created to show the records of this table. I have a command to make the form to show only records match the query, as in Private Sub ApplyADORecordset_Click(), only search Hours>=100. The problem is that when I have this sub, there's an error in Sub...

I have a combo whose row source is from a table. The combo box is on a form, the user can pick the name from the pull down list or key in a new name if it is not in the list. Then I want to the program to automatically add this new name into the table so next time this name will be in the pull...

I have a form which shows the records of the table below: JobID Name Hours DueDate 1 AAA 10 June 6, 2004 2 BBB 50 July 6, 2004 3 CCC 100 April 20, 2004 4 AAA 20 May 30, 2004 5 BBB 40 Aug 30, 2004 The user can add and delete any records...