Search results for query: *

Using me.dataentry = False causes my program to go to the OnCurrent function of a form - how do I stop it doing this.

I need to use a UDL to specify my connection details for an Access application. I have done this succesfully everywhere that I have explicitly connected to the db via code but I also need to be able to use the UDL when the application (and subsequent forms that are based on stored procedures or...

How do I get rid of the max records on a combo box in Access 2003 .adp If I convert to a2K it's fine I can just change the max records on the query but in Access 2003 .adp it will not save this change???? Also does autoexpand not work for numeric fields ?

I am getting the following error sporadically on two forms when I ty to enter data into the first text box on the form (DataEntry form) "you can't assign a value to this object". Once you click OK it accepts the value anyway. This is very annoying and users will not accept this - what is...

I need to copy a database without the data. I need to hold the keys and relationships etc. I also need to be be able to copy Views and queries ?

I have a continuous form with a select button on it, I need to be able to change the colour of the select button or something else in that record, when the select button is clicked. I can change the backcolour on click but it changes it for all records not justthe one chosen. Any help would be...

Hi Is it possible to do a batch export to Sage from Access ? I know you can adda new rec to Sage but you use the .addnew method and specify each fields data. I want to be able to upload a table into Sage from Access

I have a report with a header and 3 subreports all linked by id but the sub reports will only display if there is data for all three subreports. They need to be linked

I have a form with 2 tabs on it. Each tab has it's own form. Form on tab 2 is a datasheet with a select button on each line. Clicking this button populates the form on Tab 1. The problem I am having is that I cannot select multiple lines on Tab 2 at the same time. I can select one switch to tab...

Can you add multiple Detail sections to reports in ADP

I have a calculated field that gives me 1.333333 hours how do I convert this into 1.20mins ?

Hi I have a form with 2 tabs in one tab there is a datasheet view of the table and the second tab has the details. The second tab displayes the details depending on which record you select in the first - this all works fine. My problem is that once I choose a record and look at it on the...

FindFirst is only available for DAO what is the equivalent in ADO ?

-------------------------------------------------------------------------------- Hi I have a form with 2 tabs in one tab there is a datasheet view of the table and the second tab has the details. The second tab displayes the details depending on which record you select in the first - this all...

Hi I want to run a query that returns a calculated field (x*y) which I have done but at the same time I want to do (x*y) for the records that are marked with a flag producing two figures so that I can do two subtotals ? Any ideas. I am doing this on a form using Queries and the subtotals in the...

Hi I am getting the write conflict error message because I have a form with 3 subforms on it. When I enter the details on the mainform they are saved but then I need details from the subforms to be written to the mainform and it's table. I am getting the data written using the update method but...

Hi All Here is what I am trying to do. x = (Q*U)*Q2 X2 = Sum(each instance of x) Basically I am calculating a cost figure whic is x that is no problem but then if there is more than one x I want to add them together . Any bright ideas. I have tried loops but it is hard to get a condition that works.

Hi Guys Anybody know what is causing this error "Arguments are of the wrong type or are in conflict with one another." or how can I trace it. It occurs when I add a new record. The data is added but this error is also displayed. Cheers

Is it possible to make a check box bigger. I have tried changing the height but this just changes the area around it I want the actual check box bigger.

Hi Does anybody know how to Enable macros in Access Runtime automatically. I am packaging my app for users who do not have Access installed. They don't link having to enable the macros when they are installing - anything I can do ?