Search results for query: *

Hi, I am trying to write an function to prompt the user if they want to update it if they make a chnage to the field, and if they cancel no, to go back to the previous value, does anyone know how to do this. The Code I have written so far us as follows, but it still excepts the new value, does...

Hi, I am trying to write a SQL DDL Statement to add a column to my 'Documents Table' called DateLoaded with the default value of Now(), does anyone know how to do this. Regards, Gavin,

Hi, Recently I have been having problems on partiucular PC's when the user logs into any of my access 2000 databases, no one else then can login, has anyone else had this problem and know how to resolve it, I have looked through all the options but cant find anything that could impact this...

I have a field which returns 14 vaslues seperated by a comma, (eg 245.67,128.90,126.54,0,0,0,0,0,0,0,0,0,0,0). I need to be able subtract all these values and add them all together, does anyone have any ideas how this can be done. Regards, Gavin,

I am trying to reference the AutoNumber Field that I have in one of my tables in Code, but all it returns is a ?, but if I try access the field in a Query I get the right result from the Field. Does anyone know haw to handle an Autonumber - Replication ID Field in Code and return the correct...

Hi, I am trying to write a query to delete all "TAKE FOR MOT TEST" records that have both "TAKE FOR MOT TEST", "CARRY OUT MOT TEST" on the same Vehicle Registration Number, Can any one give me any help please. The Fields that I have which must be taken into account are RegNo, Actual-Date and...

Hi, I am having a problem with a function I have written it all works fine until you pass a date to the function for the first of the month eg 01/05/2004, when the function does its work it converts the date to 05/01/2004, I have tried everything I can think of including using format function...

Hi, I am trying to write a report which returns the Current Date and Previous Date of a service due for my Vehicle Database. The Tables I am using are : Vehicle: Vehicle ID RegNo FleetNo ... Service: Service ID Date Vehicle ID ... I need to return the RegNo, FleetNo, PreviousDate and...

I am tring to add a chart to the bottom of my report, my problem is that the Legend does not display all the items (14) in the Chart, I have tried changing the Font Size in VBA of the Legend Items this makes the text smaller, but the Items in the Legend appear to be spaced far a part, dows...

Does anyone know how to change a Parameter in either ADO/DAO. I have a query Called qryDailyReport which has a Parameter Called StartDate, which I need to be able to Change in Code, after searching Help I can find plenty of information on how to Create Parameter Queires from scratch but nothing...

Hi, I need to Convert the Case in all fields on My database to UpperCase when the User Leaves the Field, I have written a simple Procedure which uses the strConv Function, but what ever If conditions I use I can't get it to only run if the field has been changed or if the field has been...

Does anyone know how to tell a report to only show the page header when you are not on the first page. I have tried the following code, in both the on page and report header on Print events, but can't seem to get it to work. If {Page] <> 1 Then PageHeaderSection.Visible = True End If...

I need to be able to create a query in my VBA Code and specify sepcfic conditions, due to the complexity of the query and the data been stored on a Progress Database, the best way for me to do this is using a Pass-Through Query, does anyone know how to create one in code and create it with a...

I have a report which connects through RDO (ODBC) to 2 databases, 1 is an Progress Database the other is an access 2000 Database. At times when I run the report I get the following error message: Query engine Error: 'HY000:[DataDirect-Technologies][ODBC Progress Driver][Progress]Cursor not...

I have an application where I need to check to see if the two strings are identical, the only problem is that in access the followign would be seen as the same. "Hello World" "hello world" "HELLO WORLD" does anyone know how to tell Access when comparing strings to check the case as well as the...

I have writteen a procedure to produce a list of Queries for a Combo Box, but whenever I run the code it returns no data, but if I run the same SQL in the Query Window it returns data fine, Can anyone see why the code below fails on me. Dim strQueryList As String Dim rstADO As New...

I am trying to convert some old Access 97 DAO code to ADOX, to use for Linking Tables, can any one help me/give me some pointers on what I need to do to convert the following proc to ADOX. Sub UpdateLink(strTableName As String, strDatabaseName As String) On Error GoTo UpdateLink_Error...

Hi, Does anyone know how to Send an MS Access Report to MS Word in Code, If you open up a Report you can select the Office Links/Analyze it with MS Word, this is what I am trying to Automate. Thanks for your Help Gavin,

hi, I am trying to display totals which are calulated in hidden fields on my subform (fsubSalesDetails), on my main form, but I seem to be doing something wrong as all I get is an error in the text box, if I run the sub form on its own and show the total fields they work fine. The string I am...

Hi, I have a simple report with a header (including company logo), when I export this to Excel I want to try and include the header details including the Logo, when I write a report using crystal Reports you can do this, so I know that Excel can support it. does anyone know if this is possible...