Search results for query: *

Hello, I have been looking into creating an archive db that copies and ouputs the table into a new dataase. What i would like to happen is to be prompted to re-name the table so i can manually date stamp it. Does anyone know of any quick ways of doing this, as the copyobject and renaming...

Hello, I have just quite worringly discoevered that my append query isn't working as i'd hoped. Basically, in the design view i have sorted the data (or so i thought) by contract number and then appended the data by the Last value. The worrying thing is that the sort seems to have been...

Hello, Basically, we have a report that we want to keep to a particular user list. Ideally what i would like to do is have a message box that each person has to fill in to access the document (preferably with there own password)and then prints/stores their name on the document. I don't really...

Hi guys, I'm sure one of you wizards will be able to let me know what i'm doing wrong! Basically, i'm trying to populate certain start dates, based upon which date is populated and whether the F flag is set to true. The section of code below is part of a larger if statement (propbably not the...

Hello, I'm trying to paste some data from access into excel, but am currently only succeeding with the column headers. My Copy and Paste Code is: With objWorkbook.Worksheets("MonthlyView").range("A2") For i = 0 To rs.Fields.Count - 1 .offset(-1, i) = rs.Fields(i).Name Next...

Hello, I was hoping that someone could provid me with a formula for matching to dates, by month and year only/ I have tried format([date1],"mmyyyy")=format([date2],"mmyyyy"), but i assume this keeps the original dates and just makes them look different. OOch

Hello, I'm currently trying to create a query which enables me to show the forecast monthly revenue, based upon the forecast annual Revenue received. For Example If we gain a contract starting in Jan04 and ending in Dec04 and total annual revenue is 120k, then i would like to split this 120k...

Hello, I'm trying to build a crosstab query that counts the number of proposals and groups them by start date. I then hope to union this with similar count queries, that relate to different fields. However, it is only including the months where there is associated info, where as i would like...

Hi, This should be a simple query, as all i'm trying to do is find out whether a date is null or not. I have declared E2 as a date variable. Within the loop i define E2 with E2=Nz(rs2![Effective From Date]): Then my if statement egins with: If M = M2 And (rs.AbsolutePosition + 1) <> rsEnd...

Hello, I'm currenlty creating an Access module that will search through a particular customers records (Gas metering)history and if the record per meter has a null date, then populate with the original date. However I am trying to use a select case statement, but for some reason it doesn't...

Hello, Being a beginner im still struggling with some of the basics. All i want to do is using 'Select Case' copy a particular value within the recordset (rs.siterefnum) and then paste it when the an additional case is met. This segement of code of is currently stands as: Do While Not rs.EOF...

Hello, i have also posted this on the end of a previous access thread, but thought it probably best to treat my problem in it's own entity. Bascially, i have created a clone of a recordset (rs2) so i can test the 2 against each other. For some reason though, my code does not recognise the EOF...

Hi - can someone now help with my latest problem. Below, is my full code for an update query i'm trying to excecute. Only when it come to actually perform the update (highlighted), i get an error message sayig the recordset is not updatable. I have checked the connection, where readonly...

Hello, I am trying to compare and flag a set of data depending on how the values of each row change when moving down the data. I have created 2 recordsets (rs and rs2). M = the meterpoint reference and m2 = the meterpoint ref of the 2nd recordset as my code hoghloghts below: Dim F As...

Hello, I am trying to compare and flag a set of data depending on how the values of each row change when moving down the data. I have created 2 recordsets (rs and rs2). M = the meterpoint reference and m2 = the meterpoint ref of the 2nd recordset as my code hoghloghts below: Dim F As...

Hello, Can someone please help me with a bit of code i'm trying to put together. Besically, what i am trying to acheive is a loop through the recordset testing one row with any row below it. However, i am at a loss as to how to represent the next row. I've tried the following: (M <> (with...

Hello, Can someone help me. I am trying to update field NA_CTRT_STATUS, based upon the criteria within the if statement. However, the first (probably of many) error i get is runtime error 94 - invalid use of null' at the code highlighted below. Can someone please help me resolve this issue...

Hello, I am trying to import some csv files into access and am running int a few problems with missing items. In the dataset below, following the import, records 3 and 7 will be missing within the table, even though it is set as a text field. If anything i would have thought that it would be...

Hello, I am importing some text into one of my tables and as a result i get a new import errors table. As part of my import code i have used the following line to try and delete this table. DoCmd.DeleteObject acTable, "[Gas_Hull_COT_PortAnlys_ImportErrors]" However, when i then run the code...

Hello, I'm trying to view the results of my code within an excel file, however it keeps getting stuck at the copyrecodset line, saying that the 'object does not recognise this property'. Please can someone help with a way i can copy and paste the recordset??? My code is as follows: Sub...