Search results

I have a table to store our student sick leave records, we would like to print its on a timeline report. I have already sort the db by student name but I don't know how to print it in a single timeline. Student Record: StudentA 1/10/2005 StudentA 5/10/2005 StudentB 20/10/2005 : ...

I have created a date field in format of "d/m/yyyy". However, when I perform the Query statement to delete the record, I found that if the day part under 12 the Query statement recognize it as m/d/yyyy, but if the day part over 12 the Query statement can automatic recognize it as d/m/yyyy. I...

I have a photo (jpg format) which store OLE field in a table. But, I would like to display it in a Data Access Page. But, I have being prompt the following error: "You tried to drop an OLE or long binary column onto your data access page. There is no HTML control which binds correctly to this...

Dear All, I would like to create a marco which is able to check the table status, only table is free (not being used by another users) that updating process is allowed, otherwise a warming message will be pop-up. Do anyone know how to check the table status?

I have generated an Access Web page to connect with a database. Since I found there are a session will be established when user access to the database through this Web page. How I can automatic close this web page (also close the database access connection) if user doesn’t perform any action...

I am developling an inventory management program. I design a master record which has a field to store the total stock available and a Sales Form for user input the sale record(s). When user input the sales throught the Sales Form, how I can reduce the total in the master record ? Master Record...

I have a table to store the new append records from a SQL statement. In this table I have defined a "Status Date" in field type date/time with format dd/mm/yyyy. However, when execute the SQL append statement, the system has appended the record with format of dd/mm/yyyy hh:mm:ss. The problem...

I have already resolved my problem, it is due to the control source issue because I have put the customer name field into control source that it will automatic prompt the first record to me. Thus, the record pointer pointed to my first record upon I close the form. Wayne, Thanks you for help :)

Dear Wayne, I have used the customer name as control source. When I select the customer name, the subform will show me a list of correct sales records in the subform. Then, when I click the another customer name, the program is still able to show me the correct sales record. But, when I...

I have created a combox box based on customter name for selecting related customer sales records (a single customer may have multiple sales records). When I click the "Close" button, I don't know the reason why first record in the list being updated, eventhough it have not been selected...

I have a backup script using WinZip for backup and zip the copied database. Since, Windows XP contain it own compress utility, do anyone know how to combine it into the backup script. My existing backup script as follows: Call Shell(sWinZip & " -a " & sZipFile & " " & sFileToZip, vbHide)