Search results

Hi, Access 2007 now displays all the records in Continuous Forms in white and grey records. Does anyone knows how to set the display of all the records in white? Thanks...

Hi, I have a need to remove html codes from a text (memo) string. For eg: Here is the string: This is part one of the string <DIV style="padding:5px; FLOAT: middle; MARGIN: 5px; WIDTH: 88; BACKGROUND-COLOR: #cccccc; height:8"> <font color="#CC0000">don't care what's the text enclosed...

Hi, I create a form that has an Event Procedure which dynamically modifies the qry that is used as the source of a report and then is used to preview the report. When I use the form all is well. However, when a user (non admin) tries to use it return an error stating that they don't have the...

Hi There, I have a dialog popup window that allows me to choose from a list of selections, upon clicking on the Proceed button, a report based on the selection is displayed. The popup remains on top of the report, when the user chooses a different selection and then click on the Proceed...

Hi, I was looking for a tool on the Net to web-enabled my MS Access applications when I came across this: http://www.microtools.us/default.htm Has anyone had any experience to share on such a tool or other similar tools? Thanks.

Hi, I've three questions: 1. I'd like to know how to go about upsizing mdb be to MSDE. Should I use the same Upsizing Tool for this purpose? 2. How is security taken care of when data is upsized to MSDE. I presume the FE will continue to use the mdw file, how about the MSDE? 3. Has anyone...

Hi, I've created a linked table to a MS Inbox folder. With the linked table, I'm able to retrieve incoming emails to a particular email address. I am creating a Reply button on a Form which will activate MS Outlook, and the content of the email is appended just like any email client would...

Hi, If I have a VBA that creates a new record eg: Dim db As Database Dim rsNewRecord As Recordset Set db = CurrentDb() Set rsNewRecord = db.OpenRecordset("uService", dbOpenDynaset) rsNewRecord.AddNew rsNewRecord("ContractID") = Me.ContractID rsNewRecord("DateReported") = Me.Received...

Hi, I've a Macro with a conditional check for a date entered by user on a form ([ServiceDate]), which checks againsts a table (uHoliday) which has a date field [HolidayDate]: DLookUp("[HolidayDate]","uHoliday","[HolidayDate]= #" & [ServiceDate] & "#") Is Not Null The HolidayDate is a Date...

Hi, I'm having problem in trying to create a query to display records: Eg. If I have a field with the following three records: john@abc.com ben@def.com; cathy@ghi.com cathy@ghi.com If I want to pick up records containing text "cathy@efg.com", the 2nd and 3rd records should be retrieved...

I'm a complete newbie when it comes to VBA, would appreciate some help here... I have a Form bound to table 'Service' and a subform (datasheet) bound to table 'ServiceEngineer', the linked field is 'ServiceID'. The subform allows user to select the names of Engineers (email addresses of the...

I have a report which has a fixed company logo. I would like to change it so that the logo is pulled from a table field. I will design a form to allow user to upload their own logo to the field. How should I go about doing it? as I'm having problem redesigning the report to use the new image...

I need help! I have to send out access report as Excel file on the 15th of every month to several users from my access application automatically without human intervention. My plan is to create a VBA code and then create a shortcut for this code and place it on the PC, then I'll use Windows'...

I read somewhere that Access performs well when concurrent users on Access database is less than 10 users. will this limitation be resolved if I upsize my 'be' database to SQL Server?

I would like to be able to allow user to click on a button, say "User Record" from a form based on the current record (say Contract) the user is editing. However, the User record form is in one of the tabs in a lookup form. How can I program the button so that it goes directly to the record...

Is it possible to use SendObject to send an email to a user with the email embedded with a button for him/her to click on it to approve a request? - similar to a Lotus' workflow.

I have a subform that contains a call to a subroutine which creates multiple rows of new records depending on the first row of record entered. Near the end of the subroutine, it calls DoSummation (as shown below). Then when I move the mouse to the Parent form, 'error 3251 - Operation is not...

Hi There, I've noticed that when switching to View from Design View or Saving a form, they take a long time. 10 seconds to save a form, 5 seconds to switch from Design View to View. If the be is on a fileserver, it takes much much longer for these two operations. It used to be much faster...

Does anyone know wheter it is possible to downgrade Access 2002 application to Access 98?

DLookup with 3 criteria. I have a aPointsRate table such as shown below: DayTypeID____BeginTime_____EndTime____MultiplyBy 2____________00:00am______8:59am____2.0 2____________9:00am_______5:59pm____1.0 2____________6:00pm_______11:59pm___1.5 3____________00:00am______8:59am____2.0...