Search results

Hi to all. I'm making some calculations based on a multi array and i wanted to subtract two arrays but i cannot seem to accomplish that without an expensive loop. Here is my code: Dim TrainingResults as DAO.Recordset Dim NormalizedPricesArray As Variant Dim ArrArrayX As Variant Dim ArrArrayY...

Hi, Sorry if I'm posting in the wrong place but didn't saw a more appropriate one. I'm looking for an ActiveX control similar to the Microsoft Slider Control in Access but with a double arrow that one can select an interval of values instead of just one value. This is an example of what I'm...

Hi to all I have decompiled my file to clean up old compile states but i have a problem now. I have several references in VBA to fields that are "pulled" from the rowsource but are not actually a inserted field in the form. This way i don't have lots of invisible fields when i just need the...

Hi to all I have a Microsoft Web Browser Control on a form but i cant seem to format to a Flat Special Effect Style. It always returns sunken. Does anyone knows if this is possible (to have a Web Browser control with no lines or special effects showing a web page as it was part of the form)...

Hi to all, I have several complex databases (in the sense that they have lots of elements like forms, reports and modules) that are used as applications for the day to day use. My goal is to merge them into one unique interface but I'm finding it hard to come up with a solution and i think that...

Hi to all, I have two tables with the same fields: Table1: Name, Date, Value Table2: Name, Date, Value They have some combinations of the fields Name and Date that are the same, example: Table1: Jonh, 2010-05-01, 2 Table2: Jonh, 2010-05-01, 1 I wanted to insert in Table1 the combinations...

Hi, I'm relatively new to Databases and have been working on some projects. I have a doubt of what methods are more appropriate when updating or inserting data in a table. Here are the two methods that i use. 1. Open e snapshot recordset, calculate things and insert or update with sql the...

Hi to all, I have a report that is based on some temporary created tables. The report has a subform and a chart along with some textboxes. My problem is that the report is incredible slow on clicking the next page arrow (showing the message "Formatting Page, press Ctrl+Break to stop...") or...

First of all, hi to everyone here on the forum and thanks in advance for any help. I'm having troubles with a query that works fine on the Query section of Access but prompts an error when executed in VBA. The error is: Run-time error '3141' The SELECT statement includes a reserved word or an...